smartschool

attendence_type

Column	Type	Null	Default
id (Primary)	int(11)	No
type	varchar(50)	Yes	NULL
key_value	varchar(50)	No
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	6	A	No

books

Column	Type	Null	Default
id (Primary)	int(11)	No
book_title	varchar(100)	No
book_no	varchar(50)	No
isbn_no	varchar(100)	No
subject	varchar(100)	Yes	NULL
rack_no	varchar(100)	No
publish	varchar(100)	Yes	NULL
author	varchar(100)	Yes	NULL
qty	int(11)	Yes	NULL
perunitcost	float(10,2)	Yes	NULL
postdate	date	Yes	NULL
description	text	Yes	NULL
available	varchar(10)	Yes	yes
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1099	A	No

book_issues

Column	Type	Null	Default
id (Primary)	int(11)	No
book_id	int(11)	Yes	NULL
duereturn_date	date	Yes	NULL
return_date	date	Yes	NULL
issue_date	date	Yes	NULL
is_returned	int(11)	Yes	0
member_id	int(11)	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

certificates

Column	Type	Null	Default	Comments
id (Primary)	int(11)	No
certificate_name	varchar(100)	No
certificate_text	text	No
left_header	varchar(100)	No
center_header	varchar(100)	No
right_header	varchar(100)	No
left_footer	varchar(100)	No
right_footer	varchar(100)	No
center_footer	varchar(100)	No
background_image	varchar(100)	No
created_at	timestamp	Yes	current_timestamp()
updated_at	date	Yes	NULL
created_for	tinyint(1)	No		1 = staff, 2 = students
status	tinyint(1)	No
header_height	int(11)	No
content_height	int(11)	No
footer_height	int(11)	No
content_width	int(11)	No
enable_student_image	tinyint(1)	No		0=no,1=yes
enable_image_height	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

chat_connections

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
chat_user_one	int(11)	No		chat_users -> id
chat_user_two	int(11)	No		chat_users -> id
ip	varchar(30)	Yes	NULL
time	int(11)	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	7	A	No
chat_user_one	BTREE	No	No	chat_user_one	7	A	No
chat_user_two	BTREE	No	No	chat_user_two	7	A	No

chat_messages

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
message	text	Yes	NULL
chat_user_id	int(11)	No		chat_users -> id
ip	varchar(30)	No
time	int(11)	No
is_first	int(1)	Yes	0
is_read	int(1)	No	0
chat_connection_id	int(11)	No		chat_connections -> id
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	17	A	No
chat_user_id	BTREE	No	No	chat_user_id	17	A	No
chat_connection_id	BTREE	No	No	chat_connection_id	17	A	No

chat_users

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
user_type	varchar(20)	Yes	NULL
staff_id	int(11)	Yes	NULL	staff -> id
student_id	int(11)	Yes	NULL	students -> id
create_staff_id	int(11)	Yes	NULL	staff -> id
create_student_id	int(11)	Yes	NULL	students -> id
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	12	A	No
staff_id	BTREE	No	No	staff_id	12	A	Yes
student_id	BTREE	No	No	student_id	12	A	Yes
create_staff_id	BTREE	No	No	create_staff_id	6	A	Yes
create_student_id	BTREE	No	No	create_student_id	12	A	Yes

classes

Column	Type	Null	Default
id (Primary)	int(11)	No
class	varchar(60)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	54	A	No

class_sections

Column	Type	Null	Default
id (Primary)	int(11)	No
class_id	int(11)	Yes	NULL
section_id	int(11)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	688	A	No
class_id	BTREE	No	No	class_id	114	A	Yes
section_id	BTREE	No	No	section_id	32	A	Yes

class_teacher

Column	Type	Null
id (Primary)	int(11)	No
class_id	int(11)	No
staff_id	int(11)	No
section_id	int(11)	No
session_id	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	14	A	No

complaint

Column	Type	Null
id (Primary)	int(11)	No
complaint_type	varchar(255)	No
source	varchar(15)	No
name	varchar(100)	No
contact	varchar(15)	No
email	varchar(200)	No
date	date	No
description	text	No
action_taken	varchar(200)	No
assigned	varchar(50)	No
note	text	No
image	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

complaint_type

Column	Type	Null	Default
id (Primary)	int(11)	No
complaint_type	varchar(100)	No
description	mediumtext	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	3	A	No

Column	Type	Null	Default
id (Primary)	int(11)	No
title	varchar(100)	Yes	NULL
type	varchar(50)	Yes	NULL
is_public	varchar(10)	Yes	No
class_id	int(11)	Yes	NULL
cls_sec_id	int(10)	No
file	varchar(250)	Yes	NULL
created_by	int(11)	No
note	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
date	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	92	A	No

content_for

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
role	varchar(50)	Yes	NULL
content_id	int(11)	Yes	NULL	contents -> id
user_id	int(11)	Yes	NULL	users -> id
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	131	A	No
content_id	BTREE	No	No	content_id	131	A	Yes
user_id	BTREE	No	No	user_id	2	A	Yes

custom_fields

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	Yes	NULL
belong_to	varchar(100)	Yes	NULL
type	varchar(100)	Yes	NULL
bs_column	int(10)	Yes	NULL
validation	int(11)	Yes	0
field_values	text	Yes	NULL
show_table	varchar(100)	Yes	NULL
visible_on_table	int(11)	No
weight	int(11)	Yes	NULL
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

custom_field_values

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
belong_table_id	int(11)	Yes	NULL
custom_field_id	int(11)	Yes	NULL	custom_fields -> id
field_value	longtext	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
custom_field_id	BTREE	No	No	custom_field_id	0	A	Yes

department

Column	Type	Null
id (Primary)	int(11)	No
department_name	varchar(200)	No
is_active	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	6	A	No

disable_reason

Column	Type	Null	Default
id (Primary)	int(11)	No
reason	varchar(255)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No

dispatch_receive

Column	Type	Null	Default
id (Primary)	int(11)	No
reference_no	varchar(50)	No
to_title	varchar(100)	No
address	varchar(500)	No
note	varchar(500)	No
from_title	varchar(200)	No
date	varchar(20)	No
image	varchar(100)	No
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
type	varchar(10)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

email_config

Column	Type	Null	Default
id (Primary)	int(11)	No
email_type	varchar(100)	Yes	NULL
smtp_server	varchar(100)	Yes	NULL
smtp_port	varchar(100)	Yes	NULL
smtp_username	varchar(100)	Yes	NULL
smtp_password	varchar(100)	Yes	NULL
ssl_tls	varchar(100)	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

enquiry

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	No
contact	varchar(20)	No
address	mediumtext	No
reference	varchar(20)	No
date	date	No
description	varchar(500)	No
follow_up_date	date	No
note	mediumtext	No
source	varchar(50)	No
email	varchar(50)	Yes	NULL
assigned	varchar(100)	No
class	int(11)	No
no_of_child	varchar(11)	Yes	NULL
status	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

enquiry_type

