How to Select Distinct IDs from One Table Based on Rules from Another Table

Representing JSON Tree-Child Structures in Relational Databases Using Closure Tables

Designing a Scalable Multitenant System: The Benefits and Drawbacks of Repeated Primary Keys as Foreign Keys