인모

테이블 (5)

CAFE

  • cafe_id — int — 기본 키 — NOT NULL
  • cafe_name — varchar
  • location — varchar
  • phone — int

CUSTOMER

  • customer_id — int — 기본 키 — NOT NULL
  • nickname — varchar
  • name — varchar
  • phone — int

RESERVATION

  • reservation_id — int — 기본 키 — NOT NULL
  • theme_id — int
  • day — varchar
  • time — varchar
  • player_cnt — varchar
  • is_success — varchar
  • escape_timeescape_time (Field) — varchar
  • hint_cnt — varchar
  • customer_id — int — 외래 키 → CUSTOMER.customer_id — NOT NULL

REVIEW

  • review_id — int — 기본 키 — NOT NULL
  • rating — varchar
  • content — varchar
  • created_at — varchar
  • reservation_id — int — 외래 키 → RESERVATION.reservation_id — NOT NULL

THEME

  • theme_id — int — 기본 키 — NOT NULL
  • theme_name — varchar
  • difficulty — varchar
  • genre — varchar
  • time_limit — int
  • cafe_id — int — 외래 키 → CAFE.cafe_id — NOT NULL
  • reservation_id — int — 외래 키 → RESERVATION.reservation_id — NOT NULL