TimeTable
Tables (4)
assignment
- id — bigint — Primary key
- course_id — bigint — Foreign key → course.id
- title — varchar(255) — NOT NULL
- deadline — DATETIME — NOT NULL
course
- id — bigint — Primary key
- user_id — varchar(50)
- title — varchar(255) — NOT NULL
- instructor — varchar(255) — NOT NULL
- color — varchar(255)
time_table
- id — bigint — Primary key
- user_id — varchar(50) — NOT NULL
- name — varchar(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_main — BOOLEAN
time_table_detail
- id — bigint — Primary key
- time_table_id — bigint — Foreign key → time_table.id
- course_id — bigint — Foreign key → course.id
- weekday — int — NOT NULL
- location — varchar(100)
- start_time — TIME
- end_time — TIME