| id |
int(11)
|
|
|
|
| student_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| student_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| payment_code |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| gender |
enum('male', 'female')
|
utf8mb4_unicode_ci
|
|
|
| nationality |
enum('egyptian', 'foreign')
|
utf8mb4_unicode_ci
|
|
|
| city_id |
int(11)
|
|
|
|
| national_id |
varchar(14)
|
utf8mb4_unicode_ci
|
|
|
| faculty |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| study_year |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| prev_grade |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| medical_result |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| medical_date |
date
|
|
|
|
| housing_notice_date |
date
|
|
|
|
| religion |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| student_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| father_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| father_national_id |
varchar(14)
|
utf8mb4_unicode_ci
|
|
|
| father_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| father_job |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| father_address |
text
|
utf8mb4_unicode_ci
|
|
|
| guardian_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| guardian_national_id |
varchar(14)
|
utf8mb4_unicode_ci
|
|
|
| guardian_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| guardian_relation |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| guardian_address |
text
|
utf8mb4_unicode_ci
|
|
|
| guardian_abroad |
tinyint(1)
|
|
|
|
| parents_status |
enum('both_alive', 'one_dead', 'both_dead')
|
utf8mb4_unicode_ci
|
|
|
| room_type |
enum('single', 'double', 'special_needs')
|
utf8mb4_unicode_ci
|
|
|
| student_type |
enum('new', 'returning')
|
utf8mb4_unicode_ci
|
|
|
| period_id |
int(11)
|
|
|
|
| meal_plan |
tinyint(1)
|
|
|
|
| activities_consent |
tinyint(1)
|
|
|
|
| overnight_consent |
tinyint(1)
|
|
|
|
| health_condition |
tinyint(1)
|
|
|
|
| health_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| student_photo |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| documents_pdf |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| emergency_name |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| emergency_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| emergency_alt_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| emergency_relation |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('pending', 'approved', 'rejected', 'waitlist', 'evacuated')
|
utf8mb4_unicode_ci
|
|
|
| academic_year |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| rejection_reason |
text
|
utf8mb4_unicode_ci
|
|
|
| room_number |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| checkin_date |
date
|
|
|
|
| checkout_date |
date
|
|
|
|
| evacuation_reason |
enum('normal', 'administrative', 'other')
|
utf8mb4_unicode_ci
|
|
|
| evacuation_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| fees_amount |
decimal(10,2)
|
|
|
|
| fees_paid |
decimal(10,2)
|
|
|
|
| payment_status |
enum('unpaid', 'partial', 'paid')
|
utf8mb4_unicode_ci
|
|
|
| journal_entry_id |
int(11)
|
|
|
|
| receivable_id |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| created_by |
int(11)
|
|
|
|
| reviewed_by |
int(11)
|
|
|
|
| reviewed_at |
timestamp
|
|
|
|
| waitlist_priority |
int(11)
|
|
|
|
