Skip to content
Snippets Groups Projects

Provide link to new ERDs and add link to DBeaver

Merged justinfreeman (Agileware) requested to merge Link2ERDs into master
1 file
+ 2
4
Compare changes
  • Side-by-side
  • Inline
# CiviCRM Schema Design
## Why a Entity Relationship Diagram may *not* be helpful
As some coders are visual learners, ER Diagrams maybe a waste of time for those coders to understand the CiviCRM Database model and structure. Fundamentally CiviCRM's Schema design is way too complex, with at least 150 tables and loads of Foreign Key Constraints linking tables together any such graphic or design document that tries to map out the CiviCRM database design would most likely bring more confusion than help, especially for visual learners.
A number of [Entity-Relationship Diagrams](docs/api/ERDs/index.md) are available which help with exploring and better understanding the CiviCRM database design.
## Alternate Methods to ERDs to explore CiviCRM's Database Design
Another method of viewing CiviCRM's Database model is to use one of various MySQL coding tools e.g. PHPMyAdmin or [MySQL Workbench](https://www.mysql.com/products/workbench/). These tools allow coders to inspect the Table Structure more easily and look at all the constraints attached to tables very easily.
Another method of viewing CiviCRM's Database model is to use one of various MySQL coding tools e.g. [DBeaver](https://dbeaver.io/), [PHPMyAdmin](https://www.phpmyadmin.net/) or [MySQL Workbench](https://www.mysql.com/products/workbench/). These tools allow coders to inspect the Table Structure more easily and look at all the constraints attached to tables very easily.
## MySQL Workbench Workflow
Loading