My Project - Project Analysis Dashboard

Table Name	Records	Columns	Primary Key	Actions
abacus_activities	0	14	id

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
activity_id	int(11)	NO	MUL	NULL
resource_id	int(11)	NO	MUL	NULL
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
assessment_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO		NULL
assigned_by	int(11)	NO		NULL
assigned_at	datetime	NO		NULL
due_date	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
assessment_id	int(11)	NO	MUL	NULL
marks_obtained	decimal(5,2)	NO		NULL
status	varchar(20)	NO	MUL	NULL
feedback	text	YES		NULL
submitted_date	datetime	NO		NULL
evaluated_by	int(11)	YES		NULL
evaluation_date	datetime	YES		NULL
created_at	datetime	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
level_id	int(11)	NO	MUL	NULL
unit_id	int(11)	YES	MUL	NULL
topic_id	int(11)	YES	MUL	NULL
assessment_name	varchar(100)	NO		NULL
description	text	YES		NULL
assessment_type	varchar(50)	NO	MUL	NULL
total_marks	int(11)	NO		NULL
passing_marks	int(11)	NO		NULL
duration	varchar(50)	YES		NULL
instructions	text	YES		NULL
is_active	tinyint(1)	NO	MUL	1
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	NO	MUL	NULL
level_id	int(11)	NO		NULL
assigned_by	int(11)	NO		NULL
assigned_at	datetime	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
level_name	varchar(100)	NO		NULL
description	text	YES		NULL
level_order	int(11)	NO		0
is_active	tinyint(1)	NO		1
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
unit_id	int(11)	NO	MUL	NULL
topic_name	varchar(100)	NO		NULL
description	text	YES		NULL
content	longtext	YES		NULL
topic_order	int(11)	NO	MUL	0
is_active	tinyint(1)	NO	MUL	1
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
level_id	int(11)	NO	MUL	NULL
unit_name	varchar(100)	NO		NULL
description	text	YES		NULL
unit_order	int(11)	NO		0
is_active	tinyint(1)	NO		1
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
level_id	int(11)	NO	MUL	NULL
unit_id	int(11)	YES	MUL	NULL
topic_id	int(11)	YES	MUL	NULL
resource_name	varchar(100)	NO		NULL
resource_type	varchar(50)	NO	MUL	NULL
description	text	YES		NULL
file_path	varchar(255)	NO		NULL
is_active	tinyint(1)	NO	MUL	1
created_by	int(11)	NO		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
level_id	int(11)	NO	MUL	NULL
unit_id	int(11)	YES	MUL	NULL
topic_id	int(11)	YES	MUL	NULL
status	varchar(50)	NO	MUL	not_started
progress_percentage	int(11)	NO	MUL	0
notes	text	YES		NULL
last_activity_date	datetime	YES		NULL
created_at	datetime	NO		NULL
updated_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
month_id	int(11)	NO	PRI	NULL	auto_increment
year_id	int(11)	YES	MUL	NULL
term_id	int(11)	YES	MUL	NULL
month_name	varchar(50)	NO		NULL
month_key	varchar(20)	NO		NULL
start_date	date	YES		NULL
end_date	date	YES		NULL
display_order	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
session_name	varchar(255)	NO	MUL	NULL
global_template_id	int(11)	YES		NULL
active	tinyint(1)	YES		1
is_primary	tinyint(1)	YES		0
org_id	int(11)	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
start_date	date	YES		NULL
end_date	date	YES		NULL

Column	Type	Nullable	Key	Default	Extra
term_id	int(11)	NO	PRI	NULL	auto_increment
year_id	int(11)	YES	MUL	NULL
term_name	varchar(100)	NO		NULL
term_key	varchar(50)	NO		NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
focus_description	text	YES		NULL
display_order	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
week_id	int(11)	NO	PRI	NULL	auto_increment
month_id	int(11)	YES	MUL	NULL
week_number	int(11)	NO		NULL
week_name	varchar(50)	YES		NULL
start_date	date	YES		NULL
end_date	date	YES		NULL
focus_description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
year_id	int(11)	NO	PRI	NULL	auto_increment
year_name	varchar(100)	NO		NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
is_current	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	YES		NULL
email	varchar(255)	YES		NULL
reason	text	YES		NULL
requested_at	timestamp	NO		current_timestamp()
status	enum('pending','processed')	YES		pending
processed_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
code	varchar(50)	NO	UNI	NULL
name_en	varchar(100)	NO		NULL
name_hi	varchar(100)	YES		NULL
group_id	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	YES	MUL	NULL
action	varchar(50)	NO		NULL
details	text	YES		NULL
success	tinyint(1)	YES		1
ip_address	varchar(45)	NO		NULL
user_agent	varchar(255)	YES		NULL
created_at	timestamp	NO	MUL	current_timestamp()
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
enquiry_no	varchar(20)	YES		NULL
academic_year	varchar(20)	YES		NULL
applicant_name	varchar(150)	NO		NULL
dob	date	YES		NULL
gender	enum('male','female','other')	YES		NULL
class_applied	varchar(30)	YES		NULL
previous_school	varchar(150)	YES		NULL
prev_percentage	decimal(5,2)	YES		NULL
parent_name	varchar(150)	NO		NULL
relation	enum('father','mother','guardian')	NO		father
parent_mobile	varchar(15)	NO		NULL
parent_email	varchar(150)	YES		NULL
address	text	YES		NULL
source	enum('walkin','phone','online','reference','advertisement','other')	NO		walkin
reference_name	varchar(100)	YES		NULL
status	enum('enquiry','applied','test_scheduled','shortlisted','enrolled','waitlisted','rejected','withdrawn')	NO	MUL	enquiry
priority	enum('normal','high','vip')	NO		normal
test_date	date	YES		NULL
interview_date	date	YES		NULL
followup_date	date	YES	MUL	NULL
followup_done	tinyint(1)	NO		0
fee_paid	decimal(8,2)	NO		0.00
notes	text	YES		NULL
assigned_to_id	int(11)	YES		NULL
assigned_to_name	varchar(100)	YES		NULL
created_by	int(11)	NO		NULL
created_by_name	varchar(100)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
instructions	text	YES		NULL
principal_signature	varchar(255)	YES		NULL
controller_signature	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
show_title1	tinyint(1)	YES		1
show_title2	tinyint(1)	YES		1
show_session	tinyint(1)	YES		1
preserve_space	tinyint(1)	YES		0
title_generation	enum('manual','system')	YES		manual
system_title_format	int(11)	YES	MUL	NULL
header_image	varchar(255)	YES		NULL
show_left_logo	tinyint(1)	YES		1
show_right_logo	tinyint(1)	YES		1
show_school_name	tinyint(1)	YES		1
show_school_address	tinyint(1)	YES		1
show_contact_info	tinyint(1)	YES		1
show_affiliation	tinyint(1)	YES		1
show_student_photo	tinyint(1)	YES		1
show_invigilator_sign	tinyint(1)	YES		1
show_max_marks	tinyint(1)	YES		1
show_min_marks	tinyint(1)	YES		1
footer_note	text	YES		NULL
admit_card_title	varchar(255)	YES		ADMIT CARD
header_bg_color	varchar(20)	YES		#8B0000
table_header_bg	varchar(20)	YES		#2c3e50
display_school_name	varchar(500)	YES		NULL
display_address	varchar(500)	YES		NULL
display_contact	varchar(500)	YES		NULL
display_affiliation	varchar(500)	YES		NULL
school_name_font_size	varchar(10)	YES		26
school_name_color	varchar(20)	YES		#8B0000
address_font_size	varchar(10)	YES		13
contact_font_size	varchar(10)	YES		12
affiliation_font_size	varchar(10)	YES		12
principal_name	varchar(255)	YES		NULL
controller_name	varchar(255)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
prompt_name	varchar(100)	NO		NULL
prompt_text	text	NO		NULL
focus_area	varchar(50)	YES		general
is_active	tinyint(1)	YES		1
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
report_type	varchar(20)	NO		general
model	varchar(20)	NO		NULL
model_used	varchar(60)	YES
report_text	mediumtext	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO		NULL
student_id	int(11)	YES	MUL	0
org_id	int(11)	YES		0
model	varchar(20)	NO		NULL
report_type	varchar(20)	YES		general
status	varchar(20)	YES		success
error_msg	text	YES		NULL
ip_address	varchar(45)	YES
created_at	timestamp	NO	MUL	current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	YES		NULL
name	varchar(150)	NO		NULL
admission_no	varchar(30)	YES		NULL
passing_year	year(4)	YES	MUL	NULL
class_passed	varchar(30)	YES		NULL
stream	varchar(50)	YES		NULL
mobile	varchar(15)	YES		NULL
email	varchar(150)	YES		NULL
current_city	varchar(80)	YES		NULL
current_occupation	varchar(100)	YES		NULL
employer	varchar(120)	YES		NULL
higher_education	varchar(150)	YES		NULL
college	varchar(150)	YES		NULL
achievements	text	YES		NULL
profile_photo	varchar(255)	YES		NULL
linkedin_url	varchar(255)	YES		NULL
is_verified	tinyint(1)	NO		0
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
provider	varchar(50)	YES		NULL
api_key	text	YES		NULL
enabled	tinyint(1)	YES		0
is_master	tinyint(1)	NO		0
status	varchar(20)	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
endpoint	varchar(100)	NO	MUL	NULL
method	varchar(10)	NO		NULL
description	text	YES		NULL
requires_auth	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(255)	NO		NULL
email	varchar(255)	NO		NULL
phone	varchar(15)	NO		NULL
city	varchar(255)	NO		NULL
query_type	varchar(255)	NO		NULL
query	text	NO		NULL
submitted_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_id	int(11)	YES	MUL	NULL
subject_code	varchar(100)	NO	MUL	NULL
criteria_label	varchar(10)	NO		NULL
criteria_name	varchar(255)	NO		NULL
criteria_description	text	YES		NULL
week_number	varchar(10)	YES		NULL
month_name	varchar(20)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_curriculum_id	varchar(50)	NO		NULL
subject_code	varchar(100)	NO		NULL
month	varchar(20)	NO	MUL	NULL
week	int(11)	NO		NULL
criteria_label	varchar(20)	NO		C1
criteria_name	varchar(200)	NO		NULL
criteria_description	text	YES		NULL
display_order	int(11)	YES		1
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
competency_level	varchar(50)	YES		Basic
learning_outcome_id	int(11)	YES		NULL
rubric_descriptors	longtext	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
holistic_subject_id	int(11)	YES		NULL
grade	varchar(2)	NO		NULL
numeric_value	text	NO		NULL
indicator_text	text	NO		NULL
org_id	int(11)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
schedule_id	int(11)	NO	PRI	NULL	auto_increment
year_id	int(11)	YES	MUL	NULL
term_id	int(11)	YES	MUL	NULL
type_id	int(11)	YES	MUL	NULL
assessment_period	varchar(100)	YES		NULL
max_marks	int(11)	YES		NULL
syllabus_coverage	varchar(100)	YES		NULL
assessment_method	text	YES		NULL
assessment_focus	varchar(255)	YES		NULL
evaluation_criteria	text	YES		NULL
is_holistic_assessment	tinyint(1)	YES		0

Column	Type	Nullable	Key	Default	Extra
type_id	int(11)	NO	PRI	NULL	auto_increment
type_key	varchar(50)	NO		NULL
type_name	varchar(100)	NO		NULL
description	text	YES		NULL
assessment_weight	decimal(5,2)	YES		20.00
is_holistic	tinyint(1)	YES		0
display_order	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
week_name	varchar(20)	NO		NULL
week_number	int(11)	NO		NULL
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
assessment_id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO	MUL	NULL
type_id	int(11)	NO	MUL	NULL
month_id	int(11)	NO	MUL	NULL
assessment_date	date	NO		NULL
max_marks	int(11)	NO		100
notes	text	YES		NULL
status	enum('active','inactive')	NO		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_id	int(11)	NO		NULL
total_days	int(11)	NO		NULL
present	int(11)	NO		NULL
org_id	int(11)	NO		NULL
created_by	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
class_id	int(11)	YES	MUL	1
section_id	int(11)	YES	MUL	1
date	date	NO		NULL
org_id	int(11)	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
created_by	int(11)	YES		NULL
section	varchar(10)	YES		NULL
updated_by	int(11)	YES		NULL
updated_at	timestamp	YES		NULL
status	varchar(1)	NO		P
notes	text	YES		NULL
class_name	varchar(50)	YES	MUL	NULL
section_name	varchar(50)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_name	varchar(10)	NO
month_year	char(7)	NO		NULL
is_locked	tinyint(1)	NO		1
locked_by	int(11)	NO		NULL
locked_at	timestamp	NO		current_timestamp()
unlock_note	varchar(255)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_name	varchar(50)	NO		NULL
section_name	varchar(50)	NO		NULL
date	date	NO		NULL
total_students	int(11)	YES		0
present_count	int(11)	YES		0
absent_count	int(11)	YES		0
late_count	int(11)	YES		0
holiday_count	int(11)	YES		0
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class_id	int(11)	YES		NULL
section_id	int(11)	YES		NULL
total_days	int(11)	YES		0
present	int(11)	YES		0
org_id	int(11)	NO		NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	YES	MUL	NULL
action	varchar(50)	NO		NULL
entity_type	varchar(50)	NO		NULL
entity_id	int(11)	NO		NULL
old_values	longtext	YES		NULL
new_values	longtext	YES		NULL
ip_address	varchar(45)	YES		NULL
user_agent	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
token	varchar(64)	NO	UNI	NULL
user_id	int(11)	NO	MUL	NULL
ip_address	varchar(45)	YES		NULL
user_agent	varchar(255)	YES		NULL
last_activity	int(11)	NO	MUL	NULL
login_time	int(11)	NO		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	NO	MUL	NULL
height	decimal(5,2)	NO		NULL
weight	decimal(5,2)	NO		NULL
org_id	int(11)	NO	MUL	NULL
created_by	int(11)	NO	MUL	NULL
created_at	datetime	NO		NULL
updated_at	datetime	NO		NULL
blood_group	varchar(5)	YES		NULL
vision	varchar(20)	YES		NULL
vision_left	varchar(10)	YES		NULL
vision_right	varchar(10)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_name	enum('X','XII')	NO		NULL
year	varchar(12)	NO		NULL
registered	int(11)	YES		0
passed	int(11)	YES		0
pass_pct	decimal(5,2)	YES		0.00
remarks	varchar(50)	YES		NULL
appeared	int(11)	YES		0
distinctions	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
broadcast_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
recipient_name	varchar(150)	NO		NULL
mobile	varchar(15)	NO		NULL
status	enum('sent','failed','pending')	NO		pending
error_msg	varchar(255)	YES		NULL
sent_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
title	varchar(150)	NO		NULL
message	text	NO		NULL
channel	enum('sms','whatsapp','both')	NO		whatsapp
target_type	enum('all_students','all_staff','specific_class','all_parents','custom')	NO		all_students
class_filter	varchar(50)	YES		NULL
section_filter	varchar(20)	YES		NULL
recipient_count	int(11)	NO		0
sent_count	int(11)	NO		0
failed_count	int(11)	NO		0
status	enum('draft','sending','sent','failed')	NO		draft
schedule_at	datetime	YES		NULL
sent_at	datetime	YES		NULL
created_by	int(11)	NO		NULL
created_by_name	varchar(100)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
operation_type	enum('generate_reports','send_whatsapp','generate_pdf')	NO		NULL
total_students	int(11)	NO		NULL
successful_count	int(11)	YES		0
failed_count	int(11)	YES		0
operation_data	longtext	YES		NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
completed_at	timestamp	YES		NULL
status	enum('pending','processing','completed','failed')	YES		pending

