SugarCRM community edition database structure

[meggiel]

Hi all, I am new to SugarCRM. I want to know if the SugarCRM community edition database structure is fixed so I can easily look into the structure and write codes to integrate with other system such as ERP..? Who will be the one to design the database structure and what to change from one version to the other newer version? Please advise.

[kuske]

The database structure is very clear I think.
The column names are very easy to understand.

All bean tables like accounts, contacts, leads etc. have associated custom tables *_cstm if there is at least one custom field defined.
The relation is bean.id = beand_cstm.id_c.

The last grteater changes have been from 4.5.1 to 5.0.0, they are documented in SugarWIKI.

The id-Fields of all tables are UUIDs which can be generated by mySQL uuid() function calls too.

[susiewilliams]

Meggiel,

Please check out the Web Services (SOAP) API for building integrations between Sugar and other applications. Using the API ensures that your integrations will survive schema upgrades, and is the recommended way for building integrations with Sugar.

You can find details about the API in the Developer website.

[kuske]

Yes, using the SOPA api would be surely the best way to write version independant code.
But be careful with float and currency values if you have komma as decimal separator and dot as 1000s separator.
The SOAP API loves it since 5.0.0 to multiply these numbers with 100 ... ... on each save.

Greetings
Harald Kuske

[balajimani]

Yes, using the SOPA api would be surely the best way to write version independant code.
But be careful with float and currency values if you have komma as decimal separator and dot as 1000s separator.
The SOAP API loves it since 5.0.0 to multiply these numbers with 100 ... ... on each save.

Greetings
Harald Kuske

Hi,

Can you tell me which data is encrypted for IDs in all the tables of SugarCRm database.

Thanks and Regards,
Balaji.M

[daniel.passarini]

Hi balajimani

The IDs creation is set by a function named create_guid() in include/utils.php
all IDs are created by this function. If you see it, you'll be noticed that the function process the current microtime to create the ID

[kuske]

You can even use the mysql standard function guid() to create new ID values.