과제_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