escape
Tables (5)
cafe (Untitled3)
- cafe_id — int — Primary key — NOT NULL
- cafe_name — varchar
- location — varchar
- phone — int
customer (Untitled4)
- customer_id — int — Primary key — NOT NULL
- nickname — varchar
- name — varchar
- phone — int
reservation (Untitled2)
- reservation_id — int — Primary key — NOT NULL
- customer_id — int — Foreign key → customer.customer_id — NOT NULL
- theme_id — int — Foreign key → theme.theme_id — NOT NULL
- reserved_date — date
- reserved_time — date
- player_count — int
- is_success — bool
- escape_time — int
- hint_count — int
review (Untitled5)
- review_id — int — Primary key — NOT NULL
- reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL
- rating — int
- content — varchar
- create_at — time
theme (Untitled)
- theme_id — int — Primary key — NOT NULL
- difficulty — varchar
- genre — varchar
- time_limit — int
- max_players — int
- cafe_id — int — Foreign key → cafe.cafe_id — NOT NULL