test
Tables (5)
cafe
- cafe_id — int — Primary key — NOT NULL — auto increment
- cafe_name — char(30)
- location — char(30)
- phone — char(8)
customer
- customer_id — int — Primary key — NOT NULL — auto increment
- nickname — char(30)
- name — char(30)
- phone — char(30)
reservation
- reservation_id — int — Primary key — NOT NULL — auto increment
- date — char(8)
- time — char(8)
- int (player_cnt) — int
- is_success — boolean
- escape_time — char(8)
- hint_cnt — int
- customer_id — int — Foreign key → customer.customer_id — NOT NULL — auto increment
review
- review_id — int — Primary key — NOT NULL — auto increment
- rating — int
- content — char(30)
- created_at — timestamp
- reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL — auto increment
theme
- theme_id (Key) — int — Primary key — NOT NULL — autio increment
- theme_name — char(30)
- name — int
- phone — char(30)
- time_limit — int
- max_player — int
- reservation_id — int — Foreign key → reservation.reservation_id — NOT NULL — auto increment
- cafe_id — int — Foreign key → cafe.cafe_id — NOT NULL — auto increment