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_AUDIENCE

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_AUDIENCE`


Field	Type	Length	Null?	Description
`id`	INT		False	Unique ID of the table.
`partition_name`	VARCHAR2	250	False
`audience_level`	VARCHAR2	250	False
`audience_field_enum`	SMALLINT		False
`audience_number`	INT		False
`audience_text`	VARCHAR2	250	False
`audience_json`	CLOB		False
`audience_hash`	VARCHAR2	250	False
`audience_email`	VARCHAR2	250	False	The email address of the audience.
`audience_mobile`	VARCHAR2	250	False	The mobile number of the audience.
`audience_device_id`	VARCHAR2	250	False	The installation ID of the app in the audience's phone.
`createdDateEpoch`	INT		False	Created date epoch.
`lastModifiedDateEpoch`	INT		False	Last modified date epoch.
`version`	INT		False	Version information for optimistic locking.
`createdby`	INT		False	Platform ID of the user who created the entry.
`modifiedby`	INT		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.