Column	Type	Nullable	Key	Default	Extra
calendar_id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO		NULL
name	varchar(255)	NO		NULL
description	text	YES		NULL
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
member_type	enum('student','staff')	NO		student
member_id	int(11)	NO		NULL
member_name	varchar(150)	NO		NULL
balance	decimal(10,2)	NO		0.00
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
item_name	varchar(100)	NO		NULL
category	varchar(50)	YES		food
price	decimal(8,2)	NO		0.00
unit	varchar(20)	YES		plate
is_active	tinyint(1)	NO		1
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
item_name	varchar(100)	NO		NULL
category	enum('breakfast','lunch','snacks','beverages','other')	NO		snacks
price	decimal(8,2)	NO		0.00
description	varchar(200)	YES		NULL
is_available	tinyint(1)	NO		1
sort_order	int(11)	NO		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
item_id	int(11)	NO	MUL	0
student_id	int(11)	YES		NULL
quantity	int(11)	NO		1
amount	decimal(8,2)	NO		0.00
order_date	date	NO		NULL
payment_mode	varchar(20)	YES		cash
status	varchar(20)	YES		served
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
member_type	enum('student','staff')	NO	MUL	student
member_id	int(11)	NO		NULL
member_name	varchar(150)	NO		NULL
txn_type	enum('credit','debit','refund')	NO		debit
amount	decimal(8,2)	NO		NULL
balance_after	decimal(10,2)	NO		0.00
item_id	int(11)	YES		NULL
item_name	varchar(100)	YES		NULL
qty	int(11)	NO		1
remarks	varchar(200)	YES		NULL
txn_date	date	NO	MUL	NULL
done_by	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
centre_no	varchar(20)	NO		NULL
centre_name	varchar(150)	NO		NULL
board	enum('CBSE','MPBSE','ICSE','IB','other')	NO		CBSE
exam_year	year(4)	NO		NULL
cs_name	varchar(100)	YES		NULL
cs_id	int(11)	YES		NULL
deputy_cs_name	varchar(100)	YES		NULL
cctv_incharge	varchar(100)	YES		NULL
address	text	YES		NULL
contact	varchar(15)	YES		NULL
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
centre_id	int(11)	NO	MUL	NULL
exam_date	date	NO	MUL	NULL
subject_code	varchar(10)	YES		NULL
subject_name	varchar(100)	NO		NULL
class_board	enum('X','XII','both')	NO		XII
total_candidates	int(11)	NO		0
present	int(11)	NO		0
absent	int(11)	NO		0
ufm_count	int(11)	NO		0
start_time	time	YES		NULL
packing_done	tinyint(1)	NO		0
dispatched	tinyint(1)	NO		0
dispatch_via	varchar(50)	YES		NULL
dispatch_time	time	YES		NULL
tracking_no	varchar(50)	YES		NULL
status_msg	varchar(255)	YES		NULL
notes	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
centre_id	int(11)	NO	MUL	NULL
exam_date	date	NO		NULL
subject_name	varchar(100)	NO		NULL
candidate_name	varchar(150)	NO		NULL
roll_no	varchar(20)	YES		NULL
class_board	enum('X','XII')	NO		XII
ufm_type	varchar(100)	YES		NULL
recommendation	enum('ufm','non_ufm','cancelled')	NO		non_ufm
action_taken	text	YES		NULL
invigilator_name	varchar(100)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
class_id	int(11)	NO	PRI	NULL	auto_increment
class_name	varchar(100)	NO		NULL
class_key	varchar(50)	NO	UNI	NULL
display_order	int(11)	NO		100
status	enum('active','inactive')	NO		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
current_class_id	int(11)	NO	MUL	NULL
next_class_id	int(11)	YES	MUL	NULL
current_class_name	varchar(255)	NO
next_class_name	varchar(255)	YES		NULL
progression_type	enum('NORMAL','GRADUATION','FINAL')	YES		NORMAL
is_active	tinyint(1)	YES		1
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	NO	MUL	NULL
section_name	varchar(1)	NO	MUL	NULL
org_id	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
class_subject_id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO	MUL	NULL
display_order	int(11)	NO		10
status	enum('active','inactive')	NO		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_id	int(11)	YES		NULL
section_name	varchar(50)	YES		NULL
staff_member_id	int(11)	YES		NULL
user_id	int(11)	YES		NULL
teacher_name	varchar(255)	YES		NULL
role_type	varchar(50)	YES		class_teacher
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
assignment_status	varchar(20)	YES		active
start_date	date	YES		NULL
end_date	date	YES		NULL
remarks	varchar(500)	YES		NULL
created_by	int(11)	YES		NULL
updated_by	int(11)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
class_name	varchar(255)	NO		NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()
description	text	YES		NULL
level_id	int(11)	YES		NULL
class_order	int(11)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	YES	MUL	NULL
area	varchar(50)	YES		NULL
grade	char(2)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
type	enum('area','discipline','health')	NO		NULL
name	varchar(255)	NO		NULL
unit	varchar(50)	YES		NULL
field	varchar(100)	YES		NULL
grade_field	varchar(100)	YES		NULL
display_order	int(11)	YES		1
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
report_type	enum('weekly','monthly')	NO		NULL
remark_category	varchar(100)	YES		NULL
remark_text	text	YES		NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO		NULL
subject_name	varchar(100)	NO		NULL
theory_max	decimal(6,2)	YES		100.00
theory_obtained	decimal(6,2)	YES		NULL
practical_max	decimal(6,2)	YES		0.00
practical_obtained	decimal(6,2)	YES		NULL
is_absent_theory	tinyint(1)	YES		0
is_absent_practical	tinyint(1)	YES		0
remarks	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
criteria_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
achievement_level	varchar(50)	YES		Developing
proficiency_score	int(11)	YES		3
rubric_level	varchar(50)	YES		Proficient
teacher_observation	text	YES		NULL
assessment_date	date	YES		NULL
assessed_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
raised_by	int(11)	YES		NULL
category	varchar(50)	YES		general
subject	varchar(200)	NO		NULL
description	text	YES		NULL
status	varchar(20)	YES		open
assigned_to	int(11)	YES		NULL
resolved_at	datetime	YES		NULL
resolution	text	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
complaint_no	varchar(20)	YES		NULL
raised_by_type	enum('student','staff','parent','other')	NO		staff
raised_by_id	int(11)	YES		NULL
raised_by_name	varchar(150)	NO		NULL
raised_by_contact	varchar(20)	YES		NULL
subject	varchar(200)	NO		NULL
description	text	NO		NULL
category	enum('academic','facilities','staff','administration','transport','canteen','safety','other')	NO		other
priority	enum('low','medium','high','urgent')	NO		medium
status	enum('open','in_progress','resolved','closed','rejected')	NO	MUL	open
assigned_to_id	int(11)	YES		NULL
assigned_to_name	varchar(100)	YES		NULL
assigned_at	datetime	YES		NULL
resolution	text	YES		NULL
resolved_by_id	int(11)	YES		NULL
resolved_by_name	varchar(100)	YES		NULL
resolved_at	datetime	YES		NULL
is_anonymous	tinyint(1)	NO		0
is_confidential	tinyint(1)	NO		0
satisfaction	tinyint(4)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
page_number	int(11)	NO		1
section_name	varchar(100)	NO		NULL
element_name	varchar(100)	NO		NULL
is_enabled	tinyint(1)	YES		1
display_order	int(11)	YES		0
height_allocation	int(11)	YES		0
custom_text	text	YES		NULL
css_classes	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		0
student_id	int(11)	NO	MUL	NULL
student_name	varchar(150)	NO		NULL
class	varchar(20)	YES		NULL
section	varchar(10)	YES		NULL
counsellor_id	int(11)	NO	MUL	NULL
counsellor_name	varchar(100)	NO		NULL
concern_type	enum('academic','behavioural','emotional','career','family','peer','other')	NO		academic
session_date	date	NO	MUL	NULL
session_number	int(11)	NO		1
summary	text	YES		NULL
action_taken	text	YES		NULL
follow_up_date	date	YES	MUL	NULL
follow_up_done	tinyint(1)	NO		0
parent_informed	tinyint(1)	NO		0
is_confidential	tinyint(1)	NO		0
severity	enum('low','medium','high','critical')	NO		low
status	enum('open','follow_up','closed')	NO		open
referral	varchar(150)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
component_id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO	MUL	NULL
month_id	int(11)	NO	MUL	NULL
main_content	text	YES		NULL
last_updated	timestamp	NO		current_timestamp()	on update current_timestamp()
updated_by	int(11)	YES		NULL
status	enum('active','inactive')	YES		active

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
report_data	longtext	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class_id	int(11)	YES		NULL
section_id	int(11)	YES		NULL
attendance_status	enum('present','absent','late','half_day')	YES		present
date	date	NO		NULL
org_id	int(11)	NO	MUL	NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
table_count	int(11)	NO		NULL
total_records	int(11)	NO		NULL
avg_rows_per_table	float	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
meta_key	varchar(100)	NO		NULL
meta_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
teacher_id	int(11)	NO	MUL	NULL
room_id	int(11)	NO	MUL	NULL
date	date	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_subject_id	int(11)	YES	MUL	NULL
room_no	varchar(10)	YES		NULL
invigilator_id	int(11)	YES	MUL	NULL
candidate_school_id	int(11)	YES	MUL	NULL
duty_date	date	YES		NULL
created_at	timestamp	NO		current_timestamp()
status	enum('active','cancelled')	YES		active
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
table_name	varchar(255)	NO		NULL
field_name	varchar(255)	NO		NULL
field_type	enum('text','number','date','boolean','enum')	NO		NULL
is_required	tinyint(1)	YES		0
created_by	int(11)	NO	MUL	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES	MUL	NULL
student_id	int(11)	NO	MUL	NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
request_date	date	NO		NULL
leave_time	time	YES		NULL
reason	varchar(300)	NO		NULL
reason_category	enum('medical','family','emergency','exam','other')	YES		other
parent_name	varchar(100)	YES		NULL
parent_mobile	varchar(15)	YES		NULL
requested_by	enum('parent','student','teacher')	YES		parent
status	enum('pending','approved','rejected','left')	YES	MUL	pending
ct_approved	tinyint(1)	YES		NULL
ct_approved_by	int(11)	YES		NULL
ct_approved_at	datetime	YES		NULL
principal_approved	tinyint(1)	YES		NULL
principal_approved_by	int(11)	YES		NULL
principal_approved_at	datetime	YES		NULL
actual_leave_time	time	YES		NULL
gate_pass_no	varchar(20)	YES		NULL
wa_sent	tinyint(1)	NO		0
remarks	varchar(300)	YES		NULL
created_by	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
identifier	varchar(255)	NO	MUL	NULL
otp	varchar(10)	NO		NULL
type	enum('login','signup','reset','verification')	NO		NULL
expires_at	timestamp	NO	MUL	current_timestamp()	on update current_timestamp()
used	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
email	varchar(255)	NO	MUL	NULL
token	varchar(255)	NO	MUL	NULL
expires_at	timestamp	NO		current_timestamp()	on update current_timestamp()
used	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
event_id	int(11)	NO	MUL	0
student_id	int(11)	YES		NULL
name	varchar(150)	YES		NULL
phone	varchar(20)	YES		NULL
email	varchar(150)	YES		NULL
status	varchar(20)	YES		registered
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
event_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
user_id	int(11)	NO		NULL
user_name	varchar(150)	NO		NULL
status	enum('yes','no','maybe')	NO		yes
responded_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
category_name	varchar(50)	YES		NULL
max_marks	int(11)	YES		NULL
display_order	int(11)	YES		NULL
term	enum('I-TERM','II-TERM','FINAL')	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
user_id	int(11)	NO	MUL	NULL
comment	text	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
conducted_for	int(11)	YES		40
weightage	decimal(5,2)	YES		5.00
max_marks_display	int(11)	YES		20
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(255)	NO		NULL
exam_type	enum('General Purpose','Special Purpose')	NO		NULL
description	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
exam_name	varchar(255)	YES		NULL
exam_year	year(4)	YES		NULL
group_id	int(11)	YES		NULL
start_date	date	YES		NULL
end_date	date	YES		NULL
session	varchar(50)	YES		NULL
publish	tinyint(1)	YES		0
publish_result	tinyint(1)	YES		0
is_promotion_group	tinyint(1)	YES		0
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_name	varchar(10)	NO
is_locked	tinyint(1)	NO	MUL	1
locked_by	int(11)	NO		NULL
locked_at	timestamp	NO		current_timestamp()
lock_reason	varchar(255)	YES		NULL
unlocked_by	int(11)	YES		NULL
unlocked_at	timestamp	YES		NULL
unlock_reason	varchar(255)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	YES	MUL	NULL
room_no	int(11)	YES		NULL
roll_no	varchar(20)	YES		NULL
row_number	int(1)	YES		NULL
seat_number	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	YES	MUL	NULL
class_id	int(11)	YES	MUL	NULL
exam_id	int(11)	NO	MUL	NULL
subject_id	int(11)	YES	MUL	NULL
exam_date	date	NO		NULL
exam_time	time	NO		NULL
end_time	time	YES		NULL
max_marks	int(10) unsigned	NO		NULL
min_marks	int(10) unsigned	NO		NULL
weightage	decimal(5,2)	YES		100.00
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
updated_by	int(11)	YES		NULL
special_category	varchar(30)	YES		NULL
sub_order	int(11)	NO		NULL

Column	Type	Nullable	Default	Extra
id	int(11)	NO	0
org_id	int(11)	YES	NULL
class_id	int(11)	YES	NULL
exam_id	int(11)	NO	NULL
subject_id	int(11)	YES	NULL
exam_date	date	NO	NULL
exam_time	time	NO	NULL
end_time	time	YES	NULL
max_marks	int(10) unsigned	NO	NULL
min_marks	int(10) unsigned	NO	NULL
weightage	decimal(5,2)	YES	100.00
created_at	timestamp	NO	current_timestamp()
updated_at	timestamp	NO	current_timestamp()	on update current_timestamp()
updated_by	int(11)	YES	NULL
special_category	varchar(30)	YES	NULL
sub_order	int(11)	NO	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO	MUL	NULL
class	varchar(10)	NO		NULL
exam_date	date	NO		NULL
exam_time	time	NO		NULL
end_time	time	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_name	varchar(255)	NO		NULL
exam_year	varchar(4)	YES		NULL
session_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO	MUL	NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_name	varchar(255)	NO		NULL
exam_year	varchar(4)	YES		NULL
class_id	int(11)	YES	MUL	NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
org_id	int(11)	YES	MUL	1
group_id	int(11)	NO	MUL	NULL
session	varchar(50)	NO		NULL
publish	tinyint(1)	YES		0
publish_result	tinyint(1)	YES		0
description	text	YES		NULL
session_id	int(11)	NO	MUL	NULL
term	text	NO	MUL	'\'Term-I\''
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
created_at	timestamp	NO		current_timestamp()
exam_type	varchar(50)	YES		NULL
weightage	decimal(5,2)	YES		NULL
exam_date	date	YES		NULL
status	enum('pending','active','completed','cancelled')	YES		pending
primary_subject_id	int(11)	YES	MUL	NULL
display_name	varchar(100)	YES		NULL
actual_max_marks	int(11)	YES		100
display_max_marks	int(11)	YES		100
marks_weightage	decimal(5,2)	YES		100.00
short_name	varchar(20)	YES		NULL

Column	Type	Nullable	Default	Extra
id	int(11)	NO	0
exam_name	varchar(255)	NO	NULL
exam_year	varchar(4)	YES	NULL
class_id	int(11)	YES	NULL
start_date	date	NO	NULL
end_date	date	NO	NULL
org_id	int(11)	YES	1
group_id	int(11)	NO	NULL
session	varchar(50)	NO	NULL
publish	tinyint(1)	YES	0
publish_result	tinyint(1)	YES	0
description	text	YES	NULL
session_id	int(11)	NO	NULL
updated_at	timestamp	NO	current_timestamp()	on update current_timestamp()
created_at	timestamp	NO	current_timestamp()
exam_type	varchar(50)	YES	NULL
weightage	decimal(5,2)	YES	NULL
exam_date	date	YES	NULL
status	enum('pending','active','completed','cancelled')	YES	pending
primary_subject_id	int(11)	YES	NULL
display_name	varchar(100)	YES	NULL
short_name	varchar(20)	YES	NULL

