We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

CRM 7 database

In this article

    The main tables in the system are:

    Contact

    The companies

    Person

    The contact persons

    Associate

    The users - these are linked to contact persons

    Appointment

    Meetings, to-do activities

    Document

    Document activities

    Sale

    Sale activities

    Project

    Projects

    ProjectMember

    Persons who are part of a project

    Selection

    Selections

    SelectionMember

    Link table for Contact+Person who are selection members

    A source of confusion needs to be explained. The database schema was defined early on (about fifteen years ago in fact) and the names for various entities in the code was locked down.

    Unfortunately the user interface came up with names which do not match the table names used to generate the user interface.

    "Company" in the user interface = Contact table
    "Contact" in the user interface = Person table

    The Company table is used to store the id of the company that owns the license. It has nothing to do with the company display in the user interface.