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