test

Tables (5)

cafe

  • cafe_id — int — Primary key — NOT NULL — auto increment
  • cafe_name — char(30)
  • location — char(30)
  • phone — char(8)

customer

  • customer_id — int — Primary key — NOT NULL — auto increment
  • nickname — char(30)
  • name — char(30)
  • phone — char(30)

reservation

  • reservation_id — int — Primary key — NOT NULL — auto increment
  • date — char(8)
  • time — char(8)
  • int (player_cnt) — int
  • is_success — boolean
  • escape_time — char(8)
  • hint_cnt — int
  • customer_id — int — Foreign key → customer.customer_id — NOT NULL — auto increment

review

  • review_id — int — Primary key — NOT NULL — auto increment
  • rating — int
  • content — char(30)
  • created_at — timestamp
  • reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL — auto increment

theme

  • theme_id (Key) — int — Primary key — NOT NULL — autio increment
  • theme_name — char(30)
  • name — int
  • phone — char(30)
  • time_limit — int
  • max_player — int
  • reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL — auto increment
  • cafe_id — int — Foreign key → cafe.cafe_id — NOT NULL — auto increment