Column	Type	Null
id (Primary)	int(11)	No
enquiry_type	varchar(100)	No
description	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

events

Column	Type	Null
id (Primary)	int(11)	No
event_title	varchar(200)	No
event_description	varchar(300)	No
start_date	datetime	No
end_date	datetime	No
event_type	varchar(100)	No
event_color	varchar(200)	No
event_for	varchar(100)	No
role_id	int(11)	No
is_active	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	10	A	No

exams

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(200)	Yes	NULL
sesion_id	int(11)	No
note	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

exam_groups

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(250)	Yes	NULL
exam_type	varchar(250)	Yes	NULL
description	text	Yes	NULL
is_active	int(11)	Yes	1
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

exam_group_class_batch_exams

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam	varchar(250)	Yes	NULL
session_id	int(10)	No
date_from	date	Yes	NULL
date_to	date	Yes	NULL
description	text	Yes	NULL
exam_group_id	int(11)	Yes	NULL	exam_groups -> id
is_publish	int(1)	Yes	0
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
exam_group_id	BTREE	No	No	exam_group_id	0	A	Yes

exam_group_class_batch_exam_students

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam_group_class_batch_exam_id	int(11)	No		exam_group_class_batch_exams -> id
student_id	int(11)	No		students -> id
student_session_id	int(11)	No		student_session -> id
roll_no	int(6)	No	0
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_group_class_batch_exam_id	BTREE	No	No	exam_group_class_batch_exam_id	A	No
student_id	BTREE	No	No	student_id	A	No
student_session_id	BTREE	No	No	student_session_id	A	No

exam_group_class_batch_exam_subjects

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam_group_class_batch_exams_id	int(11)	Yes	NULL	exam_group_class_batch_exams -> id
subject_id	int(10)	No		subjects -> id
date_from	date	No
time_from	time	No
duration	varchar(50)	No
room_no	varchar(100)	Yes	NULL
max_marks	float(10,2)	Yes	NULL
min_marks	float(10,2)	Yes	NULL
credit_hours	float(10,2)	Yes	0.00
date_to	datetime	Yes	NULL
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_group_class_batch_exams_id	BTREE	No	No	exam_group_class_batch_exams_id	A	Yes
subject_id	BTREE	No	No	subject_id	A	No

exam_group_exam_connections

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam_group_id	int(11)	Yes	NULL	exam_groups -> id
exam_group_class_batch_exams_id	int(11)	Yes	NULL	exam_group_class_batch_exams -> id
exam_weightage	float(10,2)	Yes	0.00
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_group_id	BTREE	No	No	exam_group_id	A	Yes
exam_group_class_batch_exams_id	BTREE	No	No	exam_group_class_batch_exams_id	A	Yes

exam_group_exam_results

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam_group_class_batch_exam_student_id	int(11)	No		exam_group_class_batch_exam_students -> id
exam_group_class_batch_exam_subject_id	int(11)	Yes	NULL	exam_group_class_batch_exam_subjects -> id
attendence	varchar(10)	Yes	NULL
get_marks	float(10,2)	Yes	0.00
note	text	Yes	NULL
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
exam_group_student_id	int(11)	Yes	NULL	exam_group_students -> id

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_group_class_batch_exam_subject_id	BTREE	No	No	exam_group_class_batch_exam_subject_id	A	Yes
exam_group_student_id	BTREE	No	No	exam_group_student_id	A	Yes
exam_group_class_batch_exam_student_id	BTREE	No	No	exam_group_class_batch_exam_student_id	A	No

exam_group_students

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam_group_id	int(11)	Yes	NULL	exam_groups -> id
student_id	int(11)	Yes	NULL	students -> id
student_session_id	int(10)	Yes	NULL
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_group_id	BTREE	No	No	exam_group_id	A	Yes
student_id	BTREE	No	No	student_id	A	Yes

exam_results

Column	Type	Null	Default
id (Primary)	int(11)	No
attendence	varchar(10)	No
exam_schedule_id	int(11)	Yes	NULL
student_id	int(11)	Yes	NULL
get_marks	float(10,2)	Yes	NULL
note	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
exam_schedule_id	BTREE	No	No	exam_schedule_id	A	Yes
student_id	BTREE	No	No	student_id	A	Yes

exam_schedules

Column	Type	Null	Default
id (Primary)	int(11)	No
session_id	int(11)	No
exam_id	int(11)	Yes	NULL
teacher_subject_id	int(11)	Yes	NULL
date_of_exam	date	Yes	NULL
start_to	varchar(50)	Yes	NULL
end_from	varchar(50)	Yes	NULL
room_no	varchar(50)	Yes	NULL
full_marks	int(11)	Yes	NULL
passing_marks	int(11)	Yes	NULL
note	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
teacher_subject_id	BTREE	No	No	teacher_subject_id	0	A	Yes

expenses

Column	Type	Null	Default
id (Primary)	int(11)	No
exp_head_id	int(11)	Yes	NULL
name	varchar(50)	Yes	NULL
invoice_no	varchar(200)	No
date	date	Yes	NULL
amount	float(10,2)	Yes	NULL
documents	varchar(255)	Yes	NULL
note	text	Yes	NULL
is_active	varchar(255)	Yes	yes
is_deleted	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

expense_head

Column	Type	Null	Default
id (Primary)	int(11)	No
exp_category	varchar(50)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(255)	Yes	yes
is_deleted	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

feecategory

Column	Type	Null	Default
id (Primary)	int(11)	No
category	varchar(50)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

feemasters

Column	Type	Null	Default
id (Primary)	int(11)	No
session_id	int(11)	Yes	NULL
feetype_id	int(11)	No
class_id	int(11)	Yes	NULL
amount	float(10,2)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

fees_discounts

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
session_id	int(11)	Yes	NULL	sessions -> id
name	varchar(100)	Yes	NULL
code	varchar(100)	Yes	NULL
amount	decimal(10,2)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
session_id	BTREE	No	No	session_id	0	A	Yes

fees_reminder

Column	Type	Null	Default
id (Primary)	int(11)	No
reminder_type	varchar(10)	Yes	NULL
day	int(2)	Yes	NULL
is_active	int(1)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No

feetype

Column	Type	Null	Default
id (Primary)	int(11)	No
is_system	int(1)	No	0
feecategory_id	int(11)	Yes	NULL
type	varchar(50)	Yes	NULL
code	varchar(100)	No
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
description	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	314	A	No

fee_groups

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(200)	Yes	NULL
is_system	int(1)	No	0
description	text	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	42	A	No

fee_groups_feetype

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
fee_session_group_id	int(11)	Yes	NULL	fee_session_groups -> id
fee_groups_id	int(11)	Yes	NULL	fee_groups -> id
feetype_id	int(11)	Yes	NULL	feetype -> id
session_id	int(11)	Yes	NULL	sessions -> id
amount	decimal(10,2)	Yes	NULL
fine_type	varchar(50)	No	none
due_date	date	Yes	NULL
fine_percentage	float(10,2)	No	0.00
fine_amount	float(10,2)	No	0.00
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	143	A	No
fee_session_group_id	BTREE	No	No	fee_session_group_id	23	A	Yes
fee_groups_id	BTREE	No	No	fee_groups_id	23	A	Yes
feetype_id	BTREE	No	No	feetype_id	143	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes

