테스트

테이블 (5)

RESERVATION (Untitled4)

  • reservation_id (Primary Key) — 기본 키 — NOT NULL
  • theme_id (Field)
  • 날짜 (Field2)
  • 시간 (Field3)
  • player_cnt (Field4)
  • is_success (Field5)
  • escape_time (Field6)
  • hint_cnt (Field7)
  • customer_id (Primary Key2) — 외래 키 → customer.customer_id — NOT NULL
  • theme_id (Primary Key3) — 외래 키 → THEME.theme_id — NOT NULL
  • review_id (Primary Key4) — 외래 키 → REVIEW.review_id — NOT NULL

REVIEW (Untitled5)

  • review_id (Primary Key) — 기본 키 — NOT NULL
  • reservation_id (Foreign Key)
  • rating (Field)
  • content (Field2)
  • created_at (Field3)

THEME (Untitled3)

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

cafe (Untitled)

  • cafe_id (Primary Key) — 기본 키 — NOT NULL
  • cafe_name (Field)
  • location (Field2)
  • phone (Field3)

customer (Untitled2)

  • customer_id (Primary Key) — 기본 키 — NOT NULL
  • nickname (Field)
  • name (Field2)
  • phone (Field3)