Book Image

SugarCRM Developer's Manual: Customize and extend SugarCRM

By : Dr Mark Alexander Bain
Book Image

SugarCRM Developer's Manual: Customize and extend SugarCRM

By: Dr Mark Alexander Bain

Overview of this book

<p>SugarCRM is the world's leading commercial open-source customer relationship management (CRM) software for companies of all sizes. SugarCRM easily adapts to any business environment by offering a more flexible, cost-effective alternative to proprietary applications. SugarCRM's open-source architecture allows companies to more easily customize and integrate customer-facing business processes in order to build and maintain more profitable relationships. SugarCRM offers several deployment options, including on-demand, on-premise and appliance-based solutions to suit customers' security, integration, and configuration needs. <br /><br />This book will help you to customize the SugarCRM code. You will get learn about the database and application architecture. The book provides you with a module development tutorial, showing the essential steps for hooking your module into the SugarCRM infrastructure. You will learn about common customizations that can be performed against the codebase.</p>
Table of Contents (16 chapters)
SugarCRM Developer's Manual
Credits
About the Author
About the Reviewers
Preface
Index

SugarCRM Table Definitions


Having seen how the tables are related together, and the fields that are used to do that, we can now look at the other fields that make up each table. Each table definition contains:

  • Field name

  • Field type, width and any additional information (such as auto_increment)

  • If a null value is allowed

  • Index details—this will either be PRI—primary index, or MUL—duplicate entries allowed

  • The default value

Accounts

Field Name

Field Type

Null Allowed

Index

Default Value

id

char(36)

 

PRI

 

date_entered

datetime

  

0000-00-00 00:00:00

date_modified

datetime

  

0000-00-00 00:00:00

modified_user_id

char(36)

   

assigned_user_id

char(36)

YES

 

NULL

created_by

char(36)

YES

 

NULL

name

varchar(150)

YES

 

NULL

parent_id

char(36)

YES

MUL

NULL

account_type

varchar(25)

YES

 

NULL

industry

varchar(25)

YES

 

NULL

annual_revenue

varchar(25)

YES

 

NULL

phone_fax

varchar(25)

YES

 

NULL

billing_address_street

varchar(150)

YES

 

NULL

billing_address_city

...