fee_receipt_no

Column	Type	Null	Default	Links to	Comments	Media (MIME) type
id (Primary)	int(11)	No
payment	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

fee_session_groups

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
fee_groups_id	int(11)	Yes	NULL	fee_groups -> id
session_id	int(11)	Yes	NULL	sessions -> id
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	12	A	No
fee_groups_id	BTREE	No	No	fee_groups_id	12	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes

follow_up

Column	Type	Null
id (Primary)	int(11)	No
enquiry_id	int(11)	No
date	date	No
next_date	date	No
response	text	No
note	text	No
followup_by	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

front_cms_media_gallery

Column	Type	Null	Default
id (Primary)	int(11)	No
image	varchar(300)	Yes	NULL
thumb_path	varchar(300)	Yes	NULL
dir_path	varchar(300)	Yes	NULL
img_name	varchar(300)	Yes	NULL
thumb_name	varchar(300)	Yes	NULL
created_at	timestamp	No	current_timestamp()
file_type	varchar(100)	No
file_size	varchar(100)	No
vid_url	mediumtext	No
vid_title	varchar(250)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5	A	No

front_cms_menus

Column	Type	Null	Default
id (Primary)	int(11)	No
menu	varchar(100)	Yes	NULL
slug	varchar(200)	Yes	NULL
description	mediumtext	Yes	NULL
open_new_tab	int(10)	No	0
ext_url	mediumtext	No
ext_url_link	mediumtext	No
publish	int(11)	No	0
content_type	varchar(10)	No	manual
is_active	varchar(10)	Yes	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No

front_cms_menu_items

Column	Type	Null	Default
id (Primary)	int(11)	No
menu_id	int(11)	No
menu	varchar(100)	Yes	NULL
page_id	int(11)	No
parent_id	int(11)	No
ext_url	mediumtext	Yes	NULL
open_new_tab	int(11)	Yes	0
ext_url_link	mediumtext	Yes	NULL
slug	varchar(200)	Yes	NULL
weight	int(11)	Yes	NULL
publish	int(11)	No	0
description	mediumtext	Yes	NULL
is_active	varchar(10)	Yes	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No

front_cms_pages

Column	Type	Null	Default
id (Primary)	int(11)	No
page_type	varchar(10)	No	manual
is_homepage	int(1)	Yes	0
title	varchar(250)	Yes	NULL
url	varchar(250)	Yes	NULL
type	varchar(50)	Yes	NULL
slug	varchar(200)	Yes	NULL
meta_title	mediumtext	Yes	NULL
meta_description	mediumtext	Yes	NULL
meta_keyword	mediumtext	Yes	NULL
feature_image	varchar(200)	No
description	longtext	Yes	NULL
publish_date	date	No
publish	int(10)	Yes	0
sidebar	int(10)	Yes	0
is_active	varchar(10)	Yes	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No

front_cms_page_contents

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
page_id	int(11)	Yes	NULL	front_cms_pages -> id
content_type	varchar(50)	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
page_id	BTREE	No	No	page_id	0	A	Yes

front_cms_programs

Column	Type	Null	Default
id (Primary)	int(11)	No
type	varchar(50)	Yes	NULL
slug	varchar(255)	Yes	NULL
url	mediumtext	Yes	NULL
title	varchar(200)	Yes	NULL
date	date	Yes	NULL
event_start	date	Yes	NULL
event_end	date	Yes	NULL
event_venue	mediumtext	Yes	NULL
description	mediumtext	Yes	NULL
is_active	varchar(10)	Yes	no
created_at	timestamp	No	current_timestamp()
meta_title	mediumtext	No
meta_description	mediumtext	No
meta_keyword	mediumtext	No
feature_image	mediumtext	No
publish_date	date	No
publish	varchar(10)	Yes	0
sidebar	int(10)	Yes	0

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

front_cms_program_photos

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
program_id	int(11)	Yes	NULL	front_cms_programs -> id
media_gallery_id	int(11)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	3	A	No
program_id	BTREE	No	No	program_id	3	A	Yes

front_cms_settings

Column	Type	Null	Default
id (Primary)	int(11)	No
theme	varchar(50)	Yes	NULL
is_active_rtl	int(10)	Yes	0
is_active_front_cms	int(11)	Yes	0
is_active_sidebar	int(1)	Yes	0
logo	varchar(200)	Yes	NULL
contact_us_email	varchar(100)	Yes	NULL
complain_form_email	varchar(100)	Yes	NULL
sidebar_options	mediumtext	No
fb_url	varchar(200)	No
twitter_url	varchar(200)	No
youtube_url	varchar(200)	No
google_plus	varchar(200)	No
instagram_url	varchar(200)	No
pinterest_url	varchar(200)	No
linkedin_url	varchar(200)	No
google_analytics	mediumtext	Yes	NULL
footer_text	varchar(500)	Yes	NULL
fav_icon	varchar(250)	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

general_calls

Column	Type	Null
id (Primary)	int(11)	No
name	varchar(100)	No
contact	varchar(12)	No
date	date	No
description	varchar(500)	No
follow_up_date	date	No
call_dureation	varchar(50)	No
note	mediumtext	No
call_type	varchar(20)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

grades

Column	Type	Null	Default
id (Primary)	int(11)	No
exam_type	varchar(250)	Yes	NULL
name	varchar(100)	Yes	NULL
point	float(10,1)	Yes	NULL
mark_from	float(10,2)	Yes	NULL
mark_upto	float(10,2)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5	A	No

homework

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
class_id	int(11)	No
section_id	int(11)	No
session_id	int(10)	No
homework_date	date	No
submit_date	date	No
staff_id	int(11)	No
subject_group_subject_id	int(11)	Yes	NULL	subject_group_subjects -> id
subject_id	int(11)	No
description	varchar(500)	No
create_date	date	No
evaluation_date	date	No
document	varchar(200)	No
created_by	int(11)	No
evaluated_by	int(11)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
subject_group_subject_id	BTREE	No	No	subject_group_subject_id	0	A	Yes

homework_evaluation

Column	Type	Null	Default
id (Primary)	int(11)	No
homework_id	int(11)	No
student_id	int(11)	No
student_session_id	int(11)	Yes	NULL
date	date	No
status	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

hostel

Column	Type	Null	Default
id (Primary)	int(11)	No
hostel_name	varchar(100)	Yes	NULL
type	varchar(50)	Yes	NULL
address	text	Yes	NULL
intake	int(11)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

hostel_rooms

Column	Type	Null	Default
id (Primary)	int(11)	No
hostel_id	int(11)	Yes	NULL
room_type_id	int(11)	Yes	NULL
room_no	varchar(200)	Yes	NULL
no_of_bed	int(11)	Yes	NULL
cost_per_bed	float(10,2)	Yes	0.00
title	varchar(200)	Yes	NULL
description	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

