Do you need a separate database for CiviCRM?

Do you need a separate database for CiviCRM?

Using a separate database is generally preferred – as it makes backups and upgrades easier. The installer will create a new database for CiviCRM automatically if you enter a database name that doesn’t already exist on your database server AND the database user you enter has permission to create databases.

What should I know about the data architecture of CiviCRM?

This page is an introduction to CiviCRM’s data architecture. This should be useful for users and implementors that want to better understand the different CivICRM objects and tables and how they are related, and how they are stored in the database.

How to add custom data to a CiviCRM object?

When you add custom data to a CiviCRM object, you first create a custom data group and then add custom data fields. At the database layer, what you are doing is creating a new table for the custom data group and adding columns for the fields. The diagrams on this page were created using MySQL Workbench.

Where are the common objects stored in CiviCRM?

Most of the common objects in CivICRM (like contacts, activities, memberships, relationships, groups), are stored in the database as one or more tables. Most of the tables that represent common CRM objects (like contacts, activities, relationships), etc. can be segmented into different types. Most objects can be extended by adding custom data.

How does CiviCRM work on a wordpress site?

Once installed, CiviCRM keeps your WordPress Users synchronized with corresponding CiviCRM contact records. The ‘rule’ is that there will be a matched contact record for each WordPress user record. Conversely, only contacts who are authenticated users of your site will have corresponding WordPress user records.

Where can I find documentation for CiviCRM core?

CiviCRM offers community contributed documentation below. We encourage everyone to contribute to documentation . Some older documentation has not yet been migrated here and can still be found on the CiviCRM Wiki. Documentation for CiviCRM “Core”, that is, CiviCRM when it is installed without any extensions.

How can objects be extended in CiviCRM data architecture?

Most objects can be extended by adding custom data. Interacting directly with the database is highly discouraged.