practice
Tables (15)
favorite_movie
- favorite_movie_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- movie_id — bigint — Foreign key → movie.movie_id — NOT NULL
favorite_theater
- favorite_theater_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- theater_id — bigint — Foreign key → theater.theater_id — NOT NULL
inventory
- inventory_id — bigint — Primary key — NOT NULL
- theater_id — bigint — Foreign key → theater.theater_id — NOT NULL
- menu_id — bigint — Foreign key → menu.menu_id — NOT NULL
- stock — int — NOT NULL
menu
- menu_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- price — int — NOT NULL
movie
- movie_id — bigint — Primary key — NOT NULL
- title — varchar(50) — NOT NULL
- runtime — int — NOT NULL
- release_date — date — NOT NULL
- age_rating — varchar(50) — NOT NULL
- average_rating — decimal(2,1)
- poster_url — varchar(255)
- description — text
order_item
- order_menu_id — bigint — Primary key — NOT NULL
- inventory_id — bigint — Foreign key → inventory.inventory_id — NOT NULL
- orders_id — bigint — Foreign key → orders.orders_id — NOT NULL
- order_price — int — NOT NULL
- count — int — NOT NULL
orders
- orders_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- theater_id — bigint — Foreign key → theater.theater_id — NOT NULL
- order_date — datetime — NOT NULL
- total_price — int — NOT NULL
- refundable — boolean — NOT NULL
reservation
- reservation_id — bigint — Primary key — NOT NULL
- schedule_id — bigint — Foreign key → schedule.schedule_id — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL
- status — varchar(50) — NOT NULL — PENDING, COMPLETED, CANCELED
- reservation_date — datetime — NOT NULL
- total_price — int — NOT NULL
reservation_seat
- reservation_seat_id — bigint — Primary key — NOT NULL
- reservation_id — bigint — Foreign key → reservation.reservation_id — NOT NULL
- seat_id — bigint — Foreign key → seat.seat_id — NOT NULL
- price — int — NOT NULL
schedule
- schedule_id — bigint — Primary key — NOT NULL
- screen_id — bigint — Foreign key → screen.screen_id — NOT NULL
- movie_id — bigint — Foreign key → movie.movie_id — NOT NULL
- start_time — datetime — NOT NULL
- end_time — datetime — NOT NULL
- base_price — int — NOT NULL
screen
- screen_id — bigint — Primary key — NOT NULL
- theater_id — bigint — Foreign key → theater.theater_id — NOT NULL
- name — varchar(50) — NOT NULL
- screen_type_id — bigint — Foreign key → screen_type.screen_type_id — NOT NULL
screen_type
- screen_type_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- surcharge_price — int — NOT NULL
- description — varchar(100)
seat
- seat_id — bigint — Primary key — NOT NULL
- screen_type_id — bigint — Foreign key → screen_type.screen_type_id — NOT NULL
- seat_row — varchar(50) — NOT NULL
- seat_col — int — NOT NULL
theater
- theater_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(50)
user
- user_id — bigint — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
- login_id — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- phone_number — varchar(20) — NOT NULL
- email — varchar(100)