movie reservation system

Tables (6)

booking

  • id — Primary key — NOT NULL
  • user_id — uuid — Foreign key → user.id — NOT NULL
  • screaning_id — uuid — Foreign key → screaning.id — NOT NULL
  • seat_id — uuid — Foreign key → seat.id — NOT NULL
  • created_at — datetime — NOT NULL
  • booking_time — datetime

movie

  • id — uuid — Primary key — NOT NULL
  • title — varchar(100) — NOT NULL
  • director — varchar(50)
  • duration — int — NOT NULL

screaning

  • id — uuid — Primary key — NOT NULL
  • theater_id — uuid — Foreign key → theater.id — NOT NULL
  • movie_id — uuid — Foreign key → movie.id — NOT NULL
  • screaning_time — datetime

seat

  • id — uuid — Primary key — NOT NULL
  • theater_id — uuid — Foreign key → theater.id — NOT NULL
  • seat_number — varchar(10)

theater

  • id — uuid — Primary key — NOT NULL
  • name — varchar(100)

user

  • id — uuid — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • email — varchar(100)
  • password — varchar(50)
  • created_at — datetime