SuiteCRM – online ER diagram

View the diagram Open full screen
SuiteCRM - database diagram

From suitecrm.com:

  • SuiteCRM is an open source Customer Relationship Management (CRM) software solution that provides a 360-degree view of your customers and business.
  • Feature-rich enterprise-ready alternative to Salesforce provides all the benefits of CRM at substantially lower costs with the freedoms and flexibility of Open Source.
  • SuiteCRM is used by millions of people every day.
  • Powerful, customisable, easy to use, with hundreds of extensions and integrations.

For more information visit https://suitecrm.com/

HTML report / online ER Diagram#

The ER Diagram was created by reverse engineering the database structure from locally installed SuiteCRM version 7.11.20. The target database was MariaDB with InnoDB default engine.

How to use the ER diagram/HTML report: click on a db table in the online ER Diagram. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected MariaDB table.

The database structure doesn’t include relationships and like in many other open source systems, database functions, table triggers and other database objects are not specified.

SuiteCRM · ER diagramOpen in new tab

Details#

Target database
MariaDB
Luna Modeler project file
https://www.dbdiagrams.com/online-diagrams/suitecrm.dmm
SuiteCRM license
AGPL v3

Build on SuiteCRM#

Improve the system

Extend SuiteCRM

Planning a plugin, module or extension? Find the tables you will work with, then model your own tables and amendments right next to them, before you write a line of code.

Get inspired

Craft a new system

Building something of your own? Study how SuiteCRM structures its data, take the ideas that work, and design a data model that fits your project.

Respect the license. SuiteCRM is released under the AGPL v3. This copyleft license generally requires that work based on the code is released under the same license and keeps the original copyright notices, even when you only offer it to users over a network. Whatever you build, read the license and follow its terms.

More ER diagrams

All in MariaDB
MariaDB ER diagram GPL v2

osTicket – ER Diagram

by osTicket.com: osTicket is a robust customer support portal system to help your business maintain happy customer relationships.

MariaDB ER diagram GPL v2+

Drupal CMS – online ER diagram

Drupal is content management software. It’s used to make many of the websites and applications you use every day. Drupal has great standard features, like easy content authoring, reliable performance, and excellent security.

MariaDB ER diagram GPL v2+

MediaWiki – online ER diagram

MediaWiki is a collaboration and documentation platform. See the database structure in a form of an entity relationship diagram.