1015
Tables (17)
Untitled (감독)
- Key (내부코드) — char(10) — Primary key — NOT NULL
- Field (감독이름) — char(20)
- Field (전기정보) — text
Untitled (CASTING)
- Key (roleID) — inti(3) — Foreign key → Untitled.Key — NOT NULL
- Key (personID) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (CLIENT)
- Key (clientID) — int(100) — Primary key — NOT NULL
- Field (name) — char(30)
Untitled (ROLE)
- Key (roleID) — inti(3) — Primary key — NOT NULL
- Field (roleTitle) — char(30)
- Field (descrition)
Untitled (PERSON)
- Key (personID) — int(10) — Primary key — NOT NULL
- Field (fname) — char(30)
- Field (minit) — char(1)
- Field (Iname) — char(30)
- Field (description) — text
- Field (award)
Untitled (GENRE)
- Key (genreID) — int(5) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (description) — longtext
Untitled (RENT)
- Key (rentID) — int(1000) — Primary key — NOT NULL
- Field (rentDate) — date
- Field (returnDate) — date
- Key (clientID) — int(100) — Foreign key → Untitled.Key — NOT NULL
- Key (itemID) — int(100) — Foreign key → Untitled.Key — NOT NULL
Untitled (DVDITEM)
- Key (itemID) — int(100) — Primary key — NOT NULL
- Field (buyingDate) — date
- Field (price) — int(10)
- Field (statusLevel) — char(1)
- Key (movieID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MOVIE)
- Key (movieID) — int(10) — Primary key — NOT NULL
- Field (title) — char(30)
- Field (pubYear) — int(4)
- Field (pubMonti) — int(2)
- Field (description) — text
Untitled (ACTIVITY)
- Key (actCode) — char(10) — Primary key — NOT NULL
- Field (actName) — char(20)
- Field (description) — text
Untitled (배우)
- Key (내부코드) — char(10) — Primary key — NOT NULL
- Field (배우이름) — char(20)
- Field (전기정보) — text
Untitled (영화)
- Key (식별자) — char(10) — Primary key — NOT NULL
- Field (제목) — char(20)
- Field (제작년도) — date
Untitled (DVD)
- Key (식별코드) — char(10) — Primary key — NOT NULL
- Field (구입일) — date
- Field (대여일) — date
- Field (대여시간) — time
- Field (복사본여부) — char(3)
Untitled (회원)
- Key (회원ID) — char(10) — Primary key — NOT NULL
- Field (회원이름) — char(20)
- Field (회원주소) — char(50)
Untitled (ENROLL)
- Key (classID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (memID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (MEMBER)
- Key (memID) — char(10) — Primary key — NOT NULL
- Field (memName) — char(20)
- Field (address) — char(50)
- Field (phone) — char(11)
- Field (birthDate) — date
- Field (gender) — char(1)
Untitled (CLASS)
- Key (classID) — char(10) — Primary key — NOT NULL
- Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (className) — char(20)
- Field (time) — cha(50)
- Field (classSize) — int(3)
- Field (level) — char(4)
- Field (lecturer) — char(10)
- Field (price) — int(6)
- Field (location) — char(20)
- Field (year) — char(4)
- Field (month) — char(2)