3 ms·
When using a single db I'd highly recommend adding `account_id` to every single table that contains data for multiple accounts. It's much easier to check every
by mozey 6y ago
When using a single db I'd highly recommend adding `account_id` to every single table that contains data for multiple accounts. It's much easier to check every query contains `account_id`, as opposed to checking multiple foreign keys etc. Depending on the db you can then also easily export all data for a specific account using filters on the dump tool