실습1
테이블 (5)
CAFE (Untitled)
- cafe_id (카페ID) — char(3) — 기본 키 — NOT NULL
- cafe_name (카페이름) — varchar2(50)
- location (지역) — varchar2(50)
- phone (휴대폰번호) — varchar2(15)
CUSTOMER (Untitled2)
- customer_id (소비자ID) — varchar2(20) — 기본 키 — NOT NULL
- nickname (닉네임) — varchar2(50)
- name (이름) — varchar2(50)
- phone (휴대폰번호) — varchar2(20)
RESERVATION (Untitled4)
- reservation_id (예약_id) — varchar2(20) — 기본 키 — NOT NULL
- 날짜 — varchar2(20)
- 시간 — varchar2(20)
- player_cnt (플레이어수) — char(100)
- is_success (성공여부) — char(1)
- escape_time (탈출시간) — date
- hint_cnt (힌트 갯수) — char(10)
- customer_id (소비자ID) — varchar2(20) — 외래 키 → CUSTOMER.customer_id — NOT NULL
- theme_id (테마_id2) — varchar2(20) — 외래 키 → THEME.theme_id — NOT NULL
REVIEW (Untitled5)
- review_id (리뷰_id) — varchar2(20) — 기본 키 — NOT NULL
- rating (평가) — varchar2(50)
- content (콘텐츠) — varchar2(20)
- created_at (쓴 날짜) — date
- reservation_id (예약_id2) — varchar2(20) — 외래 키 → RESERVATION.reservation_id — NOT NULL
THEME (Untitled3)
- theme_id (테마_id) — varchar2(20) — 기본 키 — NOT NULL
- theme_name (테마_이름) — varchar2(30)
- difficulty (어려움) — varchar2(30)
- genre (장르) — varchar2(30)
- time_limit (제한시간) — varchar2(30)
- max_player (최대_인원수) — char(100)
- cafe_id (카페ID) — char(3) — 외래 키 → CAFE.cafe_id — NOT NULL