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.