| id |
int(11)
|
|
|
|
| school_year |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| student_number |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| grade_10_section |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| section |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| lrn |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| last_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| first_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| middle_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| grade_10_school |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| birthday |
date
|
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| student_contact |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| guardian_contact |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| guardian_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| four_ps |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| account_status |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| tuition_fee |
decimal(10,2)
|
|
|
|
| remaining_balance |
decimal(10,2)
|
|
|
|
| date_enrolled |
date
|
|
|
|
| referred_by |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| birth_certificate |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| form_138 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| good_moral |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pic_1x1 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pic_2x2 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| form_137 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| remarks |
text
|
utf8mb4_general_ci
|
|
|
| graduation_fee |
decimal(10,2)
|
|
|
|
| remaining_graduation_balance |
decimal(10,2)
|
|
|
|
| email_address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| civil_status |
enum('Married', 'Single', 'Widowed', 'Separated')
|
utf8mb4_general_ci
|
|
|
| sex |
enum('Male', 'Female')
|
utf8mb4_general_ci
|
|
|
| grade_level |
enum('Grade 11', 'Grade 12')
|
utf8mb4_general_ci
|
|
|
| semester |
enum('1st Semester', '2nd Semester')
|
utf8mb4_general_ci
|
|
|
| strand |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| strand_id |
int(11)
|
|
|
|
| section_id |
int(11)
|
|
|
|
| father_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| mother_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| referral_status |
enum('unclaimed', 'claimed')
|
utf8mb4_general_ci
|
|
|
| status |
enum('ACTIVE', 'TRANSFERRED OUT', 'GRADUATE', 'NOT GRADUATE', 'DROPPED')
|
utf8mb4_general_ci
|
|
|
| remark |
text
|
utf8mb4_general_ci
|
|
|
| was_transferee |
tinyint(1)
|
|
|
|
| total_paid |
decimal(10,2)
|
|
|
|
| grade11_original_tuition |
decimal(10,2)
|
|
|
|
| is_repeater |
tinyint(1)
|
|
|
|
| repeater_duration |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| curriculum_version |
varchar(15)
|
utf8mb4_general_ci
|
|
|
