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)