CGV DB

Tables (20)

Actor (Untitled5)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • birth — DATE
  • county (country) — VARCHAR
  • actor_photo (actorPhoto) — BIGINT — Foreign key → Media.id — NOT NULL

ActorInfo (Untitled7)

  • id — BIGINT — Primary key — NOT NULL
  • movie_id (movie) — BIGINT — Foreign key → Movie.id — NOT NULL
  • actor_id (actor) — BIGINT — Foreign key → Actor.id — NOT NULL

Bookmarked_Movie (Untitled12)

  • id — BIGINT — Primary key — NOT NULL
  • userId (user_id) — BIGINT — Foreign key → User.id — NOT NULL
  • movieId (movie_id) — BIGINT — Foreign key → Movie.id — NOT NULL

Bookmarked_theater (Untitled2)

  • bookmarked_id — BIGINT — Primary key — NOT NULL
  • theater_id — BIGINT — Foreign key → Theater.id — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL

Comment (Untitled9)

  • id — BIGINT — Primary key — NOT NULL
  • user_id (user) — BIGINT — Foreign key → User.id — NOT NULL
  • created_at (createdAt) — DATE
  • content — VARCHAR
  • movie_id (movie) — BIGINT — Foreign key → Movie.id — NOT NULL

Food (Untitled14)

  • id — BIGINT — Primary key — NOT NULL
  • menu_name (menuName) — VARCHAR
  • price — BIGINT
  • food_photo (foodPhoto) — BIGINT — Foreign key → Media.id — NOT NULL

Media (Untitled13)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • media_type (mediaType) — BIGINT
  • url — VARCHAR
  • created_at (createdAt) — DATE

Movie (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • movie_name (movieName) — VARCHAR
  • open_date (openDate) — DATE
  • reserv_rate (reservRate) — DECIMAL
  • egg_rate (eggRate) — BIGINT
  • prolog — VARCHAR
  • accesible_age (accesibleAge) — BIGINT
  • movie_type (movieType) — BIGINT
  • movie_photo (moviePhoto) — BIGINT — Foreign key → Media.id — NOT NULL
  • movie_video (movieVideo) — BIGINT — Foreign key → Media.id — NOT NULL
  • price — BIGINT
  • like_count (likeCount) — BIGINT

Order (Untitled8)

  • id — BIGINT — Primary key — NOT NULL
  • user_id (user) — BIGINT — Foreign key → User.id — NOT NULL

OrderItem (Untitled17)

  • id — BIGITN — Primary key — NOT NULL
  • order_id (order) — BIGINT — Foreign key → Order.id — NOT NULL
  • menuId — BIGINT — Foreign key → TeaterMenu.id — NOT NULL
  • quantity — BIGINT

Payment (Untitled19)

  • id — VARCHAR — Primary key — NOT NULL
  • created_at (createdAt) — DATE
  • store_id (storeId) — VARCHAR
  • order_name (orderName) — VARCHAR
  • total_pay_amount (toalPayAmount) — BIGINT
  • currency — VARCHAR
  • pay_type (payType) — VARCHAR

Prize (Untitled6)

  • id — BIGINT — Primary key — NOT NULL
  • actor_id (actor) — BIGINT — Foreign key → Actor.id — NOT NULL
  • prize_name (prizeName) — VARCHAR

Reservation (Untitled15)

  • id — BIGINT — Primary key — NOT NULL
  • user_id (user) — BIGINT — Foreign key → User.id — NOT NULL
  • reservation_date (ReservationDate) — DATE
  • total_price (totalPrice) — INT
  • screening — BIGINT — Foreign key → Screening.id — NOT NULL

ReservationSeat (Untitled16)

  • id — BIGINT — Primary key — NOT NULL
  • reservation_id (reservation) — BIGINT — Foreign key → Reservation.id — NOT NULL
  • seat_name (seatName) — VARCHAR
  • seat_info (seatInfo) — VARCHAR
  • price — BIGINT
  • screening_id (screeningId) — BIGINT — Foreign key → Screening.id — NOT NULL

Screen (Untitled18)

  • id — BIGINT — Primary key — NOT NULL
  • cinema_type (cinemaType) — VARCHAR
  • theater_id (theater) — BIGINT — Foreign key → Theater.id — NOT NULL
  • screen_name (screenName) — VARCHAR
  • seat_amount (seatAmount) — BIGINT

Screening (Untitled10)

  • id — BIGINT — Primary key — NOT NULL
  • screen_id (screen) — BIGINT — Foreign key → Screen.id — NOT NULL
  • movie_id (movie) — BIGINT — Foreign key → Movie.id — NOT NULL
  • startTime — DATE

TeaterMenu (Untitled11)

  • id — BIGINT — Primary key — NOT NULL
  • sold_out (soldOut) — BOOLEAN
  • theater_id (theater) — BIGINT — Foreign key → Theater.id — NOT NULL
  • food — BIGINT — Foreign key → Food.id — NOT NULL
  • amount — BIGINT

Theater (Untitled)

  • id (theater_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • region — VARCHAR
  • address — VARCHAR

User

  • id (user_id) — BIGINT — Primary key — NOT NULL
  • username — VARCHAR
  • userPW (password) — VARCHAR

audienceData (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • movie_id (movie) — BIGINT — Foreign key → Movie.id — NOT NULL
  • women_rate (womenRate) — DECIMAL
  • men_rate (menRate) — DECIMAL
  • teen_rate (teenRate) — DECIMAL
  • tw_rate (twRate) — DECIMAL
  • th_rate (thRate) — DECIMAL
  • fr_rate (frRate) — DECIMAL
  • ft_rate (ftRate) — DECIMAL