movie_backup

Tables (10)

CnmTheater

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(100)
  • Field2 — number

Gallery

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(300)
  • Field2 — varchar2(50)
  • Field3 — date — NOT NULL
  • Field5 — varchar2(100) — NOT NULL
  • Key3 — number — Foreign key → Role.Key — NOT NULL

GenreInfo

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(300)

MovieInfo

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(300) — 영화제목
  • Field2 — varchar2(300)
  • Field3 — date
  • Key2 — number — Foreign key → GenreInfo.Key — NOT NULL
  • Field5 — varchar2(300) — NOT NULL
  • Field6 — number
  • Field7 — number

Pay

  • Key2 — number — Primary key — NOT NULL
  • Field — varchar2(100)
  • Key — number — Foreign key → Gallery.Key — NOT NULL
  • Key3 — number — Foreign key → TicketInfo.Key — NOT NULL
  • Field2 — date
  • Field3 — number

Role

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(100)

Schedule

  • Key — number — Primary key — NOT NULL
  • Key2 — number — Foreign key → MovieInfo.Key — NOT NULL
  • Key3 — number — Foreign key → CnmTheater.Key — NOT NULL
  • Field2 — date
  • Field3 — date — NOT NULL
  • Field4 — number — NOT NULL

SeatInfo

  • Key — number — Primary key — NOT NULL
  • Key2 — number — Foreign key → Gallery.Key — NOT NULL
  • Field — varchar2(100)
  • Key3 — number — Foreign key → CnmTheater.Key — NOT NULL

TicketInfo

  • Key — number — Primary key — NOT NULL
  • Field — varchar2(300)
  • Key5 — number — Foreign key → Schedule.Key — NOT NULL
  • Key2 — number — Foreign key → Gallery.Key — NOT NULL
  • Field4 — number
  • Field2 — date
  • Key22 — number — Foreign key → Pay.Key2 — NOT NULL

TicketSeat

  • Key — number — Foreign key → TicketInfo.Key — NOT NULL
  • Key2 — number — Foreign key → SeatInfo.Key — NOT NULL