abcschool2

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	1138	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

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	7	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	2	A	No
chat_user_one	BTREE	No	No	chat_user_one	2	A	No
chat_user_two	BTREE	No	No	chat_user_two	2	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	5	A	No
chat_user_id	BTREE	No	No	chat_user_id	5	A	No
chat_connection_id	BTREE	No	No	chat_connection_id	5	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	3	A	No
staff_id	BTREE	No	No	staff_id	3	A	Yes
student_id	BTREE	No	No	student_id	3	A	Yes
create_staff_id	BTREE	No	No	create_staff_id	3	A	Yes
create_student_id	BTREE	No	No	create_student_id	3	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	13	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	152	A	No
class_id	BTREE	No	No	class_id	30	A	Yes
section_id	BTREE	No	No	section_id	38	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	0	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	14	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	19	A	No
content_id	BTREE	No	No	content_id	19	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	0	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	4	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	0	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

abcschool2

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