1. We have moved to a new forum! There may be a few things not working properly so please let us know if you find a bug. Remember to use the bbCode [ sql ] tag for SQL statements.
New XenForo forum! Google Ads

Civicrm - Contact Management

Discussion in 'Database Design' started by ben, Apr 8, 2007.

  1. ben Administrator

    Earlier in the year I was working on a Drupal site that heavily relied on the CiviCRM module.
    From their website: "CiviCRM is the first open source and freely downloadable constituent relationship management solution. CiviCRM is web-based, open source, internationalized, and designed specifically to meet the needs of advocacy, non-profit and non-governmental groups."

    While working on this project I took a closer look at the datbase design for storing contact information. It may be over kill for most people, but at least it gives a good example of what can be done. (As well as a good example of best practices.)

    You can read more about the database design on this page.

    You can also download the latest (version 1.7) MySQL create script for the entire civicrm database in the attachments. The script is very well crafted. Each field is commented and the actual coding style, is to me, excellent. I wish I had a script to study like this one when I first started out...

    Here is a partial picture of the database
    [IMG]

    Attached Files:

    ben, Apr 8, 2007
    #1

  2. molotov Guest

    Why TINYINT?

    On the table 'civicrm_mobile_provider', for the fields named 'is_x', why are they TINYINTs and not BOOLs? The field names make me tend to believe they are binary or true/false values.

    There are also 'is_x' on other tables as well as 'do_not_x'.
    molotov, Apr 19, 2007
    #2

  3. Roberto Guest

    Holy Crap

    Wow, ive never seen a more complete contact management database.

    What kind of business did u have in mind when u designed, cause it seems like overkill for a small business.
    Roberto, Apr 20, 2007
    #3

  4. kevod New Member

    hi can you replace the zip file because it wont unzip 4 me
    Thanks
    kevod, May 1, 2007
    #4

  5. ben Administrator

    Done. Should work now. Thanks for pointing this out.
    ben, May 2, 2007
    #5

  6. Mordy Guest

    HI Ben,
    The ability to view a database design like this is extremely informative. I would appreciate if you can provide a link or the name of the software which translated the DB schema to this beautiful image.
    Thanks,
    Mordy
    Mordy, Sep 2, 2008
    #6

  7. ben Administrator

    DbWrench
    ben, Jan 29, 2012
    #7

Share This Page