THEATER

Tables (6)

BookingSeat (좌석예약정보)

  • id (고유아이디) — long — Primary key — NOT NULL
  • orderid (주문참조id) — long
  • seatnumber (좌석번호) — String
  • price (좌석티켓가격) — int

Movie (영화)

  • id (고유아이디) — long — Primary key — NOT NULL
  • moviename (영화제목) — String
  • movieshowtime (상영시간) — String
  • movieprice (영화가격) — int
  • movieseat (좌석정보) — int
  • moviegenre (영화장르) — String
  • movieactors (영화배우) — String
  • movierunningtime (영화러닝타임) — Duration
  • moviereleasedate (영화개봉일) — LocalDate
  • agerating (영화제한나이) — String

Order (유저주문정보)

  • id (고유아이디) — long — Primary key — NOT NULL
  • userid (유저참조id) — long
  • showtimeid (참조상영회차id) — long
  • totalamount (총 결제 금액) — int
  • status (주문상태) — enum
  • orderdate (주문 일시) — LocalDateTime

Showtime (상영시간정보)

  • id (고유아이디) — long — Primary key — NOT NULL
  • movieid (참조영화id) — long
  • hallid (상영관 id) — long
  • starttime (상영시작시간) — LOCALDATETIME
  • price (티켓가격) — int
  • availableseats (예약가능 좌석수) — int
  • endtime (상영종료시각) — LocalDateTime

TheateHall (상영관정보)

  • id (고유아이디) — long — Primary key — NOT NULL
  • name (상영관이름) — String
  • totalseats (상영관총좌석) — int

Users (유저)

  • id (고유아이디) — long — Primary key — NOT NULL
  • email (이메일) — String
  • password (패스워드) — String
  • username (유저네임) — String
  • role (역할) — enum