남친
테이블 (5)
CAFE
- cafe_id — not null — 기본 키 — NOT NULL
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
리뷰 (REVIEW)
- review_id — char — 기본 키 — NOT NULL — PK
- rating — char
- content — char
- created_at — char
- reservation_id (reservation_id2) — char — 외래 키 → 예약.reservation_id — NOT NULL — FK
손님 (CUSTOMER)
- customer_id — char — 기본 키 — NOT NULL — PK
- nickname — char
- name — char
- phone — char
예약 (RESERVATION)
- reservation_id — char — 기본 키 — NOT NULL — PK
- date — char
- time — char
- player_cnt — number
- is_success — boolean
- escape_time — char
- hint_cnt — number
- customer_id — char — 외래 키 → 손님.customer_id — NOT NULL — FK
- theme_id — char — 외래 키 → 테마.theme_id — NOT NULL — FK
테마 (THEME)
- theme_id — char — 기본 키 — NOT NULL — PK
- cafe_id — char — 외래 키 → CAFE.cafe_id — NOT NULL — FK
- theme_name — char
- difficulty — number
- genre — char
- time_limit