d
Tables (6)
ARTIST
- artistID — INT
- name — VARCHAR(100)
- birthYear — INT
- nationality — VARCHAR(50)
- description — TEXT
EXPRESSION
- expressionID — INT
- workID — INT — NOT NULL
- format — VARCHAR(50)
- language — VARCHAR(50)
- duration — INT
ITEM
- itemID — INT
- manifestationID — INT — NOT NULL
- barcode — VARCHAR(50)
- condition — VARCHAR(50)
- location — VARCHAR(100)
MANIFESTATION
- manifestationID — INT
- expressionID — INT — NOT NULL
- releaseYear — INT
- medium — VARCHAR(50)
- publisher — VARCHAR(100)
WORK
- workID — INT
- title — VARCHAR(255) — NOT NULL
- genre — VARCHAR(50)
- year — INT — NOT NULL
- composer — VARCHAR(100)
- description — TEXT
WORK_ARTIST
- workID — INT — Primary key — NOT NULL
- artistID — INT — Primary key — NOT NULL
- role — VARCHAR(50)