OpenAlex API documentation
Search
⌃K
Overview
Quickstart tutorial
API Entities
Entities overview
📄
Works
👩
Authors
📚
Sources
🏫
Institutions
💡
Concepts
🏢
Publishers
💰
Funders
🌎
Geo
How to use the API
API Overview
Get single entities
Get lists of entities
Get groups of entities
Rate limits and authentication
Download all data
OpenAlex snapshot
Snapshot data format
Download to your machine
Upload to your database
Load to a data warehouse
Load to a relational database
Postgres schema diagram
Additional Help
Tutorials
Report bugs
FAQ
Powered By GitBook
Comment on page

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)
Previous
Load to a relational database
Next - Additional Help
Tutorials
Last modified 6mo ago