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