|
id
|
int(11)
|
|
|
|
|
parent_id
|
int(11)
|
|
|
|
|
admission_no
|
varchar(100)
|
utf8_general_ci
|
|
|
|
roll_no
|
varchar(100)
|
utf8_general_ci
|
|
|
|
admission_date
|
date
|
|
|
|
|
firstname
|
varchar(100)
|
utf8_general_ci
|
|
|
|
lastname
|
varchar(100)
|
utf8_general_ci
|
|
|
|
rte
|
varchar(20)
|
utf8_general_ci
|
|
|
|
image
|
varchar(100)
|
utf8_general_ci
|
|
|
|
mobileno
|
varchar(100)
|
utf8_general_ci
|
|
|
|
email
|
varchar(100)
|
utf8_general_ci
|
|
|
|
state
|
varchar(100)
|
utf8_general_ci
|
|
|
|
city
|
varchar(100)
|
utf8_general_ci
|
|
|
|
pincode
|
varchar(100)
|
utf8_general_ci
|
|
|
|
religion
|
varchar(100)
|
utf8_general_ci
|
|
|
|
cast
|
varchar(50)
|
utf8_general_ci
|
|
|
|
dob
|
date
|
|
|
|
|
gender
|
varchar(100)
|
utf8_general_ci
|
|
|
|
current_address
|
text
|
utf8_general_ci
|
|
|
|
permanent_address
|
text
|
utf8_general_ci
|
|
|
|
category_id
|
varchar(100)
|
utf8_general_ci
|
|
|
|
route_id
|
int(11)
|
|
|
|
|
school_house_id
|
int(11)
|
|
|
|
|
blood_group
|
varchar(200)
|
utf8_general_ci
|
|
|
|
vehroute_id
|
int(11)
|
|
|
|
|
hostel_room_id
|
int(11)
|
|
|
|
|
adhar_no
|
varchar(100)
|
utf8_general_ci
|
|
|
|
samagra_id
|
varchar(100)
|
utf8_general_ci
|
|
|
|
bank_account_no
|
varchar(100)
|
utf8_general_ci
|
|
|
|
bank_name
|
varchar(100)
|
utf8_general_ci
|
|
|
|
ifsc_code
|
varchar(100)
|
utf8_general_ci
|
|
|
|
guardian_is
|
varchar(100)
|
utf8_general_ci
|
|
|
|
father_name
|
varchar(100)
|
utf8_general_ci
|
|
|
|
father_phone
|
varchar(100)
|
utf8_general_ci
|
|
|
|
father_occupation
|
varchar(100)
|
utf8_general_ci
|
|
|
|
mother_name
|
varchar(100)
|
utf8_general_ci
|
|
|
|
mother_phone
|
varchar(100)
|
utf8_general_ci
|
|
|
|
mother_occupation
|
varchar(100)
|
utf8_general_ci
|
|
|
|
guardian_name
|
varchar(100)
|
utf8_general_ci
|
|
|
|
guardian_relation
|
varchar(100)
|
utf8_general_ci
|
|
|
|
guardian_phone
|
varchar(100)
|
utf8_general_ci
|
|
|
|
guardian_occupation
|
varchar(150)
|
utf8_general_ci
|
|
|
|
guardian_address
|
text
|
utf8_general_ci
|
|
|
|
guardian_email
|
varchar(100)
|
utf8_general_ci
|
|
|
|
father_pic
|
varchar(200)
|
utf8_general_ci
|
|
|
|
mother_pic
|
varchar(200)
|
utf8_general_ci
|
|
|
|
guardian_pic
|
varchar(200)
|
utf8_general_ci
|
|
|
|
is_active
|
varchar(255)
|
utf8_general_ci
|
|
|
|
previous_school
|
text
|
utf8_general_ci
|
|
|
|
height
|
varchar(100)
|
utf8_general_ci
|
|
|
|
weight
|
varchar(100)
|
utf8_general_ci
|
|
|
|
measurement_date
|
date
|
|
|
|
|
dis_reason
|
int(11)
|
|
|
|
|
note
|
varchar(200)
|
utf8_general_ci
|
|
|
|
dis_note
|
text
|
utf8_general_ci
|
|
|
|
app_key
|
text
|
utf8_general_ci
|
|
|
|
parent_app_key
|
text
|
utf8_general_ci
|
|
|
|
disable_at
|
date
|
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
date
|
|
|
|
`abcschool333`.`expenses`