Question about the documentation for the database schema and method joining method

[alecander]

Hello All,

for my work I wanted to analyze which tables are joined together in the database. The database used is MySQL. To my surprise, the visualization shows that the tables are not joined together (see picture) and the analysis of the DDL of the individual tables also gives the same result.

So my question is, how are the tables joined together, if not in the database. The probability is high that the tables are merged / joined in the application.
That's why I wanted to ask for the documentation on how the tables are joined in the EspoCRM application.

[item]

Hello,
my response is with my skill .. maybe bad

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Account.json#L218

all relationship is defined in metadata/entityDefs/table.json
all index too in theses files

there are sometimes special fields in middle table like :

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Contact.json#L219

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Contact.json#L329

[alecander]

Hello,
my response is with my skill .. maybe bad

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Account.json#L218

all relationship is defined in metadata/entityDefs/table.json
all index too in theses files

there are sometimes special fields in middle table like :

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Contact.json#L219

https://github.com/espocrm/espocrm/blob/c8395c6558a303a184007104807de8947f5bea35/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Contact.json#L329

Thank you very much .
It helped alot.