assignment1
Tables (5)
CAFE (Untitled)
- CAFE_ID (Key) — INT — Primary key — NOT NULL
- CAFE_NAME (Field) — VARCHAR2
- LOCATION (Field2) — VARCHAR2
- PHONE (Field3) — VARCHAR2
CUSTOMER (Untitled2)
- customer_id (Key) — INT — Primary key — NOT NULL
- nickname (Field) — VARCHAR2
- name (Field2) — VARCHAR2
- phone (Field3) — VARCHAR2
RESERVATION (Untitled4)
- RESERVATION_ID (Key) — INT — Primary key — NOT NULL
- date (Field) — VARCHAR2
- time (Field2) — VARCHAR2
- player_cnt (Field3) — INT
- is_success (Field4) — BOOLEAN
- escape_time (Field5) — VARCHAR2
- HINT_CNT (Field6) — INT
- customer_id (Key2) — INT — Foreign key → CUSTOMER.customer_id — NOT NULL
- THEME_ID (Key3) — INT — Foreign key → THEME.THEME_ID — NOT NULL
REVIEW (Untitled5)
- review_id (Key) — INT — Primary key — NOT NULL
- RESERVATION_ID (Key2) — INT — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL
- rating (Field) — VARCHAR2
- contnent (Field2) — VARCHAR2
- created_at (Field3) — VARCHAR2
THEME (Untitled3)
- THEME_ID (Key) — INT — Primary key — NOT NULL
- theme_name (Field) — VARCHAR2
- difficulty (Field2) — VARCHAR2
- genre (Field3) — VARCHAR2
- TIME_LIMIT (Field4) — VARCHAR2
- MAX_PLAYERS (Field5) — INT
- CAFE_ID (Key2) — INT — Foreign key → CAFE.CAFE_ID — NOT NULL