모이라

테이블 (5)

meeting

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • cancelled_at — DATETIME
  • deleted_at — DATETIME

meeting_member

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • joined_at — DATETIME — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

schedule_candidate

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_id — BIGINT — 외래 키 → meeting.id — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • status — VARCHAR(30) — NOT NULL

schedule_preference

  • id — BIGINT — 기본 키 — NOT NULL
  • meeting_member_id — BIGINT — 외래 키 → meeting_member.id — NOT NULL
  • schedule_candidate_id — BIGINT — 외래 키 → schedule_candidate.id — NOT NULL
  • preference — VARCHAR(30) — NOT NULL