museum

Tables (9)

Advertisement

  • advertisement_id — INT
  • exhibition_id — INT
  • publication_date — DATE
  • active_days — INT
  • medium — VARCHAR(100)
  • cost — DECIMAL(10,2)

Artifact

  • artifact_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • value — DECIMAL(15,2)
  • year_of_creation — INT
  • artist_id — INT

ArtifactInCollection

  • artifact_id — INT
  • collection_id — INT
  • date_added — DATE

Artist

  • artist_id — INT
  • name — VARCHAR(255) — NOT NULL
  • birth_date — DATE
  • death_date — DATE
  • bio — TEXT

Collection

  • collection_id — INT
  • title — VARCHAR(255) — NOT NULL
  • topic — VARCHAR(255)

Exhibition

  • exhibition_id — INT
  • title — VARCHAR(255) — NOT NULL
  • topic — VARCHAR(255)
  • location — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE

ExhibitionArtifact

  • exhibition_id — INT
  • artifact_id — INT

Painting

  • artifact_id — INT
  • canvas_type — VARCHAR(255)

Sculpture

  • artifact_id — INT
  • material — VARCHAR(255)
  • color — VARCHAR(100)