ㅁㄴㅇㄹㅁㄴㅇㄹㅁ
Tables (6)
CAFE
- cafe_id — INT — Primary key — NOT NULL
- theme_id — INT — Foreign key → THEME.theme_id — NOT NULL
- cafe_id (cafe_id3) — INT — Foreign key → THEME.cafe_id — NOT NULL
- Key — Foreign key → THEME.Key — NOT NULL
- cafe_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(100)
- phone — VARCHAR(20)
- theme_id (theme_id2) — INT — Foreign key → THEME.theme_id — NOT NULL
- cafe_id (cafe_id32) — INT — Foreign key → THEME.cafe_id — NOT NULL
- theme_id (theme_id22) — INT — Foreign key → THEME.theme_id — NOT NULL
- cafe_id (cafe_id322) — INT — Foreign key → THEME.cafe_id — NOT NULL
- Key (Key2) — Foreign key → THEME.Key — NOT NULL
CUSTOMER
- customer_id — INT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
RESERVATION
- reservation_id — INT — Primary key — NOT NULL
- customer_id (customer_id2) — INT — Foreign key → CUSTOMER.customer_id — NOT NULL
- customer_id — INT — NOT NULL
- theme_id — INT — NOT NULL
- reserved_at — DATETIME — NOT NULL
- participant_count — INT
- is_success — BOOLEAN
- escape_time — INT
- hint_count — INT
REVIEW
- review_id — INT — Primary key — NOT NULL
- reservation_id — INT — NOT NULL
- rating — INT
- content — TEXT
- written_at — DATETIME
THEME
- theme_id — INT — Primary key — NOT NULL
- cafe_id (cafe_id3) — INT — Foreign key → CAFE.cafe_id — NOT NULL
- theme_id (theme_id2) — INT — Foreign key → CAFE.theme_id — NOT NULL
- cafe_id (cafe_id32) — INT — Foreign key → CAFE.cafe_id — NOT NULL
- Key — Foreign key → Untitled.Key — NOT NULL
- cafe_id — INT — NOT NULL
- theme_name — VARCHAR(100) — NOT NULL
- difficulty — VARCHAR(10)
- genre — VARCHAR(20)
- time_limit — INT
- max_capacity — INT
- cafe_id (cafe_id2) — INT — Foreign key → CAFE.cafe_id — NOT NULL
- theme_id (theme_id3) — INT — Foreign key → CAFE.theme_id — NOT NULL
- cafe_id (cafe_id33) — INT — Foreign key → CAFE.cafe_id — NOT NULL
Untitled
- Key — Primary key — NOT NULL
- Field2
- Field3
- Field4
- Field5
- Field6
- Field