테스트
테이블 (5)
RESERVATION (Untitled4)
- reservation_id (Primary Key) — 기본 키 — NOT NULL
- theme_id (Field)
- 날짜 (Field2)
- 시간 (Field3)
- player_cnt (Field4)
- is_success (Field5)
- escape_time (Field6)
- hint_cnt (Field7)
- customer_id (Primary Key2) — 외래 키 → customer.customer_id — NOT NULL
- theme_id (Primary Key3) — 외래 키 → THEME.theme_id — NOT NULL
- review_id (Primary Key4) — 외래 키 → REVIEW.review_id — NOT NULL
REVIEW (Untitled5)
- review_id (Primary Key) — 기본 키 — NOT NULL
- reservation_id (Foreign Key)
- rating (Field)
- content (Field2)
- created_at (Field3)
THEME (Untitled3)
- theme_id (Primary Key) — 기본 키 — NOT NULL
- theme_name (Field2)
- difficulty (Field)
- genre (Field3)
- time_limit (Field4)
- max_players (Field5)
- cafe_id (Primary Key2) — 외래 키 → cafe.cafe_id — NOT NULL
cafe (Untitled)
- cafe_id (Primary Key) — 기본 키 — NOT NULL
- cafe_name (Field)
- location (Field2)
- phone (Field3)
customer (Untitled2)
- customer_id (Primary Key) — 기본 키 — NOT NULL
- nickname (Field)
- name (Field2)
- phone (Field3)