연습문제4

테이블 (8)

Untitled (Customer)

  • Key (CusID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Name) — CHAR(10)
  • Field (address) — CHAR(10)

Untitled (Video)

  • Key (CopyID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (BuyDate) — INT(6)
  • Field (RentalTime) — INT(10)
  • Key (MovID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Rental)

  • Key (RenID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (RenDate) — INT(6)
  • Field (RenTime) — INT(4)
  • Key (CusID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Movie)

  • Key (MovID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Title) — CHAR(20)
  • Field (Year Made) — CHAR(20)

Untitled (Person)

  • Key (ID) — CHAR(10) — 기본 키 — NOT NULL
  • Field (Name) — CHAR(20)
  • Field (Data) — CHAR(30)

Untitled (Casting)

  • Key (ID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (MovID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (RoleID) — INT(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Rental-Video)

  • Key (RenID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (CopyID) — CHAR(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Role)

  • Key (RoleID) — INT(10) — 기본 키 — NOT NULL
  • Field (Roletitle) — CHAR(10)