Where can I find relate fields in the database?
In studio we have a custom relate field on account named merged_into_c, which contains a link to another account.
I want select the accounts which were merged into another account, but the field merged_into_c does not exist in the database, not on the accounts and not on the accounts_cstm table. There is also no accounts_accounts or accounts_merged_into table. It is not clear to me where this relation is stored in the database...
SELECT Id, name FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts_cstm.merged_into_c IS NOT NULL AND NOT accounts_cstm.merged_into_c='' LIMIT 10;
Anyone any idea how this information is stored?