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