| address | Contact and Person addresses |
| appointment | Tasks, appointments, followups, phone calls; and documents (document_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| associate | Employees, resources and other users - except for External persons |
| Business | Business list table |
| Category | Category list table |
| chat_session | This table contains chat sessions. |
| company_domain | This table contains web-domains associated with a certain cust_company entry. |
| contact | Companies and Organizations. |
| contactinterest | Link-table between contact and interests in ContInt |
| CounterValue | Visible for rights |
| country | Country information |
| cust_lang | This table contains entries for customer languages. |
| dbi_agent | DBI agent settings |
| Email | Email addresses for contacts, projects and persons |
| email_item | Email data |
| form_submission | A form submission |
| freetextindex | This is the index table for the free text search function. Each word in FreeTextWords can have multiple occurrences in this table. Each record in this table points to one occurrence of the word, and points to both the table in which the word occurs (which might be contact or text), and also a pointer to the owner table (which is one of contact, person, project, appointment or sale). |
| invoice | This table contains invoice entries, normally created when an invoice is sent to a customer, and we want to update the balance. |
| invoice_sum | This table is used temporarily when listing invoice statistics. It is used because we need to sort balances from both customers and companies. |
| notify | This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc. |
| OwnerContactLink | Table specifying which contacts can own associates. All contacts that have rows in this table (i.e. rows with contact_id pointing to them) will be offered as associate owners in the maintenance client and as candidate Satellite owners. Such contacts have restrictions on editing and deletion to protect database consistency. |
| person | Persons |
| phone | Contact and Person phonenumbers (+fax) |
| projectmember | Project members. Link-table between person and project |
| s_shipment_addr | Addresses that are ready to be sent in a shipment. |
| sale | Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels. |
| SaleHist | Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here. |
| SaleStakeholder | Stakeholders in the sale, very similar to project members |
| satellite | Definition of Satellites |
| selectionmember | Selection detail table Each row in a selection is represented by one record in this table. Contact_id is always filled in, person_id is optional, but if used, must point to a person belonging to the contact in contact_id. |
| StatusValue | Values for statuses |
| target_assignment_info | Linking associate, company or user group target and other information with target values |
| target_revision_history | Revision history info in case the original target group or assignment info was deleted |
| text | Long text fields from all over the system |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_priority | This table contains the ticket priorities. |
| TZLocation | Time zone location |
| udcontactLarge | User-defined fields for contact (long strings) |
| udcontactSmall | User-defined fields for contact |
| URL | Unified Resource Locators, URL to contacts, persons or projects. |
| UserGroup | Secondary user groups |
| utm_parameters | Table for utm parameters collected from visits and formsubmissions |
| workflow_instance | A set of properties related to the workflow instance of one participant going through the flow |
