uoslife/academic_calendar

테이블 (5)

Untitled (user)

  • Key (id) — bigint — 기본 키 — NOT NULL

Untitled (notification)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (notify_at) — datetime
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

북마크 (schedule_bookmark)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (schedule_id) — bigint — 외래 키 → 학사일정.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime

알림 (schedule_notification)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (schedule_id) — bigint — 외래 키 → 학사일정.Key — NOT NULL
  • Key (notification_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

학사일정 (schedule)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (start_time) — datetime
  • Field (end_time) — datetime
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime