Primary / Foreign keys?

[joej]

The .sql creates tables, creates index/indices, but - no primary keys, no foreign keys?

Using the entity diagram, it looks like there are clear connections for Foreign Keys, and some primary keys are likely composite keys (e.g., a many-to-many via a table that points FKs outward).

Is there a reason the primary key constraints are commented out in the .sql?
Does OA not use Foreign Keys, due to the volume of records?

[sandias42]

+1 to this question- I'm a visual learner and wanted to just load up the schema into a mock db so I could browse interactively and understand all the relationships. But as joej mentions, the sql provided doesn't initialize that stuff, despite seeing them in the pg schema diagram here (https://docs.openalex.org/download-all-data/upload-to-your-database/load-to-a-relational-database/postgres-schema-diagram).