CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • Tables - define which does what?
Pages: [1]

Author Topic: Tables - define which does what?  (Read 3891 times)

Diesel9a1

  • Guest
Tables - define which does what?
October 05, 2008, 05:17:12 am
Is there a section within the forum or on the homepage that explains what each table is for and why it was created? Some tables are obvious, but some are not so.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Tables - define which does what?
October 05, 2008, 09:11:14 am

No. is there a specific table(s) you have a question about? You can check the tpl files and see how that page is constructed, makes it much more clear as to what gets pulled from where

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

roballen

  • Guest
Re: Tables - define which does what?
October 05, 2008, 01:06:29 pm
I don't know if this helps but the ERD (for 2.0) is here.

http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+ERD+2.0

Diesel9a1

  • Guest
Re: Tables - define which does what?
October 06, 2008, 09:02:59 pm
The ERD is very useful in explaining how it all links together and I have it printed out over 8 sheets of A4.

More explanation on Tables AND some fields actually. Any reasons for naming conventions etc

- contact.contact_sub_type

- loc_block table

- mapping table

- Does "Organization" cover businesses, associations, social clubs, sports clubs etc


Things, as a relative newbie to databases, that I'm not sure about is why a field in a table links to the id of the same table (activity.parent_id).


Also, does civicrm replace the standard Joomla! ACL tables or does it somehow link in to them for user registration?


I'm sorry if it is all self explanitory to yourselves but it isn't idiot proof to myself.

Pete
« Last Edit: October 07, 2008, 09:08:09 am by Diesel9a1 »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • General Discussion (please no support requests here!) (Moderator: Michał Mach) »
  • Tables - define which does what?

This forum was archived on 2017-11-26.