실습1
테이블 (5)
CUSTOMER (Untitled2)
- customer_id (PK) — 기본 키 — NOT NULL
- nickname (Field)
- Field2
- phone (Field3)
RESERVATION (Untitled4)
- reservation_id (PK) — 기본 키 — NOT NULL
- customer_id (FK) — 외래 키 → CUSTOMER.customer_id — NOT NULL
- theme_id (PK2) — 외래 키 → THEME.theme_id — NOT NULL
- date (Field)
- time (Field2)
- player_cnt (Field3)
- is_success (Field4)
- escape_time (Field5)
- hint_cnt (Field6)
REVIEW (Untitled5)
- review_id (PK) — 기본 키 — NOT NULL
- reservation_id (FK) — 외래 키 → RESERVATION.reservation_id — NOT NULL
- rating (Field)
- content (Field2)
- created_at (Field3)
THEME (Untitled3)
- theme_id (PK) — 기본 키 — NOT NULL
- cafe_id (FK) — 외래 키 → cafe.cafe_id — NOT NULL
- theme_name (Field2)
- difficulty (Field3)
- genre (Field)
- time_limit (Field4)
- max_players (Field5)
cafe (Untitled)
- cafe_id (PK) — 기본 키 — NOT NULL
- cafe_name (char)
- location (Field)
- phone (Field2)