CiviCRM: Difference between revisions
(entities) |
(change log) |
||
| (3 intermediate revisions by the same user not shown) | |||
| 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. | ||
During installation, initial values for Civi are loaded by running the 23713 line SQL script /civicrm/sql/civicrm_data.mysql. This script loads many things into SQL tables, including lists of countries, lists of options, HTML, javascript, message templates, etc. | |||
The 200 Civi tables represent data for six primary entities: | The 200 Civi tables represent data for six primary entities: | ||
| Line 20: | Line 22: | ||
*Groups and tags | *Groups and tags | ||
*Custom data | *Custom data | ||
==Customization== | |||
Useful links: | |||
https://civicrm.org/blog/dave-greenberg/usabilty-improvements-configurable-navigation-menu-with-one-click-access-to-any | |||
https://docs.civicrm.org/user/ca/latest/the-user-interface/menu-dashboard-and-dashlets/ | |||
https://docs.civicrm.org/user/en/latest/initial-set-up/customizing-the-user-interface/ | |||
==Change log== | |||
===March 15, 2018=== | |||
*Activate CiviCase | |||
*Change Druple permissions on CiviCase pages to allow administrator access | |||
*Created a test case | |||
==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] | ||
Latest revision as of 03:05, 16 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.
During installation, initial values for Civi are loaded by running the 23713 line SQL script /civicrm/sql/civicrm_data.mysql. This script loads many things into SQL tables, including lists of countries, lists of options, HTML, javascript, message templates, etc.
The 200 Civi tables represent data for six primary entities:
- Contacts and relationships
- Activities
- Memberships
- Contributions
- Groups and tags
- Custom data
Customization
Useful links:
https://civicrm.org/blog/dave-greenberg/usabilty-improvements-configurable-navigation-menu-with-one-click-access-to-any https://docs.civicrm.org/user/ca/latest/the-user-interface/menu-dashboard-and-dashlets/ https://docs.civicrm.org/user/en/latest/initial-set-up/customizing-the-user-interface/
Change log
March 15, 2018
- Activate CiviCase
- Change Druple permissions on CiviCase pages to allow administrator access
- Created a test case
External links
- Entity Relation Diagrams for version 4.7, updated Sepember 16, 2016
- Entity Relation Diagrams for version 4.1