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.
Thank you all for your time
This should help you out:
SchemaSpy tables and diagrams To learn about our database structure, with its tables and relationships, please visit the SuiteCRM Database Schema, generated with SchemaSpy.
General principles and sample SQL queries Some of the queries provided...
member organizations are just accounts inside accounts. I discuss that here:
Accounts and Contacts are very central concepts in SuiteCRM. Normally your data-modelling decisions start here - and there are a few subtleties you need to learn.
An Account is basicaly a representation of an impersonal entity, like a company, an...
So have a look in the
table. I don’t recall how the relatinship is handled, maybe it’s an
, or maybe it’s just a
field in the accounts table.