Does anyone know the location of the database table for member organizations? I need to delete the data in it after importing a ton of bad data. I prefer to do a do a full delete instead of leaving tens of thousands of entries in it with delete set to 1.
Note that member organizations are just accounts inside accounts. I discuss that here:
So have a look in the accounts table. I don’t recall how the relatinship is handled, maybe it’s an accounts_accounts, or maybe it’s just a parent_id field in the accounts table.