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