Answers.Body: <p><a href="https://doc.symbiotic.coop/dev/civicrm/latest/schema/" rel="nofollow noreferrer">https://doc.symbiotic.coop/dev/civicrm/latest/schema/</a> may offer what you need. If you click on any specific table it will show you all the children and if you keep scrolling down the page you will a 1 or 2 degree relational diagram</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-29T19:21:30.430Z
Answers.LastActivityDate: 2019-10-29T19:21:30.430Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>During installation the CiviCRM are generated from xml files, and those will not always correspond 1-1 with the tables AFAIK.</p>
  
  <p>You can find the xm definitions in the civicrm folder: civicrm/xml/schema.</p>
  
  <p>Alternative is to use the API Explorer (Support/API Explorer in your CiviCRM menu) and do a getfields action for the entity? I would recommend using the API to do a migration anyway rather than moving into the tables directly.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-29T03:01:15.703Z
Answers.Text: Also check out the various Import menu links in CiviCRM and the related user guide docs. You might be able to import the data from csv files. While there is some generic database info at https://docs.civicrm.org/dev/en/latest/framework/database/schema-design, I agree with Erik about using the api to make a smoother transition.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-29T03:01:55.767Z
Answers.Text: Also partly agree with the statement at https://docs.civicrm.org/dev/en/latest/framework/database/schema-design/#why-a-entity-relationship-diagram-may-not-be-helpful that `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`. Definitely for anyone starting out with CiviCRM.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-10-28T12:34:39.003Z
Answers.LastActivityDate: 2019-10-28T12:34:39.003Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Can someone please guide me to the table/data templates for CiviCRM.  We are in the process of migrating from an existing relational Access database to CiviCRM and want to map related data to organisations, individuals, membership payments etc.  I have not been able to locate this in any documentation.</p>
  
  <p>Thank you in advance for any pointers/help.</p>
  
  <p>Graeme</p>
  
Tags: <contacts>
Title: Data Mapping for Importing data from external database
ThreadText: # Data Mapping for Importing data from external database
  
  (Asked by: username_0 on 2019-10-28)
  
  Can someone please guide me to the table/data templates for CiviCRM. We are in the process of migrating from an existing relational Access database to CiviCRM and want to map related data to organisations, individuals, membership payments etc. I have not been able to locate this in any documentation.
  
  Thank you in advance for any pointers/help.
  
  Graeme
  
  **Tags:** contacts
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2019-10-29. Score: 0 | Accepted answer
  
  <https://doc.symbiotic.coop/dev/civicrm/latest/schema/> may offer what you need. If you click on any specific table it will show you all the children and if you keep scrolling down the page you will a 1 or 2 degree relational diagram
  
  
  ---
  
  ### Answer by username_2 on 2019-10-28. Score: 2
  
  During installation the CiviCRM are generated from xml files, and those will not always correspond 1-1 with the tables AFAIK.
  
  You can find the xm definitions in the civicrm folder: civicrm/xml/schema.
  
  Alternative is to use the API Explorer (Support/API Explorer in your CiviCRM menu) and do a getfields action for the entity? I would recommend using the API to do a migration anyway rather than moving into the tables directly.
  
  > **Comments:**
  > **username_3**: Also check out the various Import menu links in CiviCRM and the related user guide docs. You might be able to import the data from csv files. While there is some generic database info at https://docs.civicrm.org/dev/en/latest/framework/database/schema-design, I agree with Erik about using the api to make a smoother transition.  
  > **username_3**: Also partly agree with the statement at https://docs.civicrm.org/dev/en/latest/framework/database/schema-design/#why-a-entity-relationship-diagram-may-not-be-helpful that `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`. Definitely for anyone starting out with CiviCRM.  
  
  ---
  
  