DB: u170248404_bio

Generated at: 2025-09-01T08:31:21.088353

Tables

academic_terms
academic_years
bio_layouts
bio_layout_items
bio_modules
classrooms
course_sections
districts
enrollments
failed_jobs
jobs
migrations
password_resets
plickers_cards
portfolio_links
projects
schema_migrations
schools
students
subjects
teachers
timetable_slots
users

academic_terms

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`year_id`	bigint(20)	YES	NULL	-
`code`	tinyint(3)	NO	-	-
`name`	varchar(255)	NO	-	-
`start_date`	date	YES	NULL	-
`end_date`	date	YES	NULL	-
`is_active`	tinyint(1)	NO	1	-

academic_years

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`label`	varchar(255)	YES	NULL	-
`start_date`	date	YES	NULL	-
`end_date`	date	YES	NULL	-
`is_active`	tinyint(1)	NO	1	-

bio_layouts

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`slug`	varchar(100)	NO	-	-
`title`	varchar(255)	NO	-	-
`description`	text	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`is_active`	tinyint(1)	NO	1	-

bio_layout_items

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`layout_id`	bigint(20)	NO	-	-
`module_slug`	varchar(100)	NO	-	-
`slot`	enum('header'	NO	-	-
`sort_order`	smallint(5)	NO	0	-
`is_enabled`	tinyint(1)	NO	1	-
`config`	longtext	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`settings`	longtext	YES	NULL	-
`position`	int(11)	NO	0	-

bio_modules

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`slug`	varchar(100)	NO	-	-
`name`	varchar(255)	NO	-	-
`version`	varchar(20)	YES	1.0.0	-
`is_enabled`	tinyint(1)	NO	1	-
`settings_schema`	longtext	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

classrooms

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`name`	varchar(255)	YES	NULL	-
`capacity`	smallint(5)	YES	NULL	-
`grade_level`	tinyint(3)	YES	NULL	-
`school_id`	bigint(20)	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

course_sections

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`name`	varchar(255)	YES	NULL	-
`classroom_id`	bigint(20)	YES	NULL	-
`subject_id`	bigint(20)	YES	NULL	-
`teacher_id`	bigint(20)	YES	NULL	-
`term_id`	bigint(20)	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

districts

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`name`	varchar(255)	NO	-	-
`region`	varchar(255)	YES	NULL	-

enrollments

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`student_id`	bigint(20)	YES	NULL	-
`course_section_id`	bigint(20)	NO	-	-
`sort_order`	int(11)	YES	NULL	-
`classroom_id`	bigint(20)	YES	NULL	-
`term_id`	bigint(20)	YES	NULL	-
`status`	enum('active'	NO	active	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

failed_jobs

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`connection`	text	NO	-	-
`queue`	text	NO	-	-
`payload`	longtext	NO	-	-
`exception`	longtext	NO	-	-
`failed_at`	timestamp	NO	current_timestamp()	-

jobs

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`queue`	varchar(255)	NO	-	-
`payload`	longtext	NO	-	-
`attempts`	tinyint(3)	NO	-	-
`reserved_at`	int(10)	YES	NULL	-
`available_at`	int(10)	NO	-	-
`created_at`	int(10)	NO	-	-

migrations

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	int(10)	NO	-	-
`migration`	varchar(255)	NO	-	-
`batch`	int(11)	NO	-	-

password_resets

Columns

Column	Type	NULL	Default	Extra
`email`	varchar(255)	NO	-	-
`token`	varchar(255)	NO	-	-
`created_at`	timestamp	YES	NULL	-

plickers_cards

PK: id, national_id

Columns

Column	Type	NULL	Default	Extra
`id`	int(10)	NO	-	-
`national_id`	varchar(10)	NO	-	-
`card_number`	int(10)	NO	-	-
`created_at`	datetime	YES	NULL	-
`updated_at`	datetime	YES	NULL	-

portfolio_links

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`code`	varchar(32)	NO	-	-
`student_id`	bigint(20)	NO	-	-
`course_section_id`	bigint(20)	YES	NULL	-
`expires_at`	datetime	YES	NULL	-
`created_at`	datetime	NO	current_timestamp()	-

projects

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`title`	varchar(255)	NO	-	-
`slug`	varchar(255)	NO	-	-
`description`	text	YES	NULL	-
`image_url`	varchar(255)	YES	NULL	-
`url`	varchar(255)	YES	NULL	-
`published_at`	timestamp	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

schema_migrations

PK: filename

Columns

Column	Type	NULL	Default	Extra
`filename`	varchar(190)	NO	-	-
`applied_at`	datetime	NO	current_timestamp()	-

schools

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`district_id`	bigint(20)	YES	NULL	-
`name`	varchar(255)	NO	-	-
`moe_code`	varchar(255)	YES	NULL	-
`address`	varchar(255)	YES	NULL	-
`phone`	varchar(255)	YES	NULL	-

students

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`school_id`	bigint(20)	NO	-	-
`user_id`	bigint(20)	YES	NULL	-
`national_id`	varchar(20)	NO	-	-
`full_name`	varchar(255)	NO	-	-
`current_grade_level`	tinyint(3)	YES	NULL	-
`status`	enum('active'	NO	active	-
`sort_order`	int(11)	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

subjects

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-
`name`	varchar(255)	NO	-	-
`code`	varchar(255)	YES	NULL	-

teachers

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`name`	varchar(255)	NO	-	-
`code`	varchar(64)	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

timetable_slots

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	int(10)	NO	-	-
`course_section_id`	bigint(20)	NO	-	-
`day_index`	tinyint(3)	NO	-	-
`period_no`	tinyint(3)	NO	-	-
`title`	varchar(100)	YES	NULL	-
`room`	varchar(50)	YES	NULL	-
`note`	varchar(255)	YES	NULL	-

users

PK: id

Columns

Column	Type	NULL	Default	Extra
`id`	bigint(20)	NO	-	-
`name`	varchar(255)	NO	-	-
`email`	varchar(255)	NO	-	-
`email_verified_at`	timestamp	YES	NULL	-
`password`	varchar(255)	NO	-	-
`role`	enum('student'	NO	student	-
`school_id`	bigint(20)	YES	NULL	-
`remember_token`	varchar(100)	YES	NULL	-
`created_at`	timestamp	YES	NULL	-
`updated_at`	timestamp	YES	NULL	-

Findings

[course_sections] Missing FK: teacher_id -> teachers.id
[plickers_cards] Composite PRIMARY KEY (id, national_id) with AUTO_INCREMENT id; consider using PRIMARY KEY(id) and UNIQUE(national_id) or vice versa.
[national_id] Type differs: students.varchar(20) vs plickers_cards.varchar(10). Recommend aligning.
[bio_layout_items] module_slug values not found in bio_modules.slug: ['plickers_min']
[bio_layouts] Found row with empty slug ''. UNIQUE constraint allows only one empty slug; consider forbidding empty slug.

Source: db_schema_report.json