Kentico CMS 6.0 On-line Marketing Guide

Database tables

Database tables

Previous topic Next topic Mail us feedback on this topic!  

Database tables

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

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.

 

onlinemarketingguide_clip0203