실습1
테이블 (5)
CAFE
- cafe_id — 기본 키 — NOT NULL — PK
- cafe_name
- location
CUSTOMER (Untitled2)
- customer_id — 기본 키 — NOT NULL — PK
- nickname
- phone
- name
RESERVATION
- reservation_id — 기본 키 — NOT NULL — PK
- 날짜
- 시간
- player_cnt
- is_success
- escape_time
- hint_cnt
- customer_id — 외래 키 → CUSTOMER.customer_id — NOT NULL — PK
REVIEW
- review_id — 기본 키 — NOT NULL — PK
- rating
- content
- created_at (created_id)
- reservation_id — 외래 키 → RESERVATION.reservation_id — NOT NULL — PK
THEME
- theme_id (cafe_id) — 기본 키 — NOT NULL — PK
- theme_name
- difficulty
- genre (Field2)
- time_limit
- max_player
- cafe_id (cafe_id2) — 외래 키 → CAFE.cafe_id — NOT NULL — PK
- reservation_id — 외래 키 → RESERVATION.reservation_id — NOT NULL — PK