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_