movie_test
Tables (11)
CNMTHEATER
- CNMTHEATER_ID — NUMBER — Primary key — NOT NULL
- THEATER_TYPE — VARCHAR2(100)
- PRICE — NUMBER
GALLERY
- USER_ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR2(300)
- PHONE_NUMBER — VARCHAR2(50) — NOT NULL
- BIRTH_DATE — DATE
- GENDER — VARCHAR2(100)
- ROLE_ID — NUMBER — Foreign key → ROLE.ROLE_ID — NOT NULL
GENREINFO
- GENRE_ID — NUMBER — Primary key — NOT NULL
- GENRE — VARCHAR2(300)
MOVIEINFO
- MOVIE_ID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(300) — 영화제목
- DESCRIPTION — VARCHAR2(1000)
- DIRECTOR — VARCHAR2(300)
- OPENING_DATE — DATE
- GENRE_ID — NUMBER — Foreign key → GENREINFO.GENRE_ID — NOT NULL
- COUNTRY — VARCHAR2(300) — NOT NULL
- DURATION — NUMBER — NOT NULL
- AGE_RATING — NUMBER — NOT NULL
- POSTER — VARCHAR2(1000)
PAY
- PAY_ID — NUMBER — Primary key — NOT NULL
- PAYMENT_CODE — VARCHAR2(100)
- USER_ID — NUMBER — Foreign key → GALLERY.USER_ID — NOT NULL
- PAYMENT_DATE — DATE
- AMOUNT — NUMBER
ROLE
- ROLE_ID — NUMBER — Primary key — NOT NULL
- ROLE_NAME — VARCHAR2(100)
SCHEDULE
- SCHEDULE_ID — NUMBER — Primary key — NOT NULL
- MOVIE_ID — NUMBER — Foreign key → MOVIEINFO.MOVIE_ID — NOT NULL
- CNMTHEATER_ID — NUMBER — Foreign key → CNMTHEATER.CNMTHEATER_ID — NOT NULL
- START_TIME — DATE
- END_TIME — DATE — NOT NULL
- TOTAL_SEAT — NUMBER — NOT NULL
SEATINFO
- SEATINFO_ID — NUMBER — Primary key — NOT NULL
- SEAT_NUMBER — VARCHAR2(100)
- CNMTHEATER_ID — NUMBER — Foreign key → CNMTHEATER.CNMTHEATER_ID — NOT NULL
TICKETINFO
- TICKET_ID — NUMBER — Primary key — NOT NULL
- TICKET_CODE — VARCHAR2(300)
- SCHEDULE_ID — NUMBER — Foreign key → SCHEDULE.SCHEDULE_ID — NOT NULL
- USER_ID — NUMBER — Foreign key → GALLERY.USER_ID — NOT NULL
- ADULT — NUMBER
- YOUTH — NUMBER
- RESERVATION_TIME — DATE
TICKETPAY
- PAY_ID — NUMBER — Foreign key → PAY.PAY_ID — NOT NULL
- TICKET_ID — NUMBER — Foreign key → TICKETINFO.TICKET_ID — NOT NULL
TICKETSEAT
- SEATINFO_ID — NUMBER — Foreign key → SEATINFO.SEATINFO_ID — NOT NULL
- TICKET_ID — NUMBER — Foreign key → TICKETINFO.TICKET_ID — NOT NULL