테스트
테이블 (8)
member
- member_id — varchar2(50) — 기본 키 — NOT NULL
- password — varchar2(50) — NOT NULL
- member_name — varchar2(50) — NOT NULL
- member_ssn — char(7) — NOT NULL
- email — varchar2(50)
- phone — char(11)
- preference_genre — varchar2(255)
- member_status — char(1)
- member_grade — varchar2(50)
- enroll_date — date
- point — number
movie
- movie_title — varchar2(255) — 기본 키 — NOT NULL
- movie_link — varchar2(255)
- movie_img — varchar2(255)
- movie_subtitle — varchar2(1000)
- opening_date — varchar2(50)
- movie_director — varchar2(50)
- movie_actor — varchar2(1000)
- movie_rate — number
product
- product_no — number — 기본 키 — NOT NULL
- pd_category — char(1)
- product_name — varchar2(50)
- product_price — number
- stock — number
- accumulate_sale — number
- pd_status — char(1)
- pd_img — varchar2(255)
- pd_info — varchar2(255)
screen_info
- screen_no — varchar2(50) — 기본 키 — NOT NULL
- movie_title — varchar2(255) — NOT NULL
- manager_id — varchar2(50)
- theater_no — varchar2(50) — NOT NULL
- start_time — timestamp
- end_time — timestamp
- total_ticket — number
- sold_ticket — number
screen_movie
- movie_title — varchar2(255) — 기본 키 — NOT NULL
- genre — varchar2(500)
- main_poster — varchar2(255)
- poster — varchar2(255)
- steel_cut — varchar2(255)
- trailer — varchar2(255)
- synopsis — varchar2(1000)
- purchase_rate — number
- screening_rate — char(1)
- screnn_status — char(1)
seat
- seat_no — varchar2(50) — 기본 키 — NOT NULL
- theater_no — varchar2(50) — NOT NULL
- seat_status — char(1)
theater
- theater_no — varchar2(50) — 기본 키 — NOT NULL
- theater_seat — number
- theater_status — char(1)
ticket
- ticket_no — varchar2(50) — 기본 키 — NOT NULL
- member_id — varchar2(50)
- screen_no — varchar2(50) — NOT NULL
- seat_no — varchar2(50)
- ticket_price — number
- ticket_status — char(1)