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)