Homework1

Tables (5)

Cafe (cafe)

  • Cafe id (cafe_id) — Primary key
  • Cafe name (cafe_name)
  • Location (location)
  • Phone (phone)

Copy Of Customer (review)

  • Customer id (review_id) — Primary key
  • Nickname (rating)
  • Name (content)
  • Phone (created_at)

Customer (customer)

  • Customer id (customer_id) — Primary key — NOT NULL
  • Nickname (nickname)
  • Name (name)
  • Phone (phone)

Theme (theme)

  • Theme id (theme_id) — Primary key — NOT NULL
  • Cafe id (cafe_id) — Foreign key → Cafe.Cafe id — NOT NULL
  • Theme name (theme_name)
  • Difficulty (difficulty)
  • Genre (genre)
  • Time limit (time_limit)
  • Max players (max_players)

reservation

  • Customer id (reservation_id) — Primary key — NOT NULL
  • Customer id (customer_id) — Foreign key → Customer.Customer id — NOT NULL
  • Theme id (theme_id) — Foreign key → Theme.Theme id — NOT NULL
  • Cafe id (cafe_id) — Foreign key → Theme.Cafe id — NOT NULL
  • Customer id (review_id) — Foreign key → Copy Of Customer.Customer id
  • date
  • Name (time)
  • Phone (player_cnt)
  • Field (is_success)
  • Field (escape_time)
  • Field (hint_cnt)