SlotMaster
테이블 (3)
예약 내역 (reservations)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- user_id (Key2) — BIGINT — 외래 키 → 회원.id — NOT NULL
- slot_id (Key3) — BIGINT — 외래 키 → 예약 슬롯.id — NOT NULL
- status (Field) — ENUM
- reserved_at (Field2) — TIMESTAMP
- cancelled_at (Field3) — TIMESTAMP
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
예약 슬롯 (slots)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- start_time (Field2) — DATETIME
- end_time (Field3) — DATETIME
- max_participants (Field4) — INT
- current_participants (Field5) — INT
- status (Field6) — ENUM
- created_at (Field7) — TIMESTAMP
- updated_at (Field8) — TIMESTAMP
회원 (users)
- id (Key) — BIGINT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP