These are implicit, not enforced foreign keys. Most of the primary keys are explicit. These are not "complete" diagrams because some historical tables may implicitly link to one of the tables in a given diagram. Those shown are the "core" tables for a particular category of tables. All diagrams are courtesy of Scott Christley.