ERD Exercise4(여영규)
테이블 (6)
ACTOR (배우)
- actorCode (Key) — char(10) — 기본 키 — NOT NULL
- moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL
- actorName (Field) — char(10)
CUSTOMERS (고객)
- customerID (Key) — char(10) — 기본 키 — NOT NULL
- customerName (Field) — char(20)
- customerAddress (Field2) — char(50)
DIRECTOR (감독)
- directorCode (Key) — char(10) — 기본 키 — NOT NULL
- moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL
- directorName (Field) — char(20)
DVD
- dvdCode (Key) — char(10) — 기본 키 — NOT NULL
- dvdCopycode (Field) — char(10)
- dvdPurchaseDate (Field2) — date
- dvdRendtimes (Field3) — char(5)
- moviesID (Key2) — char(10) — 외래 키 → MOVIES.moviesID — NOT NULL
MOVIES (영화)
- moviesID (Key) — char(10) — 기본 키 — NOT NULL
- moviesTitle (Field) — char(20)
- moviesYearmade (Field2) — date
RENTVIDEO (비디오대여)
- rentvideoCode (Key) — char(10) — 기본 키 — NOT NULL
- rentDate (Field) — date
- rentTime (Field2) — char(10)
- rendDVDCode (Field3) — char(10)
- customerID (Key2) — char(10) — 외래 키 → CUSTOMERS.customerID — NOT NULL
- dvdCode (Key3) — char(10) — 외래 키 → DVD.dvdCode — NOT NULL