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