task 1-1
Tables (5)
Cafe
- cafe_id — int — Primary key — NOT NULL
- cafe_name — varchar(255)
- location (Field2) — varchar(255)
- phone (Field3) — varchar(255)
Customer
- customer_id — int — Primary key — NOT NULL
- nickname — varchar(255)
- name — varchar(255)
- phone — varchar(255)
Reservation
- reservation_id — int — Primary key — NOT NULL
- theme_id — int — Foreign key → Theme.theme_id — NOT NULL
- cafe_id — int — Foreign key → Theme.cafe_id — NOT NULL
- customer_id — int — Foreign key → Customer.customer_id — NOT NULL
- date — varchar(255)
- time — varchar(255)
- player_cnt — int
- is_success — boolean
- escape_time — int
- hint_cnt — int
Review
- review_id — int — Primary key — NOT NULL
- reservation_id — int — Foreign key → Reservation.reservation_id — NOT NULL
- theme_id — int — Foreign key → Reservation.theme_id — NOT NULL
- cafe_id — int — Foreign key → Reservation.cafe_id — NOT NULL
- customer_id — int — Foreign key → Reservation.customer_id — NOT NULL
- rating — int
- content — text
- created_at — date
Theme
- theme_id — int — Primary key — NOT NULL
- cafe_id — int — Foreign key → Cafe.cafe_id — NOT NULL
- theme_name — varchar(255)
- difficulty — varchar(255)
- genre — varchar(255)
- time_limit — int
- max_players — int
- Field