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