practice

Tables (5)

CAFE (1)

  • primary key (cafe_id) — Primary key — NOT NULL
  • Field (cafe_name)
  • Field2 (location)
  • Field3 (phone)

CUSTOMER (3)

  • primary key (customer_id) — Primary key — NOT NULL
  • Field (nickname)
  • Field2 (name)
  • Field3 (phone)

RESERVATION (4)

  • primary key (reservation_id) — Primary key — NOT NULL
  • foreign key (customer_id) — Primary key — NOT NULL
  • foreign key (theme) — Primary key — NOT NULL
  • Field (date)
  • Field2 (time)
  • Field3 (player_cnt)
  • Field (is_success)
  • Field2 (escape_time)
  • Field3 (hint_cnt)

REVIEW (CopyOf2)

  • primary key (review_id) — Primary key — NOT NULL
  • Foreign key (reservation_id) — Primary key — NOT NULL
  • Field (time_limit) — Primary key
  • Field (rating)
  • Field2 (content)
  • Field3 (created_at)

THEME (2)

  • primary key (theme_id) — Primary key — NOT NULL
  • Foreign key (cafe_id) — Primary key — NOT NULL
  • Field (theme_name)
  • Field2 (difficulty)
  • Field3 (genre)
  • Field (time_limit)
  • Field2 (max_players)
  • primary key (cafe_id2) — Foreign key → CAFE.primary key — NOT NULL