FRBR_ERD_기말과제1

테이블 (9)

Copy Of Untitled (MUSIC)

  • Key (musicID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (time) — int(2)
  • Key (animationID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORK)

  • Key (workID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (theme) — char(10)
  • Field (genre) — char(10)
  • Field (description) — text

Untitled (MANIFESTATION)

  • Key (manifestationID) — int(10) — 기본 키 — NOT NULL
  • Key (expressionID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (workID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (publisher) — char(10)
  • Field (publicationYear) — int(4)
  • Field (mediaType) — char(10)
  • Field (ISBN) — char(13)
  • Field (Edition) — int(2)
  • Field (manifestationMemo) — text

Untitled (AUTHOR)

  • Key (authotID) — int(10) — 기본 키 — NOT NULL
  • Field (authorName) — char(30)
  • Field (altName) — char(30)
  • Field (description) — text
  • Field (majorWork) — text
  • Field (nationality) — int(3)
  • Field (birthdate) — date
  • Field (contact) — char(30)

Untitled (WORK_AUTHOR)

  • Key (workID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (authotID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (ANIMATION)

  • Key (animationID) — int(10) — 기본 키 — NOT NULL
  • Field (title) — char(30)
  • Field (runTime) — int(3)
  • Field (releaseYear) — int(4)
  • Field (expression) — char(3)
  • Field (description) — text

Untitled (ACTIVITY)

  • Key (activityID) — int(3) — 기본 키 — NOT NULL
  • Field (activityTitle) — char(10)
  • Field (theme) — char(10)
  • Field (location)
  • Field (level) — int(1)

Untitled (EXPRESSION)

  • Key (expressionID) — int(10) — 기본 키 — NOT NULL
  • Key (workID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (language) — char(3)
  • Field (formatType) — char(20)
  • Field (translator) — char(30)
  • Field (expressionNote) — text

Untitled (ITEM)

  • Key (itemID) — int(10) — 기본 키 — NOT NULL
  • Key (manifestationID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (expressionID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (workID) — int(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (location) — char(10)
  • Field (itemCondition) — char(20)