|
sl_id
|
int(11)
|
|
|
|
|
trust_name
|
varchar(100)
|
|
|
|
|
institution_name
|
text
|
|
|
|
|
address1
|
varchar(150)
|
|
|
|
|
address2
|
varchar(150)
|
|
|
|
|
city
|
varchar(50)
|
|
|
|
|
city_code
|
varchar(20)
|
|
|
|
|
contact1
|
varchar(12)
|
|
|
|
|
contact2
|
varchar(12)
|
|
|
|
|
logo_1
|
text
|
|
|
|
|
logo_2
|
text
|
|
|
|
|
certified_no
|
varchar(20)
|
|
|
|
|
certify_details
|
varchar(150)
|
|
|
|
|
school_latitude
|
double
|
|
|
|
|
school_longitude
|
double
|
|
|
|
|
website
|
varchar(50)
|
|
|
|
|
email
|
varchar(100)
|
|
|
|
|
facebook
|
varchar(150)
|
|
|
|
|
twitter
|
varchar(150)
|
|
|
|
|
bank_current_ac
|
varchar(50)
|
|
|
|
|
bank_ifsc_code
|
varchar(50)
|
|
|
|
|
bank_name
|
varchar(100)
|
|
|
|
|
bank_branch
|
varchar(100)
|
|
|
|
|
bank_city
|
varchar(100)
|
|
|
|
|
active_status
|
tinyint(4)
|
|
|
1
|
|
modified_at
|
datetime
|
|
|
current_timestamp()
|