Column	Type	Nullable	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
email	varchar(255)	NO	MUL	NULL
ip_address	varchar(45)	NO		NULL
attempt_time	timestamp	NO	MUL	current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
user_type	enum('student','parent','staff')	NO		parent
user_id	int(11)	NO		NULL
fcm_token	text	NO		NULL
device_info	varchar(200)	YES		NULL
is_active	tinyint(1)	NO	MUL	1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
student_id	int(11)	NO		NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
fee_name	varchar(80)	NO		NULL
amount	decimal(10,2)	NO		NULL
paid_amount	decimal(10,2)	NO		0.00
due_date	date	YES		NULL
paid_date	date	YES		NULL
receipt_no	varchar(30)	YES		NULL
payment_mode	enum('cash','upi','cheque','dd','online')	NO		cash
status	enum('pending','paid','partial','waived')	NO		pending
collected_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
student_id	int(11)	NO	MUL	0
fee_structure_id	int(11)	YES		NULL
amount_paid	decimal(10,2)	NO		0.00
payment_date	date	NO		NULL
payment_mode	varchar(20)	YES		cash
receipt_no	varchar(50)	YES		NULL
transaction_id	varchar(100)	YES		NULL
collected_by	int(11)	YES		NULL
remarks	text	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
student_id	int(11)	NO		NULL
fee_head_id	int(11)	NO		NULL
discount_amount	decimal(10,2)	NO		0.00
reason	varchar(255)	YES
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(100)	NO		NULL
description	varchar(255)	YES
is_active	tinyint(1)	YES		1
sort_order	int(11)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
student_id	int(11)	NO		NULL
fee_head_id	int(11)	NO		NULL
amount_paid	decimal(10,2)	NO		0.00
payment_mode	enum('Cash','Online','UPI','Cheque','DD','Bank Transfer')	YES		Cash
transaction_ref	varchar(100)	YES
cheque_no	varchar(50)	YES
bank_name	varchar(100)	YES
payment_date	date	NO		NULL
receipt_no	varchar(30)	YES
collected_by	int(11)	YES		NULL
remarks	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_num	varchar(5)	NO		NULL
fee_head_id	int(11)	NO		NULL
amount	decimal(10,2)	NO		0.00
due_date	date	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
class_id	int(11)	YES		NULL
fee_head	varchar(120)	NO		NULL
amount	decimal(10,2)	NO		0.00
frequency	varchar(20)	YES		annual
due_date	date	YES		NULL
is_active	tinyint(1)	NO		1
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	NO		NULL
exam_id	int(11)	YES		NULL
subject_name	varchar(255)	NO		NULL
term	varchar(20)	NO	MUL	term1
week	varchar(50)	NO		NULL
month	varchar(50)	NO		NULL
assessment_date	date	NO		NULL
assessment_mode	enum('marks','holistic','both')	YES		holistic
grading_system	varchar(50)	YES		holistic
max_marks	int(11)	YES		100
competency_data	longtext	YES		NULL
overall_grade	varchar(10)	YES		NULL
overall_marks	decimal(5,2)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES	MUL	NULL
person_type	enum('student','staff','visitor')	NO	MUL	student
person_id	int(11)	YES		NULL
person_name	varchar(150)	NO		NULL
person_class	varchar(30)	YES		NULL
direction	enum('in','out')	NO		NULL
log_time	datetime	NO		current_timestamp()
log_date	date	NO		NULL
reason	varchar(200)	YES		NULL
is_late	tinyint(1)	NO		0
expected_time	time	YES		NULL
logged_by	int(11)	NO		NULL
remarks	varchar(255)	YES		NULL

Column	Type	Nullable	Key	Default
org_id	int(11)	NO	PRI	NULL
school_start_time	time	NO		08:00:00
school_end_time	time	NO		14:00:00
late_grace_mins	int(11)	NO		15

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
student_data	longtext	YES		NULL
statements	longtext	YES		NULL
term_assessments	longtext	YES		NULL
generated_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(30)	NO	UNI	NULL
display_name	varchar(60)	YES		NULL
numeric_order	int(11)	NO		0
level	enum('pre_primary','primary','middle','secondary','senior_secondary')	NO		primary
nep_stage	varchar(60)	YES		NULL
age_group	varchar(20)	YES		NULL
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(10)	NO	UNI	NULL
sort_order	int(11)	NO		0
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(20)	NO	UNI	NULL
start_month	tinyint(4)	NO		4
end_month	tinyint(4)	NO		3
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(100)	NO	UNI	NULL
code	varchar(20)	YES		NULL
category	enum('language','science','mathematics','social','vocational','arts','sports','other')	NO		other
applicable_classes	varchar(200)	YES		NULL
nep_stage	varchar(100)	YES		NULL
board	varchar(50)	YES		CBSE
is_compulsory	tinyint(1)	NO		0
sort_order	int(11)	NO		0
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_id	int(11)	NO		NULL
term1_grade1	varchar(3)	YES
term1_grade2	varchar(3)	YES
term1_grade3	varchar(3)	YES
term1_total	decimal(5,2)	YES		NULL	STORED GENERATED
term2_grade1	varchar(3)	YES
term2_grade2	varchar(3)	YES
term2_grade3	varchar(3)	YES
term2_total	decimal(5,2)	YES		NULL	STORED GENERATED
final_total	decimal(5,2)	YES		NULL	STORED GENERATED
org_id	int(11)	NO		NULL
created_by	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
group_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
health_detail	text	NO		NULL
last_updated	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(100)	NO		NULL
unit	varchar(20)	YES		tablet
stock_qty	int(11)	NO		0
min_stock	int(11)	NO		10
expiry_date	date	YES		NULL
is_active	tinyint(1)	NO		1
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	YES	MUL	NULL
height	decimal(5,2)	YES		NULL
weight	decimal(5,2)	YES		NULL
bmi	decimal(5,2)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES	MUL	NULL
student_id	int(11)	NO	MUL	NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
visit_date	date	NO		NULL
visit_time	time	YES		NULL
complaint	varchar(300)	NO		NULL
symptoms	text	YES		NULL
temperature	decimal(4,1)	YES		NULL
bp	varchar(20)	YES		NULL
weight_kg	decimal(5,1)	YES		NULL
diagnosis	varchar(300)	YES		NULL
treatment	text	YES		NULL
medicine_given	varchar(300)	YES		NULL
sent_home	tinyint(1)	NO		0
parent_informed	tinyint(1)	NO		0
follow_up_date	date	YES		NULL
attended_by	varchar(100)	YES		NULL
logged_by	int(11)	NO		NULL
remarks	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
class_id	int(11)	YES	MUL	NULL
section_id	int(11)	YES	MUL	NULL
knowledge_grade	varchar(2)	YES		NULL
knowledge_indicator	text	YES		NULL
leadership_grade	varchar(2)	YES		NULL
leadership_indicator	text	YES		NULL
traditional_knowledge_grade	varchar(2)	YES		NULL
traditional_knowledge_indicator	text	YES		NULL
civic_awareness_grade	varchar(2)	YES		NULL
civic_awareness_indicator	text	YES		NULL
social_emotional_grade	varchar(2)	YES		NULL
social_emotional_indicator	text	YES		NULL
attentive_grade	varchar(2)	YES		NULL
attentive_indicator	text	YES		NULL
problem_solving_grade	varchar(2)	YES		NULL
problem_solving_indicator	text	YES		NULL
collaboration_grade	varchar(2)	YES		NULL
collaboration_indicator	text	YES		NULL
communication_grade	varchar(2)	YES		NULL
communication_indicator	text	YES		NULL
motor_skills_grade	varchar(2)	YES		NULL
motor_skills_indicator	text	YES		NULL
creativity_grade	varchar(2)	YES		NULL
creativity_indicator	text	YES		NULL
curiosity_grade	varchar(2)	YES		NULL
curiosity_indicator	text	YES		NULL
persistence_grade	varchar(2)	YES		NULL
persistence_indicator	text	YES		NULL
adaptability_grade	varchar(2)	YES		NULL
adaptability_indicator	text	YES		NULL
self_regulation_grade	varchar(2)	YES		NULL
self_regulation_indicator	text	YES		NULL
responsibility_grade	varchar(2)	YES		NULL
responsibility_indicator	text	YES		NULL
following_directions_grade	varchar(2)	YES		NULL
following_directions_indicator	text	YES		NULL
strengths_grade	varchar(2)	YES		NULL
strengths_indicator	text	YES		NULL
improvement_areas_grade	varchar(2)	YES		NULL
improvement_areas_indicator	text	YES		NULL
recommendations_grade	varchar(2)	YES		NULL
recommendations_indicator	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
holistic_subject_id	int(11)	NO	MUL	NULL
grade	char(1)	NO		NULL
numeric_value	int(11)	NO		NULL
indicator_text	text	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
holistic_subject_id	int(11)	NO	MUL	NULL
grade	char(1)	NO		NULL
numeric_value	int(11)	NO		NULL
indicator_text	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
holistic_subject_id	int(11)	NO	MUL	NULL
grade	char(1)	NO		NULL
numeric_value	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Default
COL 1	varchar(85)	YES	NULL
COL 2	varchar(16)	YES	NULL
COL 3	varchar(23)	YES	NULL
COL 4	varchar(7)	YES	NULL
COL 5	varchar(10)	YES	NULL
COL 6	varchar(35)	YES	NULL
COL 7	varchar(8)	YES	NULL
COL 8	varchar(5)	YES	NULL
COL 9	varchar(13)	YES	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
holistic_subject_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
grade	char(1)	YES		B
numeric_value	int(11)	YES		3
teacher_remarks	text	YES		NULL
additional_notes	text	YES		NULL
assessment_date	date	YES		NULL
assessed_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
category_code	char(1)	NO		NULL
category_name	varchar(255)	NO		NULL
max_subjects	int(11)	YES		5
display_order	int(11)	YES		1
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
holistic_subject_id	int(11)	NO		NULL
grade	varchar(10)	NO		NULL
numeric_value	decimal(3,2)	YES		NULL
indicator_text	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
subject_name	varchar(255)	NO		NULL
assessment_category	char(1)	YES		B
display_order	int(11)	YES		0
description	text	YES		NULL
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
class_id	int(11)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
session_id	int(11)	NO		NULL
class_num	varchar(5)	NO		NULL
section	varchar(5)	NO		NULL
subject	varchar(100)	NO		NULL
title	varchar(255)	NO		NULL
description	text	YES		NULL
due_date	date	NO		NULL
attachment_path	varchar(400)	YES
attachment_name	varchar(255)	YES
created_by	int(11)	NO		NULL
created_by_name	varchar(150)	YES
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
class_id	int(11)	NO	MUL	0
section_id	int(11)	YES		NULL
subject_id	int(11)	YES		NULL
title	varchar(200)	NO		NULL
description	text	YES		NULL
assigned_date	date	NO		NULL
due_date	date	NO		NULL
file_url	varchar(255)	YES		NULL
assigned_by	int(11)	YES		NULL
wa_sent	tinyint(1)	YES		0
is_active	tinyint(1)	NO		1
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
homework_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
status	enum('pending','done','late')	YES		pending
marked_at	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(80)	NO		NULL
card_type	enum('student','staff')	NO		student
layout	longtext	YES		NULL
include_qr	tinyint(1)	NO		1
include_photo	tinyint(1)	NO		1
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(80)	NO		NULL
icon	varchar(30)	YES		box

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
category_id	int(11)	YES	MUL	NULL
item_name	varchar(150)	NO		NULL
item_code	varchar(30)	YES		NULL
description	text	YES		NULL
unit	varchar(20)	YES		Nos
total_qty	decimal(10,2)	NO		0.00
available_qty	decimal(10,2)	NO		0.00
min_qty	decimal(10,2)	NO		0.00
location	varchar(100)	YES		NULL
purchase_price	decimal(10,2)	YES		NULL
supplier	varchar(120)	YES		NULL
purchase_date	date	YES		NULL
warranty_expiry	date	YES		NULL
asset_type	enum('consumable','fixed_asset','returnable')	NO		consumable
condition_status	enum('good','fair','poor','condemned')	NO		good
is_active	tinyint(1)	NO		1
added_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
item_id	int(11)	NO	MUL	NULL
txn_type	enum('purchase','issue','return','adjustment','condemned')	NO		NULL
quantity	decimal(10,2)	NO		NULL
issued_to	varchar(150)	YES		NULL
remarks	varchar(255)	YES		NULL
txn_date	date	NO		NULL
done_by	int(11)	NO		NULL
done_by_name	varchar(100)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
school_name	varchar(255)	NO		NULL
invigilator_name	varchar(255)	NO		NULL
room_no	int(11)	NO		NULL
signature_time	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
area_id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	YES		NULL
area_key	varchar(50)	YES		NULL
area_title	varchar(100)	NO		NULL
icon	varchar(20)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
goal_id	int(11)	NO	PRI	NULL	auto_increment
area_id	int(11)	YES	MUL	NULL
goal_text	text	NO		NULL
display_order	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
outcome_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
achievement_status	varchar(50)	YES		In Progress
mastery_level	varchar(50)	YES		Developing
evidence_type	varchar(100)	YES		Observation
teacher_notes	text	YES		NULL
assessment_date	date	YES		NULL
assessed_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_id	int(11)	YES	MUL	NULL
subject_code	varchar(50)	NO	MUL	NULL
outcome_code	varchar(50)	NO		NULL
outcome_description	text	NO		NULL
learning_level	varchar(50)	YES		Basic
outcome_category	varchar(100)	YES		NULL
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(60)	NO		NULL
code	varchar(10)	NO		NULL
annual_quota	decimal(5,1)	NO		12.0
is_paid	tinyint(1)	NO		1
carry_forward	tinyint(1)	NO		0
max_consecutive	int(11)	YES		NULL
requires_medical	tinyint(1)	NO		0
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
accession_no	varchar(30)	NO		NULL
title	varchar(255)	NO	MUL	NULL
author	varchar(200)	YES		NULL
publisher	varchar(150)	YES		NULL
isbn	varchar(20)	YES	MUL	NULL
edition	varchar(30)	YES		NULL
publication_year	smallint(6)	YES		NULL
category	varchar(80)	YES		NULL
language	varchar(40)	YES		English
total_copies	int(11)	NO		1
available_copies	int(11)	NO		1
shelf_location	varchar(50)	YES		NULL
price	decimal(8,2)	YES		NULL
cover_image	varchar(300)	YES		NULL
description	text	YES		NULL
is_active	tinyint(1)	NO		1
added_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
book_id	int(11)	NO	MUL	NULL
member_type	enum('student','staff')	NO	MUL	student
member_id	int(11)	NO		NULL
member_name	varchar(150)	NO		NULL
member_class	varchar(20)	YES		NULL
issued_by	int(11)	NO		NULL
issued_date	date	NO		NULL
due_date	date	NO	MUL	NULL
returned_date	date	YES		NULL
fine_per_day	decimal(6,2)	NO		1.00
fine_amount	decimal(8,2)	NO		0.00
fine_paid	tinyint(1)	NO		0
status	enum('issued','returned','overdue','lost')	NO		issued
remarks	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default
org_id	int(11)	NO	PRI	NULL
fine_per_day	decimal(6,2)	NO		1.00
max_issue_days	int(11)	NO		14
max_books_student	int(11)	NO		2
max_books_staff	int(11)	NO		5
library_name	varchar(150)	YES		School Library
librarian_name	varchar(100)	YES		NULL
librarian_mobile	varchar(15)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
book_id	int(11)	NO	MUL	0
student_id	int(11)	YES	MUL	NULL
staff_id	int(11)	YES		NULL
issue_date	date	NO		NULL
due_date	date	NO		NULL
return_date	date	YES		NULL
fine_amount	decimal(8,2)	YES		0.00
fine_paid	tinyint(1)	YES		0
status	varchar(20)	YES		issued
issued_by	int(11)	YES		NULL
remarks	text	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
username	varchar(50)	NO	MUL	NULL
ip_address	varchar(45)	NO		NULL
timestamp	timestamp	NO	MUL	current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
subject_id	int(11)	NO	MUL	NULL
exam_id	int(11)	NO	MUL	NULL
marks_obtained	decimal(10,2)	YES		NULL
is_absent	tinyint(1)	YES		0
notes	text	YES		NULL
created_at	timestamp	YES		current_timestamp()
updated_at	timestamp	YES		current_timestamp()	on update current_timestamp()
org_id	int(11)	NO	MUL	NULL
th_marks	decimal(6,2)	YES		NULL
pr_marks	decimal(6,2)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
mark_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
exam_id	int(11)	NO		NULL
subject_id	int(11)	NO		NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
old_value	decimal(10,2)	YES		NULL
new_value	decimal(10,2)	YES		NULL
old_is_absent	tinyint(1)	YES		0
new_is_absent	tinyint(1)	YES		0
action	enum('insert','update','delete')	NO		update
changed_by	int(11)	NO	MUL	NULL
changed_at	timestamp	NO	MUL	current_timestamp()
reason	varchar(255)	YES		NULL
ip_address	varchar(45)	YES		NULL
description	text	YES		NULL

