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
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
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.
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.