Home
System Schema
Overview
This guide is a reference to the table and column structure, content, and semantics of the database system for Unica Contact Central.
System Tables
The following list mentions all the system tables used by Unica Contact Central.
UPC_CONSENT

System Schema
- Overview
  This guide is a reference to the table and column structure, content, and semantics of the database system for Unica Contact Central.
  - System Tables
    The following list mentions all the system tables used by Unica Contact Central.
    - UPC_PREFERENCE_TYPE
      This table stores information related to preference types for different regional preferences.
    - UPC_REGIONAL_PREFERENCE
      This table stores information related to regional preferences created by the user.
    - UPC_CHANNEL_PREFERENCE
      This table stores information related to channel preferences created by the user to link to a global preference.
    - UPC_CHANNEL_PREFERENCE_MAPPING
      This table stores information related to mapping between global preference, channel preference, and their corresponding channels.
    - UPC_CHANNEL
      This table stores information related to channel names supported by Contact Central.
    - UPC_CHANNEL_CAPACITY
      This table stores information related to channel capacity allocation for each channel.
    - UPC_CHANNEL_CAPACITY_TRANSACTIONS
    - UPC_CONSENT_CATEGORY
    - UPC_AUDIENCE
    - UPC_CONSENT
    - UPC_CONSENT_DETAILS

`UPC_CONSENT`


Field	Type	Length	Null?	Description
`id`	INT		False	Unique ID of the table.
`audience_id`	INT		False
`consent_source`	VARCHAR2	100	False
`channel_id`	INT		False
`category_id`	INT		False
`optedOut`	INT	1	False	Stores the audience consent. The valid values are: 0 for No 1 for Yes
`reason`	VARCHAR2	250	False	Detailed reason for audience not providing consent.
`consentDateEpoch`	INT		False	Consent date epoch.
`createdDateEpoch`	INT		False	Created date epoch.
`lastModifiedDateEpoch`	INT		False	Last modified date epoch.
`version`	INT	20	False	Version information for optimistic locking.
`createdby`	INT	20	False	Platform ID of the user who created the entry.
`modifiedby`	INT	20	False	Platform ID of the user modifying the entry

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.