id_card

Column	Type	Null	Comments
id (Primary)	int(11)	No
title	varchar(100)	No
school_name	varchar(100)	No
school_address	varchar(500)	No
background	varchar(100)	No
logo	varchar(100)	No
sign_image	varchar(100)	No
header_color	varchar(100)	No
enable_admission_no	tinyint(1)	No	0=disable,1=enable
enable_student_name	tinyint(1)	No	0=disable,1=enable
enable_class	tinyint(1)	No	0=disable,1=enable
enable_fathers_name	tinyint(1)	No	0=disable,1=enable
enable_mothers_name	tinyint(1)	No	0=disable,1=enable
enable_address	tinyint(1)	No	0=disable,1=enable
enable_phone	tinyint(1)	No	0=disable,1=enable
enable_dob	tinyint(1)	No	0=disable,1=enable
enable_blood_group	tinyint(1)	No	0=disable,1=enable
status	tinyint(1)	No	0=disable,1=enable

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

income

Column	Type	Null	Default
id (Primary)	int(11)	No
inc_head_id	varchar(11)	Yes	NULL
name	varchar(50)	Yes	NULL
invoice_no	varchar(200)	No
date	date	Yes	NULL
amount	float	Yes	NULL
note	text	Yes	NULL
is_active	varchar(255)	Yes	yes
is_deleted	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
documents	varchar(255)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

income_head

Column	Type	Null	Default
id (Primary)	int(255)	No
income_category	varchar(255)	Yes	NULL
description	varchar(255)	Yes	NULL
is_active	varchar(255)	No	yes
is_deleted	varchar(255)	No	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

item

Column	Type	Null	Default
id (Primary)	int(11)	No
item_category_id	int(11)	Yes	NULL
name	varchar(255)	No
unit	varchar(100)	No
item_photo	varchar(225)	Yes	NULL
description	text	No
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL
item_store_id	int(11)	Yes	NULL
item_supplier_id	int(11)	Yes	NULL
quantity	int(100)	No
date	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

item_category

Column	Type	Null	Default
id (Primary)	int(255)	No
item_category	varchar(255)	No
is_active	varchar(255)	No	yes
description	varchar(255)	No
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No

item_issue

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
issue_type	varchar(15)	Yes	NULL
issue_to	varchar(100)	Yes	NULL
issue_by	varchar(100)	Yes	NULL
issue_date	date	Yes	NULL
return_date	date	Yes	NULL
item_category_id	int(11)	Yes	NULL	item_category -> id
item_id	int(11)	Yes	NULL	item -> id
quantity	int(10)	No
note	text	No
is_returned	int(2)	No	1
created_at	timestamp	No	current_timestamp()
is_active	varchar(10)	Yes	no

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
item_id	BTREE	No	No	item_id	A	Yes
item_category_id	BTREE	No	No	item_category_id	A	Yes

item_stock

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
item_id	int(11)	Yes	NULL	item -> id
supplier_id	int(11)	Yes	NULL	item_supplier -> id
symbol	varchar(10)	No	+
store_id	int(11)	Yes	NULL	item_store -> id
quantity	int(11)	Yes	NULL
purchase_price	varchar(100)	No
date	date	No
attachment	varchar(250)	Yes	NULL
description	text	No
is_active	varchar(10)	Yes	yes
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
item_id	BTREE	No	No	item_id	A	Yes
supplier_id	BTREE	No	No	supplier_id	A	Yes
store_id	BTREE	No	No	store_id	A	Yes

item_store

Column	Type	Null
id (Primary)	int(255)	No
item_store	varchar(255)	No
code	varchar(255)	No
description	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

item_supplier

Column	Type	Null
id (Primary)	int(255)	No
item_supplier	varchar(255)	No
phone	varchar(255)	No
email	varchar(255)	No
address	varchar(255)	No
contact_person_name	varchar(255)	No
contact_person_phone	varchar(255)	No
contact_person_email	varchar(255)	No
description	text	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

languages

Column	Type	Null	Default
id (Primary)	int(11)	No
language	varchar(50)	Yes	NULL
short_code	varchar(255)	No
country_code	varchar(255)	No
is_deleted	varchar(10)	No	yes
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	73	A	No

leave_types

Column	Type	Null
id (Primary)	int(11)	No
type	varchar(200)	No
is_active	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
type	BTREE	Yes	No	type	0	A	No

libarary_members

Column	Type	Null	Default
id (Primary)	int(11)	No
library_card_no	varchar(50)	Yes	NULL
member_type	varchar(50)	Yes	NULL
member_id	int(11)	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

logs

Column	Type	Null	Default
id (Primary)	int(11)	No
message	text	Yes	NULL
record_id	int(11)	No
user_id	int(11)	Yes	NULL
action	varchar(50)	Yes	NULL
ip_address	varchar(50)	Yes	NULL
platform	varchar(50)	Yes	NULL
agent	varchar(50)	Yes	NULL
time	timestamp	No	current_timestamp()
created_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	172663	A	No

messages

Column	Type	Null	Default
id (Primary)	int(11)	No
title	varchar(200)	Yes	NULL
message	text	Yes	NULL
send_mail	varchar(10)	Yes	0
send_sms	varchar(10)	Yes	0
is_group	varchar(10)	Yes	0
is_individual	varchar(10)	Yes	0
is_class	int(10)	No	0
group_list	text	Yes	NULL
user_list	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	196	A	No

migrations

Column	Type	Null	Default	Links to	Comments	Media (MIME) type
version	bigint(20)	No

multi_class_students

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
student_id	int(11)	Yes	NULL	students -> id
student_session_id	int(11)	Yes	NULL	student_session -> id
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
student_id	BTREE	No	No	student_id	A	Yes
student_session_id	BTREE	No	No	student_session_id	A	Yes

notification_roles

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
send_notification_id	int(11)	Yes	NULL	send_notification -> id
role_id	int(11)	Yes	NULL	roles -> id
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
send_notification_id	BTREE	No	No	send_notification_id	A	Yes
role_id	BTREE	No	No	role_id	A	Yes

notification_setting

Column	Type	Null	Default
id (Primary)	int(11)	No
type	varchar(100)	Yes	NULL
is_mail	varchar(10)	Yes	0
is_sms	varchar(10)	Yes	0
is_notification	int(11)	No	0
display_notification	int(11)	No	0
template	longtext	No
variables	text	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	7	A	No

onlineexam

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
exam	text	Yes	NULL
attempt	int(11)	No
exam_from	date	Yes	NULL
exam_to	date	Yes	NULL
time_from	time	Yes	NULL
time_to	time	Yes	NULL
duration	time	No
passing_percentage	float	No	0
description	text	Yes	NULL
session_id	int(11)	Yes	NULL	sessions -> id
publish_result	int(11)	No	0
is_active	varchar(1)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2133	A	No
session_id	BTREE	No	No	session_id	2	A	Yes