Column	Type	Nullable	Default	Extra
id	int(11)	NO	0
student_id	int(11)	NO	NULL
session_id	int(11)	NO	NULL
subject_id	int(11)	NO	NULL
exam_id	int(11)	NO	NULL
marks_obtained	decimal(10,2)	YES	NULL
is_absent	tinyint(1)	YES	0
notes	text	YES	NULL
created_at	timestamp	YES	current_timestamp()
updated_at	timestamp	YES	current_timestamp()	on update current_timestamp()
org_id	int(11)	NO	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
subject_id	int(11)	YES		NULL
exam_id	int(11)	NO		NULL
weightage	decimal(5,2)	NO		100.00
display_original	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
class_name	varchar(255)	NO	UNI	NULL
class_code	varchar(50)	YES		NULL
description	text	YES		NULL
level	enum('Primary','Secondary','Higher Secondary','Graduate','Post Graduate')	YES		Primary
display_order	int(11)	YES		1
is_active	tinyint(1)	YES	MUL	1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
section_name	varchar(10)	NO	UNI	NULL
section_code	varchar(10)	YES		NULL
description	text	YES		NULL
color_code	varchar(7)	YES		NULL
display_order	int(11)	YES		1
is_active	tinyint(1)	YES	MUL	1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
subject_name	varchar(255)	NO		NULL
subject_code	varchar(50)	YES	UNI	NULL
subject_type	enum('Theory','Practical','Both')	YES		Theory
category	enum('Core','Elective','Optional','Language','Science','Arts','Commerce')	YES	MUL	Core
description	text	YES		NULL
min_marks	int(11)	YES		0
max_marks	int(11)	YES		100
display_order	int(11)	YES		1
is_active	tinyint(1)	YES	MUL	1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
parent_id	int(11)	YES	MUL	NULL
title	varchar(100)	NO		NULL
icon	varchar(50)	YES		NULL
url	varchar(255)	YES		NULL
permission_name	varchar(50)	YES	MUL	NULL
order_index	int(11)	YES		0
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
curriculum_id	int(11)	NO	PRI	NULL	auto_increment
class_id	int(11)	YES		NULL
subject_id	int(11)	YES		NULL
month_id	int(11)	YES		NULL
content	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
report_month	int(11)	NO		NULL
report_year	int(11)	NO		NULL
report_data	longtext	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_curriculum_id	varchar(50)	NO		NULL
subject_code	varchar(100)	NO		NULL
month	varchar(20)	NO		NULL
week	int(11)	NO		NULL
criteria_name	varchar(200)	NO		NULL
criteria_description	text	YES		NULL
display_order	int(11)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
assessment_id	int(11)	NO	MUL	NULL
subject	varchar(100)	NO		NULL
competency	text	NO		NULL
progress_code	char(1)	NO	MUL	NULL
progress_level	varchar(50)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
exam_id	int(11)	YES		NULL
class_id	int(11)	YES	MUL	NULL
subject_id	int(11)	YES		NULL
subject_code	varchar(100)	NO		NULL
month	varchar(20)	NO	MUL	NULL
week	int(11)	NO		NULL
criteria_name	varchar(255)	NO		NULL
criteria_description	text	YES		NULL
display_order	int(11)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	NO		NULL
subject_id	int(11)	YES	MUL	NULL
week	varchar(20)	NO	MUL	NULL
term	varchar(20)	NO		term1
assessment_date	date	YES	MUL	NULL
assessment_data	longtext	YES		NULL
competency_1	varchar(10)	YES		NULL
competency_2	varchar(10)	YES		NULL
competency_3	varchar(10)	YES		NULL
competency_4	varchar(10)	YES		NULL
competency_5	varchar(10)	YES		NULL
marks_1	decimal(5,2)	YES		NULL
marks_2	decimal(5,2)	YES		NULL
marks_3	decimal(5,2)	YES		NULL
marks_4	decimal(5,2)	YES		NULL
marks_5	decimal(5,2)	YES		NULL
subject_total	decimal(7,2)	YES		NULL
subject_grade	varchar(10)	YES		NULL
overall_grade	varchar(10)	YES		NULL
assessment_mode	enum('marks','holistic','both')	YES		marks
grading_system	varchar(20)	YES		9point
max_marks	int(11)	YES		100
created_at	timestamp	NO		current_timestamp()
modified_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Default	Extra
id	int(11)	NO	0
org_id	int(11)	NO	NULL
student_id	int(11)	NO	NULL
session_id	int(11)	NO	NULL
class_id	int(11)	NO	NULL
section_id	int(11)	NO	NULL
week	varchar(20)	NO	NULL
term	varchar(20)	NO	term1
competency_en	varchar(200)	YES	NULL
competency_hi	varchar(200)	YES	NULL
activity_en	text	YES	NULL
activity_hi	text	YES	NULL
observation_en	text	YES	NULL
observation_hi	text	YES	NULL
progress_level	varchar(50)	NO	NULL
teacher_note_en	text	YES	NULL
teacher_note_hi	text	YES	NULL
assessment_date	date	YES	NULL
assessment_data	longtext	YES	NULL
created_at	timestamp	NO	current_timestamp()
updated_at	timestamp	NO	current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
previous_org_name	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
blood_group	enum('A+','A-','B+','B-','AB+','AB-','O+','O-')	YES		NULL
category	enum('General','OBC','SC','ST','Other')	YES		NULL
sub_category	varchar(50)	YES		NULL
minority	enum('Yes','No')	YES		NULL
religion	varchar(50)	YES		NULL
nationality	varchar(50)	YES		NULL
mother_tongue	varchar(50)	YES		NULL
height	decimal(5,2)	YES		NULL
weight	decimal(5,2)	YES		NULL
identification_marks	text	YES		NULL
medical_conditions	text	YES		NULL
disabilities	varchar(255)	YES		NULL
permanent_address	text	YES		NULL
current_address	text	YES		NULL
district	varchar(100)	YES		NULL
state	varchar(100)	YES		NULL
pincode	varchar(10)	YES		NULL
phone	varchar(15)	YES		NULL
email	varchar(255)	YES		NULL
emergency_contact_name	varchar(255)	YES		NULL
emergency_contact_phone	varchar(15)	YES		NULL
emergency_contact_relation	varchar(50)	YES		NULL
aadhar_no	varchar(20)	YES		NULL
samagra_id	varchar(20)	YES		NULL
abha_id	varchar(20)	YES		NULL
aapar_id	varchar(20)	YES		NULL
student_bank_name	varchar(100)	YES		NULL
student_account_no	varchar(50)	YES		NULL
student_bank_ifsc	varchar(20)	YES		NULL
father_occupation	varchar(100)	YES		NULL
father_education	varchar(100)	YES		NULL
father_annual_income	decimal(12,2)	YES		NULL
father_phone	varchar(15)	YES		NULL
father_email	varchar(255)	YES		NULL
father_bank_name	varchar(100)	YES		NULL
father_account_no	varchar(50)	YES		NULL
father_bank_ifsc	varchar(20)	YES		NULL
father_aadhar_no	varchar(20)	YES		NULL
mother_occupation	varchar(100)	YES		NULL
mother_education	varchar(100)	YES		NULL
mother_annual_income	decimal(12,2)	YES		NULL
mother_phone	varchar(15)	YES		NULL
mother_email	varchar(255)	YES		NULL
mother_aadhar_no	varchar(20)	YES		NULL
guardian_name	varchar(255)	YES		NULL
guardian_relation	varchar(50)	YES		NULL
guardian_occupation	varchar(100)	YES		NULL
guardian_phone	varchar(15)	YES		NULL
guardian_email	varchar(255)	YES		NULL
guardian_address	text	YES		NULL
transport_required	enum('Yes','No')	YES		No
route_no	varchar(20)	YES		NULL
bus_stop	varchar(255)	YES		NULL
hostel_required	enum('Yes','No')	YES		No
previous_academic_info	text	YES		NULL
achievement_records	text	YES		NULL
tc_received	enum('Yes','No')	YES		No
tc_date	date	YES		NULL
tc_number	varchar(50)	YES		NULL
documents_submitted	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
type	enum('email','whatsapp')	NO		NULL
sent_at	datetime	NO		current_timestamp()
message	text	NO		NULL
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
title	varchar(255)	NO		NULL
message	text	NO		NULL
type	varchar(50)	YES		info
is_read	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()
read_at	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO		NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
started_at	datetime	NO		NULL
submitted_at	datetime	YES		NULL
score	int(11)	NO		0
total_marks	int(11)	NO		0
percentage	decimal(5,2)	NO		0.00
passed	tinyint(1)	NO		0
answers	longtext	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
exam_id	int(11)	NO	MUL	0
subject_id	int(11)	YES		NULL
question_text	text	NO		NULL
question_type	varchar(20)	YES		mcq
option_a	text	YES		NULL
option_b	text	YES		NULL
option_c	text	YES		NULL
option_d	text	YES		NULL
correct_ans	varchar(10)	YES		NULL
marks	decimal(5,2)	YES		1.00
display_order	int(11)	YES		0
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
exam_id	int(11)	NO	MUL	0
student_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
score	decimal(8,2)	YES		0.00
max_score	decimal(8,2)	YES		0.00
percentage	decimal(5,2)	YES		0.00
time_taken	int(11)	YES		NULL
submitted_at	datetime	YES		NULL
status	varchar(20)	YES		pending
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
title	varchar(200)	NO		NULL
subject	varchar(80)	YES		NULL
class_filter	varchar(50)	YES		NULL
section_filter	varchar(20)	YES		NULL
exam_date	date	YES		NULL
start_time	time	YES		NULL
duration_mins	int(11)	NO		60
total_marks	int(11)	NO		0
pass_marks	int(11)	NO		0
instructions	text	YES		NULL
shuffle_questions	tinyint(1)	NO		1
show_result_immediately	tinyint(1)	NO		1
is_active	tinyint(1)	NO		0
created_by	int(11)	NO		NULL
created_by_name	varchar(100)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
question	text	NO		NULL
option_a	varchar(300)	NO		NULL
option_b	varchar(300)	NO		NULL
option_c	varchar(300)	YES		NULL
option_d	varchar(300)	YES		NULL
correct_answer	enum('a','b','c','d')	NO		NULL
marks	int(11)	NO		1
explanation	text	YES		NULL
sort_order	int(11)	NO		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
global_class_id	int(11)	YES		NULL
name	varchar(30)	NO		NULL
numeric_order	int(11)	NO		0
level	varchar(30)	YES		primary
is_custom	tinyint(1)	NO		0
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
item_type	enum('class','section','subject')	NO	MUL	NULL
item_id	int(11)	NO		NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
created_by	int(11)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
global_section_id	int(11)	YES		NULL
name	varchar(10)	NO		NULL
sort_order	int(11)	NO		0
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
school_name	varchar(255)	YES		NULL
address_line1	varchar(255)	YES		NULL
address_line2	varchar(255)	YES		NULL
contact_info	varchar(255)	YES		NULL
affiliation_info	text	YES		NULL
logo_left	varchar(255)	YES		NULL
logo_right	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
header_image	varchar(255)	YES		NULL
header_style	enum('image','text')	YES		text
font_name	varchar(50)	YES		Arial
font_color	varchar(7)	YES		#000000
is_bold	tinyint(1)	YES		0
school_name_font	varchar(50)	YES		NULL
school_name_color	varchar(7)	YES		NULL
school_name_bold	tinyint(1)	YES		NULL
logo_left_size	int(11)	YES		NULL
logo_right_size	int(11)	YES		NULL
address1_font	varchar(50)	YES		Arial
address1_color	varchar(7)	YES		#000000
address1_bold	tinyint(1)	YES		0
address2_font	varchar(50)	YES		Arial
address2_color	varchar(7)	YES		#000000
address2_bold	tinyint(1)	YES		0
contact_font	varchar(50)	YES		Arial
contact_color	varchar(7)	YES		#000000
contact_bold	tinyint(1)	YES		0
affiliation_font	varchar(50)	YES		Arial
affiliation_color	varchar(7)	YES		#000000
affiliation_bold	tinyint(1)	YES		0
session_title	varchar(255)	YES		NULL
report_card_title	varchar(255)	YES		NULL
header_options	text	YES		NULL
font_size	varchar(10)	YES		14px
header_image_size	varchar(10)	YES		full
logo_size_type	varchar(20)	YES		medium
custom_logo_size	int(11)	YES		NULL
header_type	enum('image','text','custom')	YES		text
school_name_size	varchar(10)	YES		24px
address_size	varchar(10)	YES		14px
contact_size	varchar(10)	YES		14px
affiliation_size	varchar(10)	YES		14px
address1_size	varchar(10)	YES		14px
address2_size	varchar(10)	YES		14px
signature_class_teacher	varchar(100)	YES		CLASS TEACHER
signature_exam_controller	varchar(100)	YES		EXAM CONTROLLER
signature_principal	varchar(100)	YES		PRINCIPAL
signature_coordinator	varchar(100)	YES		COORDINATOR
show_class_teacher_signature	tinyint(1)	YES		1
show_exam_controller_signature	tinyint(1)	YES		1
show_principal_signature	tinyint(1)	YES		1
show_coordinator_signature	tinyint(1)	YES		0
signature_class_teacher_image	varchar(255)	YES		NULL
signature_exam_controller_image	varchar(255)	YES		NULL
signature_principal_image	varchar(255)	YES		NULL
signature_coordinator_image	varchar(255)	YES		NULL
session_title_font	varchar(100)	YES		Arial
session_title_size	varchar(10)	YES		16px
session_title_color	varchar(7)	YES		#000000
session_title_bold	tinyint(1)	YES		1
report_title_font	varchar(100)	YES		Arial
report_title_size	varchar(10)	YES		18px
report_title_color	varchar(7)	YES		#000000
report_title_bold	tinyint(1)	YES		1
signature_size	int(11)	YES		12
class_teacher_name	varchar(255)	YES		NULL
exam_controller_name	varchar(255)	YES		NULL
principal_name	varchar(255)	YES		NULL
coordinator_name	varchar(255)	YES		NULL
rc_page_margin_top	varchar(10)	YES		8
rc_page_margin_bottom	varchar(10)	YES		8
rc_page_margin_left	varchar(10)	YES		10
rc_page_margin_right	varchar(10)	YES		10
rc_marks_font_size	varchar(10)	YES		10
rc_marks_header_size	varchar(10)	YES		10
rc_marks_row_height	varchar(10)	YES		4
rc_marks_subject_width	varchar(10)	YES		15
rc_marks_margin_top	varchar(10)	YES		4
rc_marks_margin_bottom	varchar(10)	YES		4
rc_grand_total_size	varchar(10)	YES		13
rc_coscho_font_size	varchar(10)	YES		11
rc_coscho_row_height	varchar(10)	YES		5
rc_coscho_margin_top	varchar(10)	YES		6
rc_attend_font_size	varchar(10)	YES		12
rc_attend_padding	varchar(10)	YES		8
rc_attend_margin_top	varchar(10)	YES		6
rc_result_font_size	varchar(10)	YES		11
rc_result_pct_size	varchar(10)	YES		14
rc_result_margin_top	varchar(10)	YES		8
rc_skill_font_size	varchar(10)	YES		10
rc_skill_row_height	varchar(10)	YES		4
rc_skill_margin_top	varchar(10)	YES		6
rc_health_font_size	varchar(10)	YES		11
rc_health_margin_top	varchar(10)	YES		6
rc_notes_font_size	varchar(10)	YES		11
rc_notes_padding	varchar(10)	YES		8
rc_notes_margin_top	varchar(10)	YES		6
rc_sig_height	varchar(10)	YES		45
rc_sig_font_size	varchar(10)	YES		12
rc_sig_margin_top	varchar(10)	YES		14
rc_section_header_size	varchar(10)	YES		13
rc_section_header_padding	varchar(10)	YES		6
rc_term1_bg	varchar(20)	YES		#e0e0e0
rc_term1_color	varchar(20)	YES		#000000
rc_term2_bg	varchar(20)	YES		#d0d0d0
rc_term2_color	varchar(20)	YES		#000000
rc_final_bg	varchar(20)	YES		#c0c0c0
rc_final_color	varchar(20)	YES		#000000
rc_marks_header_bg	varchar(20)	YES		#e0e0e0
rc_marks_header_color	varchar(20)	YES		#000000
rc_scholastic_bg	varchar(20)	YES		#000000
rc_scholastic_color	varchar(20)	YES		#ffffff
rc_grand_total_bg	varchar(20)	YES		#e0e0e0
rc_result_header_bg	varchar(20)	YES		#800000
rc_result_header_color	varchar(20)	YES		#ffffff
rc_skill_header_bg	varchar(20)	YES		#e0e0e0
rc_marks_header_font	varchar(20)	YES		10
rc_marks_cell_padding	varchar(20)	YES		4
rc_marks_border_width	varchar(20)	YES		1
rc_section_spacing	varchar(20)	YES		4
rc_grand_total_font	varchar(20)	YES		13
rc_grand_total_bold	varchar(20)	YES		900
rc_scholastic_font	varchar(20)	YES		13
rc_result_pct_font	varchar(20)	YES		14
rc_result_status_bg	varchar(20)	YES		#f0f0f0
rc_marks_font_color	varchar(20)	YES		#000000
rc_health_cell_bg	varchar(20)	YES		#CCFFFF
rc_sig_img_size	int(11)	YES		60
sig_img_size_showCT	int(11)	YES		60
sig_img_size_showEC	int(11)	YES		60
sig_img_size_showPR	int(11)	YES		60
sig_img_size_showCO	int(11)	YES		60

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
global_subject_id	int(11)	YES	MUL	NULL
name	varchar(100)	NO		NULL
code	varchar(20)	YES		NULL
category	varchar(30)	YES		other
is_custom	tinyint(1)	NO		0
is_active	tinyint(1)	NO		1
sort_order	int(11)	NO		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	YES	MUL	NULL
section_name	varchar(10)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
school_name	varchar(255)	YES		NULL
address_line1	varchar(255)	YES		NULL
address_line2	varchar(255)	YES		NULL
contact_info	varchar(255)	YES		NULL
affiliation_info	varchar(255)	YES		NULL
logo_left	varchar(255)	YES		NULL
logo_right	varchar(255)	YES		NULL
logo_left_size	int(11)	YES		100
logo_right_size	int(11)	YES		100
school_name_font	varchar(50)	YES		Arial
school_name_color	varchar(7)	YES		#000000
school_name_bold	tinyint(1)	YES		0
address1_font	varchar(50)	YES		Arial
address1_color	varchar(7)	YES		#000000
contact_font	varchar(50)	YES		Arial
contact_color	varchar(7)	YES		#000000
affiliation_font	varchar(50)	YES		Arial
affiliation_color	varchar(7)	YES		#000000
affiliation_bold	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_name	varchar(255)	NO		NULL
org_address	varchar(255)	YES		NULL
contact_person	varchar(100)	YES		NULL
admin_id	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()
modified_at	timestamp	YES		NULL
status	enum('active','suspended')	YES		active
phone	varchar(50)	YES		NULL
email	varchar(255)	YES		NULL
affiliation_no	varchar(100)	YES		NULL
school_no	varchar(100)	YES		NULL
address	text	YES		NULL
address_line1	text	YES		NULL
address_line2	text	YES		NULL
district	varchar(100)	YES		NULL
state	varchar(100)	YES		NULL
pincode	varchar(10)	YES		NULL
website	varchar(255)	YES		NULL
logo_left	varchar(500)	YES		NULL
logo_right	varchar(500)	YES		NULL
header_image	varchar(500)	YES		NULL
affiliation	varchar(255)	YES		NULL
affiliation_code	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI	NULL	auto_increment
email	varchar(255)	NO	MUL	NULL
code	varchar(255)	NO		NULL
status	enum('active','used','expired')	YES		active
created_at	timestamp	NO		current_timestamp()
expires_at	timestamp	NO	MUL	0000-00-00 00:00:00
used_at	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
otp	varchar(6)	NO		NULL
created_at	timestamp	NO		current_timestamp()
expires_at	timestamp	NO		0000-00-00 00:00:00
is_used	tinyint(1)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
identifier	varchar(100)	NO	MUL	NULL
otp	varchar(10)	NO		NULL
type	varchar(20)	YES		login
expires_at	timestamp	NO	MUL	current_timestamp()	on update current_timestamp()
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
otp	varchar(255)	NO		NULL
status	enum('active','used','expired')	NO		active
created_at	timestamp	NO		current_timestamp()
expires_at	timestamp	NO		0000-00-00 00:00:00

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
access_token	varchar(255)	NO	MUL	NULL
expires_at	timestamp	NO		current_timestamp()	on update current_timestamp()
created_at	timestamp	NO		current_timestamp()
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
report_id	varchar(100)	NO		NULL
feedback_text	text	YES		NULL
rating	int(11)	YES		NULL
concerns	text	YES		NULL
suggestions	text	YES		NULL
home_observations	text	YES		NULL
parent_name	varchar(100)	YES		NULL
parent_email	varchar(100)	YES		NULL
parent_phone	varchar(20)	YES		NULL
feedback_date	timestamp	NO		current_timestamp()
is_private	tinyint(1)	YES		0
status	enum('draft','submitted')	YES		draft

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
email	varchar(255)	NO	MUL	NULL
token	varchar(64)	NO	MUL	NULL
expires_at	datetime	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
used	tinyint(1)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
permission_key	varchar(100)	NO	UNI	NULL
permission_name	varchar(100)	NO		NULL
description	text	YES		NULL
category	varchar(50)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
permission_name	varchar(255)	NO	UNI	NULL
category	varchar(50)	YES		NULL
description	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
level_en	varchar(50)	NO		NULL
level_hi	varchar(50)	NO		NULL
emoji	varchar(10)	YES		NULL
sort_order	int(11)	YES		NULL
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Default
student_id	int(11)	NO	0
admission_no	varchar(255)	NO	NULL
std_name	varchar(255)	NO	NULL
current_session	int(11)	YES	NULL
from_session	varchar(255)	NO	NULL
to_session	varchar(255)	YES	NULL
from_class	varchar(255)	NO	NULL
to_class	varchar(255)	YES	NULL
promoted_date	timestamp	NO	current_timestamp()
action_type	enum('PROMOTED','DETAINED','TC_ISSUED')	YES	PROMOTED
assigned_exams	bigint(21)	NO	0
exam_list	mediumtext	YES	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_id	int(11)	YES	MUL	NULL
criteria_name	varchar(255)	NO		NULL
min_percentage	decimal(5,2)	YES		33.00
min_grade	varchar(10)	YES		D
additional_conditions	text	YES		NULL
is_active	tinyint(1)	YES		1
applies_to_session	int(11)	YES	MUL	NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
promotion_id	int(11)	NO		NULL
student_id	int(11)	NO	MUL	NULL
reverted_by	int(11)	YES	MUL	NULL
reverted_date	datetime	NO	MUL	NULL
reason	text	YES		NULL
original_promotion_data	longtext	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Default
id	int(11)	NO	0
promoted_date	timestamp	NO	current_timestamp()
admission_no	varchar(255)	NO	NULL
std_name	varchar(255)	NO	NULL
roll_no	int(11)	NO	NULL
from_session	varchar(255)	NO	NULL
to_session	varchar(255)	YES	NULL
from_class	varchar(255)	NO	NULL
to_class	varchar(255)	YES	NULL
action_type	enum('PROMOTED','DETAINED','TC_ISSUED')	YES	PROMOTED
promotion_status	varchar(27)	YES	NULL
percentage	decimal(5,2)	YES	NULL
result_status	varchar(255)	YES	NULL
promoted_by	varchar(255)	YES	NULL
org_name	varchar(255)	NO	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
type	varchar(30)	NO		NULL
title	varchar(200)	NO		NULL
body	varchar(500)	NO		NULL
sent_to	int(11)	NO		0
success	int(11)	NO		0
failed	int(11)	NO		0
ref_id	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
subject_id	int(11)	NO	MUL	NULL
chapter_no	int(11)	YES		1
chapter_name	varchar(200)	NO		NULL
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class	varchar(5)	NO		NULL
subject_id	int(11)	NO		NULL
paper_title	varchar(200)	NO		NULL
exam_type	varchar(50)	YES		Unit Test
total_marks	int(11)	YES		100
duration_mins	int(11)	YES		180
sections	text	YES		NULL
question_ids	text	YES		NULL
created_by	int(11)	YES		NULL
session_id	int(11)	YES		NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO		NULL
chapter_id	int(11)	YES	MUL	NULL
class	varchar(5)	NO		NULL
question_type	enum('mcq','short','long','assertion','case_based','fill','truefalse')	NO	MUL	NULL
difficulty	enum('easy','medium','hard')	YES		medium
marks	decimal(4,1)	YES		1.0
question_text	text	NO		NULL
option_a	text	YES		NULL
option_b	text	YES		NULL
option_c	text	YES		NULL
option_d	text	YES		NULL
correct_answer	varchar(5)	YES		NULL
answer_text	text	YES		NULL
hint	text	YES		NULL
has_formula	tinyint(1)	YES		0
image_url	varchar(255)	YES		NULL
tags	varchar(200)	YES		NULL
source	enum('manual','ai','imported')	YES		manual
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class	varchar(5)	NO		NULL
subject_name	varchar(100)	NO		NULL
subject_code	varchar(20)	YES		NULL
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(100)	NO		NULL
email	varchar(100)	NO		NULL
phone	varchar(15)	NO		NULL
city	varchar(100)	NO		NULL
query	text	NO		NULL
query_type	varchar(255)	NO		NULL
submitted_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
org_subject_id	int(11)	YES		NULL
is_global	tinyint(1)	NO	MUL	0
source_org_id	int(11)	YES		NULL
subject	varchar(80)	NO		NULL
class	varchar(30)	YES		NULL
topic	varchar(100)	YES		NULL
difficulty	enum('easy','medium','hard')	NO	MUL	medium
question	text	NO	MUL	NULL
option_a	varchar(300)	NO		NULL
option_b	varchar(300)	NO		NULL
option_c	varchar(300)	YES		NULL
option_d	varchar(300)	YES		NULL
correct_answer	enum('a','b','c','d')	NO		a
marks	int(11)	NO		1
explanation	text	YES		NULL
tags	varchar(255)	YES		NULL
image_path	varchar(255)	YES		NULL
image_position	enum('above','left','below')	YES		above
times_used	int(11)	NO		0
created_by	int(11)	NO		NULL
created_by_name	varchar(100)	NO		NULL
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
q_type	varchar(30)	NO		mcq
answer_text	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
subject_id	int(11)	YES	MUL	NULL
class_id	int(11)	YES	MUL	NULL
chapter	varchar(100)	YES		NULL
question_text	text	NO		NULL
question_type	varchar(30)	YES		mcq
option_a	text	YES		NULL
option_b	text	YES		NULL
option_c	text	YES		NULL
option_d	text	YES		NULL
correct_ans	text	YES		NULL
explanation	text	YES		NULL
difficulty	varchar(10)	YES		medium
marks	decimal(5,2)	YES		1.00
bloom_level	varchar(20)	YES		understand
source	varchar(20)	YES		manual
is_active	tinyint(1)	NO		1
created_by	int(11)	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
ip_address	varchar(45)	YES	MUL	NULL
action	varchar(50)	YES		NULL
attempts	int(11)	YES		1
last_attempt	timestamp	NO		current_timestamp()
blocked_until	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
identifier	varchar(255)	NO	MUL	NULL
action	varchar(50)	NO		NULL
ip_address	varchar(45)	YES		NULL
created_at	timestamp	NO	MUL	current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
class_group	enum('all','primary','middle','secondary','sr_secondary')	NO		all
format_code	varchar(50)	NO		default
format_label	varchar(120)	YES		NULL
notes	text	YES		NULL
updated_by	int(11)	YES		NULL
updated_at	datetime	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
token	varchar(255)	NO	MUL	NULL
expires_at	datetime	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
org_id	int(11)	NO	MUL	NULL
report_data	longtext	YES		NULL
holistic_statements	text	YES		NULL
generated_at	timestamp	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
report_type	text	NO		NULL
generated_at	timestamp	NO		current_timestamp()
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
note_id	int(11)	NO	MUL	NULL
is_default	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
report_note_id	int(11)	NO	MUL	NULL
is_default	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
note_title	varchar(100)	NO		NULL
note_content	text	NO		NULL
org_id	int(11)	NO	MUL	NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
show_on	varchar(10)	YES		none
is_selected	tinyint(1)	YES		0
sort_order	int(11)	YES		0
note_scope	enum('all','class')	NO		all
class_id	int(11)	NO		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
user_id	int(11)	NO		0
session_id	int(11)	NO		0
pref_key	varchar(80)	NO		NULL
pref_value	text	YES		NULL
updated_at	datetime	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
progress_id	varchar(50)	NO	UNI	NULL
session_id	varchar(100)	NO		NULL
total_students	int(11)	NO		NULL
processed_students	int(11)	YES		0
operation_type	varchar(50)	NO		NULL
status	enum('started','processing','completed','failed')	YES		started
message	text	YES		NULL
download_url	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
completed_at	timestamp	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
show_rank	tinyint(1)	YES		0
show_grand_total	tinyint(1)	YES		1
show_percentage	tinyint(1)	YES		1
show_grades	tinyint(1)	YES		1
show_attendance	tinyint(1)	YES		1
show_signatures	tinyint(1)	YES		1
show_coscholastic_conditional	tinyint(1)	YES		1
default_blank_format	tinyint(1)	YES		0
grade_scale_type	enum('cbse','icse','state','custom')	YES		cbse
percentage_decimal_places	int(11)	YES		1
header_type	enum('text','image')	YES		text
header_image	varchar(255)	YES		NULL
footer_text	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
role	varchar(50)	NO		NULL
signature_file	varchar(255)	NO		NULL
signature_size	int(11)	YES		100
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(100)	NO		NULL
org_id	int(11)	NO		NULL
created_by	int(11)	NO		NULL
preferences	longtext	NO		NULL
is_public	tinyint(1)	YES		0
usage_count	int(11)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Default
reversal_id	int(11)	NO	0
reverted_date	datetime	NO	NULL
admission_no	varchar(255)	NO	NULL
std_name	varchar(255)	NO	NULL
roll_no	int(11)	NO	NULL
from_session_id	longtext	YES	NULL
to_session_id	longtext	YES	NULL
original_action	longtext	YES	NULL
reason	text	YES	NULL
reverted_by_name	varchar(255)	YES	NULL
org_name	varchar(255)	NO	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
role_id	int(11)	NO	MUL	NULL
permission_id	int(11)	NO	MUL	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
role_name	varchar(255)	NO	UNI	NULL
description	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
roll_no	int(11)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
room_name	varchar(50)	NO		NULL
capacity	int(11)	NO		NULL
room_no	varchar(50)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		0
user_id	int(11)	NO	MUL	NULL
employee_name	varchar(150)	NO		NULL
designation	varchar(80)	YES		NULL
pay_month	tinyint(4)	NO	MUL	NULL
pay_year	smallint(6)	NO		NULL
salary_struct_id	int(11)	NO		NULL
working_days	int(11)	NO		26
present_days	decimal(5,1)	NO		26.0
leave_days	decimal(5,1)	NO		0.0
unpaid_days	decimal(5,1)	NO		0.0
basic_salary	decimal(10,2)	NO		0.00
hra	decimal(10,2)	NO		0.00
transport_allow	decimal(10,2)	NO		0.00
medical_allow	decimal(10,2)	NO		0.00
other_allow	decimal(10,2)	NO		0.00
gross_salary	decimal(10,2)	NO		0.00
pf_deduction	decimal(10,2)	NO		0.00
pt_deduction	decimal(10,2)	NO		0.00
tds_deduction	decimal(10,2)	NO		0.00
leave_deduction	decimal(10,2)	NO		0.00
loan_deduction	decimal(10,2)	NO		0.00
other_deduction	decimal(10,2)	NO		0.00
total_deductions	decimal(10,2)	NO		0.00
net_payable	decimal(10,2)	NO		0.00
bonus	decimal(10,2)	NO		0.00
arrears	decimal(10,2)	NO		0.00
payment_mode	enum('bank_transfer','cash','cheque','upi')	YES		bank_transfer
payment_date	date	YES		NULL
transaction_ref	varchar(60)	YES		NULL
status	enum('draft','approved','paid')	NO	MUL	draft
approved_by	int(11)	YES		NULL
approved_at	datetime	YES		NULL
paid_by	int(11)	YES		NULL
paid_at	datetime	YES		NULL
slip_generated	tinyint(1)	NO		0
remarks	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
user_id	int(11)	NO	MUL	NULL
employee_name	varchar(150)	NO		NULL
designation	varchar(80)	YES		NULL
department	varchar(60)	YES		NULL
employee_code	varchar(30)	YES		NULL
bank_name	varchar(100)	YES		NULL
bank_account	varchar(30)	YES		NULL
ifsc_code	varchar(15)	YES		NULL
pan_number	varchar(15)	YES		NULL
pf_number	varchar(25)	YES		NULL
basic_salary	decimal(10,2)	NO		0.00
hra	decimal(10,2)	NO		0.00
transport_allow	decimal(10,2)	NO		0.00
medical_allow	decimal(10,2)	NO		0.00
other_allow	decimal(10,2)	NO		0.00
pf_deduction	decimal(10,2)	NO		0.00
pt_deduction	decimal(10,2)	NO		0.00
tds_deduction	decimal(10,2)	NO		0.00
other_deduction	decimal(10,2)	NO		0.00
gross_salary	decimal(10,2)	YES		NULL	STORED GENERATED
total_deductions	decimal(10,2)	YES		NULL	STORED GENERATED
net_salary	decimal(10,2)	YES		NULL	STORED GENERATED
effective_from	date	NO		NULL
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
title	varchar(200)	NO		NULL
description	text	YES		NULL
event_date	date	NO	MUL	NULL
end_date	date	YES		NULL
event_time	time	YES		NULL
end_time	time	YES		NULL
venue	varchar(150)	YES		NULL
category	enum('academic','sports','cultural','holiday','meeting','exam','trip','other')	NO		other
target_audience	enum('all','students','staff','parents')	NO		all
is_holiday	tinyint(1)	NO		0
rsvp_required	tinyint(1)	NO		0
rsvp_deadline	date	YES		NULL
max_attendees	int(11)	YES		NULL
is_published	tinyint(1)	NO		1
created_by	int(11)	NO		NULL
created_by_name	varchar(100)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
school_no	varchar(10)	YES		NULL
affiliation_no	varchar(10)	YES		NULL
name	varchar(100)	YES		NULL
address	text	YES		NULL
phone	varchar(15)	YES		NULL
website	varchar(100)	YES		NULL
email	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
school_name	varchar(255)	YES		NULL
school_code	varchar(50)	YES		NULL
address	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
room_id	int(11)	NO	MUL	NULL
seat_number	int(11)	NO		NULL
roll_no	int(11)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
section_name	varchar(255)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
is_active	tinyint(1)	YES		1
created_by	int(11)	YES	MUL	NULL
updated_by	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
teacher_id	int(11)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	YES	MUL	NULL
action	varchar(100)	YES		NULL
resource	varchar(100)	YES		NULL
ip_address	varchar(45)	YES		NULL
user_agent	text	YES		NULL
created_at	timestamp	NO	MUL	current_timestamp()
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
preference_key	varchar(100)	NO		NULL
preference_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Default
org_id	int(11)	NO	NULL
session_id	int(11)	YES	NULL
session_name	varchar(255)	NO	NULL
class_id	int(11)	NO	0
class_name	varchar(255)	NO	NULL
section_id	int(11)	YES	0
section_name	varchar(255)	YES	NULL
student_count	bigint(21)	NO	0
exam_count	bigint(21)	NO	0
avg_percentage	decimal(9,6)	YES	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_name	varchar(20)	NO		NULL
start_date	date	YES		NULL
end_date	date	YES		NULL
is_current	tinyint(1)	NO		0
status	enum('active','inactive','archived')	NO		active
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
setting_key	varchar(80)	NO		NULL
setting_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
setting_type	varchar(50)	NO		NULL
setting_value	varchar(100)	YES		NULL
usage_count	int(11)	YES		1
last_used	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
student_id	int(11)	NO	MUL	0
subject_id	int(11)	NO		0
theory_marks	decimal(6,2)	YES		NULL
theory_max	decimal(6,2)	YES		100.00
practical_marks	decimal(6,2)	YES		NULL
practical_max	decimal(6,2)	YES		100.00
grade	varchar(5)	YES		NULL
remarks	varchar(255)	YES		NULL
updated_at	datetime	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
grade	varchar(5)	NO	MUL	NULL
min_percentage	decimal(5,2)	NO		NULL
max_percentage	decimal(5,2)	NO		NULL
performance_level	varchar(50)	NO		NULL
description	text	YES		NULL
org_id	int(11)	NO	MUL	NULL
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
skill_subject_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	YES		NULL
exam_type	enum('theory','practical','both')	YES		both
theory_marks	decimal(5,2)	YES		NULL
theory_max_marks	int(11)	YES		100
practical_marks	decimal(5,2)	YES		NULL
practical_max_marks	int(11)	YES		100
total_marks	decimal(5,2)	YES		NULL	STORED GENERATED
total_max_marks	int(11)	YES		NULL	STORED GENERATED
percentage	decimal(5,2)	YES		NULL	STORED GENERATED
grade	varchar(5)	YES		NULL
performance_comment	text	YES		NULL
teacher_remarks	text	YES		NULL
assessment_date	date	YES		NULL
assessed_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
skill_subject_id	int(11)	NO	MUL	NULL
criteria_name	varchar(255)	NO		NULL
criteria_description	text	YES		NULL
weightage	decimal(5,2)	YES		100.00
org_id	int(11)	NO	MUL	NULL
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
skill_subject_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_id	int(11)	YES		NULL
assigned_date	date	YES		NULL
status	enum('active','inactive','completed')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
subject_name	varchar(255)	NO		NULL
subject_code	varchar(50)	YES		NULL
description	text	YES		NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	YES	MUL	NULL
section_id	int(11)	YES		NULL
exam_group	varchar(100)	YES		NULL
is_theory_applicable	tinyint(1)	YES		1
is_practical_applicable	tinyint(1)	YES		1
theory_max_marks	int(11)	YES		100
practical_max_marks	int(11)	YES		100
status	enum('active','inactive')	YES	MUL	active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
code	varchar(50)	NO	UNI	NULL
name_en	varchar(100)	NO		NULL
name_hi	varchar(100)	YES		NULL
group_id	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
event_id	int(11)	YES		NULL
club_id	int(11)	YES		NULL
student_id	int(11)	YES	MUL	NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
achievement_type	enum('winner','runner_up','third','participation','best_player','special')	NO		participation
sport_name	varchar(100)	NO		NULL
event_title	varchar(200)	YES		NULL
event_date	date	YES		NULL
level	enum('school','inter_school','district','state','national','international')	YES		school
medal	enum('gold','silver','bronze','certificate','trophy','none')	YES		none
certificate_issued	tinyint(1)	YES		0
notes	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	YES	MUL	NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
roll_no	varchar(30)	YES		NULL
mobile	varchar(20)	YES		NULL
father_name	varchar(150)	YES		NULL
sport_interest	varchar(200)	NO		NULL
second_interest	varchar(200)	YES		NULL
experience	enum('beginner','intermediate','advanced')	YES		beginner
experience_details	text	YES		NULL
available_days	varchar(100)	YES		NULL
status	enum('pending','approved','rejected','waitlisted')	NO		pending
remarks	text	YES		NULL
applied_at	timestamp	NO		current_timestamp()
reviewed_by	varchar(100)	YES		NULL
reviewed_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
camp_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	YES		NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
section	varchar(10)	YES		NULL
mobile	varchar(20)	YES		NULL
payment_status	enum('paid','pending','waived')	YES		pending
attendance	tinyint(1)	YES		1
registered_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(200)	NO		NULL
camp_type	enum('sports','personality','enrichment','adventure','fitness','mixed')	NO		sports
description	text	YES		NULL
start_date	date	NO		NULL
end_date	date	NO		NULL
venue	varchar(200)	YES		NULL
coordinator	varchar(100)	YES		NULL
max_participants	int(11)	YES		50
fee	decimal(8,2)	YES		0.00
eligibility	varchar(200)	YES		NULL
status	enum('upcoming','ongoing','completed','cancelled')	NO		upcoming
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(100)	NO		NULL
type	enum('sport','club','activity')	NO		sport
description	text	YES		NULL
coach_id	int(11)	YES		NULL
coach_name	varchar(100)	YES		NULL
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
club_id	int(11)	YES	MUL	NULL
title	varchar(150)	NO		NULL
event_type	enum('match','tournament','competition','practice','other')	NO		match
event_date	date	NO		NULL
venue	varchar(100)	YES		NULL
opponent	varchar(100)	YES		NULL
our_score	varchar(20)	YES		NULL
opponent_score	varchar(20)	YES		NULL
result	enum('win','loss','draw','na')	NO		na
notes	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
club_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO		NULL
student_name	varchar(150)	NO		NULL
class	varchar(30)	YES		NULL
role	varchar(50)	YES		Member
joined_date	date	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
session_id	int(11)	NO		0
team_name	varchar(100)	NO		NULL
sport_name	varchar(100)	NO		NULL
category	varchar(20)	YES		mixed
coach_name	varchar(150)	YES		NULL
is_active	tinyint(1)	NO		1
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
staff_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
att_date	date	NO		NULL
status	enum('present','absent','half_day','on_leave','holiday')	YES		present
note	varchar(255)	YES
marked_by	int(11)	YES		NULL
created_at	datetime	YES		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
staff_id	int(11)	NO		NULL
staff_name	varchar(150)	NO		NULL
leave_type	enum('casual','medical','earned','maternity','special')	NO		casual
from_date	date	NO		NULL
to_date	date	NO		NULL
days	int(11)	NO		1
reason	text	YES		NULL
status	enum('pending','approved','rejected','cancelled')	NO		pending
approved_by	int(11)	YES		NULL
approved_by_name	varchar(100)	YES		NULL
applied_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
user_id	int(11)	NO	MUL	NULL
leave_type_id	int(11)	NO		NULL
entitled	decimal(5,1)	NO		0.0
used	decimal(5,1)	NO		0.0
pending	decimal(5,1)	NO		0.0
balance	decimal(5,1)	YES		NULL	VIRTUAL GENERATED

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
staff_id	int(11)	NO	MUL	0
leave_type	varchar(30)	YES		casual
from_date	date	NO		NULL
to_date	date	NO		NULL
days	decimal(4,1)	NO		1.0
reason	text	YES		NULL
status	varchar(20)	YES		pending
approved_by	int(11)	YES		NULL
approved_at	datetime	YES		NULL
remarks	text	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		0
user_id	int(11)	NO	MUL	NULL
user_name	varchar(150)	NO		NULL
designation	varchar(60)	YES		NULL
leave_type_id	int(11)	NO		NULL
leave_type_name	varchar(60)	NO		NULL
from_date	date	NO	MUL	NULL
to_date	date	NO		NULL
days	decimal(4,1)	NO		1.0
is_half_day	tinyint(1)	NO		0
half_day_session	enum('morning','afternoon')	YES		NULL
reason	text	NO		NULL
attachment	varchar(300)	YES		NULL
substitute_name	varchar(100)	YES		NULL
hod_status	enum('pending','approved','rejected')	NO		pending
hod_id	int(11)	YES		NULL
hod_name	varchar(100)	YES		NULL
hod_remarks	varchar(200)	YES		NULL
hod_at	datetime	YES		NULL
principal_status	enum('pending','approved','rejected')	NO		pending
principal_id	int(11)	YES		NULL
principal_name	varchar(100)	YES		NULL
principal_remarks	varchar(200)	YES		NULL
principal_at	datetime	YES		NULL
overall_status	enum('pending','approved','rejected','cancelled')	NO	MUL	pending
is_deducted	tinyint(1)	NO		0
applied_at	timestamp	NO		current_timestamp()
cancelled_at	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
registration_no	varchar(20)	YES	UNI	NULL
teacher_id	varchar(20)	YES		NULL
name	varchar(100)	YES		NULL
designation	enum('PRINCIPAL','VICE PRINCIPAL','PGT','TGT','PRT','PTI','PET','NTT','LIBRARIAN','COUNSELOR','CLERK','OTHER')	YES		NULL
date_of_joining	date	YES		NULL
qualification	varchar(50)	YES		NULL
phone_number	varchar(15)	YES		NULL
date_of_birth	date	YES		NULL
gender	enum('M','F')	YES		NULL
email	varchar(100)	YES		NULL
photo	varchar(255)	YES		NULL
status	enum('active','inactive','transferred','resigned','terminated')	YES		active
org_id	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
class_id	int(11)	YES		NULL
section_name	varchar(50)	YES		NULL
is_class_teacher	tinyint(1)	YES		0
user_id	int(11)	YES		NULL
exit_date	date	YES		NULL
exit_reason	varchar(20)	YES		NULL
exit_note	text	YES		NULL
transfer_to_class	int(11)	YES		NULL
transfer_to_section	varchar(50)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO	MUL	NULL
stream_id	int(11)	NO		NULL
subject_id	int(11)	NO		NULL
subject_role	enum('compulsory','elective')	YES		compulsory
mark_structure	enum('TH','TH_PR','TH_PROJECT')	YES		TH
th_max_marks	smallint(5) unsigned	YES		100
pr_max_marks	smallint(5) unsigned	YES		0
project_max_marks	smallint(5) unsigned	YES		0
th_min_marks	smallint(5) unsigned	YES		33
pr_min_marks	smallint(5) unsigned	YES		0
project_min_marks	smallint(5) unsigned	YES		0
weightage	tinyint(3) unsigned	YES		100
sub_order	tinyint(3) unsigned	YES		0
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
stream_name	varchar(100)	NO		NULL
stream_code	varchar(20)	NO		NULL
display_order	tinyint(4)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
activity_id	int(11)	NO	MUL	NULL
completion_date	date	NO		NULL
time_spent	int(11)	YES		0
score	int(11)	YES		0
completed	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
academic_score	decimal(5,2)	YES		NULL
attendance_pct	decimal(5,2)	YES		NULL
sports_achievements	int(11)	YES		0
homework_completion	decimal(5,2)	YES		NULL
ai_summary	text	YES		NULL
ai_strengths	text	YES		NULL
ai_improvements	text	YES		NULL
overall_grade	char(2)	YES		NULL
generated_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	NO		NULL
subject_code	varchar(100)	NO	MUL	NULL
week	varchar(20)	NO		NULL
term	varchar(20)	NO		NULL
assessment_date	date	NO		NULL
assessment_mode	enum('marks','holistic','both')	YES		marks
grading_system	enum('9point','percentage','holistic')	YES		9point
max_marks	int(11)	YES		100
criteria_assessments	longtext	NO		NULL
subject_total	decimal(10,2)	YES		NULL
subject_grade	varchar(10)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
assignment_date	date	NO		NULL
subject	varchar(100)	YES		NULL
assignment_title	varchar(255)	YES		NULL
submission_status	enum('Submitted','Pending','Late','Completed')	YES		Pending
marks_obtained	int(11)	YES		NULL
total_marks	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class_id	int(11)	YES		NULL
section	varchar(10)	YES		NULL
attendance_date	date	NO		NULL
status	enum('Present','Absent','Late','Half Day')	YES		Present
remarks	text	YES		NULL
marked_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
field_id	int(11)	NO		NULL
field_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
special_achievements	text	YES		NULL
extra_curricular	text	YES		NULL
behavioral_observations	text	YES		NULL
areas_of_interest	text	YES		NULL
teacher_special_remarks	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
student_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO		NULL
session_id	int(11)	NO		NULL
stream_subject_id	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
exam_id	int(11)	NO	MUL	NULL
skill_subject_id	int(11)	YES	MUL	NULL
session_id	int(11)	YES	MUL	NULL
assigned_at	timestamp	NO		current_timestamp()
class_id	int(11)	YES	MUL	NULL
section_id	int(11)	YES	MUL	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
code	varchar(20)	NO	UNI	NULL
name_en	varchar(50)	NO		NULL
name_hi	varchar(50)	YES		NULL
color	varchar(7)	YES		#80D8FF
org_id	int(11)	YES	MUL	NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class_id	int(11)	YES		NULL
section_id	int(11)	YES		NULL
height	decimal(5,2)	YES		NULL
weight	decimal(5,2)	YES		NULL
org_id	int(11)	NO		NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
holistic_subject_id	int(11)	NO		NULL
grade	varchar(10)	YES		NULL
numeric_value	decimal(3,2)	YES		NULL
indicator_text	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO		NULL
session_id	int(11)	NO		NULL
subject_id	int(11)	NO		NULL
mark_structure	enum('TH','TH_PR','TH_PROJECT')	YES		TH
th_max_marks	smallint(5) unsigned	YES		100
pr_max_marks	smallint(5) unsigned	YES		0
project_max_marks	smallint(5) unsigned	YES		0
th_min_marks	smallint(5) unsigned	YES		33
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
type	varchar(20)	NO		NULL
title	varchar(200)	NO		NULL
message	text	NO		NULL
sent_by	int(11)	YES		NULL
sent_by_name	varchar(100)	YES		NULL
attendance_date	date	YES		NULL
is_read	tinyint(1)	YES		0
wa_sent	tinyint(1)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
observation_date	date	NO		NULL
behavior_type	enum('positive','neutral','improvement_needed')	YES		neutral
observation_text	text	YES		NULL
severity_level	varchar(50)	YES		normal
teacher_id	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
academic_year	varchar(20)	YES		NULL
month_year	varchar(7)	NO		NULL
attendance	decimal(5,2)	YES		0.00
academic_performance	decimal(5,2)	YES		0.00
behavior_score	decimal(5,2)	YES		0.00
improvement_areas	text	YES		NULL
achievements	text	YES		NULL
teacher_notes	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
code_type	enum('admit_card','promotion_code','tc_number','hall_ticket')	YES		NULL
code_value	varchar(50)	NO		NULL
additional_data	longtext	YES		NULL
org_id	int(11)	NO		NULL
year	year(4)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
from_session_id	int(11)	NO	MUL	NULL
to_session_id	int(11)	NO	MUL	NULL
from_class_id	int(11)	NO	MUL	NULL
to_class_id	int(11)	NO	MUL	NULL
promoted_date	timestamp	NO		current_timestamp()
promoted_by	int(11)	NO	MUL	NULL
action_type	enum('PROMOTED','DETAINED','TC_ISSUED')	YES		PROMOTED
remarks	text	YES		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
report_type	enum('weekly','monthly')	NO		NULL
period_identifier	varchar(50)	NO		NULL
remark_type	enum('teacher','parent','admin')	YES	MUL	teacher
remark_text	text	YES		NULL
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	UNI	NULL
total_marks	decimal(10,2)	NO		NULL
percentage	decimal(5,2)	NO		NULL
grade	varchar(10)	NO		NULL
result_status	varchar(255)	NO		NULL
remarks	text	NO		NULL
e_grade_subjects	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
session_id	int(11)	YES	MUL	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_name	varchar(10)	NO
roll_no	varchar(20)	YES		NULL
enrollment_date	date	YES		NULL
status	enum('active','promoted','retained','transferred','dropout','alumni')	NO	MUL	active
promoted_from_session_id	int(11)	YES		NULL
promoted_by	int(11)	YES		NULL
remarks	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
photo_path	varchar(500)	NO		NULL
photo_name	varchar(255)	NO
uploaded_by	int(11)	NO		NULL
uploaded_at	timestamp	NO		current_timestamp()
is_active	tinyint(1)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
skill_id	int(11)	NO	MUL	NULL
progress	int(11)	YES		0
level	enum('beginner','developing','proficient','advanced')	YES		beginner
last_updated	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
old_status	enum('active','inactive')	NO		NULL
new_status	enum('active','inactive')	NO		NULL
changed_by	varchar(100)	NO		NULL
changed_at	timestamp	NO	MUL	current_timestamp()
reason	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO		NULL
student_id	int(11)	NO	MUL	NULL
class_id	int(11)	NO		NULL
session_id	int(11)	NO		NULL
stream_id	int(11)	NO		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
org_id	int(10) unsigned	NO		NULL
session_id	int(10) unsigned	NO	MUL	NULL
student_id	int(10) unsigned	NO	MUL	NULL
class_id	int(10) unsigned	NO	MUL	NULL
section_id	int(10) unsigned	YES		NULL
subject_id	int(10) unsigned	NO		NULL
stream_id	int(10) unsigned	YES		NULL
group_id	int(10) unsigned	YES		NULL
sub_role	enum('main','additional')	YES		main
theory_max	decimal(6,2)	YES		70.00
practical_max	decimal(6,2)	YES		30.00
pass_theory_pct	decimal(5,2)	YES		33.00
pass_prac_pct	decimal(5,2)	YES		33.00
pass_combined	tinyint(1)	YES		1
display_order	tinyint(3) unsigned	YES		0
enrolled_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
test_date	date	NO		NULL
subject	varchar(100)	YES		NULL
test_type	varchar(100)	YES		NULL
marks_obtained	int(11)	YES		NULL
total_marks	int(11)	YES		NULL
grade	varchar(10)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
bus_id	int(11)	YES	MUL	NULL
route_id	int(11)	YES	MUL	NULL
stop_id	int(11)	YES		NULL
pickup_point	varchar(150)	YES		NULL
pickup_time	varchar(10)	YES		NULL
drop_time	varchar(10)	YES		NULL
monthly_fee	decimal(8,2)	YES		0.00
is_active	tinyint(1)	NO		1
assigned_by	int(11)	YES		NULL
assigned_at	timestamp	NO		current_timestamp()
notes	varchar(255)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
academic_year	varchar(20)	NO
class	varchar(10)	NO
section	varchar(5)	NO
roll_no	varchar(20)	YES
photo_path	varchar(400)	YES
class_teacher	varchar(100)	YES
overall_pct	decimal(5,2)	YES		0.00
att_pct	decimal(5,2)	YES		0.00
hw_completion_pct	decimal(5,2)	YES		0.00
total_obtained	decimal(8,2)	YES		0.00
total_max	decimal(8,2)	YES		0.00
subject_marks_json	mediumtext	YES		NULL
teacher_note	text	YES		NULL
ai_report	mediumtext	YES		NULL
ai_model_used	varchar(50)	YES
ai_generated_at	timestamp	YES		NULL
snapshot_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
sr_no	int(11)	NO		NULL
org_id	int(11)	NO	MUL	NULL
class	varchar(50)	NO
section	varchar(50)	NO
roll_no	int(11)	NO		NULL
admission_no	varchar(255)	NO	MUL	NULL
gender	enum('B','G','Other')	YES		NULL
std_name	varchar(255)	NO		NULL
father_name	varchar(255)	NO		NULL
mother_name	varchar(255)	NO		NULL
dob	date	YES		NULL
sssmid	varchar(255)	YES		NULL
mobile_no	varchar(15)	YES		NULL
profile_photo	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()
status	enum('active','inactive','TC-ISSUED','graduated','transferred')	YES		active
promotion_status	varchar(30)	YES		active
current_session	int(11)	YES	MUL	NULL
blood_group	varchar(5)	YES		NULL
category	varchar(50)	YES		NULL
sub_category	varchar(50)	YES		NULL
minority	varchar(50)	YES		NULL
religion	varchar(50)	YES		NULL
nationality	varchar(50)	YES		NULL
mother_tongue	varchar(50)	YES		NULL
height	decimal(5,2)	YES		NULL
weight	decimal(5,2)	YES		NULL
identification_marks	text	YES		NULL
medical_conditions	text	YES		NULL
disabilities	text	YES		NULL
permanent_address	text	YES		NULL
current_address	text	YES		NULL
district	varchar(100)	YES		NULL
state	varchar(100)	YES		NULL
pincode	varchar(10)	YES		NULL
phone	varchar(20)	YES		NULL
emergency_contact_name	varchar(255)	YES		NULL
emergency_contact_phone	varchar(20)	YES		NULL
emergency_contact_relation	varchar(50)	YES		NULL
aadhar_no	varchar(20)	YES	MUL	NULL
samagra_id	varchar(20)	YES	MUL	NULL
abha_id	varchar(20)	YES		NULL
aapar_id	varchar(20)	YES		NULL
student_bank_name	varchar(255)	YES		NULL
student_account_no	varchar(50)	YES		NULL
student_bank_ifsc	varchar(20)	YES		NULL
father_occupation	varchar(100)	YES		NULL
father_education	varchar(100)	YES		NULL
father_annual_income	decimal(10,2)	YES		NULL
father_phone	varchar(20)	YES		NULL
father_whatsapp	varchar(20)	YES	MUL	NULL
father_email	varchar(255)	YES		NULL
father_bank_name	varchar(255)	YES		NULL
father_account_no	varchar(50)	YES		NULL
father_bank_ifsc	varchar(20)	YES		NULL
father_aadhar_no	varchar(20)	YES		NULL
mother_occupation	varchar(100)	YES		NULL
mother_education	varchar(100)	YES		NULL
mother_annual_income	decimal(10,2)	YES		NULL
mother_phone	varchar(20)	YES		NULL
mother_whatsapp	varchar(20)	YES	MUL	NULL
mother_email	varchar(255)	YES		NULL
mother_aadhar_no	varchar(20)	YES		NULL
guardian_name	varchar(255)	YES		NULL
guardian_relation	varchar(50)	YES		NULL
guardian_occupation	varchar(100)	YES		NULL
guardian_phone	varchar(20)	YES		NULL
guardian_whatsapp	varchar(20)	YES		NULL
guardian_email	varchar(255)	YES		NULL
guardian_address	text	YES		NULL
transport_required	tinyint(1)	YES		0
route_no	varchar(20)	YES		NULL
bus_stop	varchar(255)	YES		NULL
hostel_required	tinyint(1)	YES		0
previous_org_name	varchar(255)	YES		NULL
previous_academic_info	text	YES		NULL
achievement_records	text	YES		NULL
tc_received	tinyint(1)	YES		0
tc_date	date	YES		NULL
tc_number	varchar(100)	YES		NULL
documents_submitted	text	YES		NULL
updated_at	timestamp	YES		NULL	on update current_timestamp()
whatsapp_opted_in	tinyint(1)	YES		1
promoted_to_class	varchar(20)	YES		NULL
promoted_to_section	varchar(10)	YES		NULL
prev_class	varchar(20)	YES		NULL
prev_section	varchar(10)	YES		NULL

