갠프
테이블 (5)
MEMBER (Untitled3)
- ID (Key) — varchar2(10) — 기본 키 — NOT NULL
- password (Field) — varchar2(20)
- phone_number (Field2) — varchar2(14)
- age (Field3) — number
MOVIE (Untitled2)
- movie_code (Key) — varchar2(10) — 기본 키 — NOT NULL
- movie_name (Field) — varchar2(50)
- movie_time (Field2) — varchar2(20)
- movie_director (Field3) — varchar2(20)
- movie_price (Field5) — number
- movie_poster (Field4) — varchar2(50)
- movie_grade (Field6) — varchar2(10)
MOVIE_BOOKING (Untitled6)
- ticket_num (Key2) — varchar2(30) — 기본 키 — NOT NULL
- timetble_code (Key4) — varchar2(20) — 외래 키 → TIMETABLE.timetable_code — NOT NULL
- ID (Key) — varchar2(10) — 외래 키 → MEMBER.ID — NOT NULL
- seat_code (Field) — varchar2(5)
- ageComm_pct (Field3) — number
- final_price (Field2) — number
THEATER (Untitled4)
- theater_code (Key) — varchar2(10) — 기본 키 — NOT NULL
- screen_name (Field) — varchar2(10)
- theater_name (Field3) — varchar2(30)
TIMETABLE (Untitled5)
- timetable_code (Key4) — varchar2(30) — 기본 키 — NOT NULL
- theater_code (Key) — varchar2(10) — 외래 키 → THEATER.theater_code — NOT NULL
- movie_code (Key3) — varchar2(10) — 외래 키 → MOVIE.movie_code — NOT NULL
- start_time (Field) — varchar2(10)
- end_time (Field2) — varchar2(10)
- screening_date (Field3) — date