남친

테이블 (5)

CAFE

  • cafe_id — not null — 기본 키 — NOT NULL
  • Key — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3

리뷰 (REVIEW)

  • review_id — char — 기본 키 — NOT NULL — PK
  • rating — char
  • content — char
  • created_at — char
  • reservation_id (reservation_id2) — char — 외래 키 → 예약.reservation_id — NOT NULL — FK

손님 (CUSTOMER)

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

예약 (RESERVATION)

  • reservation_id — char — 기본 키 — NOT NULL — PK
  • date — char
  • time — char
  • player_cnt — number
  • is_success — boolean
  • escape_time — char
  • hint_cnt — number
  • customer_id — char — 외래 키 → 손님.customer_id — NOT NULL — FK
  • theme_id — char — 외래 키 → 테마.theme_id — NOT NULL — FK

테마 (THEME)

  • theme_id — char — 기본 키 — NOT NULL — PK
  • cafe_id — char — 외래 키 → CAFE.cafe_id — NOT NULL — FK
  • theme_name — char
  • difficulty — number
  • genre — char
  • time_limit