onlineexam_attempts

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
onlineexam_student_id	int(11)	No		onlineexam_students -> id
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2969	A	No
onlineexam_student_id	BTREE	No	No	onlineexam_student_id	2969	A	No

onlineexam_questions

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
question_id	int(11)	Yes	NULL	questions -> id
onlineexam_id	int(11)	Yes	NULL	onlineexam -> id
session_id	int(11)	Yes	NULL	sessions -> id
is_active	varchar(1)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	142159	A	No
onlineexam_id	BTREE	No	No	onlineexam_id	3645	A	Yes
question_id	BTREE	No	No	question_id	10154	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes

onlineexam_students

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
onlineexam_id	int(11)	Yes	NULL	onlineexam -> id
student_session_id	int(11)	Yes	NULL	student_session -> id
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	3118	A	No
onlineexam_id	BTREE	No	No	onlineexam_id	3118	A	Yes
student_session_id	BTREE	No	No	student_session_id	445	A	Yes

onlineexam_student_results

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
onlineexam_student_id	int(11)	No		onlineexam_students -> id
onlineexam_question_id	int(11)	No		onlineexam_questions -> id
select_option	varchar(10)	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	195659	A	No
onlineexam_student_id	BTREE	No	No	onlineexam_student_id	4076	A	No
onlineexam_question_id	BTREE	No	No	onlineexam_question_id	195659	A	No

online_admissions

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
admission_no	varchar(100)	Yes	NULL
roll_no	varchar(100)	Yes	NULL
admission_date	date	Yes	NULL
firstname	varchar(100)	Yes	NULL
lastname	varchar(100)	Yes	NULL
rte	varchar(20)	No	No
image	varchar(100)	Yes	NULL
mobileno	varchar(100)	Yes	NULL
email	varchar(100)	Yes	NULL
state	varchar(100)	Yes	NULL
city	varchar(100)	Yes	NULL
pincode	varchar(100)	Yes	NULL
religion	varchar(100)	Yes	NULL
cast	varchar(50)	No
dob	date	Yes	NULL
gender	varchar(100)	Yes	NULL
current_address	text	Yes	NULL
permanent_address	text	Yes	NULL
category_id	int(11)	Yes	NULL
class_section_id	int(11)	Yes	NULL	class_sections -> id
route_id	int(11)	No
school_house_id	int(11)	Yes	NULL
blood_group	varchar(200)	No
vehroute_id	int(11)	No
hostel_room_id	int(11)	No
adhar_no	varchar(100)	Yes	NULL
samagra_id	varchar(100)	Yes	NULL
bank_account_no	varchar(100)	Yes	NULL
bank_name	varchar(100)	Yes	NULL
ifsc_code	varchar(100)	Yes	NULL
guardian_is	varchar(100)	No
father_name	varchar(100)	Yes	NULL
father_phone	varchar(100)	Yes	NULL
father_occupation	varchar(100)	Yes	NULL
mother_name	varchar(100)	Yes	NULL
mother_phone	varchar(100)	Yes	NULL
mother_occupation	varchar(100)	Yes	NULL
guardian_name	varchar(100)	Yes	NULL
guardian_relation	varchar(100)	Yes	NULL
guardian_phone	varchar(100)	Yes	NULL
guardian_occupation	varchar(150)	No
guardian_address	text	Yes	NULL
guardian_email	varchar(100)	No
father_pic	varchar(200)	No
mother_pic	varchar(200)	No
guardian_pic	varchar(200)	No
is_enroll	int(255)	Yes	0
previous_school	text	Yes	NULL
height	varchar(100)	No
weight	varchar(100)	No
note	varchar(200)	No
measurement_date	date	Yes	NULL
app_key	text	Yes	NULL
document	text	Yes	NULL
disable_at	date	No
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	12	A	No
class_section_id	BTREE	No	No	class_section_id	12	A	Yes

payment_settings

Column	Type	Null	Default
id (Primary)	int(11)	No
payment_type	varchar(200)	No
api_username	varchar(200)	Yes	NULL
api_secret_key	varchar(200)	No
salt	varchar(200)	No
api_publishable_key	varchar(200)	No
api_password	varchar(200)	Yes	NULL
api_signature	varchar(200)	Yes	NULL
api_email	varchar(200)	Yes	NULL
paypal_demo	varchar(100)	No
account_no	varchar(200)	No
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	7	A	No

payslip_allowance

Column	Type	Null
id (Primary)	int(11)	No
payslip_id	int(11)	No
allowance_type	varchar(200)	No
amount	int(11)	No
staff_id	int(11)	No
cal_type	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

permission_category

Column	Type	Null	Default
id (Primary)	int(11)	No
perm_group_id	int(11)	Yes	NULL
name	varchar(100)	Yes	NULL
short_code	varchar(100)	Yes	NULL
enable_view	int(11)	Yes	0
enable_add	int(11)	Yes	0
enable_edit	int(11)	Yes	0
enable_delete	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	185	A	No

permission_group

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	Yes	NULL
short_code	varchar(100)	No
is_active	int(11)	Yes	0
system	int(11)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	26	A	No

permission_parent

Column	Type	Null	Default
id (Primary)	int(11)	No
group_id	int(11)	No
name	varchar(100)	Yes	NULL
short_code	varchar(100)	No
is_active	int(11)	Yes	0
system	int(11)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	12	A	No

permission_student

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	Yes	NULL
short_code	varchar(100)	No
is_active	int(11)	Yes	0
system	int(11)	No
group_id	int(11)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	15	A	No

print_headerfooter

Column	Type	Null	Default
id (Primary)	int(11)	No
print_type	varchar(255)	No
header_image	varchar(255)	No
footer_content	text	No
created_by	int(11)	No
entry_date	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No

questions

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
subject_id	int(11)	Yes	NULL	subjects -> id
question	text	Yes	NULL
opt_a	text	Yes	NULL
opt_b	text	Yes	NULL
opt_c	text	Yes	NULL
opt_d	text	Yes	NULL
opt_e	text	Yes	NULL
correct	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5848	A	No
subject_id	BTREE	No	No	subject_id	167	A	Yes

question_answers

Column	Type	Null	Default
id (Primary)	int(11)	No
question_id	int(11)	No
option_id	int(11)	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

question_options

Column	Type	Null	Default
id (Primary)	int(11)	No
question_id	int(11)	No
option	text	No
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

read_notification

Column	Type	Null	Default
id (Primary)	int(11)	No
student_id	int(11)	Yes	NULL
parent_id	int(10)	Yes	NULL
staff_id	int(11)	Yes	NULL
notification_id	int(11)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

reference

Column	Type	Null
id (Primary)	int(11)	No
reference	varchar(100)	No
description	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

roles

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	Yes	NULL
slug	varchar(150)	Yes	NULL
is_active	int(11)	Yes	0
is_system	int(1)	No	0
is_superadmin	int(11)	No	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	17	A	No

roles_permissions

