기말과제

테이블 (17)

Copy Of Copy Of Copy Of Copy Of Untitled22 (supply_drama)

  • Key (dramaID) — int(30) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled2 (drama)

  • Key (dramaID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (genre) — char(30)
  • Field (ageLimit) — int(3)
  • Field (capacity) — int(3)
  • Field (releaseYear) — int(4)
  • Field (purchasePrice) — int(10)
  • Field (runTime) — int(3)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Copy Of Copy Of Untitled22 (supply_movie)

  • Key (movieID) — int(30) — 외래 키 → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Copy Of Untitled2 (movie)

  • Key (movieID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (genre) — char(30)
  • Field (ageLimit) — int(3)
  • Field (runTime) — int(3)
  • Field (capacity) — int(3)
  • Field (releaseYear) — int(4)
  • Field (purchasePrice) — int(10)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Copy Of Untitled22 (supply_book)

  • Key (ISBN) — char(13) — 외래 키 → Untitled.Key — NOT NULL
  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Untitled (webnovel)

  • Key (wnID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (genre) — char(30)
  • Field (ageLimit) — int(3)
  • Field (capacity) — int(3)
  • Field (openYear) — int(4)
  • Field (finishYear) — int(4)
  • Field (contractPeriod) — int(4)
  • Field (purchasePrice) — int(10)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Copy Of Untitled2 (supply_webnovel)

  • Key (wnID) — int(30) — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (multimedia_person)

  • Key (dramaID) — int(30) — 외래 키 → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (personID) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (dramaID2) — int(30) — 외래 키 → Copy Of Copy Of Copy Of Untitled2.Key — NOT NULL

Untitled (supply_webtoon)

  • Key (supplierID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (wtID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (person)

  • Key (personID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (role) — char(20)
  • Field (birthYear) — int(4)
  • Field (deathYear) — int(4)
  • Field (gender) — char(10)
  • Field (nationality) — char(30)

Untitled (work)

  • Key (workID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (description) — char(100)

Untitled (specialization)

  • Key (spID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — int(20)
  • Field (discription) — text

Untitled (work_author)

  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authorID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (supplier)

  • Key (supplierID) — int(30) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (department) — char(10)
  • Field (depPhone) — int(11)
  • Field (grade) — int(3)
  • Key (spID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (author)

  • Key (authorID) — int(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (alternativeName) — char(30)
  • Field (nationality) — char(30)
  • Field (biography) — text

Untitled (book)

  • Key (ISBN) — char(13) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (subject) — char(50)
  • Field (kdc) — char(20)
  • Field (ageLimit) — int(3)
  • Field (capacity) — int(3)
  • Field (pubYear) — int(4)
  • Field (type) — char(10)
  • Field (purchasePrice) — int(10)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (webtoon)

  • Key (wtID) — int(30) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (genre) — char(30)
  • Field (ageLimit) — int(3)
  • Field (capacityy) — int(3)
  • Field (openYear) — int(4)
  • Field (finishYear) — int(4)
  • Field (contractPeriod) — int(4)
  • Field (purchasePrice) — int(10)
  • Key (workID) — int(30) — 외래 키 → Untitled.Key — NOT NULL