task 1-1

Tables (5)

Cafe

  • cafe_id — int — Primary key — NOT NULL
  • cafe_name — varchar(255)
  • location (Field2) — varchar(255)
  • phone (Field3) — varchar(255)

Customer

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

Reservation

  • reservation_id — int — Primary key — NOT NULL
  • theme_id — int — Foreign key → Theme.theme_id — NOT NULL
  • cafe_id — int — Foreign key → Theme.cafe_id — NOT NULL
  • customer_id — int — Foreign key → Customer.customer_id — NOT NULL
  • date — varchar(255)
  • time — varchar(255)
  • player_cnt — int
  • is_success — boolean
  • escape_time — int
  • hint_cnt — int

Review

  • review_id — int — Primary key — NOT NULL
  • reservation_id — int — Foreign key → Reservation.reservation_id — NOT NULL
  • theme_id — int — Foreign key → Reservation.theme_id — NOT NULL
  • cafe_id — int — Foreign key → Reservation.cafe_id — NOT NULL
  • customer_id — int — Foreign key → Reservation.customer_id — NOT NULL
  • rating — int
  • content — text
  • created_at — date

Theme

  • theme_id — int — Primary key — NOT NULL
  • cafe_id — int — Foreign key → Cafe.cafe_id — NOT NULL
  • theme_name — varchar(255)
  • difficulty — varchar(255)
  • genre — varchar(255)
  • time_limit — int
  • max_players — int
  • Field