Multi-site schemas: lessons from evolving one large system over time

Multi-site schemas: lessons from evolving one large system over time I worked on a large multi-site system where the data model had to evolve as the product grew. It started out simple, but as always, with progress the demand also grew to something that allowed flexibility. The progression was: site_id many-to-many relationships scope_id Each stage solved the limitations of the previous one. Looking back, I would skip directly to the final model. 1. Start simple: site_id The original model was: