실습1

테이블 (5)

CUSTOMER (Untitled2)

  • customer_id (PK) — 기본 키 — NOT NULL
  • nickname (Field)
  • Field2
  • phone (Field3)

RESERVATION (Untitled4)

  • reservation_id (PK) — 기본 키 — NOT NULL
  • customer_id (FK) — 외래 키 → CUSTOMER.customer_id — NOT NULL
  • theme_id (PK2) — 외래 키 → THEME.theme_id — NOT NULL
  • date (Field)
  • time (Field2)
  • player_cnt (Field3)
  • is_success (Field4)
  • escape_time (Field5)
  • hint_cnt (Field6)

REVIEW (Untitled5)

  • review_id (PK) — 기본 키 — NOT NULL
  • reservation_id (FK) — 외래 키 → RESERVATION.reservation_id — NOT NULL
  • rating (Field)
  • content (Field2)
  • created_at (Field3)

THEME (Untitled3)

  • theme_id (PK) — 기본 키 — NOT NULL
  • cafe_id (FK) — 외래 키 → cafe.cafe_id — NOT NULL
  • theme_name (Field2)
  • difficulty (Field3)
  • genre (Field)
  • time_limit (Field4)
  • max_players (Field5)

cafe (Untitled)

  • cafe_id (PK) — 기본 키 — NOT NULL
  • cafe_name (char)
  • location (Field)
  • phone (Field2)