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

Optimizing Database Design: Multiple Tables vs One Table with More Columns

Database Design Strategies for Merging Tables: Improving Relational Integrity