4주차 연습문제 4번

테이블 (8)

Copy Of Untitled (DIRECTOR)

  • Key (internalCode) — int — 기본 키 — NOT NULL
  • Field (bioInfo) — text

Untitled (CUSTOMER)

  • Key (customNo) — int — 기본 키 — NOT NULL
  • Field (customName) — char(30)
  • Field (address) — char(200)

Untitled (DVD)

  • Key (dvdCode) — int — 기본 키 — NOT NULL
  • Field (purchaseDate) — date
  • Field (rentedNo) — int
  • Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MOVIE_TITLE)

  • Key (identifier) — char(6) — 기본 키 — NOT NULL
  • Field (movieTitle) — char(40)
  • Field (releaseDate) — char(10)

Untitled (ACTOR)

  • Key (internalCode) — int — 기본 키 — NOT NULL
  • Field (bioInfo) — text

Untitled (CUSTOMER_DVD)

  • Key (cstm_dvdNo) — int — 기본 키 — NOT NULL
  • Field (rentedDate) — char(10)
  • Field (rentedTime) — char(5)
  • Key (customNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (dvdCode) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (MOVIE_ACTOR)

  • Key (internalCode) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MOVIE_DIRECTOR)

  • Key (internalCode) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (identifier) — char(6) — 외래 키 → Untitled.Key — NOT NULL