영화예매

테이블 (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