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