Sample Table Structure for Storing Publication Data

[Wayne Turner]

We would like to download the ORCiD data for our faculty and students and store it locally. We need this data to quickly respond to information requests from the University of Texas system.

Do you know of any examples of database table structure that would help us plan for our storage? The Public API gives us more than enough data for our needs. Surely some other institution faces similar requirements.

Thank you.,