practice
Tables (5)
CAFE (1)
- primary key (cafe_id) — Primary key — NOT NULL
- Field (cafe_name)
- Field2 (location)
- Field3 (phone)
CUSTOMER (3)
- primary key (customer_id) — Primary key — NOT NULL
- Field (nickname)
- Field2 (name)
- Field3 (phone)
RESERVATION (4)
- primary key (reservation_id) — Primary key — NOT NULL
- foreign key (customer_id) — Primary key — NOT NULL
- foreign key (theme) — Primary key — NOT NULL
- Field (date)
- Field2 (time)
- Field3 (player_cnt)
- Field (is_success)
- Field2 (escape_time)
- Field3 (hint_cnt)
REVIEW (CopyOf2)
- primary key (review_id) — Primary key — NOT NULL
- Foreign key (reservation_id) — Primary key — NOT NULL
- Field (time_limit) — Primary key
- Field (rating)
- Field2 (content)
- Field3 (created_at)
THEME (2)
- primary key (theme_id) — Primary key — NOT NULL
- Foreign key (cafe_id) — Primary key — NOT NULL
- Field (theme_name)
- Field2 (difficulty)
- Field3 (genre)
- Field (time_limit)
- Field2 (max_players)
- primary key (cafe_id2) — Foreign key → CAFE.primary key — NOT NULL