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)