Unica Campaign System Tables Data Dictionary V12.0 | 1 - Unica Campaign system tables overview | 3
System database schema changes for v11.0.0.0
• The following changes were made.ALTER TABLE UA_InteractedSMS ADD COLUMN
MessageBody varchar(256) NULL;
•
The following new table was added:
CREATE TABLE UA_EmailOptOut (
RecordIDbigint NOT NULL GENERATED ALWAYS AS IDENTITY,
Providervarchar(64) NULL,
EndpointSourcevarchar(64) NULL,
Channelvarchar(64) NULL,
X1IDvarchar(64) NULL,
ContactIdvarchar(64) NULL,
Emailvarchar(64) NULL,
EventCodevarchar(64) NOT NULL,
EventTimeStamptimestamp NOT NULL,
EventNameSpacevarchar(64) NULL,
EventVersionvarchar(64) NULL,
EventNamevarchar(64) NULL,
Descriptionvarchar(128) NULL,
OptOutDetails varchar(1024) NOT NULL,
MessageIdbigint NULL,
MailingTemplateId bigint NULL,
ReportIdvarchar(64) NULL,
SubjectLine varchar(256) NULL,
MessageName varchar(1024) NULL,
DocTypevarchar(64) NULL,
EventId varchar(64) NULL,
TrackingCode varchar(1024) NULL,
ExternalSystemName varchar(64) NULL,
ExternalSystemReferenceID varchar(64) NULL,
CampaignAudienceID varchar(256) NULL,
CONSTRAINT tUA_EmailOptOut_PK PRIMARY KEY (RecordID)