escape

Tables (5)

cafe (Untitled3)

  • cafe_id — int — Primary key — NOT NULL
  • cafe_name — varchar
  • location — varchar
  • phone — int

customer (Untitled4)

  • customer_id — int — Primary key — NOT NULL
  • nickname — varchar
  • name — varchar
  • phone — int

reservation (Untitled2)

  • reservation_id — int — Primary key — NOT NULL
  • customer_id — int — Foreign key → customer.customer_id — NOT NULL
  • theme_id — int — Foreign key → theme.theme_id — NOT NULL
  • reserved_date — date
  • reserved_time — date
  • player_count — int
  • is_success — bool
  • escape_time — int
  • hint_count — int

review (Untitled5)

  • review_id — int — Primary key — NOT NULL
  • reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL
  • rating — int
  • content — varchar
  • create_at — time

theme (Untitled)

  • theme_id — int — Primary key — NOT NULL
  • difficulty — varchar
  • genre — varchar
  • time_limit — int
  • max_players — int
  • cafe_id — int — Foreign key → cafe.cafe_id — NOT NULL