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