CiviCRM: Difference between revisions
Jump to navigation
Jump to search
(druple version) |
(entities) |
||
| Line 11: | Line 11: | ||
==Database== | ==Database== | ||
Civi and Druple store much of their data in SQL tables. Civi and Druple have about 200 tables each. The database management system uses another hundred tables, resulting in a database with about 500 tables. | Civi and Druple store much of their data in SQL tables. Civi and Druple have about 200 tables each. The database management system uses another hundred tables, resulting in a database with about 500 tables. | ||
The 200 Civi tables represent data for six primary entities: | |||
*Contacts and relationships | |||
*Activities | |||
*Memberships | |||
*Contributions | |||
*Groups and tags | |||
*Custom data | |||
==External links== | ==External links== | ||
*[https://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+data+architecture Entity Relation Diagrams for version 4.7], updated Sepember 16, 2016 | *[https://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+data+architecture Entity Relation Diagrams for version 4.7], updated Sepember 16, 2016 | ||
*[https://wiki.civicrm.org/confluence/display/CRMDOC41/CiviCRM+ERD+2.0 Entity Relation Diagrams for version 4.1] | *[https://wiki.civicrm.org/confluence/display/CRMDOC41/CiviCRM+ERD+2.0 Entity Relation Diagrams for version 4.1] | ||
Revision as of 16:31, 13 March 2018
CiviCRM is an open source Customer relationship management (CRM) system.
CiviCRM 4.7.31 is the latest version.
CiviCRM 4.6.36 is the current Long Term Support (LTS) release.
CiviCRM 4.7.29 is the version Maker Nexus is testing.
Maker Nexus is using Drupal 7.56, which should be updated to 7.57, because of security.
Database
Civi and Druple store much of their data in SQL tables. Civi and Druple have about 200 tables each. The database management system uses another hundred tables, resulting in a database with about 500 tables.
The 200 Civi tables represent data for six primary entities:
- Contacts and relationships
- Activities
- Memberships
- Contributions
- Groups and tags
- Custom data
External links
- Entity Relation Diagrams for version 4.7, updated Sepember 16, 2016
- Entity Relation Diagrams for version 4.1