The following database tables are used to store contact management and scoring data:
•OM_Contact - contains records representing contacts and their settings.
•OM_ContactStatus - contains records representing possible contact statuses.
•OM_ContactRole - stores the possible roles that contacts can have within accounts.
•OM_Membership - this table is used to bind users, subscribers and customers to contacts. Each entry has a member type, which determines whether the related object is a user, subscriber or customer. The given object is then connected through its ID (RelatedID). Please note that the relationships with the CMS_User, Newsletter_Subscriber and COM_Customer tables are not indicated in the diagram below.
•OM_IP - used to store the IP addresses associated with contacts.
•OM_UserAgent - stores the browser user agents of contacts.
•OM_Account - contains records representing accounts and their settings.
•OM_AccountContact - stores relationships between contacts and accounts. Each record indicates that a contact belongs to a specific account. If the contact has a certain role within the account, the information is also stored in this relationship.
•OM_AccountStatus - contains records representing possible account statuses.
•OM_ContactGroup - contains records representing contact groups.
•OM_ContactGroupMember - this table is used to bind contacts and accounts to contact groups. Each entry has a member type, which determines whether the related object is a contact or account. The given object is then connected through its ID (ContactGroupMemberRelatedID). Please note that the relationships with the OM_Contact and OM_Account tables are not indicated in the diagram below.
•OM_Activity - contains records representing the logged activities.
•OM_ActivityType - contains records of all possible activity types.
•OM_PageVisit - used to store the additional details, which are logged along with Page visit activities.
•OM_Search - used to store additional details for Search activities.
•OM_Score - contains records representing and their configuration.
•OM_Rule - contains records representing scoring rules.
•OM_ScoreContactRule - contains relationships between contacts, scores and rules. Each record stores the value that a specific contact has according to a certain scoring rule. The total score points of a contact are calculated as the sum of all values for the rules that belong to the given score.
The diagram below shows the relationships between these tables. For a full‑size diagram including table columns, please click here.