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.
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.
Having seen how the tables are related ...