Column	Type	Null	Default
id (Primary)	int(11)	No
role_id	int(11)	Yes	NULL
perm_cat_id	int(11)	Yes	NULL
can_view	int(11)	Yes	NULL
can_add	int(11)	Yes	NULL
can_edit	int(11)	Yes	NULL
can_delete	int(11)	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	1213	A	No

room_types

Column	Type	Null	Default
id (Primary)	int(11)	No
room_type	varchar(200)	Yes	NULL
description	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

school_houses

Column	Type	Null
id (Primary)	int(11)	No
house_name	varchar(200)	No
description	varchar(400)	No
is_active	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	16	A	No

sch_settings

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

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
lang_id	BTREE	No	No	lang_id	A	Yes
session_id	BTREE	No	No	session_id	A	Yes

sections

Column	Type	Null	Default
id (Primary)	int(11)	No
section	varchar(60)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	16	A	No

send_notification

Column	Type	Null	Default
id (Primary)	int(11)	No
title	varchar(50)	Yes	NULL
publish_date	date	Yes	NULL
date	date	Yes	NULL
message	text	Yes	NULL
visible_student	varchar(10)	No	no
visible_staff	varchar(10)	No	no
visible_parent	varchar(10)	No	no
created_by	varchar(60)	Yes	NULL
created_id	int(11)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

sessions

Column	Type	Null	Default
id (Primary)	int(11)	No
session	varchar(60)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	14	A	No

sms_config

Column	Type	Null	Default
id (Primary)	int(11)	No
type	varchar(50)	No
name	varchar(100)	No
api_id	varchar(100)	No
authkey	varchar(100)	No
senderid	varchar(100)	No
contact	text	Yes	NULL
username	varchar(150)	Yes	NULL
url	varchar(150)	Yes	NULL
password	varchar(150)	Yes	NULL
is_active	varchar(255)	Yes	disabled
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

source

Column	Type	Null
id (Primary)	int(11)	No
source	varchar(100)	No
description	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No

staff

Column	Type	Null	Default
id (Primary)	int(11)	No
employee_id	varchar(200)	No
lang_id	int(11)	No
department	int(11)	Yes	0
designation	int(11)	Yes	0
qualification	varchar(200)	No
work_exp	varchar(200)	No
name	varchar(200)	No
surname	varchar(200)	No
father_name	varchar(200)	No
mother_name	varchar(200)	No
contact_no	varchar(200)	No
emergency_contact_no	varchar(200)	No
email	varchar(200)	No
dob	date	No
marital_status	varchar(100)	No
date_of_joining	date	No
date_of_leaving	date	No
local_address	varchar(300)	No
permanent_address	varchar(200)	No
note	varchar(200)	No
image	varchar(200)	No
password	varchar(250)	No
gender	varchar(50)	No
account_title	varchar(200)	No
bank_account_no	varchar(200)	No
bank_name	varchar(200)	No
ifsc_code	varchar(200)	No
bank_branch	varchar(100)	No
payscale	varchar(200)	No
basic_salary	varchar(200)	No
epf_no	varchar(200)	No
contract_type	varchar(100)	No
shift	varchar(100)	No
location	varchar(100)	No
facebook	varchar(200)	No
twitter	varchar(200)	No
linkedin	varchar(200)	No
instagram	varchar(200)	No
resume	varchar(200)	No
joining_letter	varchar(200)	No
resignation_letter	varchar(200)	No
other_document_name	varchar(200)	No
other_document_file	varchar(200)	No
user_id	int(11)	No
is_active	int(11)	No
verification_code	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	25	A	No
employee_id	BTREE	Yes	No	employee_id	25	A	No

staff_attendance

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
date	date	No
staff_id	int(11)	No		staff -> id
staff_attendance_type_id	int(11)	No		staff_attendance_type -> id
remark	varchar(200)	No
is_active	int(11)	No
created_at	datetime	No
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	278	A	No
FK_staff_attendance_staff	BTREE	No	No	staff_id	27	A	No
FK_staff_attendance_staff_attendance_type	BTREE	No	No	staff_attendance_type_id	8	A	No

staff_attendance_type

Column	Type	Null	Default
id (Primary)	int(11)	No
type	varchar(200)	No
key_value	varchar(200)	No
is_active	varchar(50)	No
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	5	A	No

staff_designation

Column	Type	Null
id (Primary)	int(11)	No
designation	varchar(200)	No
is_active	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	16	A	No

staff_leave_details

Column	Type	Null	Links to
id (Primary)	int(11)	No
staff_id	int(11)	No	staff -> id
leave_type_id	int(11)	No	leave_types -> id
alloted_leave	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
FK_staff_leave_details_staff	BTREE	No	No	staff_id	A	No
FK_staff_leave_details_leave_types	BTREE	No	No	leave_type_id	A	No

staff_leave_request

Column	Type	Null	Links to
id (Primary)	int(11)	No
staff_id	int(11)	No	staff -> id
leave_type_id	int(11)	No	leave_types -> id
leave_from	date	No
leave_to	date	No
leave_days	int(11)	No
employee_remark	varchar(200)	No
admin_remark	varchar(200)	No
status	varchar(100)	No
applied_by	varchar(200)	No
document_file	varchar(200)	No
date	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
FK_staff_leave_request_staff	BTREE	No	No	staff_id	A	No
FK_staff_leave_request_leave_types	BTREE	No	No	leave_type_id	A	No

staff_payroll

Column	Type	Null
id (Primary)	int(11)	No
basic_salary	int(11)	No
pay_scale	varchar(200)	No
grade	varchar(50)	No
is_active	varchar(50)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

staff_payslip

Column	Type	Null	Links to
id (Primary)	int(11)	No
staff_id	int(11)	No	staff -> id
basic	int(11)	No
total_allowance	int(11)	No
total_deduction	int(11)	No
leave_deduction	int(11)	No
tax	varchar(200)	No
net_salary	int(11)	No
status	varchar(100)	No
month	varchar(200)	No
year	varchar(200)	No
payment_mode	varchar(200)	No
payment_date	date	No
remark	varchar(200)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
FK_staff_payslip_staff	BTREE	No	No	staff_id	0	A	No

staff_rating

Column	Type	Null	Default	Links to	Comments
id (Primary)	int(11)	No
staff_id	int(11)	No		staff -> id
comment	text	No
rate	int(11)	No
user_id	int(11)	No
role	varchar(255)	No
status	int(11)	No			0 decline, 1 Approve
entrydt	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No
FK_staff_rating_staff	BTREE	No	No	staff_id	0	A	No

staff_roles

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
role_id	int(11)	Yes	NULL	roles -> id
staff_id	int(11)	Yes	NULL	staff -> id
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	25	A	No
role_id	BTREE	No	No	role_id	25	A	Yes
staff_id	BTREE	No	No	staff_id	25	A	Yes

staff_timeline