Column	Type	Nullable	Default
student_id	int(11)	NO	0
admission_no	varchar(255)	NO	NULL
std_name	varchar(255)	NO	NULL
current_session	int(11)	YES	NULL
to_session_id	int(11)	NO	NULL
to_class_id	int(11)	NO	NULL
to_class	varchar(255)	NO	NULL
assigned_exams	bigint(21)	NO	0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_name	varchar(20)	NO
subject_id	int(11)	YES	MUL	NULL
subject_label	varchar(100)	NO
title	varchar(255)	NO		NULL
description	text	YES		NULL
material_type	enum('PDF','DOC','PPT','IMAGE','VIDEO','LINK','OTHER')	NO		PDF
file_path	varchar(500)	YES		NULL
file_name	varchar(255)	YES		NULL
file_size	int(11)	YES		0
ext_link	varchar(500)	YES		NULL
uploaded_by	int(11)	NO	MUL	NULL
uploaded_by_name	varchar(150)	NO
is_active	tinyint(1)	NO		1
download_count	int(11)	NO		0
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
subject_id	int(11)	NO	PRI	NULL	auto_increment
subject_name	varchar(100)	NO		NULL
status	enum('active','inactive')	NO		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
sub_code	varchar(20)	YES		NULL
sub_type	enum('core','elective','additional','co_curricular')	YES		core
display_order	int(11)	YES		1
assessment_category	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
category_name	varchar(100)	NO		NULL
category_code	char(1)	NO		NULL
description	text	YES		NULL
display_order	int(11)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
exam_id	int(11)	NO	MUL	NULL
subject_id	int(11)	NO		NULL
org_id	int(11)	NO		NULL
session_id	int(11)	NO		NULL
conducted_for	int(11)	YES		40
weightage	decimal(5,2)	YES		5.00
max_marks_display	int(11)	YES		20
status	enum('active','inactive')	YES		active
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
subject_id	int(11)	NO	PRI	NULL
exam_subject_id	int(11)	NO	PRI	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
section_name	varchar(50)	NO
subject_id	int(11)	NO	MUL	NULL
user_id	int(11)	NO	MUL	NULL
staff_member_id	int(11)	YES		NULL
assignment_status	varchar(20)	NO		active
start_date	date	YES		NULL
end_date	date	YES		NULL
remarks	varchar(500)	YES		NULL
created_by	int(11)	YES		NULL
updated_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
sub_name	varchar(255)	NO		NULL
sub_code	varchar(50)	YES		NULL
sub_type	enum('Theory','Practical')	YES		NULL
org_id	int(11)	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
category_id	int(11)	YES	MUL	NULL
display_order	int(11)	YES		1
assessment_category	char(1)	YES		B
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Default
id	int(11)	NO	0
sub_name	varchar(255)	NO	NULL
sub_code	varchar(50)	YES	NULL
sub_type	enum('Theory','Practical')	YES	NULL
org_id	int(11)	NO	NULL
created_at	timestamp	NO	current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class	varchar(30)	NO		NULL
subject	varchar(80)	NO		NULL
chapter_no	int(11)	NO		1
chapter_name	varchar(200)	NO		NULL
topics	text	YES		NULL
planned_start	date	YES		NULL
planned_end	date	YES		NULL
actual_start	date	YES		NULL
actual_end	date	YES		NULL
status	enum('not_started','in_progress','completed','skipped')	NO		not_started
completion_pct	int(11)	NO		0
assigned_teacher_id	int(11)	YES		NULL
assigned_teacher_name	varchar(100)	YES		NULL
notes	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	YES	MUL	NULL
action	varchar(100)	NO	MUL	NULL
detail	text	YES		NULL
ip	varchar(45)	YES		NULL
org_id	int(11)	YES		NULL
created_at	datetime	YES	MUL	current_timestamp()
details	text	YES		NULL
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	0
student_id	int(11)	NO	MUL	0
applied_date	date	NO		NULL
reason	text	YES		NULL
status	varchar(20)	YES		pending
tc_number	varchar(50)	YES		NULL
issued_date	date	YES		NULL
issued_by	int(11)	YES		NULL
created_at	datetime	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
table_name	varchar(60)	NO		NULL
record_id	int(11)	NO		NULL
action	varchar(20)	NO		NULL
field_changed	varchar(100)	YES		NULL
old_value	text	YES		NULL
new_value	text	YES		NULL
session_id	int(11)	YES	MUL	NULL
class_id	int(11)	YES		NULL
section_name	varchar(50)	YES		NULL
subject_id	int(11)	YES		NULL
changed_by	int(11)	YES		NULL
changed_by_name	varchar(200)	YES		NULL
changed_at	timestamp	NO		current_timestamp()
ip_address	varchar(45)	YES		NULL
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		NULL
class_id	int(11)	NO		NULL
subject_id	int(11)	YES	MUL	NULL
observation_text	text	NO		NULL
behaviour	enum('excellent','good','satisfactory','needs_improvement')	YES		NULL
participation	enum('high','medium','low')	YES		NULL
effort	enum('excellent','good','satisfactory','needs_improvement')	YES		NULL
term	enum('Term1','Term2','Annual','General')	NO		General
created_by	int(11)	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(255)	NO		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	YES		NULL
class	varchar(30)	NO		NULL
section	varchar(10)	YES		NULL
day_of_week	tinyint(4)	NO		NULL
period_no	tinyint(4)	NO		NULL
start_time	time	NO		NULL
end_time	time	NO		NULL
subject	varchar(80)	NO		NULL
teacher_id	int(11)	YES		NULL
teacher_name	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
period_no	int(11)	NO		NULL
period_name	varchar(30)	NO		Period 1
start_time	time	NO		NULL
end_time	time	NO		NULL
is_break	tinyint(1)	NO		0
day_type	enum('all','weekday','saturday')	NO		all
sort_order	int(11)	NO		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		0
class_id	int(11)	NO	MUL	NULL
class_name	varchar(30)	NO		NULL
section	varchar(10)	NO		NULL
day_of_week	tinyint(4)	NO	MUL	NULL
period_id	int(11)	NO		NULL
subject_id	int(11)	YES		NULL
subject_name	varchar(80)	YES		NULL
teacher_id	int(11)	YES	MUL	NULL
teacher_name	varchar(100)	YES		NULL
room_no	varchar(20)	YES		NULL
is_free	tinyint(1)	NO		0
created_by	int(11)	YES		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
session_id	int(11)	NO		0
slot_id	int(11)	NO	MUL	NULL
sub_date	date	NO		NULL
absent_teacher_id	int(11)	NO		NULL
absent_teacher_name	varchar(100)	NO		NULL
sub_teacher_id	int(11)	NO		NULL
sub_teacher_name	varchar(100)	NO		NULL
reason	varchar(150)	YES		NULL
approved_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
format_name	varchar(100)	NO		NULL
title_line1_format	varchar(255)	NO		NULL
title_line2_format	varchar(255)	YES		NULL
session_format	varchar(255)	YES		NULL
active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO		NULL
tc_number	varchar(50)	YES	UNI	NULL
issue_date	date	NO		NULL
reason	text	YES		NULL
org_id	int(11)	NO		NULL
year	year(4)	NO		NULL
status	enum('issued','cancelled')	YES		issued
conduct	varchar(50)	YES		Good
leaving_date	date	YES		NULL
last_class	varchar(50)	YES		NULL
last_exam	varchar(100)	YES		NULL
fee_paid	varchar(10)	YES		yes
ncc	varchar(50)	YES		No
games_sports	varchar(100)	YES		NULL
extra_activity	varchar(100)	YES		NULL
remarks	text	YES		NULL
class_name	varchar(50)	YES		NULL
section_name	varchar(50)	YES		NULL
result	varchar(100)	YES		NULL
issued_by	int(11)	YES		NULL
issued_by_name	varchar(100)	YES		NULL
cancelled_at	datetime	YES		NULL
cancelled_by	varchar(100)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
bus_number	varchar(30)	NO		NULL
registration_no	varchar(30)	YES		NULL
capacity	int(11)	NO		40
driver_name	varchar(100)	NO
driver_mobile	varchar(15)	YES		NULL
driver_license	varchar(30)	YES		NULL
conductor_name	varchar(100)	YES		NULL
conductor_mobile	varchar(15)	YES		NULL
gps_number	varchar(20)	YES		NULL
insurance_expiry	date	YES		NULL
fitness_expiry	date	YES		NULL
notes	text	YES		NULL
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
route_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO	MUL	NULL
stop_name	varchar(100)	NO		NULL
stop_order	int(11)	NO		1
morning_time	time	YES		NULL
afternoon_time	time	YES		NULL
distance_km	decimal(6,1)	YES		NULL
landmark	varchar(150)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
route_name	varchar(100)	NO		NULL
route_number	varchar(20)	YES		NULL
bus_id	int(11)	YES	MUL	NULL
from_place	varchar(100)	YES		NULL
to_place	varchar(100)	YES		NULL
morning_arrival	time	YES		NULL
afternoon_departure	time	YES		NULL
monthly_fee	decimal(8,2)	NO		0.00
distance_km	decimal(6,1)	YES		NULL
is_active	tinyint(1)	NO		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
route_id	int(11)	NO		NULL
student_id	int(11)	NO		NULL
student_name	varchar(150)	NO		NULL
pickup_point	varchar(100)	YES		NULL
fee_monthly	decimal(8,2)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
org_id	int(11)	YES	MUL	NULL
role	enum('super_admin','org_admin','user')	NO		NULL
file_name	varchar(255)	NO		NULL
uploaded_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
activity_type	varchar(50)	NO		NULL
description	text	YES		NULL
ip_address	varchar(45)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
class_id	int(11)	NO	MUL	NULL
section_id	int(11)	NO		0
section_name	varchar(20)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
login_time	timestamp	NO		current_timestamp()
ip_address	varchar(45)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
title	varchar(255)	NO		NULL
message	text	NO		NULL
type	enum('info','warning','success','error')	YES		info
is_read	tinyint(1)	YES		0
read_at	timestamp	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
permission_id	int(11)	NO	MUL	NULL
granted	tinyint(1)	NO		1
org_id	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
user_id	int(11)	NO		NULL
preference_key	varchar(100)	NO		NULL
preference_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
role_id	int(11)	NO	MUL	NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
module_name	varchar(50)	NO		UNKNOWN
page_url	varchar(200)	YES		NULL
session_date	date	NO		NULL
total_seconds	int(11)	NO		0
last_ping	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
session_id	varchar(255)	NO		NULL
expires_at	datetime	NO		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
user_id	int(11)	NO	MUL	NULL
notification_email	tinyint(1)	YES		1
notification_web	tinyint(1)	YES		1
theme_preference	varchar(10)	YES		light
language_preference	varchar(5)	YES		en
profile_visible	tinyint(1)	YES		1
activity_visible	tinyint(1)	YES		1
created_at	datetime	YES		current_timestamp()
updated_at	datetime	YES		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
username	varchar(255)	NO	UNI	NULL
name	varchar(255)	YES		NULL
email	varchar(255)	NO	UNI	NULL
mobile	varchar(20)	YES		NULL
google_id	varchar(100)	YES	MUL	NULL
profile_image	text	YES		NULL
password	varchar(255)	NO		NULL
plain_password	varchar(100)	YES		NULL
role	enum('super_admin','org_admin','org_user','user')	NO		NULL
portal_type	enum('staff','parent','student')	YES		staff
designation	enum('class_teacher','subject_teacher','principal','vice_principal','office_staff','accountant','librarian','coordinator','exam_controller','other')	YES		NULL
portal_redirect	varchar(100)	YES		NULL
org_id	int(11)	YES	MUL	NULL
student_id	int(11)	YES		NULL
approval_status	enum('approved','pending','rejected')	YES		pending
created_at	timestamp	NO		current_timestamp()
status	enum('active','inactive','pending')	YES		active
last_login	timestamp	YES		NULL
phone	varchar(15)	YES	MUL	NULL
photo	varchar(255)	YES		NULL
last_login_at	datetime	YES		NULL
password_changed_at	datetime	YES		NULL
remember_token	varchar(100)	YES		NULL
profile_photo	varchar(255)	YES		NULL
two_factor_enabled	tinyint(1)	YES		0
two_factor_secret	varchar(255)	YES		NULL
login_attempts	int(11)	YES		0
locked_until	timestamp	YES		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
visit_date	date	NO		NULL
visit_time_in	time	NO		NULL
visit_time_out	time	YES		NULL
visitor_name	varchar(150)	NO		NULL
visitor_mobile	varchar(15)	YES		NULL
visitor_address	varchar(255)	YES		NULL
visitor_id_type	enum('aadhar','pan','voter_id','driving_license','passport','school_id','other')	YES		NULL
visitor_id_no	varchar(30)	YES		NULL
purpose	enum('meeting','student_pickup','delivery','maintenance','inspection','other')	NO		meeting
purpose_detail	varchar(200)	YES		NULL
whom_to_meet	varchar(150)	YES		NULL
student_id	int(11)	YES	MUL	NULL
student_name	varchar(150)	YES		NULL
student_class	varchar(20)	YES		NULL
badge_no	varchar(20)	YES		NULL
items_brought	varchar(200)	YES		NULL
items_carried_out	varchar(200)	YES		NULL
logged_by	int(11)	NO		NULL
logged_by_name	varchar(100)	NO		NULL
status	enum('inside','exited','overstay')	NO	MUL	inside
remarks	varchar(255)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
history_text	text	YES		NULL
vision_text	text	YES		NULL
mission_text	text	YES		NULL
values_text	text	YES		NULL
school_photo_url	varchar(255)	YES		NULL
total_students	varchar(30)	YES		NULL
total_staff	varchar(30)	YES		NULL
campus_acres	varchar(30)	YES		NULL
classes_range	varchar(50)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
curriculum_text	text	YES		NULL
classes_info	text	YES		NULL
exam_pattern	text	YES		NULL
academic_calendar_url	varchar(255)	YES		NULL
syllabus_urls	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
student_name	varchar(150)	NO		NULL
father_name	varchar(150)	YES		NULL
mother_name	varchar(150)	YES		NULL
dob	date	YES		NULL
gender	enum('male','female','other')	YES		NULL
class_applying	varchar(10)	YES		NULL
previous_school	varchar(200)	YES		NULL
prev_percentage	varchar(20)	YES		NULL
phone	varchar(20)	NO		NULL
email	varchar(100)	YES		NULL
address	text	YES		NULL
message	text	YES		NULL
status	enum('new','reviewing','approved','rejected')	YES		new
submitted_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
campus_area_sqmt	varchar(50)	YES		NULL
classrooms_count	varchar(10)	YES		NULL
classroom_size_sqmt	varchar(30)	YES		NULL
labs_count	varchar(10)	YES		NULL
labs_size_sqmt	varchar(30)	YES		NULL
boys_toilets	varchar(10)	YES		NULL
girls_toilets	varchar(10)	YES		NULL
internet_facility	enum('Yes','No')	YES		Yes
youtube_inspection	varchar(255)	YES		NULL
teacher_section_ratio	varchar(30)	YES		NULL
special_educator	varchar(30)	YES		NULL
counsellor	varchar(30)	YES		NULL
total_teachers	varchar(10)	YES		NULL
staff_pgt	varchar(10)	YES		NULL
staff_tgt	varchar(10)	YES		NULL
staff_prt	varchar(10)	YES		NULL
doc_affiliation	varchar(255)	YES		NULL
doc_trust_reg	varchar(255)	YES		NULL
doc_noc	varchar(255)	YES		NULL
doc_rte_recognition	varchar(255)	YES		NULL
doc_building_safety	varchar(255)	YES		NULL
doc_fire_safety	varchar(255)	YES		NULL
doc_deo_certificate	varchar(255)	YES		NULL
doc_water_health	varchar(255)	YES		NULL
doc_land_certificate	varchar(255)	YES		NULL
doc_fee_structure	varchar(255)	YES		NULL
doc_academic_calendar	varchar(255)	YES		NULL
doc_smc	varchar(255)	YES		NULL
doc_pta	varchar(255)	YES		NULL
doc_board_result	varchar(255)	YES		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
title	varchar(200)	NO		NULL
category	varchar(60)	YES		General
file_url	varchar(255)	NO		NULL
file_size	varchar(20)	YES		NULL
description	varchar(200)	YES		NULL
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(100)	NO		NULL
email	varchar(100)	YES		NULL
phone	varchar(20)	YES		NULL
subject	varchar(150)	YES		NULL
message	text	NO		NULL
status	enum('new','read','replied')	YES		new
submitted_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(150)	NO		NULL
designation	varchar(100)	YES		NULL
department	varchar(80)	YES		NULL
qualification	varchar(150)	YES		NULL
experience_years	int(11)	YES		NULL
photo_url	varchar(255)	YES		NULL
email	varchar(100)	YES		NULL
is_teaching	tinyint(1)	YES		1
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(150)	NO		NULL
from_year	varchar(10)	YES		NULL
to_year	varchar(10)	YES		NULL
qualification	varchar(150)	YES		NULL
photo_url	varchar(255)	YES		NULL
note	varchar(255)	YES		NULL
display_order	int(11)	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
album_name	varchar(100)	YES		General
caption	varchar(200)	YES		NULL
image_url	varchar(255)	NO		NULL
is_active	tinyint(1)	YES		1
display_order	int(11)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
title	varchar(200)	NO		NULL
icon	varchar(60)	YES		fas fa-file-pdf
file_url	varchar(255)	YES		NULL
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
title	varchar(200)	NO		NULL
content	text	YES		NULL
news_date	date	NO		NULL
image_url	varchar(255)	YES		NULL
is_active	tinyint(1)	YES		1
display_order	int(11)	YES		0
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class_name	enum('X','XII')	NO		NULL
year	varchar(12)	NO		NULL
registered	int(11)	YES		0
passed	int(11)	YES		0
pass_pct	decimal(5,2)	YES		0.00
remarks	varchar(50)	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	UNI	NULL
tagline	varchar(200)	YES		NULL
about_text	text	YES		NULL
established_year	varchar(10)	YES		NULL
principal_name	varchar(150)	YES		NULL
principal_qualification	varchar(150)	YES		NULL
principal_message	text	YES		NULL
principal_photo	varchar(255)	YES		NULL
school_code	varchar(30)	YES		NULL
logo_url	varchar(255)	YES		NULL
banner_url	varchar(255)	YES		NULL
primary_color	varchar(10)	YES		#003087
secondary_color	varchar(10)	YES		#c8a000
contact_whatsapp	varchar(20)	YES		NULL
contact_address	varchar(300)	YES		NULL
contact_phone	varchar(50)	YES		NULL
contact_email	varchar(100)	YES		NULL
google_maps_embed	text	YES		NULL
social_facebook	varchar(255)	YES		NULL
social_youtube	varchar(255)	YES		NULL
social_instagram	varchar(255)	YES		NULL
social_twitter	varchar(255)	YES		NULL
modules_enabled	text	YES		NULL
site_status	enum('live','maintenance','draft')	YES		draft
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
show_stats	tinyint(1)	YES		1
show_calendar	tinyint(1)	YES		0
vision_text	text	YES		NULL
mission_text	text	YES		NULL
values_text	text	YES		NULL
milestones_json	text	YES		NULL
layout_style	varchar(30)	YES		standard
slider_type	varchar(20)	YES		fade
gallery_cols	tinyint(4)	YES		3

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
image_url	varchar(255)	NO		NULL
caption	varchar(200)	YES		NULL
link_url	varchar(255)	YES		NULL
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
name	varchar(100)	NO		NULL
role	varchar(60)	YES		NULL
batch_year	varchar(20)	YES		NULL
quote	text	NO		NULL
photo_url	varchar(255)	YES		NULL
rating	tinyint(4)	YES		5
display_order	int(11)	YES		0
is_active	tinyint(1)	YES		1

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
week_start	date	NO		NULL
observations	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
org_id	int(11)	NO		NULL
week_start	date	NO		NULL
week_end	date	NO		NULL
report_data	longtext	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
message_id	int(11)	YES		NULL
sent_time	datetime	YES		NULL
delivery_time	datetime	YES		NULL
read_time	datetime	YES		NULL
parent_response	text	YES		NULL
response_time	datetime	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
student_id	int(11)	NO	MUL	NULL
parent_name	varchar(255)	YES		NULL
whatsapp_number	varchar(20)	NO	MUL	NULL
relationship	enum('father','mother','guardian','self')	YES		father
is_primary	tinyint(1)	YES		1
is_active	tinyint(1)	YES		1
opted_in	tinyint(1)	YES		1
opted_in_date	datetime	YES		NULL
opted_out_date	datetime	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	YES		NULL	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
recipient	varchar(20)	NO	MUL	NULL
message	text	NO		NULL
message_sid	varchar(50)	YES		NULL
status	enum('sent','failed','delivered','read')	NO	MUL	NULL
error_message	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()
description	text	YES		NULL

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
report_detail_id	int(11)	NO	MUL	NULL
priority	int(11)	YES	MUL	5
scheduled_at	datetime	YES		current_timestamp()
processed_at	datetime	YES		NULL
status	enum('pending','processing','completed','failed')	YES	MUL	pending
retry_count	int(11)	YES		0
max_retries	int(11)	YES		3

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
report_id	int(11)	NO	MUL	NULL
student_id	int(11)	NO	MUL	NULL
message	text	NO		NULL
status	enum('success','failed')	NO	MUL	failed
error_message	text	YES		NULL
sent_at	datetime	NO		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
report_type	varchar(50)	NO		NULL
class_id	varchar(50)	NO		NULL
section_id	varchar(50)	NO		NULL
success_count	int(11)	NO		0
fail_count	int(11)	NO		0
sent_date	datetime	NO	MUL	NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
recipient	varchar(20)	NO		NULL
message	text	NO		NULL
scheduled_time	datetime	NO	MUL	NULL
status	enum('pending','sent','failed')	YES	MUL	pending
sent_time	datetime	YES		NULL
error_message	text	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
message_type	varchar(50)	YES		NULL
template_id	int(11)	YES		NULL
custom_message	text	YES		NULL
scheduled_date	datetime	YES		NULL
recurrence	varchar(20)	YES		NULL
status	varchar(20)	YES		NULL
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
setting_key	varchar(50)	NO		NULL
setting_value	text	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
template_name	varchar(100)	NO		NULL
template_type	enum('daily_attendance','absent_notification','homework','announcement','monthly_report','custom')	NO	MUL	custom
message_text	text	NO		NULL
variables	longtext	YES		NULL
org_id	int(11)	YES		NULL
is_active	tinyint(1)	YES		1
created_by	int(11)	YES		NULL
created_at	timestamp	NO		current_timestamp()
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(11)	NO	PRI	NULL	auto_increment
org_id	int(11)	NO	MUL	NULL
class	varchar(5)	NO		NULL
subject	varchar(100)	NO		NULL
topic	varchar(200)	NO		NULL
difficulty	enum('easy','medium','hard')	YES		easy
content_json	longtext	YES		NULL
created_by	int(11)	YES		NULL
session_id	int(11)	YES		NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
group_id	int(10) unsigned	NO	MUL	NULL
subject_id	int(10) unsigned	NO		NULL
sub_role	enum('main','additional')	YES		main
theory_max	decimal(6,2)	YES		70.00
practical_max	decimal(6,2)	YES		30.00
pass_theory	decimal(5,2)	YES		33.00
pass_practical	decimal(5,2)	YES		33.00
pass_combined	tinyint(1)	YES		1
display_order	tinyint(3) unsigned	YES		0

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
org_id	int(10) unsigned	NO	MUL	NULL
session_id	int(10) unsigned	NO	MUL	NULL
student_id	int(10) unsigned	NO	MUL	NULL
subject_id	int(10) unsigned	NO		NULL
exam_id	int(10) unsigned	NO		NULL
enrollment_id	int(10) unsigned	YES		NULL
theory_obtained	decimal(6,2)	YES		NULL
practical_obtained	decimal(6,2)	YES		NULL
theory_max	decimal(6,2)	YES		70.00
practical_max	decimal(6,2)	YES		30.00
is_absent_theory	tinyint(1)	YES		0
is_absent_practical	tinyint(1)	YES		0
is_exempt	tinyint(1)	YES		0
grace_applied	decimal(4,1)	YES		0.0
remarks	varchar(100)	YES		NULL
entered_by	int(10) unsigned	YES		NULL
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
org_id	int(10) unsigned	NO	MUL	NULL
exam_group_id	int(10) unsigned	NO	MUL	NULL
subject_id	int(10) unsigned	YES		NULL
pass_mode	enum('subject_wise','overall','theory_practical','custom')	YES		theory_practical
theory_pass_pct	decimal(5,2)	YES		33.00
prac_pass_pct	decimal(5,2)	YES		33.00
overall_pass_pct	decimal(5,2)	YES		33.00
combined_pass	tinyint(1)	YES		1
grace_marks	decimal(4,1)	YES		0.0
compartment_limit	tinyint(4)	YES		2
updated_at	timestamp	NO		current_timestamp()	on update current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
org_id	int(10) unsigned	NO	MUL	NULL
session_id	int(10) unsigned	NO		NULL
class_id	int(10) unsigned	NO		NULL
stream_name	varchar(60)	NO		NULL
description	varchar(200)	YES		NULL
is_active	tinyint(1)	YES		1
created_at	timestamp	NO		current_timestamp()

Column	Type	Nullable	Key	Default	Extra
id	int(10) unsigned	NO	PRI	NULL	auto_increment
stream_id	int(10) unsigned	NO	MUL	NULL
group_name	varchar(60)	NO		NULL
group_type	enum('compulsory','optional','additional')	YES		optional
min_select	tinyint(3) unsigned	YES		1
max_select	tinyint(3) unsigned	YES		1
display_order	tinyint(3) unsigned	YES		0

Database Structure

Tables

355

Total Records

290,954

Avg. Table Size

820

Tables