smallMovieBooking

Tables (4)

BOOKING (Untitled4)

  • ID (Key) — LONG — Primary key — NOT NULL
  • SCREENING_ID (Key2) — LONG — Foreign key → SCREENING.ID — NOT NULL
  • CUSTOMERNAME (Field) — VARCHAR2
  • PHONE (Field2) — VARCHAR2
  • SEATCODE (Field3) — VARCHAR2
  • TICKETCOUNT (Field4) — INT

MOVIE (Untitled)

  • ID (Key) — LONG — Primary key — NOT NULL
  • TITLE (Field) — VARCHAR2
  • RUNNINGTIME (Field2) — INT
  • RATING (Field3) — STRING

SCREENING (Untitled3)

  • ID (Key) — LONG — Primary key — NOT NULL
  • MOVIE_ID (Key2) — LONG — Foreign key → MOVIE.ID — NOT NULL
  • THEATER_ID (Key3) — LONG — Foreign key → THEATER.ID — NOT NULL
  • SCREENDATE (Field) — LOCALDATE
  • SCREENTIME (Field2) — LOCALTIME
  • TOTALSEATS (Field3) — INT
  • RESERVEDSEATS (Field4) — INT

THEATER (Untitled2)

  • ID (Key) — LONG — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2
  • CITY (Field2) — VARCHAR2
  • CAPACITY (Field3) — INT