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