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)