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