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)