DB_FRBR_ERD
Tables (5)
Untitled (author)
- Key (authorID) — char(13) — Primary key — NOT NULL
- Field (authorName) — char(50)
- Field (alterName) — char(100)
- Field (description) — text
- Field (majorWork) — char(100)
Untitled (subject)
- Key (subID) — char(13) — Primary key — NOT NULL
- Field (subTitle) — char(20)
- Field (description) — text
Untitled (work_sub)
- Key (workID) — char(13) — Foreign key → work.Key — NOT NULL
- Key (subID) — char(13) — Foreign key → Untitled.Key — NOT NULL
Untitled (work_author)
- Key (authorID) — char(13) — Foreign key → Untitled.Key — NOT NULL
- Key (workID) — char(13) — Foreign key → work.Key — NOT NULL
work
- Key (workID) — char(13) — Primary key — NOT NULL
- Field (workTitle) — char(50)
- Field (description) — text