연습4
테이블 (7)
actor (Untitled4)
- actCODE (Key) — 기본 키 — NOT NULL
- name (Field2)
- biography (Field)
director (Untitled5)
- dirCODE (Key) — 기본 키 — NOT NULL
- name (Field2)
- biography (Field)
dvd (Untitled2)
- dvdCODE (Key) — 기본 키 — NOT NULL
- purchaseDate (Field)
- number of rental (Field2)
- movieID (Key2) — 외래 키 → movie.movieID — NOT NULL
enroll (Untitled7)
- movieID (Key2) — 외래 키 → movie.movieID — NOT NULL
- dirCODE (Key) — 외래 키 → director.dirCODE — NOT NULL
- actCODE (Key3) — 외래 키 → actor.actCODE — NOT NULL
member (Untitled)
- memberID (Key) — 기본 키 — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)
movie (Untitled3)
- movieID (Key) — 기본 키 — NOT NULL
- title (Field)
- year (Field2)
rental service (Untitled6)
- memberID (Key) — 외래 키 → member.memberID — NOT NULL
- dvdCODE (Key2) — 외래 키 → dvd.dvdCODE — NOT NULL
- date (Field)
- time (Field2)