영화예매
테이블 (5)
개봉예정영화 (scheduled for release)
- filmNum — Number — 기본 키 — NOT NULL
- filmName — String
- userId — Number — 외래 키 → 회원.userId — NOT NULL
- likeAbility — String
상영관리 (screeningManagement)
- theater — String — 기본 키 — NOT NULL
- movieStart — Date — 기본 키 — NOT NULL
- moveEnd — Date — 기본 키 — NOT NULL
- filmNum — Number — 외래 키 → 상영영화.filmNum — NOT NULL
- moveRank — String
- seatNumber — Number
상영영화 (screening Film)
- filmNum — Number — 외래 키 → 개봉예정영화.filmNum — NOT NULL
- filmName — String
- moveSynopses — String
- actor — String
- grade — String
- startPeriod — Date
- endPeriod — Date
- admission — Number
- ScreeningNumber — Number
영화예매 (moveReservation)
- userId — Number — 외래 키 → 회원.userId — NOT NULL
- filmNum — Number — 외래 키 → 상영영화.filmNum — NOT NULL
- admission — Number
- depositAmount (depoistAmount) — Number
- reservationDate — Date
- screeningDate — Date
- screeningDay — Number
회원 (Member)
- userId — Number — 기본 키 — NOT NULL
- userNm — String
- userPwd — String
- gender — String
- birthDay — Date
- number — String
- email — String
- grade — String
- gradeNm — String
- chargeAmount — Number
- mileage — Number
- accumlatedFund (accumlatedFundw) — Number
- moveViewNumber — Number
- outstandingMember — String