모이라
테이블 (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