| id | int(11) |
|
|
|
| name | varchar(100) |
|
|
|
| biometric | int(11) |
|
|
0
|
| biometric_device | text |
|
|
|
| email | varchar(100) |
|
|
|
| phone | varchar(50) |
|
|
|
| address | text |
|
|
|
| lang_id | int(11) |
|
|
|
| languages | varchar(500) |
|
|
|
| dise_code | varchar(50) |
|
|
|
| date_format | varchar(50) |
|
|
|
| time_format | varchar(255) |
|
|
|
| currency | varchar(50) |
|
|
|
| currency_symbol | varchar(50) |
|
|
|
| is_rtl | varchar(10) |
|
|
disabled
|
| is_duplicate_fees_invoice | int(1) |
|
|
0
|
| timezone | varchar(30) |
|
|
UTC
|
| session_id | int(11) |
|
|
|
| cron_secret_key | varchar(100) |
|
|
|
| currency_place | varchar(50) |
|
|
before_number
|
| class_teacher | varchar(100) |
|
|
|
| start_month | varchar(40) |
|
|
|
| attendence_type | int(10) |
|
|
0
|
| image | varchar(100) |
|
|
|
| admin_logo | varchar(255) |
|
|
|
| admin_small_logo | varchar(255) |
|
|
|
| theme | varchar(200) |
|
|
default.jpg
|
| fee_due_days | int(3) |
|
|
0
|
| adm_auto_insert | int(1) |
|
|
1
|
| adm_prefix | varchar(50) |
|
|
ssadm19/20
|
| adm_start_from | varchar(11) |
|
|
|
| adm_no_digit | int(10) |
|
|
6
|
| adm_update_status | int(11) |
|
|
0
|
| staffid_auto_insert | int(11) |
|
|
1
|
| staffid_prefix | varchar(100) |
|
|
staffss/19/20
|
| staffid_start_from | varchar(50) |
|
|
|
| staffid_no_digit | int(11) |
|
|
6
|
| staffid_update_status | int(11) |
|
|
0
|
| is_active | varchar(255) |
|
|
no
|
| online_admission | int(1) |
|
|
0
|
| is_blood_group | int(10) |
|
|
1
|
| is_student_house | int(10) |
|
|
1
|
| roll_no | int(11) |
|
|
1
|
| category | int(11) |
|
|
|
| religion | int(11) |
|
|
1
|
| cast | int(11) |
|
|
1
|
| mobile_no | int(11) |
|
|
1
|
| student_email | int(11) |
|
|
1
|
| admission_date | int(11) |
|
|
1
|
| lastname | int(11) |
|
|
|
| student_photo | int(11) |
|
|
1
|
| student_height | int(11) |
|
|
1
|
| student_weight | int(11) |
|
|
1
|
| measurement_date | int(11) |
|
|
1
|
| father_name | int(11) |
|
|
1
|
| father_phone | int(11) |
|
|
1
|
| father_occupation | int(11) |
|
|
1
|
| father_pic | int(11) |
|
|
1
|
| mother_name | int(11) |
|
|
1
|
| mother_phone | int(11) |
|
|
1
|
| mother_occupation | int(11) |
|
|
1
|
| mother_pic | int(11) |
|
|
1
|
| guardian_relation | int(11) |
|
|
1
|
| guardian_email | int(11) |
|
|
1
|
| guardian_pic | int(11) |
|
|
1
|
| guardian_address | int(11) |
|
|
1
|
| current_address | int(11) |
|
|
1
|
| permanent_address | int(11) |
|
|
1
|
| route_list | int(11) |
|
|
1
|
| hostel_id | int(11) |
|
|
1
|
| bank_account_no | int(11) |
|
|
1
|
| national_identification_no | int(11) |
|
|
1
|
| local_identification_no | int(11) |
|
|
1
|
| rte | int(11) |
|
|
1
|
| previous_school_details | int(11) |
|
|
1
|
| student_note | int(11) |
|
|
1
|
| upload_documents | int(11) |
|
|
1
|
| staff_designation | int(11) |
|
|
1
|
| staff_department | int(11) |
|
|
1
|
| staff_last_name | int(11) |
|
|
1
|
| staff_father_name | int(11) |
|
|
1
|
| staff_mother_name | int(11) |
|
|
1
|
| staff_date_of_joining | int(11) |
|
|
1
|
| staff_phone | int(11) |
|
|
1
|
| staff_emergency_contact | int(11) |
|
|
1
|
| staff_marital_status | int(11) |
|
|
1
|
| staff_photo | int(11) |
|
|
1
|
| staff_current_address | int(11) |
|
|
1
|
| staff_permanent_address | int(11) |
|
|
1
|
| staff_qualification | int(11) |
|
|
1
|
| staff_work_experience | int(11) |
|
|
1
|
| staff_note | int(11) |
|
|
1
|
| staff_epf_no | int(11) |
|
|
1
|
| staff_basic_salary | int(11) |
|
|
1
|
| staff_contract_type | int(11) |
|
|
1
|
| staff_work_shift | int(11) |
|
|
1
|
| staff_work_location | int(11) |
|
|
1
|
| staff_leaves | int(11) |
|
|
1
|
| staff_account_details | int(11) |
|
|
1
|
| staff_social_media | int(11) |
|
|
1
|
| staff_upload_documents | int(11) |
|
|
1
|
| mobile_api_url | tinytext |
|
|
|
| app_primary_color_code | varchar(20) |
|
|
|
| app_secondary_color_code | varchar(20) |
|
|
|
| app_logo | varchar(250) |
|
|
|
| created_at | timestamp |
|
|
current_timestamp()
|
| updated_at | date |
|
|
|
