Data structure

Schema

10 tables and 2 views from the pinned source fixture. Names and relationships retain the source database’s native shape.

Tables

10 native tables.

Views

2 database views.

Foreign keys

9 declared relationships.

Including self-references and composite-key tables.
assignmentspartner_id→partnerspartner_id
assignmentsattempt_id→attemptsattempt_id
attemptsconfig_revision→configurationsrevision
attemptsrequest_id→requestsrequest_id
eventsattempt_id→attemptsattempt_id
publicationsrequest_id→requestsrequest_id
receiptsrequest_id→requestsrequest_id
routespartner_id→partnerspartner_id
routesrevision→configurationsrevision