과제_0911_김서영
테이블 (7)
ACTOR (Untitled6)
- actor Biography (Key) — text — 기본 키 — NOT NULL
ACTOR_LIST (Untitled4)
- actor ID Code (Key) — char(30) — 기본 키 — NOT NULL
- actor Name (Field) — char(30)
- actor Biography (Key2) — text — 외래 키 → ACTOR.actor Biography — NOT NULL
- director ID Code (Key3) — char(30) — 외래 키 → DIRECTED_MOVIE.director ID Code — NOT NULL
CUSTOMER (Untitled3)
- customer Number (Key) — int — 기본 키 — NOT NULL
- customer Name (Field) — char(30)
- address (Field2) — char(50)
DIRECTED_MOVIE (Untitled5)
- director ID Code (Key) — char(30) — 기본 키 — NOT NULL
- director Name (Field) — char(30)
- director Biography (Key2) — text — 외래 키 → DIRECTOR.director Biography — NOT NULL
DIRECTOR (Untitled7)
- director Biography (Key) — text — 기본 키 — NOT NULL
DVD (Untitled2)
- identifier ID Code (Key) — char(8) — 기본 키 — NOT NULL
- purchase Date (Field) — date
- number of rentals (Field2) — int
- rental Date (Field3) — date
- rental Time (Field4) — time
- customer Number (Key2) — int — 외래 키 → CUSTOMER.customer Number — NOT NULL
MOVIE (Untitled)
- identifier (Key) — char(6) — 기본 키 — NOT NULL
- title (Field) — varchar(50)
- production Year (Field2) — int
- identifier ID Code (Key2) — char(8) — 외래 키 → DVD.identifier ID Code — NOT NULL