DataBase

Tables (6)

Employee

  • id (employee_id) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • contact — VARCHAR2(20)

Movie

  • id (movie_id) — NUMBER — Primary key — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL

Screen

  • id (screen_id) — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • employee_id — NUMBER — Foreign key → Employee.id — NOT NULL

ScreenPeriod

  • id (screen_period_id) — NUMBER — Primary key — NOT NULL
  • start_time — DATE — NOT NULL
  • end_time — DATE — NOT NULL
  • movie_id — NUMBER — Foreign key → Movie.id — NOT NULL
  • screen_id — NUMBER — Foreign key → Screen.id — NOT NULL

Seat

  • id (seat_id) — NUMBER — Primary key — NOT NULL
  • location — VARCHAR2(10) — NOT NULL
  • type — VARCHAR2(20)
  • price — NUMBER — NOT NULL
  • screen_id — NUMBER — Foreign key → Screen.id — NOT NULL

Ticket

  • id (ticket_id) — NUMBER — Primary key — NOT NULL
  • id — NUMBER
  • phone — VARCHAR2(20) — NOT NULL
  • reservation_time — DATE
  • seat_id — NUMBER — Foreign key → Seat.id — NOT NULL
  • screen_period_id — NUMBER — Foreign key → ScreenPeriod.id — NOT NULL