NationalGalleryOfArt / opendata

The National Gallery of Art Open Data Program
https://www.nga.gov/open-access-images/open-data.html
Creative Commons Zero v1.0 Universal
358 stars 64 forks source link

Add database schema to documentation #2

Closed timtomch closed 2 years ago

timtomch commented 2 years ago

Hello and thank you for making your data available for reuse!

I am working with the Curationist project, a platform to collate openly available artworks from multiple museums and cultural institutions, including the National Gallery of Art.

We were able to import your data and map it to our own schema thanks to the documentation you provided, however we had to work our way through your relational database schema in order to figure out how the multiple tables work together (see attached). Future users of your data may appreciate having the schema described this way, so if you want to add it to the documentation, please feel free to reuse and expand on what we have done! The SVG file should be editable.

Thank you.

natgal-dbschema

mehdi-nga commented 2 years ago

Thomas, Thank you so much to share this with us. It will be an useful resource for the users of our data. We will add this documentation to our repo after it is reviewed and verified.

brwz-nga commented 2 years ago

Hi Thomas,

We have reviewed and verified the database schema and have added it to the documentation.