Unica Interact Design Time System Tables
When you install the Unica Interact design time server, you also run a series of SQL scripts to set up the required system tables in your data source that Unica Interact needs to operate. This document provides a data dictionary describing the structure and content of the design time system tables.
UACI_ICBatchOffers
Contains a mapping of offers to interactive channels. The Offers for a particular IC will be added to the deployment of the IC at deploy time.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ICName | VARCHAR | 64 | false | Name of the interactive channel. May be any text characters, minus standard disallowed special name characters. |
| OfferCode1 | VARCHAR | 64 | false | The first part of offerCode. May be any text characters, minus standard disallowed special name characters. |
| OfferCode2 | VARCHAR | 64 | true | Optional second part of offerCode. May be any text characters, minus standard disallowed special name characters. |
| OfferCode3 | VARCHAR | 64 | true | Optional third part of offerCode. May be any text characters, minus standard disallowed special name characters. |
| OfferCode4 | VARCHAR | 64 | true | Optional fourth part of offerCode. May be any text characters, minus standard disallowed special name characters. |
| OfferCode5 | VARCHAR | 64 | true | Optional fifth part of offerCode. May be any text characters, minus standard disallowed special name characters. |
UACI_Rule
Deprecated. Use UACI_SmartTable instead.
Contains the Rule information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| RuleID | INT64 | false | pk, Unique ID of the Rule. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| RuleGroupID | INT64 | false | fk, Unique ID of the RuleGroup. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| MarketWeight | INT32 | true | Value from 1 to 100 that reflects the slider setting from the strategy page. | |
| Disabled | INT32 | true | Indicates whether this rule is active or inactive. | |
| DisplayOrder | INT32 | true | Affects the display position of this rule in the strategy page. | |
| OfferID | INT64 | false | FK, unique ID of offer referred to by this rule. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ZoneID | INT64 | true | FK, unique ID of zone that this rule applies to. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CreateDate | DATETIME | true | Date of when this rule was first created. | |
| CreateBy | INT32 | true | Platform ID of the user who first created this rule. Must be a valid userId in the Platform database. | |
| UpdateDate | DATETIME | true | Date of when this rule was last modified. | |
| UpdateBy | INT32 | true | Platform ID of the user who last modified this rule. Must be a valid userId in the Platform database. | |
| PredicateID | INT64 | true | FK, unique ID of predicate that is associated to this rule. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Suppression Count | INT32 | false | This field is for Exclusive offer suppression. The field is located on the Strategy page. Once you save the Suppression Count in the Strategy Advance Option for rule then the 'Suppression Count' value is updated in this column, By default the value is 0. | |
| Max Score | INT32 | false | By default the value is false(0) and in the Strategy once you select Max score for rule and save the Strategy then the value becomes true(1). |
UACI_Predicate
Contains the predicate information as defined the Advanced Rules option of the Strategy page.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| PredicateID | INT64 | false | PK, unique ID of predicate. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Name | VARCHAR | 256 | true | The name of the predicate. May be any text characters, minus standard disallowed special name characters. |
| Description | VARCHAR | 512 | true | The description of predicate. My be any text characters, minus standard disallowed special name characters. |
| Predicate | VARCHAR | 4000 | true | The predicate expression. May be any text characters, minus standard disallowed special name characters. |
| EnableStateID | INT32 | false | Flag indicating whether or not this predicate is disabled, acting as a boolean filter, or
acting as a way to calculate marketing score. Values may be one of:
|
|
| FolderID | INT64 | true | FK, unique ID of folder that contains this predicate. This is currently not utilized and was added for future use since there is no place in the gui to manage the predicates across folders. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CreateDate | DATETIME | true | The date when this predicate was first created. | |
| CreateBy | INT32 | true | Platform ID of the user who first created this predicate. Must be a valid userId in the Platform database. | |
| UpdateDate | DATETIME | true | The date when this predicate was last modified. | |
| UpdateBy | INT32 | true | Platform ID of the user who last modified this predicate. Must be a valid userId in the Platform database. |
UACI_PredState
A type table that contains each enumeration of a Predicate option. [ disabled; boolean filter; marketing score calculator]
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EnableStateID | INT32 | false | PK, unique ID enablestate. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Description | VARCHAR | 512 | true | Description of the enable state. Values may be:
|
UACI_ProfileMap
Contains the Central Profile Map information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ICID | INT64 | false | FK, unique ID of the interactive channel. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| AudienceLevel | VARCHAR | 64 | false | The audience level that this profile represents. May be any text characters, minus standard disallowed special name characters. |
| PhysicalTableName | VARCHAR | 64 | true | The real name of the underlying database table to be used as the base profile table. May be any text characters, minus standard disallowed special name characters. |
| LogicalTableName | VARCHAR | 64 | true | The virtual name of the profile table. May be any text characters, minus standard disallowed special name characters. |
| ProfileData | TEXT | true | A blob that contains the profile map definition in XML form. | |
| CreateDate | DATETIME | true | The date that this profilemap was first created. | |
| CreateBy | INT32 | true | Platform ID of the user who created this profilemap. Must be a valid userId in the Platform database. | |
| UpdateDate | DATETIME | true | The date that this profilemap was last modified. | |
| UpdateBy | INT32 | true | Platform ID of the user who last modified this profilemap. Must be a valid userId in the Platform database. |
UACI_RuleGroup
.
Deprecated. Use UACI_SmartRuleGroup insteadContains RuleGroup information. A Rule Group is a group of rules associated to a particular segment within a Strategy.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| RuleGroupID | INT64 | false | PK, unique ID of the rulegroup. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CellID | INT64 | false | FK, unique ID of cell with which this rulegroup is associated. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| StrategyID | INT64 | false | FK, unique ID of strategy that owns this rule group. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| SegmentID | INT64 | false | FK, unique ID of the segment with which this rule group is associated. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| DisplayOrder | INT32 | true | Indicates the position in the strategy page where this rule group will be displayed. | |
| CreateDate | DATETIME | true | Date when this rulegroup was first created. | |
| CreateBy | INT32 | true | Platform ID of the user who first created this rulegroup. Must be a valid userId in the Platform database. | |
| UpdateDate | DATETIME | true | Date when this rulegroup was last modified. | |
| UpdateBy | INT32 | true | Platform ID of the user who last modified this rulegroup. Must be a valid userId in the Platform database. | |
| LearningMode | INT32 | true | Indicates the learning mode for this rule group (that is, use marketer score or learning score to rank offers). Valid values are 1, 2, or 3. | |
| LearningModelID | INT64 | true | If LearningMode is set to use learning score, then this indicates the ID of the learning model to use. |
UACI_DepFlowchart
Contains all the deployed flowchart objects. Records get added after each interactive channel (IC) deployment. This table is important for subsequent deployments of an IC. If a user has not made changes to the flowchart, the deployment action refers to this table to deploy the same flowchart that was deployed previously.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DeploymentID | INT64 | false | FK, unique ID of deployment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| FlowchartID | INT64 | false | FK, unique ID of the flowchart. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| FlowchartName | VARCHAR | 64 | true | The name of the flowchart. May contain any text characters, minus standard disallowed special name characters. |
| AudienceLevel | VARCHAR | 64 | true | The audience level of the flowchart. May contain any text characters, minus standard disallowed special name characters. |
| SessionID | INT64 | true | FK, the unique ID of the Session object that contains the flowchart. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| SessionName | VARCHAR | 64 | true | The name of the Session object that contains the flowchart. May contain any text characters, minus standard disallowed special name characters. |
| RequestUser | INT32 | true | Platform ID of the user who issued the deployment. Must be a valid userId in the Platform database. | |
| RequestUserName | VARCHAR | 64 | true | Name of user who issued the deployment. Must be a valid userId in the Platform database. |
| RequestTime | DATETIME | true | Timestamp of when the deployment took place. | |
| DeployTypeID | INT32 | true | Type of deployment (such as Add, Update, Remove). Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| SerializedObject | IMAGE | true | A Java serialized object of the flowchart. Must be a binary representation of a Strategy object. |
UACI_DepStratTab
Contains all of the deployed strategy objects. Records get added after each interactive channel (IC) deployment. This table is important for subsequent deployments of an IC. If a user has not made changes to the strategy, the deployment action refers to this table to deploy the same strategy that was deployed before.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| StrategyID | INT64 | false | FK, unique ID of the strategy. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| DeploymentID | INT64 | false | FK, unique ID of a deployment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| StrategyName | VARCHAR | 64 | true | Name of the Strategy object. May be any text characters, minus standard disallowed special name characters. |
| CampaignID | INT64 | true | FK, unique ID of campaign that contains the strategy. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CampaignName | VARCHAR | 64 | true | Name of the campaign that contains the strategy. May contain any text characters, minus standard disallowed special name characters. |
| RequestUser | INT32 | true | Platform ID of the user who issued the deployment. Must be a valid userId in the Platform database. | |
| RequestUserName | VARCHAR | 64 | true | Platform name of the user who issued the deployment. May contain any text characters, minus standard disallowed special name characters. |
| RequestTime | DATETIME | true | Timestamp of when the deployment took place. | |
| DeployTypeID | INT32 | true | Type of deployment (such as Add, Update, Remove). | |
| SerializedObject | IMAGE | true | A Java serialized object of the strategy. Must be a binary representation of strategy object. |
UACI_TrmtRuleInv
Contains all the treatment rules that have been deployed. Records get added after each interactive channel (IC) deployment.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| TreatmentRuleID | INT64 | false | PK, unique ID of the TreatmentRule. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| DeploymentID | INT64 | false | FK, unique ID of the deployment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICID | INT64 | false | FK, unique ID of the interactive channel. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICName | VARCHAR | 64 | false | Name of the interactive channel. May be any text characters, minus standard disallowed special name characters. |
| CellID | INT64 | false | FK, unique ID of the cell. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CellName | VARCHAR | 64 | false | The name of the cell. May be any text characters, minus standard disallowed special name characters. |
| ZoneID | INT64 | false | FK, unique ID of the zone. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ZoneName | VARCHAR | 64 | true | Name of the zone. May be any text characters, minus standard disallowed special name characters. |
| StrategyID | INT64 | false | FK, unique ID of the strategy. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| StrategyName | VARCHAR | 64 | false | Name of the strategy object. May be any text characters, minus standard disallowed special name characters. |
| OfferID | INT64 | false | FK, unique ID of the offer. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| OfferName | VARCHAR | 130 | false | Name of the offer. May be any text characters, minus standard disallowed special name characters. |
| CampaignID | INT64 | false | FK, unique ID of the campaign that contains the strategy. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| CampaignName | VARCHAR | 64 | false | Name of the campaign that contains the strategy. May be any text characters, minus standard disallowed special name characters. |
| CampaignCode | VARCHAR | 64 | true | Code of the campaign that contains the strategy. May be any text characters, minus standard disallowed special name characters. |
| SegmentID | INT64 | true | FK, unique ID of the segment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| SegmentName | VARCHAR | 64 | true | The name of the segment. May be any text characters, minus standard disallowed special name characters. |
| MarketWeight | INT32 | false | The value of the Marketing Score slider, from 1 to 100. | |
| LastUpdate | DATETIME | true | The timestamp of when the deployment occurred. | |
| Predicate | VARCHAR | 4000 | true | The predicate expression, if any, for the rule. May be any text characters, minus standard disallowed special name characters. |
| EnableStateID | INT32 | true | Advanced Rule options mode. Values can be 1='This is disabled', 2='Use Expression as a column only', or 3='Use Predicate only'). |
UACI_DepVersion
This table stores versioned deployment object automatically gererated from deployments.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DepVersionID | INT64 | false | PK, unique ID of the deployment versioned object. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICID | INT64 | true | FK, unique ID of the interactive channel (IC). Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICName | VARCHAR | 64 | true | This is the same interactive channel name at the time of deployment. |
| VersionNumber | INT32 | true | This is a sequence number automatically generated by the system for a given IC. | |
| VersionName | VARCHAR | 128 | true | This is the version name user enters in the UI. It is partially generated based on ICName. May be any text characters, minus standard disallowed special name characters. |
| DeploymentData | IMAGE | true | Blob that contains a Java serialized version of the deployment object. | |
| CreateDate | DATETIME | true | Date that this event was first created. | |
| CreateBy | INT32 | true | Platform name of the user who created this event. May contain any text characters, minus standard disallowed special name characters. |
UACI_DeployOpType
A type table that contains each enumeration of a deployment operation.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DeployOpTypeID | INT32 | false | PK, unique ID of the deployment state. Valid values are:
|
|
| Description | VARCHAR | 512 | true | Description of the deployment state. Values include seed data as above, added through SQL scripts. |
UACI_Deployment
Contains the deployment information including the status of each deployment.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DeploymentID | INT64 | false | PK, unique ID of the deployment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICID | INT64 | true | fk, unique ID of the interactive channel (IC). | |
| DeploymentStatusID | INT32 | true | State of the deployment, containing one of the following values:
|
|
| StatusDetail | VARCHAR | 4000 | true | A status that is XML based. The XML contains a status code, a list of error codes, and their respective parameters. |
| DeployTypeID | INT32 | true | Specifies the type of deployment (for example, add, update, and undeploy). Values include:
|
|
| StartTime | DATETIME | true | Timestamp of when the deployment began. | |
| EndTime | DATETIME | true | Timestamp of when the deployment ended. | |
| IsProduction | INT32 | true | Flag indicating whether this deployment was targed to a production server group. | |
| ServerGroupName | VARCHAR | 512 | true | The name of the server group to which this deployment was sent. |
| RequestUser | INT32 | true | Platform ID of the user who issued the deployment. Must be a valid userId in the Platform database. | |
| RequestUserName | VARCHAR | 64 | true | Platform name of the user who issued the deployment. Must be a valid userName in the Platform database. |
| Description | VARCHAR | 512 | true | Deployment description entered in the UI during deploy/undeploy/redeploy/global deploy operations. |
| DepVersionID | INT64 | true | This is the FK to the UACI_DepVersion.DepVersionID. | |
| RemoteID | VARCHAR | 64 | true | For an interactive channel deployment with an advanced event pattern, this is the corresponding Opportunity Detection deployment ID. |
| DeployOpTypeID | INT32 | true | Name of user who issued the deployment. Values include:
|
UACI_DepStratQueue
This is a staging table that holds Strategy objects that are marked for deployment. When a strategy is marked for deployment, a record is inserted. When the IC is deployed, the record is removed from this table.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| StrategyID | INT64 | false | PK, unique ID of the strategy. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| RequestUser | INT32 | true | Platform ID of the user who markeed this strategy for deployment. Must be a valid userId in the Platform database. | |
| RequestTime | DATETIME | true | Timestamp when this strategy was marked for deployment. | |
| DeployTypeID | INT32 | true | FK, indicates the type of deployment (removal, update, add). Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
UACI_DepFlowQueue
This is a staging table that holds Interactive Flowchart objects that are marked for deployment. When a flowchart is marked for deployment, a record is inserted. When the interactive channel (IC) is deployed, the record is removed from this table.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| FlowchartID | INT64 | false | PK, unique ID of flowchart. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| RequestUser | INT32 | true | Platform ID of the user who markeed this flowchart for deployment. Must be a valid userId in the Platform database. | |
| RequestTime | DATETIME | true | Timestamp when this flowchart was marked for deployment. | |
| DeployTypeID | INT32 | true | FK, unique ID of deployType (add, update,undeploy). Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
UACI_DeployType
A type table that contains each enumeration of a deployment type (such as add, remove, update).
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DeployTypeID | INT32 | false | PK, unique ID of deployType. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Description | VARCHAR | 512 | true | Description of deployType. Values include 1=NOOP, 2=Add, 3=Update, 4=Remove. |
UACI_Action
This table contains the Interact system-defined action type information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ActionID | INT32 | false | PK, unique ID of action type. | |
| Name | VARCHAR | 64 | true | Name of action. |
| Description | VARCHAR | 512 | true | Description of action. |
UACI_Gateway
This table contains the information of the Gateway and the field mappings between the Interact and Endpoint applications.
| Field | Type | Length | Null? | Description |
| GatewayID | INT64 | false | PK, ID of the Gateway. | |
| Name | VARCHAR | 64 | false | Name of the Gateway. |
| Description | VARCHAR | 512 | true | Description of the Gateway. |
| Priority | INT64 | false | Priority of the Gateway. | |
| GatewayType | INT64 | false |
Type of the Gateway.
|
|
| EndpointID | VARCHAR | 64 | true | Unique ID of Endpoint |
| AudienceLevel | VARCHAR | 64 | false | Audience Level |
| DefaultCellID | INT64 | true | Cell ID | |
| NoOfMessages | INT64 | true | Number of messages/Offers to be sent | |
| EffectiveDate | INT64 | true | Effective Date | |
| ExpirationDate | INT64 | true | Expiration Date | |
| EventMapping | VARCHAR(max) | 4000 | true | Event Mappings |
| FieldMapping | VARCHAR(max) | 4000 | true | Field Mappings |
| ICID | INT64 | false | ICID | |
| CreateDate | DATETIME | true | CreateDate | |
| CreateBy | INT64 | true | CreateBy | |
| UpdateDate | DATETIME | true | UpdateDate | |
| UpdateBy | INT64 | true | UpdateBy | |
| isDeployed | INT64 | true | Indicated whether the gateway is deployed. | |
| ChannelID | INT64 | true | Selected channel preference ID. | |
| GlobalPrefID | INT64 | true | Selected global preference ID. | |
| PrefConfig | INT | false | 1 = Discard the message and log. 2 = Still send the message. 3 = no integration (default value) |
|
| useConsent | INT | false | Default value = 0 |
UACI_GatewayType
This table contains the information of the different Gateway types and and their ID.
| Field | Type | Length | Null? | Description |
| GatewayID | INT64 | false |
PK, Gateway Type ID
|
|
| Name | VARCHAR | 64 | false | Gateway Type |
UACI_EventAction
Contains actions defined for events or event patterns.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventActionID | INT64 | false | PK, unique ID of each event action. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| EventID | INT64 | false | FK, uaciunique ID of an Action Type defined in UACI_Action table | |
| ActionID | INT32 | false | FK, unique ID of the Action. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ActionValue | INT32 | false | A flag that indicates whether or not the action has been enabled for the corresponding event. A non-zero and non-null value indicates enabled. | |
| IsAsync | INT32 | false | A flag that indicates whether action has to be executed asynchronously. | |
| ExecutionOrder | INT32 | false | A number indicating the order in which this action will be executed. Values include 0, 1, ... n. | |
| Details | CLOB | true | The information of the eligibility condition, offer selection method, and outbound channel in the format of a JSON string. | |
| WaitMode | INT | false | It has four possible modes.
|
|
| WaitDuration | BIGINT | false | Wait time in seconds to check pattern state . It is only applicable to Event Patterns. | |
| Delay | VARCHAR | false | The information related to the delay of invoking this action from the time it is determined to be invoked in the format of JSON string. |
UACI_EventActionCondition
A table containing name value pairs that should be matched in the incoming event before executing the action.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventActionID | INT64 | false | PK, unique ID of each event action. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ParamName | VARCHAR | 64 | false | Name part of the name-value pair (part of pk). May be any text characters, minus standard disallowed special name characters. |
| ParamValue | VARCHAR | 255 | false | Value part of the name-value pair. May be any text characters, minus standard disallowed special name characters. |
UACI_EventActionExpr
A table containing name value pairs that should be matched in the incoming event before executing the action.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventActionID | INT64 | false | PK, unique ID of each event action. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| AudienceLevel | VARCHAR | 64 | true | Audience level from which fields are picked to be used in expression. Must be a valid audience level defined in the system. |
| Expression | VARCHAR | 1024 | true | Expression to be triggered. May be any text characters. |
| FieldName | VARCHAR | 64 | true | Optional field name to assign the result value of expression. May be any text characters, minus standard disallowed special name characters. |
UACI_EventActionInfr
A table containing inferred events to be generated when this event occurs.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventActionID | INT64 | false | PK, unique ID of each event action. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| InferredEventID | INT64 | false | FK to the EventID. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
UACI_EventPatternTest
A table containing test values for event pattern states within a flowchart.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| FlowchartID | INT64 | false | PK, unique ID of interactive flowchart. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| EventID | INT64 | false | PK, unique ID of event pattern for which pattern state test value needs to be specified. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| TestValue | INT32 | true | Test value of the pattern state. Values include:
|
|
| CreateDate | DATETIME | false | Data when this record was first inserted. | |
| CreateBy | INT32 | false | Platform ID of the user who first inserted this record. Must be a valid userId in the Platform database. | |
| UpdateDate | DATETIME | false | Same as CreateDate. | |
| UpdateBy | INT32 | false | Same as CreateBy. |
UACI_EventPatternItem
A table containing events used in the pattern definition.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ItemID | BIGINT | false | A unique identifier for each record in this table. | |
| EventID | INT64 | false | PK, unique ID of the event pattern. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ItemEventID | INT64 | false | PK, unique ID of the event. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ItemValue | INT32 | false | Contains score value for weighted patterns or occurrences of the event for counter pattern. | |
| ItemType | INT | false | Determines whether this item behaves as a positive or negative event to the enclosing pattern. | |
| EffectiveDuration | BIGINT | true |
Effective duration of a suspending event that makes Pattern state evaluation to pause state. When the duration ends, the pattern resumes as normal. It is applicable to suspending events of a Pattern. |
UACI_EvtPtnltmDep
A table containing event dependency information.
| Field | Type | Null? | Description |
|---|---|---|---|
| ID | INT64 | false | A unique identifier for each record in this table. |
| PatternItemID | INT64 | false |
The ID referencing UACI_EventPatternItem.ItemID of the depending event. |
| DependedItemID | INT64 | false | The ID referencing UACI_EventPatternItem. ItemID of the depended event. |
| MinTimeGap | INT64 | true |
The minimum time in milliseconds for which a depending event has to occur after its depended event occurred so that the depending event can be counted. |
| MaxTimeGap | INT64 | true |
The maximum time in milliseconds for which a depending event has to occur after its depended event occurred so that the depending event can be counted. |
UACI_EventPatternItemCondition
A table containing condition information that make an event eligible to a Pattern.
But when event macros (offerContacted, offerAccepted, or offerRejected, offerContactedInCategory, offerAcceptedInCategory, or offerRejectedInCategory) is added to a pattern, name or value pair of offer attribute for the macro is stored in this table with the AttributeName, StringValue, NumberValue or DateValue, depending on the data type.
| Fields | Type | Length | Null? | Description |
|---|---|---|---|---|
| ItemConditionID | INT64 | false | A unique identifier for records in this table. | |
| ItemID | BIGINT | false | The ID referencing UACI_EventPatternItem. ItemID of the event. |
|
| AttributeName | VARCHAR | 100 | false | Attribute name for offer |
| Comparator | VARCHAR | 20 | false | For expression, default is '='. |
| StringValue | VARCHAR | 200 | true | The expected value used for comparing to the offer attribute. |
| NumberValue | INT32 | true | The expected value used for comparing to the offer attribute | |
| DatetimeValue | DateTime | true | The expected value used for comparing to the offer attribute. |
UACI_Event
This table contains the event information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventID | INT64 | false | PK, unique ID of event. | |
| Name | VARCHAR | 64 | false | Name of event. |
| Description | VARCHAR | 512 | true | Description of the event. |
| CategoryID | INT64 | false | FK, unique ID of category, which is similar to a folder. | |
| EventTypeID | INT32 | false | FK, unique ID of eventType; tells which system event this is or if it is a userdefined event. | |
| CreateDate | DATETIME | true | Date that this event was first created. | |
| CreateBy | INT32 | true | Unica ID of user who created the event. | |
| UpdateDate | DATETIME | true | Date that this event was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this event. |
UACI_EventPattern
A table containing additional information about event patterns.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventID | INT64 | false | PK, unique ID of event pattern. | |
| PatternType | INT32 | false | Type of the pattern. | |
| IsEnabled | INT32 | false | A flag that indicates whether pattern is enabled or not. | |
| IsAsync | INT32 | false | A flag that indicates whether pattern has to be evaluated asynchronously. | |
| StartDate | DATETIME | true | The effective date of the pattern. | |
| EndDate | DATETIME | true | The end date of the pattern. | |
| ResetDuration | INT64 | true | After pattern state becomes true, this is the time in milliseconds the pattern state remains true after that. | |
| MatchTotal | INT32 | true | Total score in the case of weighted counter pattern. | |
| TimeDuration | INT64 | true | For an advanced pattern used with Opportunity Detection, this column has time pattern time duration. |
UACI_EventType
Type table containing EventTypes. Each record is an enumeration of the type of events understood by the system. (eg. StartSession, GetOffers, UserDefined)
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventTypeID | INT32 | false | PK, unique ID of eventType. | |
| Name | VARCHAR | 64 | false | Name of eventType. |
| IsSystemDefined | INT32 | false | Indicates whether or not this eventtype is system defined (if 1) or user defined (if 0). |
UACI_IntFlowchart
Contains the Interactive Flowchart information - this table is really an extention of UA_Flowchart.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| FlowchartID | INT64 | false | PK, unique ID of flowchart. | |
| ICID | INT64 | false | FK, unique ID of Interact Channel. | |
| AudienceLevel | VARCHAR | 64 | false | The audience level of the flowchart. |
| LastProdDepTime | DATETIME | true | Last time this flowchart was deployed to a production server group. | |
| RunEnable | INT32 | false | Indicates whether or not this flowchart is currently deployed or about to be deployed. 0 is not deployed. 1 is deployed. | |
| DeleteLock | INT32 | false | Indicates whether or not this flowchart is deletable or not. 0 is deletable. 1 is not deletable. | |
| EditLock | INT32 | false | Indicates whether or not this flowchart may be edited. 0 is editable. 1 is not editable. | |
| FlowchartXML | TEXT | true | The entire definition of the flowchart in XML form. | |
| CreateDate | DATETIME | true | Date that this flowchart was first created. | |
| CreateBy | INT32 | true | Unica ID of the user who first created this flowchart. | |
| UpdateDate | DATETIME | true | Date that this flowchart was last modified. | |
| UpdateBy | INT32 | true | Unica ID of the user who last modified this flowchart. |
UACI_ICToSvrGroup
Contains a mapping of what server groups are linked to the ICs.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ICID | INT64 | false | FK, unique ID of Interact Channel. | |
| ServerGroupName | VARCHAR | 512 | true | Name of server group associated to IC. |
| IsProduction | INT32 | true | Flag indicating whether or not this server group will server as a production server group for the corresponding IC. |
UACI_Category
Contains the Category information. A category acts like a folder or container of events.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| CategoryID | INT64 | false | PK, unique ID of category. | |
| Name | VARCHAR | 64 | false | Name of category. |
| Description | VARCHAR | 512 | true | Description of category. |
| ICID | INT64 | false | FK, unique ID of interact channel. | |
| IsSystemDefined | INT32 | true | Indicates whether or not this category contains the system defined events. | |
| CreateDate | DATETIME | true | Date that this category was first created. | |
| CreateBy | INT32 | true | Unica ID of user who first created the category. | |
| UpdateDate | DATETIME | true | Date that this category was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this category. |
UACI_IntPoint
Contains the interaction point information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| IPID | INT64 | false | PK, unique ID of Interaction Point. | |
| Name | VARCHAR | 64 | false | Name of interaction point |
| Description | VARCHAR | 512 | true | Description of interaction point. |
| DefaultString | VARCHAR | 1024 | false | Contains the default content string which is served to the client facing system on getOffers calls that do not yield any offers. |
| ZoneID | INT64 | false | FK, unique ID of zone that this IP belongs to. | |
| CreateDate | DATETIME | true | Date that this IP was first created. | |
| CreateBy | INT32 | true | Unica ID of user who first created this IP. | |
| UpdateDate | DATETIME | true | Date that this IP was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this IP. |
UACI_Zone
Contains the Zone information. A zone servers as a container of Interaction Points.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ZoneID | INT64 | false | PK, unique ID of zone. | |
| Name | VARCHAR | 64 | false | Name of zone. |
| Description | VARCHAR | 512 | true | Description of zone. |
| ICID | INT64 | false | FK, unique ID of Interact Channel. | |
| CreateDate | DATETIME | true | Date when this zone was first created. | |
| CreateBy | INT32 | true | Unica ID of user who first created this zone. | |
| UpdateDate | DATETIME | true | Date when this zone was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this zone. | |
| percentRandom | FLOAT | true | Percentage of time to simply randomize the rankings vs using the score. | |
| RuleGroupResolutionType | INT32 | true | Indicates how to resolve ranking offers across rule groups of conflicting learning mode. | |
| LearningMode | INT32 | true | Indicates the learning mode for this rule group (ie., use marketer score or learning score to rank offers). | |
| LearningModelID | INT64 | true | If learningmode is to use learning score, then this indicates the id of the learning model to use. |
UACI_Strategy
Contains the Strategy information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| StrategyID | INT64 | false | PK, unique ID of strategy. | |
| Name | VARCHAR | 64 | false | Name of Strategy object. |
| Description | VARCHAR | 512 | true | Description of strategy. |
| CampaignID | INT64 | true | CampaignID can be null. FK, unique ID of campaign that contains the strategy. |
|
| ICID | INT64 | false | FK, unique ID of Interact Channel. | |
| LastProdDepTime | DATETIME | true | Last time this strategy was deployed to a production server group. | |
| RunEnable | INT32 | false | Indicates whether or not this strategy is currently deployed or about to be deployed. 0 is not deployed. 1 is deployed. | |
| DeleteLock | INT32 | false | Indicates whether or not this strategy may be deleted. 0 is deletable. 1 is not deleteable. | |
| EditLock | INT32 | false | Indicates whether or not this strategy may be edited. 0 is editable. 1 is not editable. | |
| CreateDate | DATETIME | true | Date that this strategy is first created. | |
| CreateBy | INT32 | true | Unica ID of user who first created this strategy. | |
| UpdateDate | DATETIME | true | Date that this strategy was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this strategy. |
UACI_IntChannel
Contains the Interact Channel information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ICID | INT64 | false | PK, unique ID of Interact channel. | |
| Name | VARCHAR | 64 | false | Name of Interact channel. |
| Description | VARCHAR | 512 | true | Description of Interact channel. |
| OfferThreshold | INT32 | false | Represents the maximum number of times the same offer can be served to the client facing system within the same session. | |
| LastProdDepTime | DATETIME | true | Timestamp of when this IC was deployed to a production server group. | |
| RunEnable | INT32 | false | Indicates whether or not this IC has been deployed. 0 is not deployed. 1 is deployed. | |
| DeleteLock | INT32 | false | Indicates whether or not this IC is deletable. 0 is deletable. 1 is not deleteable. | |
| EditLock | INT32 | false | Indicates whether or not this ic is editable. 0 is editable. 1 is not editable. | |
| CreateDate | DATETIME | true | Date that this IC was first created. | |
| CreateBy | INT32 | true | Unica ID of user who first created this IC. | |
| UpdateDate | DATETIME | true | Date that this IC was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this IC. | |
| PolicyID | INT32 | true | Security policy ID for the object, which determines which ASM users are allowed to access this object. The security policy for the object is automatically set to the security policy of the folder in which the object resides if the object is created in a folder (cannot be changed by the user). The user can change the security policy of the object by moving the object to a different folder with a different security policy (user requires "move" permissions for that object in both the source and destination security policies). | |
| ACLID | INT32 | true | It is directly settable by the user only when the object is created in the top-level root folder for that object type (security policies in which the user has a role are displayed as choices). | |
| IsActive | INT32 | false | Original intention for this column is to use it as an indicator whether or not this IC is active. Currently, this column is not used anywhere. | |
| percentRandom | FLOAT | true | Percentage of time to simply randomize the rankings vs using the score. | |
| RuleGroupResolutionType | INT32 | true | Indicates how to resolve ranking offers across rule groups of conflicting learning mode. | |
| LearningMode | INT32 | true | Indicates the learning mode for this rule group (ie., use marketer score or learning score to rank offers). | |
| LearningModelID | INT64 | true | If learningmode is to use learning score, then this indicates the id of the learning model to use. | |
| ParentICID | INT64 | true | The ID of the parent Interact Channel. |
UACI_DeploymentStatus
A type table that contains each enumeration of a deployment state.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DeploymentStatusID | INT32 | false | PK, unique ID of deployment state. | |
| Description | VARCHAR | 512 | true | Description of the deployment state. |
UACI_SYSTAB_Ver
Contains the version information of the current Interact Design time System table installation.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| VersionID | INT64 | false | PK, unique ID of version table. | |
| VersionNumber | VARCHAR | 50 | false | Full version (major, minor, point, and build). |
| Parameters | VARCHAR | 255 | true | Optional parameters - this is currently not utilized and is here for future use. |
| CreateDate | DATETIME | false | Date when the interact design time system tables was installed. |
UACI_Constraint
Table that contains definition of Constraints.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ConstraintID | INT64 | false | Unique ID of constraint. | |
| OfferFamilyIndicator | INT32 | false | Indicates whether or not the offers for this constraint are coming from an offerList or an offer folder. | |
| OfferFolderID | INT64 | true | ID of offer folder if the offerFamilyIndicator is set as by folder. | |
| OfferListID | INT64 | true | ID of offer List if the offerfamilyindicator is set as by offer list. | |
| icID | INT64 | false | ID of IC that contains this constraints. | |
| isEnabled | INT32 | false | Flag that determines if this constraint is active. Only enabled constraints are deployed to the IC. | |
| name | VARCHAR | 64 | true | Name of Constraint object. |
| description | VARCHAR | 512 | true | Description of constraint object. |
| maxOffers | INT32 | true | Maximum number of times that offers associated to this constraint shall be served. | |
| startTime | DATETIME | true | The time at which the constraint shall take effect - offers are constrainted until the start time has been reached. | |
| endTime | DATETIME | true | Time at which the constraint shall stop serving offers. | |
| distInterval | INT32 | true | Indicates the interval period for which the system will enforce a sub max, i.e., distribute no more than 100 offers per HOUR, o r per DAY, or Per 7 DAYS, etc. | |
| maxPerInterval | INT32 | true | The max number of offers to serve per distInterval. | |
| allocationSize | INT32 | true | Currently, this field is not utilized. System relies on a configuration setting for this. The purpose of the field was to indicate how many offers the interact runtime instance would allocate - this way the runtime instance doesn't have to always go back to the database for every distribution of the offer. The smaller the allocation, the more db hits. | |
| CreateDate | DATETIME | true | Date that the constraint object was created. | |
| CreateBy | INT32 | true | User ID that created the constraint object. | |
| UpdateDate | DATETIME | true | Last update time of the constraint object. | |
| UpdateBy | INT32 | true | User ID of user who last updated the constraint object. |
UACI_DistInterval
Table that enumerates the distInterval field of the UACI_Constraint table, indicating at what level to enforce a sub max: by hour, by day, by 7 days, by 30 days, by month.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| DistInterval | INT32 | false | PK, unique ID of distribution interval. | |
| Description | VARCHAR | 512 | true | Description. |
UACI_OfferFamily
Table that enumerates the offerFamily field of the UACI_Constraint table, indicating how we allocate the family of offers associated to a constraint, either by folder or by offer list.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| OfferFamilyIndicator | INT32 | false | PK, unique ID of offerFamily type. | |
| Description | VARCHAR | 512 | true | Description. |
UACI_LearningModel
Table that contains the learning model object.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| LearningModelID | INT64 | false | PK, unique ID of learning model. | |
| Name | VARCHAR | 64 | false | Name. |
| Description | VARCHAR | 512 | true | Description. |
| icID | INT64 | false | ID of IC that contains the learning model. | |
| isEnabled | INT32 | false | Flag that indicates whether or not learning model is active. | |
| CreateDate | DATETIME | true | Creation date of this learning model. | |
| CreateBy | INT32 | true | User ID that created the learning model object. | |
| UpdateDate | DATETIME | true | Last update time of the learning model object. | |
| UpdateBy | INT32 | true | User ID that last updated the learning model object. |
UACI_LModelAttr
Table that contains the attributes for each learning model object.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| LearningModelAttrID | INT64 | false | PK, unique ID of learningmodel attribute. | |
| LearningModelID | INT64 | false | ID of learning model that contains this attribute. | |
| Name | VARCHAR | 64 | false | Name of attribute which this record represents. |
UACI_LearningMode
Table that enumerates the learningMode: 1) learningmode not set 2) use marketer score 3) use learning score.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| LearningMode | INT32 | false | Indicates whether engine should use the learning score or the marketer score in ranking offers. | |
| Description | VARCHAR | 512 | true | Description. |
UACI_RGResolution
Table that enumerates the options for resolving rulegroup conflicts wrt learning.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| RuleGroupResolutionType | INT32 | false | Indicates how to resolve ranking offers across rule groups of conflicting learning mode. | |
| Description | VARCHAR | 512 | true | Descrption. |
UACI_OfferTblType
Table that enumerates the type of table driven features supported by the InteractList processbox.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| offerTblTypeID | INT32 | false | Indicates the type of table driven feature that is defined. | |
| name | VARCHAR | 64 | true | Name of the table driven feature (white list, black list, global offers, and offersBySQL). |
| description | VARCHAR | 512 | true | Description. |
UACI_OffersByTbl
Table that contains the config info for WhiteList, blacklist and global offers.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| icID | INT64 | false | IC that will have access to the this table driven offer mapping feature. | |
| offerTblTypeID | INT32 | false | Indicates which table driven feature (white list, black list, global offers). | |
| audienceLevel | VARCHAR | 64 | false | Audience level that this table driven feature represents. |
| physicalTable | VARCHAR | 64 | false | Name of physical table containing the offerCodes. |
| isEnabled | INT32 | false | Indicates whether or not this offersByTbl definition is active. | |
| lastRunTime | DATETIME | false | Indicates the last time that the campaign batch flowchart containing the Interact List process box was run. | |
| lastRunBy | INT32 | false | User ID of who ran the campaign batch flowchart containing the Interact List process box that populates this record. | |
| sourceFlowchartID | INT64 | false | ID of the Campaign flowchart that contains the Interact List process box that populates this record. |
UACI_OffersBySQL
Table that contains config info for OffersBySQL definitions.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| icID | INT64 | false | Globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| offerSQLName | VARCHAR | 64 | false | May be any text characters, minus standard disallowed special name characters. |
| offerSQLTemplate | VARCHAR | 4000 | true | May be any text characters, minus standard disallowed special name characters. |
| physicalTable | VARCHAR | 64 | true | May be any text characters, minus standard disallowed special name characters. |
| isEnabled | INT32 | false | Flag indicating whether or not offersBySQL is enabled. Values may be one of:
|
|
| isDefault | INT32 | false | Flag indicating whether or not offersBySQL is the default. Values may be one of:
|
|
| lastRunTime | DATETIME | false | The date and time on which offersBySQL was last run. | |
| lastRunBy | INT32 | false | Platform ID of the user who last ran offersBySQL. Must be a valid userId in the Platform database. | |
| sourceFlowchartID | INT64 | false | ID of the Campaign flowchart that contains the Interact List process box that populates this record. |
UACI_RuleOfferAttrOverride
Table that overrides offer attribute values inherited from offer templates and definitions. Override values are specified by editing offer attributes for individual rules within the Interactive Strategy. Overrides defined in this table are only used during offer personalization; they are ignored when calculating offer inclusion.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| RuleID | INT64 | false | Unique ID of the Rule. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameters values for generated values. | |
| OfferAttributeID | INT64 | false | The ID of the offer attribute this rule overrides. | |
| Expression | VARCHAR | 4000 | true | The macro expression overrides the inherited attribute values during offer personalization. This attribute value override is ignored when calculating offer inclusion. |
UACI_EventPatternReset
Contains information for the event pattern reset.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ResetID | INT64 | false | PK. ID of an event pattern reset. | |
| EventID | INT64 | false | FK, unique ID of Event. | |
| ResetType | INT | false | Type of resets.
|
|
| Criteria | CLOB | true | JSON data to define reset conditions |
UACI_LearningAttrBinDef
Contains definition of bins for learning attributes .
| Field | Type | Length | Null? | Description |
| BinDefID | BIGINT | false |
pk, Unique ID of a bin definition . Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
|
| Description | VARCHAR | 512 | true | Description of bin def . May be any text characters, minus standard disallowed special name characters. |
| AttributeName | VARCHAR | 512 | false | Name of the attribute. May be any text characters, minus standard disallowed special name characters. |
| AttrbuteDataType | INT | false | Datatype of the attribute | |
| Bins | VARCHAR | 2048 | true | JSON format of list of bins defined for this attribute values |
| CreateDate | TIMESTAMP | false | Timestamp when the record is created | |
| CreateBy | BIGINT | false | Platform ID of the user who created this bin. Must be a valid userid in the Platform database | |
| UpdateDate | TIMESTAMP | false | Date of when this bin was last modified. | |
| UpdateBy | BIGINT | false | Platform ID of the user who last modified this bin. Must be a valid userid in the Platform database |
UACI_LearningAttrBinDefInIC
This is a relationship table to associate a Bin definition with an IC and AudienceLevel because a Bin definition can exist in multiple ICs and multiple profile tables.
| Field | Type | Length | Null? | Description |
| BinDefID | BIGINT | false | Pk .Unique ID of a bin definition . Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| ICID | BIGINT | true |
FK to UACI_IntChannel . unique ID of the interactive channel. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. |
|
| AudienceLevel | VARCHAR | 64 | true | Audience Level of the attribute |
UACI_SimulationHistory
This table contain summary of each simulation Runs.
| Column Name | Data Type | Allow Null? | Key type | Description |
| RunID | bigint | no | primary | ID of a simulation run |
| ScenarioID | bigint | no | foreign key to UACI_SimulationScenario | ID of scenario definition record |
| CreateTime | timestamp | no | The date time this record was created | |
| CreatedBy | bigint | no | The ID of the user who created this record | |
| RunBy | bigint | yes | The ID of the user who start this simulation run | |
| StartDateTime | timestamp | yes | Start datetime of run | |
| EndDateTime | timestamp | yes | End datetime of run | |
| RunBy | int | no | User id who runs | |
| Status | int | no |
Run status, 0: success, 1: simulation not enable on the server group, 2: error retrieving the simulation information 3: invalid simulation scenario 4: error creating the table for storing simulation results 5: error retrieving the audience information 6: error connecting to the database 7: error persisting the simulation results 8: the specified simulation scenario cannot be found 9: internal processing error 10: error updating UACI_SimulationHistory with the result after simulation completed |
|
| AudienceProcessed | int | yes | Number of audiences processed in this simulation run | |
| Parameters | Varchar | yes | Optional parameters passed to the run time for this specific run | |
| Summary | Varchar | yes | JSON data for general status | |
| JMXStat | Varchar | yes | The JMX stats collected during this simulation run |
UACI_SimulationScenario
This table is used to store Simulation Scenario.
| Column Name | Data Type | Allow Null? | Key type | Description |
| ScenarioID | INT | No | primary | Unique ID of the scenario. |
| ICID | INT | No | Unique ID of the interactive channel. It must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Name | VARCHAR | No | Name of the scenario. | |
| Description | VARCHAR | Yes | Description of the scenario. | |
| ScenarioType | INT | No | Type of scenario, either basic or advanced. | |
| isTemplate | INT | No | Determines if the scenario is a template. | |
| Details | CLOB | Yes | Details of the scenario, a JSON string to specify API calls and API parameters. | |
| CreateDate | DATETIME | Yes | Creation date of the scenario. | |
| CreateBy | INT | Yes | User ID that created the scenario. | |
| UpdateDate | DATETIME | Yes | Last update time of the scenario. | |
| UpdateBy | INT | Yes | User ID that last updated the scenario. | |
| ResultTable | Varchar | no | Database table name for saving simulation results | |
| CheckResult | int | no | Boolean to indicate if previous run results will be checked or not when user fires a run |
UACI_SimResults_< ScenarioId>
These tables will be created only once user runs the coverage simulation scenario and will contain the simulation results for the Coverage scenario.
| Column Name | Data Type | Allow Null? | Key type | Description |
| AudienceID | no | one column for each component | ||
| SegmentID | bigint | yes | Segment ID for the audience | |
| ZoneID | bigint | yes | ZoneID where the offer is displayed | |
| OfferID | bigint | yes | OfferID of returned offer for the audience. |
UACI_SimResults_< ScenarioId >_Attributes
This table contains the attributes selected by the user in the Coverage Scenario definition.
| Column Name | Data Type | Allow Null? | Key type | Description |
| AudienceID | As per profile table column | no | one column for each component | |
| Attributes | varchar | yes | JSON format of selected extra profile attributes |
UACI_RealTimeAttribute
This is a table that the design time system populates at startup time. The table contains attribute data.
| Column Name | Data Type | Allow Null | Length | Description |
| AttributeId | AINT64 | FALSE | oID of a real-time attribute | |
| Description | varchar | TRUE | 512 | JSON format of selected extra profile attributes |
| Name | varchar | FALSE | 512 | Name of the attribute |
| DataData Type | INT32 | FALSE | DataData Type of the attribute | |
| DefaultValueString | VARCHAR | TRUE | 512 | Default value |
| DefaultValueNumeric | FLOAT | TRUE | 512 | Default value |
| DefaultValueDate | DATE | TRUE | Default value | |
| CreateDate | DATETIME | FALSE | Timestamp when the record is created | |
| CreateBy | INT64 | FALSE | User Id who creates the record | |
| UpdateDate | DATETIME | FALSE | Timestamp when the record is created | |
| UpdateBy | INT64 | FALSE | User Id who updates the record |
UACI_RealTimeAttributeUsage
This is a table that the design time system populates at startup time. The table contains attribute usage data.
| Column Name | Data Type | Allow Null | Length | Description |
| AttributeUsageId | INT64 | FALSE | 8 | ID of RealTimeAttributeUsage |
| AttributeId | INT64 | FALSE | 8 | Foreign key to UACI_RealTimeAttribute |
| IcId | INT64 | FALSE | 8 | Foreign key to UACI_IntChannel |
| FlowchartId | INT64 | TRUE | 8 | Foreign key to UACI_Flowchart |
| RuleId | INT64 | TRUE | 8 | Foreign key to UACI_Rule |
| ScenarioId | INT64 | TRUE | 8 | Foreign key to UACI_SimulationScenario |
| LearningModelId | INT64 | TRUE | 8 | Foreign key to UACI_LearningModel |
UACI_SmartRule
This table holds the information about the Smart Rule.
| Field | Type | Length | Null? | Description |
| RuleID | INT64 | false | Primary Key for Rule Table | |
| RuleName | VARCHAR | 64 | false | Rule name |
| StrategyID | INT64 | false | Reference to Strategy Table. Giving info. About UACI_STRATEGY | |
| SegmentID | INT64 | false |
Reference to UA_Segment Table. Giving info on Segment |
|
| CellID | INT64 | false | Reference to UA_TargetCells Table. Giving Info on Segment. | |
| OfferType | INT | 10 | false | The type of offer object referenced by this rule. Valid values are:
|
| SelectionPolicy | VARCHAR | 512 | true | The selected policy for selecting offers from an offer list. It is
applicable only when OfferType=1. Valid values are:
|
| ZoneID | INT64 | true | Zone Id - UACI_Zone Table ZoneId=Null means "All zones" |
|
| OfferID | INT64 | false | Offer Id - UACI_Offer Table | |
| MarketScore | INT64 | false | MarketScore – Default - 0 | |
| Disabled | INT64 | false | Is Rule Disabled | |
| ScorePredicateID | INT64 | true | This is referencing to UACI_Predicate table. | |
| ScorePredicateEnabled | INT64 | false | This is true
false for Score Predicate Enabled. |
|
| EligibilityPredicateID | INT64 | true | This is referencing to UACI_Predicate table. | |
| EligibilityPredicateEnabled | INT64 | false | This is true
false for Eligibility Predicate Enabled |
|
| Priority | INT64 | true | Set this as Integer and use as priority. When its value is null, this rule is always be considered and arbitrated using its score. | |
| MaxScore | INT64 | true | maxScore | |
| SuppressCount | INT64 | true | after how many times offer should suppress | |
| LearningMode | INT64 | true | Reference to UACI_LEARNINGMODE | |
| LearningModelID | INT64 | true | Reference to UACI_LEARNINGMODEL | |
| EffectiveDate | INT64 | true | Effective Date | |
| ExpirationDate | INT64 | true | Expiration Date | |
| CreateBy | INT64 | true | User name who created this | |
| CreateDate | DATETIME | true | Date of rule created | |
| UpdateDate | DATETIME | true | Updated Date | |
| UpdateBy | INT64 | true | Updated By |
UACI_SMARTRULEGROUP
This table holds the information about the Smart Rule groups. Multiple rules can be associated with Smart Rule group.
| Field | Type | Length | Null? | Description |
| RuleGroupID | INT64 | false | Primary Key Rule Group | |
| RuleGroupName | VARCHAR | false | Name of Group | |
| StrategyID | INT64 | falsef | Reference to Strategy Table. | |
| RuleGroupType | INT64 | false | Default is 1, normal group type | |
| Description | VARCHAR | true | Description of group | |
| CreateDate | DATETIME | true | Date when Created. | |
| CreateBy | INT64 | truet | User Id who created. | |
| UpdateDate | DATETIME | true | Update date | |
| UpdateBy | INT64 | true | User Id who updated. |
UACI_SmartRuletoRuleGroup
This table contains the association between Smart Rules and Smart Rule groups.
| Field | Type | Length | Null? | Description |
| RuleId | BigInt | No | Primary Key | Primary Key Rule Table |
| RuleGroupId | BigInt | No | Primary Key | Primary Key for Rule Group Table |
UACI_UserPreference
In new Strategy UI, since there are many rule properties available like Segment, Cell code, Zone, Offer, Offer Code, Offer Attributes, learning model setting etc. This can be personalized to allow users to customize table columns to be displayed based on their use cases and persist their selections in database so that they can see same table data next time when they log in.
| Column Name | Data Type | Allow Null | Key Type | Description |
| UserPreferenceID | bigint | No | Primary Key | |
| UserID | bigint | No | Foreign Key | User id |
| TargetID | bigint | Yes | Id of object this preference for | |
| PreferenceType | int | Yes | 0 for Strategy list, 1 for rule list | |
| Preference | String | Yes | JSON string for user settings |
UACI_ABTest
This table stores the A/B testing data defined for the smart rule. A smart rule can have none or one A/B testing defined.
| Column Name | Data Type | Allow Null | Key Type | Description |
| RuleId | Int64 | no | FK | Reference to SmartRule table |
| Enabled | Int | no | Set AB testing enabled or disabled | |
| EffectiveDate | Int64 | yes | Datetime when ABTest starts, optional | |
| ExpirationDate | Int64 | yes | Datetime when ABTest ends, optional | |
| SelectionMode | Int | no | The list of options to render the offer. |
UACI_ABTestBranch
This table stores the branch data of an A/B testing. An A/B testing can have multiple branches.
| Column Name | Data Type | Allow Null | Key Type | Description |
| BranchId | Int64 | no | PK | Id of branch |
| RuleId | Int64 | no | FK | Reference to SmartRule table |
| BranchName | Varchar(64) | no | Unique name for branch | |
| Enabled | Int | no | Set branch enabled or disabled | |
| IsDefault | Int | no | True if a branch is default | |
| SamplePercent | Float | yes | Percentage of branch | |
| CellId | Int64 | yes | FK | Refer to UA_TargetCell |
| OfferId | Int64 | yes | FK | Refer to UA_Offer table |
| OfferAttributes | Varchar(max) | yes | JSON string to define parametrized offer attributes of the offer |
UACI_DepOfferMappingQueue
This is a staging table that holds FlexOffer objects that are marked for deployment. When a FlexOffer is marked for deployment, a record is inserted. When the IC is deployed, the record is removed from this table.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| OfferMappingID | INT64 | false | PK,unique ID of FlexOffers. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values | |
| RequestUser | INT32 | true | Platform ID of the user who markeed the FlexOffer for deployment. Must be a valid userId in the Platform database. | |
| RequestTime | DATETIME | true | Timestamp when this FlexOffer was marked for deployment | |
| DeployTypeID | INT32 | true | FK, indicates the type of deployment (removal, update, add). Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
UACI_DepOffermappingList
Contains all of the deployed FlexOffer objects. Records get added after each interactive channel (IC) deployment. This table is important for subsequent deployments of an IC. If a user has not made changes to the FlexOffers, the deployment action refers to this table to deploy the same FlexOffers that was deployed before.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| OffermappingID | INT64 | false? | PK, unique ID of FlexOffers. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values | |
| DeploymentID | INT64 | false | PK, unique ID of a deployment. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| OfferMappingName | VARCHAR | 64 | true | Name of the FlexOffers object. May be any text characters, minus standard disallowed special name characters. |
| IcID | INT64 | true | FK, unique ID of interactive channel that contains the FlexOffers. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. parameter values for generated values. | |
| IcName | VARCHAR | 64 | true | Name of the interactive channel that contains the FlexOffers. May contain any text characters, minus standard disallowed special name characters. |
| RequestUser | INT32 | true | Platform ID of the user who issued the deployment. Must be a valid userId in the Platform database. | |
| RequestUserName | VARCHAR | 64 | true | Platform name of the user who issued the deployment. May contain any text characters, minus standard disallowed special name characters. |
| RequestTime | DATETIME | true | Timestamp of when the deployment took place. | |
| DeployTypeID | INT32 | true | Type of deployment (such as Add, Update, Remove). | |
| SerializedObject | IMAGE | true | A Java serialized object of the strategy. Must be a binary representation of FlexOffers object. |
UACI_OfferMappingList
Contains the FlexOffers mapping information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| OfferMappingID | INT64 | false | PK,unique ID of FlexOffers. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values | |
| Name | VARCHAR | 256 | true | Name of FlexOffers object. |
| Description | VARCHAR | 512 | true | Description of FlexOffers |
| PhysicalTableName | VARCHAR | 256 | true | Name of the FlexOffers Rule table. |
| sourceFileName | VARCHAR | 256 | true | Name of the csv file or the existing table from which FlexOffers is created. |
| ICID | INT64 | false | FK, unique ID of Interactive Channel. | |
| LastProdDepTime | DATETIME | true | Last time this FlexOffers was deployed to a production server group. | |
| RunEnable | INT32 | false | Indicates whether or not this FlexOffer is currently deployed or about to be deployed. 0 is not deployed. 1 is deployed. | |
| DeleteLock | INT32 | false | Indicates whether or not this FlexOffer may be deleted. 0 is deletable. 1 is not deletable. | |
| EditLock | INT32 | false | Indicates whether or not this Flexoffer may be edited. 0 is editable. 1 is not editable. | |
| CreateDate | DATETIME | true | Date on which the FlexOffers is first created | |
| CreateBy | INT32 | true | Unica ID of user who first created this FlexOffers. | |
| UpdateDate | DATETIME | true | Date that the FlexOffers was last modified. | |
| UpdateBy | INT32 | true | Unica ID of user who last modified this FlexOffers. | |
| LastRuleUpdateDate | DATETIME | true | Date that the FlexOffers Rule table was last modified. |
UACI_OfferMappingSG
This table contains the information for all FlexOffers and the server groups where the FlexOffers rule tables have been copied.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| OfferMappingID | INT64 | PK,unique ID of FlexOffers. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | ||
| ServerGroupName | VARCHAR | 512 | true | Name of the server group where the FlexOffers rule table has been copied. |
| TableName | VARCHAR | 256 | true | Name of the FlexOffers rule table- |
| LastCopyDate | DATETIME | true | Date that the FlexOffers rule table was last copied to the particular server group. |
UACI_OfferMapping
This is a sample schema of the default FlexOffers rule table.
| Column Name | Data Type | Length | Allow Null? | Description |
|---|---|---|---|---|
| OfferMappingRowID | INT64 | false | PK,unique ID ofFlexOffers Rule.Must be a globallyuniquepositiveinteger within the internalIDLowerLimitandinternalIDUpperLimitconfigurationparameter values forgenerated values | |
| OfferID | INT64 | false | Offer Id -must be a valid value from UA_Offer table | |
| OfferName | Varchar | 130 | true | Name of the Offer from UA_OFFER |
| OfferType | INT | false | Type of the offer. Default = 0. | |
| OfferCode | Varchar | 320 | true | Offer Code |
| CellID | INT64 | true | Reference to UA_TargetCells Table. | |
| CellCode | Varchar | |||
| ZoneID | INT64 | |||
| ZoneName | VARCHAR | 64 | true | Zone Name- UACI_Zonetable |
| EligibilityPredicateEnabled | INT64 | true | Indicates if EligibilityPredicate is enabled or not | |
| EligibilityPredicate | Varchar | 4000 | true | Eligibility Predicate Expression |
| MarketerScore | INT64 | false | Market Score value-Default 0 | |
| ScorePredicateEnabled | INT64 | true |
Indicates if ScorePredicate is enabled or not |
|
| ScorePredicate | Varchar | 4000 | true | Score Predicate Expression |
| SelectionPolicy | Varchar | 512 | true | Selection policy of the offer list. |
| LearningMode | INT64 | true | Reference toUACI_LEARNINGMODE. Can be 1,2 or 3 |
|
| LearningModelId | INT64 | true | Learning Model Id from UACI_LEARNINGMODE | |
| ParameterizedOfferAttribute | varchar | 4000 | true | OfferAttributes in JSON format |
| EffectiveDate | INT64 | true | Rule Effective Date | |
| ExpirationDate | INT64 | true | Rule Expiration Date | |
| EnableState | INT64 | true | Indicates if rule is enables | |
| CreateDate | DATETIME | true | Date of rule creation | |
| CreateBy | INT64 | true | Unica ID of the user whocreated the rule | |
| UpdateDate | DATETIME | true | Last Update Date of Rule | |
| UpdateBy | INT64 | true | Unica ID of the user who last updated the rule |
UACI_OfferMappingFilter
Contains the FlexOffers Filters information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| FilterID | INT64 | false | PK,unique ID of FlexOffers filter. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values. | |
| Name | VARCHAR | 64 | true | Name of the FlexOffer Filter object |
| Description | VARCHAR | 512 | true | Description of filter. |
| FilterDetails | VARCHAR | 2048 | true | Conditions defined in the filter in JSON format. |
| OfferMappingID | INT64 | true | FK, unique FlexOffers ID | |
| IsDefault | INT64 | true | Indicates if filter will be applied by default or not. | |
| CreateDate | DATETIME | true | Date of Filter creation. | |
| CreateBy | INT64 | true | Unica Id of the user who created the filter. | |
| UpdateDate | DATETIME | Last modified date of this filter. | ||
| UpdateBy | INT64 | true | Unica Id of the user who last modified the filter. |
UACI_TriggeredAction
Contains the triggered action information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| EventActionID | BIGINT | false | A foreign key pointing to the UACI_EventAction. It also serves as the primary key in this table. | |
| Name | VARCHAR | 64 | false | Name of the triggered action. |
| ICID | BIGINT | false | A foreign key pointing of UACI_IntChannel | |
| Description | VARCHAR | 512 | true | Description of triggered message entry. |
| EffectiveDate | BIGINT | 2048 | true | |
| ExpirationDate | BIGINT | true | ||
| CreateDate | DATETIME | true | ||
| CreateBy | INT64 | true | Unica Id of the user who created the triggered action | |
| UpdateDate | DATETIME | true | Last modified date of this triggered atction. | |
| UpdateBy | INT64 | true | Unica Id of the user who last modified the triggered action. |
UACI_TABranch
Contains the triggered action branch information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| BranchID | BIGINT | false | This is the primary key of this table. | |
| EventActionID | BIGINT | false | The ID of the triggered message record – a foreign key pointing to the EventActionID in UACI_ TriggeredAction table. | |
| AudienceLevel | VARCHAR | 512 | false | The audience level this branch is applicable to. |
| Eligibility | VARCHAR | 4000 | true | A JSON string that lists all the conditions for this branch. |
| OfferSelection | INT | false | An indicator how offer is selected.
|
|
| ZoneID | BIGINT | true | The ID of the zone when OfferSelection is 1. Foreign key pointing to UACI_Zone | |
| ChannelName | VARCHAR | 64 | false | Name of channel or gateway. |
| ChannelType | VARCHAR | 64 | false | It could be ‘Channel’ or ‘Gateway’. |
| Delay | BIGINT | true | delayvalue | |
| CreateDate | DATETIME | true | ||
| CreateBy | INT64 | true | Unica Id of the user who created the triggered action | |
| UpdateDate | DATETIME | true | Last modified date of this triggered atction. | |
| UpdateBy | INT64 | true | Unica Id of the user who last modified the triggered action. |
UACI_TAOffers
Contains the triggered action branch information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| BranchID | BIGINT | false | The ID of a branch this record is associated to. This is a foreign key point to UACI_TABranch table and also primary key of this table. | |
| OfferID | BIGINT | false | ID of UA_Offer or UA_OfferList table (NOT NULL) (handle the relationship for offerid) | |
| CellID | BIGINT | true | The ID of the target cell when OfferSelection is 2. Foreign key pointing to UA_TargetCells | |
| OfferType | false | 0 for offer and 1 for offer list with default 0 value | ||
| SelectionPolicy | VARCHAR | 512 | true | Selection policy for offer list. |
| EligibilityPredicateEnabled | INT | false | Eligibility Predicate Enabled field with DEFAULT 0 value | |
| EligibilityPredicate | VARCHAR | 4000 | true | Eligibility Predicate expression value. |
| MarketerScore | BIGINT | false | MarketerScore with DEFAULT 50 value. | |
| ScorePredicateEnabled | INT | false | Score Predicate Enabled field with DEFAULT 0 value | |
| ScorePredicate | VARCHAR | 4000 | true | Score Predicate expression value |
| LearningMode | INT | true | ||
| LearningModeID | BIGINT | true | Foreign key of UACI_LearningModel table. | |
| EffectiveDate | BIGINT | true | ||
| ExpirationDate | BIGINT | true | ||
| ParameterizedOfferAttribute | VARCHAR | 4000 | true | |
| CreateDate | DATETIME | true | ||
| CreateBy | INT64 | true | Unica Id of the user who created the triggered offer. | |
| UpdateDate | DATETIME | true | Last modified date of this triggered offer. | |
| UpdateBy | INT64 | true | Unica Id of the user who last modified the triggered offer. |
UACI_OutboundChannel
Contains the outbound channel information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ChannelID | BIGINT | false | The ID uniquely identifies this outbound channel. Primary key of this table. | |
| ChannelName | VARCHAR | 64 | false | The name of outbound channel. It is case insensitively unique within across all channels. |
| Description | VARCHAR | 512 | true | Description of outbound channel. |
| ICID | BIGINT | false | The ID of the containing interactive channel. A foreign key pointing to UACI_IntChannel. | |
| ChannelType | VARCHAR | 64 | true | Value of the column is channel. |
| CreateDate | DATETIME | true | ||
| CreateBy | INT64 | true | Unica Id of the user who created the outbound channel. | |
| UpdateDate | DATETIME | true | Last modified date of this outbound channel. | |
| UpdateBy | INT64 | true | Unica Id of the user who last modified the outbound channel. |
UACI_OutboundChannelGateway
Contains the outbound channel gateway information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| ChannelID | BIGINT | false | The ID of an outbound channel. Foreign key pointing to UACI_OutboundChannel. | |
| GatewayName | VARCHAR | 64 | false | The name of outbound gateway. |
UACI_PlaybackFilter
Contains the playback filters information.
| Field | Type | Length | Null? | Description |
|---|---|---|---|---|
| FilterID | BIGINT | False | Autogenerated Primary Key of playback filter. | |
| Name | VARCHAR | 64 | False | Name of playback filter. |
| DESCRIPTION | VARCHAR | 512 | True | Description of filter. |
| FILTERDETAILS | VARCHAR | 2048 | False | Conditions defined in the filter in JSON format. |
| ICID | BIGINT | False | Interactive Channel ID as foreign key. | |
| VIEWTYPE | VARCHAR | 64 | False | View type of filter:
|
| AUDIENCELEVEL | VARCHAR | 64 | True | Filter defined for AUDIENCE ViewType. |
| CREATEDATE | DATETIME | True | Filter creation date. | |
| CREATEBY | INT64 | True | Unica ID of the user who created the filter. | |
| UPDATEDATE | DATETIME | True | Last modified date of the filter. | |
| UPDATEBY | INT64 | True | Unica ID of the user who updated the filter. |