test
Tables (4)
MOVIE
- MOVIE_ID — INT — Primary key — NOT NULL
- TITLE — NVARCHAR2(50) — NOT NULL
- GENRE — NVARCHAR2(25)
- RUNNING_TIME — INT
- RATING — NVARCHAR2(10)
RESERVATION
- RESERVATION_ID — INT — Primary key — NOT NULL
- SCREENING_ID — INT — NOT NULL
- CUSTOMER_NAME — NVARCHAR2(5)
- SEAT_COUNT — INT
- TOTAL_PRICE — NUMBER(6)
- RESERVATION_TIME — DATE
SCREENING
- SCREENING_ID — INT — Primary key — NOT NULL
- MOVIE_ID — INT — NOT NULL
- THEATER_ID — INT — NOT NULL
- START_TIME — DATE — NOT NULL
- END_TIME — DATE — NOT NULL
THEATER
- THEATER_ID — INT — Primary key — NOT NULL
- MOVIE_ID — INT — Foreign key → MOVIE.MOVIE_ID — NOT NULL
- BRANCH — NVARCHAR2(25) — NOT NULL
- SEATS — INT — NOT NULL