Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id int(11)
company_id int(11)
branch_id int(11)
academic_year_id int(11)
generation_batch_id int(11)
version_id int(11)
schedule_mode enum('WEEKLY', 'DATE_SPECIFIC') utf8mb4_general_ci
timetable_date date
day_name varchar(20) utf8mb4_general_ci
period_id int(11)
period_order int(11)
class_id int(11)
section_id int(11)
subject_id int(11)
teacher_id int(11)
room_id int(11)
slot_type enum('REGULAR', 'BLOCK', 'LAB', 'BREAK', 'FREE', 'SUBSTITUTION', 'SPECIAL', 'EXAM', 'EVENT') utf8mb4_general_ci
entry_status enum('DRAFT', 'REVIEWED', 'APPROVED', 'PUBLISHED') utf8mb4_general_ci
source_type enum('AI_GENERATED', 'MANUAL', 'TEACHER_SELF_ENTRY', 'IMPORT', 'SUBSTITUTION', 'DAILY_CHANGE') utf8mb4_general_ci
status enum('DRAFT', 'ACTIVE', 'LOCKED', 'CANCELLED', 'REPLACED') utf8mb4_general_ci
is_published tinyint(1)
published_at datetime
is_locked tinyint(1)
locked_by int(11)
locked_at datetime
is_ai_generated tinyint(1)
ai_score decimal(5,2)
ai_reason text utf8mb4_general_ci
parent_entry_id int(11)
remarks text utf8mb4_general_ci
delete_status tinyint(1)
created_by int(11)
updated_by int(11)
created_at datetime
updated_at datetime