과제 예제4_임미숙
테이블 (6)
ACTOR (Untitled6)
- actorCode (Key) — char(5) — 기본 키 — NOT NULL
- titleCode (Key2) — char(10) — 외래 키 → MOVIE.titleCode — NOT NULL
- directorCode (Key22) — char(5) — 외래 키 → MOVIE.directorCode — NOT NULL
- biography (Field) — text
- name (Field2) — char(20)
- phone (Field3) — int
- email (Field4) — char(25)
CUSTOMER (Untitled)
- customerNo (Key) — char(5) — 기본 키 — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — char(15)
DIRECTOR (Untitled5)
- directorCode (Key) — char(5) — 기본 키 — NOT NULL
- bioraphy (Field) — text
- name (Field2) — char(20)
- phone (Field3) — int
- email (Field4) — char(25)
MOVIE (Untitled4)
- titleCode (Key) — char(10) — 기본 키 — NOT NULL
- directorCode (Key2) — char(5) — 외래 키 → DIRECTOR.directorCode — NOT NULL
- title (Field) — char(20)
- yearMade (Field2) — year
- director (Field3) — char(20)
- actor (Field4) — char(20)
TRANSACTION (Untitled3)
- customerNo (Key) — 기본 키 — NOT NULL
- customerNo (Key2) — char(5) — 외래 키 → CUSTOMER.customerNo — NOT NULL
- movietitleId (Field) — char(10)
- transactionDate (Field2) — date
- transactionTime (Field3) — char(10)
VIDEO (Untitled2)
- videoCode (Key) — char(5) — 기본 키 — NOT NULL
- titleCode (Key2) — char(10) — 외래 키 → MOVIE.titleCode — NOT NULL
- directorCode (Key22) — char(5) — 외래 키 → MOVIE.directorCode — NOT NULL
- customerNo (Key3) — 외래 키 → TRANSACTION.customerNo — NOT NULL
- customerNo (Key23) — char(5) — 외래 키 → TRANSACTION.customerNo — NOT NULL
- copyCode (Field) — char(5)
- purchaseDate (Field2) — date
- NoOfRented (Field3) — int