Postgres schema diagram

This is a diagram of one possible schema for storing the OpenAlex data in a relational database. It's the one used in our examples here, but may not be the best one for the ways you'll use the dataset.

(click to embiggen)