과제
테이블 (10)
CAFE (Untitled5)
- pk (Key) — 기본 키 — NOT NULL
- Field
- Field2
CAFE
- cafe_id — VARCHAR(50) — 기본 키 — NOT NULL
- phone (.) — VARCHAR(50)
- cafe_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100)
CUSTOMER
- customer_id — VARCHAR(50) — 기본 키 — NOT NULL
- nickname — VARCHAR(50)
- name — VARCHAR(50)
- phone — VARCHAR(50)
RESERVATION
- reservation_id — VARCHAR(50) — 기본 키 — NOT NULL
- customer_id — VARCHAR(50) — 외래 키 → CUSTOMER.customer_id — NOT NULL
- theme_id — VARCHAR(50) — 외래 키 → THEME.theme_id — NOT NULL
- reservation_date — DATE
- reservation_time — TIME
- player_cnt — INT
- is_success — VARCHAR(10)
- escape_time — TIME
- hint_cnt — INT
REVIEW
- review_id — VARCHAR(50) — 기본 키 — NOT NULL
- reservation_id — VARCHAR(50) — 외래 키 → RESERVATION.reservation_id — NOT NULL
- rating — INT
- content — TEXT
- created_at — DATETIME
- customer_id (2) — VARCHAR(50) — 외래 키 — NOT NULL
THEME
- theme_id — VARCHAR(50) — 기본 키 — NOT NULL
- cafe_id — VARCHAR(50) — 외래 키 → CAFE.cafe_id — NOT NULL
- theme_name — VARCHAR(100)
- difficulty — INT
- genre — VARCHAR(50)
- time_limit — INT
- max_players — INT