You definitely would not do this, this way. Its too hard, risky and there is no chance we will add a “scope” column to every table, never going to happen.
Instead look at apartment gem and how it does schema switching, you would have to port that in conditionally to rails-multisite.
You would need to handle provisioning and comms and a bunch of other stuff.