|
id
|
int(11)
|
|
|
|
|
company_id
|
int(11)
|
|
|
0
|
|
branch_id
|
int(11)
|
|
|
0
|
|
academic_year_id
|
int(11)
|
|
|
0
|
|
generation_batch_id
|
int(11)
|
|
|
0
|
|
version_id
|
int(11)
|
|
|
0
|
|
schedule_mode
|
enum
|
-- |
|
WEEKLY
|
|
timetable_date
|
date
|
|
|
|
|
day_name
|
varchar(20)
|
|
|
|
|
period_id
|
int(11)
|
|
|
0
|
|
period_order
|
int(11)
|
|
|
0
|
|
class_id
|
int(11)
|
|
|
0
|
|
section_id
|
int(11)
|
|
|
0
|
|
subject_id
|
int(11)
|
|
|
0
|
|
teacher_id
|
int(11)
|
|
|
0
|
|
room_id
|
int(11)
|
|
|
0
|
|
slot_type
|
enum
|
-- |
|
REGULAR
|
|
entry_status
|
enum
|
-- |
|
DRAFT
|
|
source_type
|
enum
|
-- |
|
AI_GENERATED
|
|
status
|
enum
|
-- |
|
DRAFT
|
|
is_published
|
tinyint(1)
|
|
|
0
|
|
published_at
|
datetime
|
|
|
|
|
is_locked
|
tinyint(1)
|
|
|
0
|
|
locked_by
|
int(11)
|
|
|
0
|
|
locked_at
|
datetime
|
|
|
|
|
is_ai_generated
|
tinyint(1)
|
|
|
0
|
|
ai_score
|
decimal(5,2)
|
|
|
0.00
|
|
ai_reason
|
text
|
|
|
|
|
parent_entry_id
|
int(11)
|
|
|
0
|
|
remarks
|
text
|
|
|
|
|
delete_status
|
tinyint(1)
|
|
|
0
|
|
created_by
|
int(11)
|
|
|
0
|
|
updated_by
|
int(11)
|
|
|
0
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|