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)