인모
테이블 (5)
CAFE
- cafe_id — int — 기본 키 — NOT NULL
- cafe_name — varchar
- location — varchar
- phone — int
CUSTOMER
- customer_id — int — 기본 키 — NOT NULL
- nickname — varchar
- name — varchar
- phone — int
RESERVATION
- reservation_id — int — 기본 키 — NOT NULL
- theme_id — int
- day — varchar
- time — varchar
- player_cnt — varchar
- is_success — varchar
- escape_timeescape_time (Field) — varchar
- hint_cnt — varchar
- customer_id — int — 외래 키 → CUSTOMER.customer_id — NOT NULL
REVIEW
- review_id — int — 기본 키 — NOT NULL
- rating — varchar
- content — varchar
- created_at — varchar
- reservation_id — int — 외래 키 → RESERVATION.reservation_id — NOT NULL
THEME
- theme_id — int — 기본 키 — NOT NULL
- theme_name — varchar
- difficulty — varchar
- genre — varchar
- time_limit — int
- cafe_id — int — 외래 키 → CAFE.cafe_id — NOT NULL
- reservation_id — int — 외래 키 → RESERVATION.reservation_id — NOT NULL