Database Schema ER diagram

ER diagram Link(dbdiagram.io): https://dbdiagram.io/d/Museum-686574bbf413ba3508f9dac7

Description of ER digram:

users

• users is the core account table, with a role field distinguishing museum admin, curators and artists.
• curators.user_id and artists.user_id links that only users with right role can have a curator or artist profile.

museums

• museums.admin_user_id ties each museum to exactly one admin account.

artworks

• artworks.external_artist_name lets museum admins upload artworks by unregistered artists. (nullable)
• artworks.artist_id, records which which artist added this(if the artist has signed). (nullable)
• artworks.museum_id, marks pieces owned/displayed by the museum. (nullable)
• artworks.created_by_user_id, records who actually added each record(by artist or museum admin).

exhibitions

• exhibitions.museum_id holds every show to its venue.
• exhibitions.curator_id assigns responsibility for selecting and running the exhibition.