Column	Type	Null	Links to
id (Primary)	int(11)	No
staff_id	int(11)	No	staff -> id
title	varchar(200)	No
timeline_date	date	No
description	varchar(300)	No
document	varchar(200)	No
status	varchar(200)	No
date	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2	A	No
FK_staff_timeline_staff	BTREE	No	No	staff_id	2	A	No

students

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

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	419	A	No

student_applyleave

Column	Type	Null	Default	Comments
id (Primary)	int(11)	No
student_session_id	int(11)	No
from_date	date	No
to_date	date	No
apply_date	date	No
status	int(1)	No
created_at	timestamp	No	current_timestamp()
docs	text	No
reason	text	No
approve_by	int(11)	No
request_type	int(11)	No		0 student,1 staff

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

student_attendences

Column	Type	Null	Default
id (Primary)	int(11)	No
student_session_id	int(11)	Yes	NULL
biometric_attendence	int(1)	No	0
date	date	Yes	NULL
attendence_type_id	int(11)	Yes	NULL
remark	varchar(200)	No
biometric_device_data	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	2	A	No
student_session_id	BTREE	No	No	student_session_id	2	A	Yes
attendence_type_id	BTREE	No	No	attendence_type_id	2	A	Yes

student_doc

Column	Type	Null	Default
id (Primary)	int(11)	No
student_id	int(11)	Yes	NULL
title	varchar(200)	Yes	NULL
doc	varchar(200)	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

student_fees

Column	Type	Null	Default
id (Primary)	int(11)	No
student_session_id	int(11)	Yes	NULL
feemaster_id	int(11)	Yes	NULL
amount	float(10,2)	Yes	NULL
amount_discount	float(10,2)	No
amount_fine	float(10,2)	No	0.00
description	text	Yes	NULL
date	date	Yes	NULL
payment_mode	varchar(50)	No
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

student_fees_deposite

Column	Type	Null	Default
id (Primary)	int(11)	No
student_fees_master_id	int(11)	Yes	NULL
fee_groups_feetype_id	int(11)	Yes	NULL
amount_detail	text	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
student_fees_master_id	BTREE	No	No	student_fees_master_id	A	Yes
fee_groups_feetype_id	BTREE	No	No	fee_groups_feetype_id	A	Yes

student_fees_discounts

Column	Type	Null	Default
id (Primary)	int(11)	No
student_session_id	int(11)	Yes	NULL
fees_discount_id	int(11)	Yes	NULL
status	varchar(20)	Yes	assigned
payment_id	varchar(50)	Yes	NULL
description	text	Yes	NULL
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
student_session_id	BTREE	No	No	student_session_id	A	Yes
fees_discount_id	BTREE	No	No	fees_discount_id	A	Yes

student_fees_master

Column	Type	Null	Default
id (Primary)	int(11)	No
is_system	int(1)	No	0
student_session_id	int(11)	Yes	NULL
fee_session_group_id	int(11)	Yes	NULL
amount	float(10,2)	Yes	0.00
is_active	varchar(10)	No	no
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	13	A	No
student_session_id	BTREE	No	No	student_session_id	13	A	Yes
fee_session_group_id	BTREE	No	No	fee_session_group_id	2	A	Yes

student_session

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
session_id	int(11)	Yes	NULL	sessions -> id
student_id	int(11)	Yes	NULL	students -> id
class_id	int(11)	Yes	NULL	classes -> id
section_id	int(11)	Yes	NULL	sections -> id
route_id	int(11)	No
hostel_room_id	int(11)	No
vehroute_id	int(10)	Yes	NULL
transport_fees	float(10,2)	No	0.00
fees_discount	float(10,2)	No	0.00
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	427	A	No
session_id	BTREE	No	No	session_id	4	A	Yes
student_id	BTREE	No	No	student_id	427	A	Yes
class_id	BTREE	No	No	class_id	85	A	Yes
section_id	BTREE	No	No	section_id	28	A	Yes

student_sibling

Column	Type	Null	Default
id (Primary)	int(11)	No
student_id	int(11)	Yes	NULL
sibling_student_id	int(11)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

student_subject_attendances

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
student_session_id	int(11)	Yes	NULL	student_session -> id
subject_timetable_id	int(11)	Yes	NULL	subject_timetable -> id
attendence_type_id	int(11)	Yes	NULL	attendence_type -> id
date	date	Yes	NULL
remark	text	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
attendence_type_id	BTREE	No	No	attendence_type_id	A	Yes
student_session_id	BTREE	No	No	student_session_id	A	Yes
subject_timetable_id	BTREE	No	No	subject_timetable_id	A	Yes

student_timeline

Column	Type	Null
id (Primary)	int(11)	No
student_id	int(11)	No
title	varchar(200)	No
timeline_date	date	No
description	varchar(200)	No
document	varchar(200)	No
status	varchar(200)	No
date	date	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

subjects

Column	Type	Null	Default
id (Primary)	int(11)	No
name	varchar(100)	Yes	NULL
code	varchar(100)	No
type	varchar(100)	No
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	145	A	No

subject_groups

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
name	varchar(250)	Yes	NULL
description	text	Yes	NULL
session_id	int(11)	Yes	NULL	sessions -> id
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	57	A	No
session_id	BTREE	No	No	session_id	2	A	Yes

subject_group_class_sections

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
subject_group_id	int(11)	Yes	NULL	subject_groups -> id
class_section_id	int(11)	Yes	NULL	class_sections -> id
session_id	int(11)	Yes	NULL	sessions -> id
description	text	Yes	NULL
is_active	int(11)	Yes	0
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	46	A	No
class_section_id	BTREE	No	No	class_section_id	46	A	Yes
subject_group_id	BTREE	No	No	subject_group_id	46	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes

subject_group_subjects

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
subject_group_id	int(11)	Yes	NULL	subject_groups -> id
session_id	int(11)	Yes	NULL	sessions -> id
subject_id	int(11)	Yes	NULL	subjects -> id
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	164	A	No
subject_group_id	BTREE	No	No	subject_group_id	164	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes
subject_id	BTREE	No	No	subject_id	164	A	Yes

subject_timetable

Column	Type	Null	Default	Links to
id (Primary)	int(11)	No
day	varchar(20)	Yes	NULL
class_id	int(11)	Yes	NULL	classes -> id
section_id	int(11)	Yes	NULL	sections -> id
subject_group_id	int(11)	Yes	NULL	subject_groups -> id
subject_group_subject_id	int(11)	Yes	NULL	subject_group_subjects -> id
staff_id	int(11)	Yes	NULL	staff -> id
time_from	varchar(20)	Yes	NULL
time_to	varchar(20)	Yes	NULL
room_no	varchar(20)	Yes	NULL
session_id	int(11)	Yes	NULL	sessions -> id
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	id	37	A	No
class_id	BTREE	No	No	class_id	12	A	Yes
section_id	BTREE	No	No	section_id	9	A	Yes
subject_group_id	BTREE	No	No	subject_group_id	18	A	Yes
subject_group_subject_id	BTREE	No	No	subject_group_subject_id	37	A	Yes
staff_id	BTREE	No	No	staff_id	18	A	Yes
session_id	BTREE	No	No	session_id	2	A	Yes

