DVD 대여
테이블 (6)
Untitled (CUSTOMER)
- Key (customer ID) — INT (40) — 기본 키 — NOT NULL
- Field (customer NAME) — CHAR (30)
- Field (customer PH NUMBER) — INT (11)
- Field (customer ADDRESS) — CHAR (40)
- Field (customer GENDER) — CHAR (1)
- Field (customer E-MAIL) — CHAR (40)
Untitled (RENTAL RECORD)
- Key (DVD ID) — INT (40) — 기본 키 — NOT NULL
- Key (customer ID) — INT (40) — 외래 키 → Untitled.Key — NOT NULL
- Field (DVD RENTAL DAY) — INT (8)
- Field (DVD RENTAL TIME) — INT (6)
- Key (DVD ID2) — INT (40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DVD LIST)
- Key (DVD ID) — INT (40) — 기본 키 — NOT NULL
- Field (MOVIE TITLE) — CHAR (40)
- Field (RENT COUNT) — INT (40)
- Key (MOVIE ID) — INT (40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (MOVIE INFORMATION)
- Key (MOVIE ID) — INT (40) — 기본 키 — NOT NULL
- Field (MOVIE TITLE) — CHAR(40)
- Field (MAKING YEAR) — INT (8)
- Key (DIRECTOR ID) — INT (11) — 외래 키 → Untitled.Key — NOT NULL
- Key (ACTOR ID) — INT(11) — 외래 키 → Untitled.Key — NOT NULL
Untitled (DIRECTOR)
- Key (DIRECTOR ID) — INT (11) — 기본 키 — NOT NULL
- Field (DIRECTOR NAME) — CHAR(40)
- Field (DIRECTOR BIOGRAPHY) — CHAR(40)
Untitled (ACTOR)
- Key (ACTOR ID) — INT(11) — 기본 키 — NOT NULL
- Field (ACTOR NAME) — CHAR(40)
- Field (ACTOR BIOGRAPHY) — CHAR(40_