Hopefully someone can give me some advice on how to approach this
problem… I’m getting ready to start a large new project where
several different organizations would be working with a lot of tables.
Each table would have an organization_id field to signify which
organization owns that record. Organizations would only be able to
view/edit records they own. Potentially thousands of organizations
and dozens of tables.
I’m hoping rails has some magic way to handle this in the model
somehow. The alternative is I’d have to include a where
organization_id = to virtually every single query…
btw, I’m using mysql, in case there might be some way to accomplish
this on the database level.