submit_assignment

Column	Type	Null	Default
id (Primary)	int(11)	No
homework_id	int(11)	No
student_id	int(11)	No
message	text	No
docs	varchar(225)	No
file_name	text	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

teacher_subjects

Column	Type	Null	Default
id (Primary)	int(11)	No
session_id	int(11)	Yes	NULL
class_section_id	int(11)	Yes	NULL
subject_id	int(11)	Yes	NULL
teacher_id	int(11)	Yes	NULL
description	varchar(100)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Collation	Null
PRIMARY	BTREE	Yes	No	id	A	No
class_section_id	BTREE	No	No	class_section_id	A	Yes
session_id	BTREE	No	No	session_id	A	Yes
subject_id	BTREE	No	No	subject_id	A	Yes
teacher_id	BTREE	No	No	teacher_id	A	Yes

template_admitcards

Column	Type	Null	Default
id (Primary)	int(11)	No
template	varchar(250)	Yes	NULL
heading	text	Yes	NULL
title	text	Yes	NULL
left_logo	varchar(200)	Yes	NULL
right_logo	varchar(200)	Yes	NULL
exam_name	varchar(200)	Yes	NULL
school_name	varchar(200)	Yes	NULL
exam_center	varchar(200)	Yes	NULL
sign	varchar(200)	Yes	NULL
background_img	varchar(200)	Yes	NULL
is_name	int(1)	No	1
is_father_name	int(1)	No	1
is_mother_name	int(1)	No	1
is_dob	int(1)	No	1
is_admission_no	int(1)	No	1
is_roll_no	int(1)	No	1
is_address	int(1)	No	1
is_gender	int(1)	No	1
is_photo	int(11)	No
is_class	int(11)	No	0
is_section	int(11)	No	0
content_footer	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

template_marksheets

Column	Type	Null	Default
id (Primary)	int(11)	No
template	varchar(200)	Yes	NULL
heading	text	Yes	NULL
title	text	Yes	NULL
left_logo	varchar(200)	Yes	NULL
right_logo	varchar(200)	Yes	NULL
exam_name	varchar(200)	Yes	NULL
school_name	varchar(200)	Yes	NULL
exam_center	varchar(200)	Yes	NULL
left_sign	varchar(200)	Yes	NULL
middle_sign	varchar(200)	Yes	NULL
right_sign	varchar(200)	Yes	NULL
exam_session	int(1)	Yes	1
is_name	int(1)	Yes	1
is_father_name	int(1)	Yes	1
is_mother_name	int(1)	Yes	1
is_dob	int(1)	Yes	1
is_admission_no	int(1)	Yes	1
is_roll_no	int(1)	Yes	1
is_photo	int(11)	Yes	1
is_division	int(1)	No	1
is_customfield	int(1)	No
background_img	varchar(200)	Yes	NULL
date	varchar(20)	Yes	NULL
is_class	int(11)	No	0
is_section	int(11)	No	0
content	text	Yes	NULL
content_footer	text	Yes	NULL
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

timetables

Column	Type	Null	Default
id (Primary)	int(11)	No
teacher_subject_id	int(20)	Yes	NULL
day_name	varchar(50)	Yes	NULL
start_time	varchar(50)	Yes	NULL
end_time	varchar(50)	Yes	NULL
room_no	varchar(50)	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

transport_route

Column	Type	Null	Default
id (Primary)	int(11)	No
route_title	varchar(100)	Yes	NULL
no_of_vehicle	int(11)	Yes	NULL
fare	float(10,2)	Yes	NULL
note	text	Yes	NULL
is_active	varchar(255)	Yes	no
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

userlog

Column	Type	Null	Default
id (Primary)	int(11)	No
user	varchar(100)	Yes	NULL
role	varchar(100)	Yes	NULL
ipaddress	varchar(100)	Yes	NULL
user_agent	varchar(500)	Yes	NULL
login_datetime	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	16505	A	No

users

Column	Type	Null	Default
id (Primary)	int(11)	No
user_id	int(10)	No
username	varchar(50)	Yes	NULL
password	varchar(50)	Yes	NULL
childs	text	No
role	varchar(30)	No
verification_code	varchar(200)	No
lang_id	int(11)	No
is_active	varchar(255)	Yes	yes
created_at	timestamp	No	current_timestamp()
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	832	A	No

users_authentication

Column	Type	Null	Default
id (Primary)	int(11)	No
users_id	int(11)	No
token	varchar(255)	No
expired_at	timestamp	No	current_timestamp()
created_at	date	Yes	NULL
updated_at	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

vehicles

Column	Type	Null	Default
id (Primary)	int(10)	No
vehicle_no	varchar(20)	Yes	NULL
vehicle_model	varchar(100)	No	None
manufacture_year	varchar(4)	Yes	NULL
driver_name	varchar(50)	Yes	NULL
driver_licence	varchar(50)	No	None
driver_contact	varchar(20)	Yes	NULL
note	text	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

vehicle_routes

Column	Type	Null	Default
id (Primary)	int(11)	No
route_id	int(11)	Yes	NULL
vehicle_id	int(11)	Yes	NULL
created_at	timestamp	No	current_timestamp()

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	0	A	No

visitors_book

Column	Type	Null	Default
id (Primary)	int(11)	No
source	varchar(100)	Yes	NULL
purpose	varchar(255)	No
name	varchar(100)	No
email	varchar(100)	Yes	NULL
contact	varchar(12)	No
id_proof	varchar(50)	No
no_of_pepple	int(11)	No
date	date	No
in_time	varchar(20)	No
out_time	varchar(20)	No
note	mediumtext	No
image	varchar(100)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	275	A	No

visitors_purpose

Column	Type	Null
id (Primary)	int(11)	No
visitors_purpose	varchar(100)	No
description	mediumtext	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	4	A	No

smartschool

attendence_type

Indexes

books

Indexes

book_issues

Indexes

categories

Indexes

certificates

Indexes

chat_connections

Indexes

chat_messages

Indexes

chat_users

Indexes

classes

Indexes

class_sections

Indexes

class_teacher

Indexes

complaint

Indexes

complaint_type

Indexes

contents

Indexes

content_for

Indexes

custom_fields

Indexes

custom_field_values

Indexes

department

Indexes

disable_reason

Indexes

dispatch_receive

Indexes

email_config

Indexes

enquiry

Indexes

enquiry_type

Indexes

events

Indexes

exams

Indexes

exam_groups

Indexes

exam_group_class_batch_exams

Indexes

exam_group_class_batch_exam_students

Indexes

exam_group_class_batch_exam_subjects

Indexes

exam_group_exam_connections

Indexes

exam_group_exam_results

Indexes

exam_group_students

Indexes

exam_results

Indexes

exam_schedules

Indexes

expenses

Indexes

expense_head

Indexes

feecategory

Indexes

feemasters

Indexes

fees_discounts

Indexes

fees_reminder