연습4번

테이블 (5)

Client (Untitled)

  • id (Key) — CHAR(30) — 기본 키 — NOT NULL
  • name (Field) — CHAR(30)
  • address (Field2) — CHAR(30)
  • rental date (Field3) — date
  • arrears (Field4) — CHAR(30)
  • rental video (Field5) — CHAR(30)

Rental video (Untitled4)

  • video id (Key2) — CHAR(30) — 외래 키 → Video.id — NOT NULL
  • client id (Key) — CHAR(30) — 외래 키 → Client.id — NOT NULL
  • fee (Field) — number
  • day (Field2) — date
  • arrears (Field3) — CHAR(30)

Video (Untitled2)

  • id (Key) — CHAR(30) — 기본 키 — NOT NULL
  • buying date (Field) — date
  • rental count (Field2) — number
  • title (Field3) — CHAR(30)
  • years (Field4) — number
  • fee (Field5) — CHAR(30)
  • actor id (Key2) — CHAR(30) — 외래 키 → actor information.id — NOT NULL
  • director id (Key3) — CHAR(30) — 외래 키 → director information.id — NOT NULL
  • copy number (Field6) — number

actor information (Untitled3)

  • id (Key) — CHAR(30) — 기본 키 — NOT NULL
  • biography (Field) — CHAR(30)

director information (Untitled5)

  • id (Key) — CHAR(30) — 기본 키 — NOT NULL
  • biography (Field) — CHAR(30)