| app_id |
int(11)
|
|
|
|
| reg_number |
varchar(25)
|
latin1_swedish_ci
|
|
|
| issue_date |
date
|
|
|
|
| first_name |
varchar(150)
|
latin1_swedish_ci
|
|
|
| last_name |
varchar(150)
|
latin1_swedish_ci
|
|
|
| gender |
int(11)
|
|
|
|
| guardian_first_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| guardian_last_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| occupation |
varchar(50)
|
latin1_swedish_ci
|
|
|
| address |
text
|
latin1_swedish_ci
|
|
|
| city |
varchar(50)
|
latin1_swedish_ci
|
|
|
| pincode |
int(11)
|
|
|
|
| mobile |
varchar(15)
|
latin1_swedish_ci
|
|
|
| whatsapp |
varchar(15)
|
latin1_swedish_ci
|
|
|
| other_contact |
varchar(15)
|
latin1_swedish_ci
|
|
|
| email |
varchar(100)
|
latin1_swedish_ci
|
|
|
| fee_amount |
int(11)
|
|
|
|
| category |
int(11)
|
|
|
|
| dependent_details |
text
|
latin1_swedish_ci
|
|
|
| pre_inst_name |
varchar(50)
|
latin1_swedish_ci
|
|
|
| pre_inst_address |
text
|
latin1_swedish_ci
|
|
|
| acadamic_year_id |
int(11)
|
|
|
|
| course_id |
int(11)
|
|
|
|
| course_batch_id |
int(11)
|
|
|
|
| app_fee_id |
int(11)
|
|
|
|
| mode_of_transport |
int(11)
|
|
|
|
| transport_route |
int(11)
|
|
|
|
| note |
text
|
latin1_swedish_ci
|
|
|
| application_status |
tinyint(4)
|
|
|
|
| fee_status |
tinyint(4)
|
|
|
|
| fee_paid_date |
datetime
|
|
|
|
| added_by |
int(11)
|
|
|
|
| added_at |
timestamp
|
|
|
|
| modified_by |
int(11)
|
|
|
|
| modified_at |
timestamp
|
|
|
|