실습1

테이블 (5)

CAFE

  • cafe_id — 기본 키 — NOT NULL — PK
  • cafe_name
  • location

CUSTOMER (Untitled2)

  • customer_id — 기본 키 — NOT NULL — PK
  • nickname
  • phone
  • name

RESERVATION

  • reservation_id — 기본 키 — NOT NULL — PK
  • 날짜
  • 시간
  • player_cnt
  • is_success
  • escape_time
  • hint_cnt
  • customer_id — 외래 키 → CUSTOMER.customer_id — NOT NULL — PK

REVIEW

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

THEME

  • theme_id (cafe_id) — 기본 키 — NOT NULL — PK
  • theme_name
  • difficulty
  • genre (Field2)
  • time_limit
  • max_player
  • cafe_id (cafe_id2) — 외래 키 → CAFE.cafe_id — NOT NULL — PK
  • reservation_id — 외래 키 → RESERVATION.reservation_id — NOT NULL — PK