* id year_name

* id person_type person_id att_date check_in check_out status notes

* id category_name category_type description is_active created_at

* id transaction_type category_id amount transaction_date description reference_number payment_method related_person_type related_person_id related_student_id related_salary_id related_lesson_payment_id created_by created_at

* id class_name grade_level_id section section_name academic_year created_at

* id employee_code name job_title salary work_days annual_leave_days used_leave_days created_at

* id student_fee_id installment_number amount due_date paid_date status payment_method receipt_number notes confirmed_by confirmed_at created_at

* id guardian_id student_id installment_id notification_type title message is_read read_at created_at

* id installment_id student_fee_id amount payment_date payment_method receipt_number received_by notes created_at

* id fee_name fee_description academic_year grade_level_id class_id total_amount installments_count first_installment_amount is_active created_at

* id student_id subject_id semester year academic_year coursework final_exam total listening reading writing speaking grammar phonics

* id academic_year created_at

* id full_name phone reference_code student_id created_at

* id holiday_name holiday_date description

* id student_id academic_year attendance teacher_name ratings_data signatures_data final_result result_date created_at updated_at

* id person_type person_id year annual_entitlement annual_used sick_used emergency_used unpaid_used

* id person_type person_id leave_type start_date end_date days_count reason status approved_by approved_at created_at

* id student_id academic_year english_data math_data science_data kg_english_data kg_math_data kg_islamic_data kg_arabic_data kg_local_math_data kg_crafts_data general_behavior_data notes_signatures_data local_data local_notes_data created_at updated_at

* id person_type person_id note note_date created_by created_at

* id user_type user_id phone code expires_at used created_at

* id student_id from_class_id to_class_id from_grade_level to_grade_level academic_year avg_score status promoted_at promoted_by

* id person_type person_id month year basic_salary bonus deduction absence_days absence_deduction net_salary paid_date status created_at

* id setting_key setting_value

* id student_code name national_id birth_date gender class_id academic_year semester guardian_name guardian_phone address enroll_date status

* id title note file_name original_name mime_type file_size uploaded_by created_at

* clip_id class_id

* id student_id fee_type_id academic_year semester total_amount paid_amount remaining_amount status created_at

* id subject_name academic_year grade_level_id class_id max_grade coursework_max final_max subject_type is_english created_at

* id employee_code name national_id phone email subject hire_date salary address work_days work_start work_end annual_leave_days used_leave_days lesson_price lesson_days created_at

* id teacher_id subject_name lesson_date lesson_day lesson_price timetable_id payment_id completed notes recorded_by created_at

* id teacher_id amount lesson_count payment_date payment_method reference_number budget_transaction_id created_by created_at

* id grade_level_id class_id section_id teacher_id subject_name school_name day_of_week period_number start_time end_time notes created_at

* id username password full_name phone role created_at

select table academic_years attendance budget_categories budget_transactions classes employees fee_installments fee_notifications fee_payments fee_types grades grade_levels guardians holidays kg2_term_evaluations leave_balance leave_requests monthly_evaluations notes password_resets promotions salaries settings students student_audio_clips student_audio_targets student_fees subjects teachers teacher_lessons teacher_lesson_payments timetables users . select column
عرض

criteria

ترتيب	تصاعديا	تنازليا
إضافة كـ	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	نص Another column
	select table academic_years attendance budget_categories budget_transactions classes employees fee_installments fee_notifications fee_payments fee_types grades grade_levels guardians holidays kg2_term_evaluations leave_balance leave_requests monthly_evaluations notes password_resets promotions salaries settings students student_audio_clips student_audio_targets student_fees subjects teachers teacher_lessons teacher_lesson_payments timetables users .	select column