O'Reilly logo

SugarCRM Developer's Manual by Dr Mark Alexander Bain

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. SugarCRM Data Dictionary

InChapter 5 we looked at the SugarCRM database schematics—this showed us all of the relationships between the tables in the database. We'll now turn our attention to the individual tables themselves.

Differences between Versions 4.5.0 and 4.5.1

You'll find that some minor changes in the table structures between SugarCRM version 4.5.0 and 4.5.1. The changes are:

  • One or two additional fields in 4.5.1—these are all marked in the table definitions.

  • The data type for each id field has been changed from varchar to char. This has no effect on the operation of the database, but can potentially save some of the space required to store the data.

SugarCRM Table Definitions

Having seen how the tables are related ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required