ERD_Exercise4_박현철
테이블 (5)
ACTOR
- Key (actorCODE) — integer — 기본 키 — NOT NULL
- Field (biography) — char(100)
- Key (producerCODE) — integer — 외래 키 → PRODUCER.Key — NOT NULL
CUSTOMER
- Key (customerNO) — integer(10) — 기본 키 — NOT NULL
- Field (name) — char(30)
- Field (address) — char(40)
DVD
- Key (movieNO) — integer(6) — 기본 키 — NOT NULL
- Key (actorCODE) — integer — 외래 키 → ACTOR.Key — NOT NULL
- Key (producerCODE) — integer — 외래 키 → PRODUCER.Key — NOT NULL
- Field (actor) — char(30)
- Field (producer) — char(30)
- Key (customerNO) — integer(10) — 외래 키 → CUSTOMER.Key — NOT NULL
PRODUCER
- Key (producerCODE) — integer — 기본 키 — NOT NULL
- Field (biography) — char(100)
STORE
- Key (customerNO) — integer(10) — 외래 키 → CUSTOMER.Key — NOT NULL
- Key (movieNO) — integer(6) — 외래 키 → DVD.Key — NOT NULL
- Field (rentalTIME) — char(4)
- Field (purchaseDATE) — char(8)