cinema

Tables (9)

movie

  • id — bigint
  • running_time — int
  • title — varchar(255)
  • released_at — datetime(6)
  • poster_url — varchar(255)
  • genre — enum(ACTION,COMEDY,DRAMA,HORROR,ROMANCE,SCI_FI)
  • rating — enum(ALL,NC_19,PG_12,PG_15,RESTRICT)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

reservation

  • id — bigint
  • schedule_id — bigint — Foreign key → schedule.id — NOT NULL
  • seat_id — bigint — Foreign key — NOT NULL
  • user_id — bigint — Foreign key → user_account.id
  • is_reserved — boolean
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint
  • Key — Foreign key → seat.id — NOT NULL

schedule

  • id — bigint
  • screen_id — bigint — NOT NULL
  • movie_id — bigint — Foreign key → screen.id — NOT NULL
  • start_at — datetime(6)
  • end_at — datetime(6)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

screen

  • id — bigint
  • theater_id — bigint — Foreign key → theater.id — NOT NULL
  • name — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

seat

  • id (Key) — Primary key — NOT NULL
  • screen_id — bigint — Foreign key → screen.id — NOT NULL
  • seat_number — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

theater

  • id — bigint
  • name — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

ticket

  • id — bigint
  • schedule_id — bigint — Foreign key → schedule.id — NOT NULL
  • user_id — bigint — Foreign key → user_account.id — NOT NULL
  • reserved_at — datetime(6)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint

ticket_seat

  • id — bigint
  • ticket_id — bigint — Foreign key → ticket.id — NOT NULL
  • seat_id — bigint — Foreign key — NOT NULL
  • reserved_at — datetime(6)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint
  • Key — Foreign key → seat.id — NOT NULL

user_account

  • id — bigint
  • name — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • updated_at — datetime(6)
  • updated_by — bigint