Data structure

Schema

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

Tables

11 native tables.

Views

1 database views.

Foreign keys

10 declared relationships.

Including self-references and composite-key tables.
discountsstor_id→storesstor_id
employeepub_id→publisherspub_id
employeejob_id→jobsjob_id
pub_infopub_id→publisherspub_id
royschedtitle_id→titlestitle_id
salestitle_id→titlestitle_id
salesstor_id→storesstor_id
titleauthortitle_id→titlestitle_id
titleauthorau_id→authorsau_id
titlespub_id→publisherspub_id