System tables
The following tables describe the system tables.
This table contains information about each template in Unica Journey.
Organisations - This table captures the organisations deltails within the customers that are using Journey. This is intended for future use where customers would want segration between assets created on Journey across different units within.
For now this is not really being used and has been provisioned as and when required.
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NUMBER | No |
Generated by default on null as identity
|
|
organisationName |
VARCHAR2 | 250 | Yes | Display Organisation's name |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
organisationDescription |
VARCHAR2 | 250 | Yes | Display brief description of the organisation |
version |
Number | 20 | No | Maintains updated count |
partitionId |
Number | 20 | Captures id of platform partition with which organization is associated | |
partitionName |
VARCHAR2 | 250 | Captures name of platform partition with which organization is associated | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch forma |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (primary key) |
NUMBER | No | Auto genrated unique value, work as a primary key | |
userName (foreign key) (references) |
VARCHAR2 | 250 | No | Display Platform user name |
platformId |
NUMBER | 20 | Yes | Display User's Platform ID |
emailId |
VARCHAR2 | 255 | Yes | Display User's Platform email-id |
firstName |
VARCHAR2 | 255 | Yes | Display first name of Platform user |
lastName |
VARCHAR2 | 255 | Yes | Display last name of Platform user |
locale |
VARCHAR2 | 100 | Yes | Display user's Platform locale |
organisationId |
NUMBER | 20 | Yes | Display the Organization Id |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch forma |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (primary key) |
No | Auto genrated unique value, work as a primary key | ||
organisationId (foreign key)
(references) |
NUMBER | 20 | Yes | Foreign key of Organisation table, Reference column name ID |
folderName |
VARCHAR2 | 128 | Yes | Display name of the folder |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy (foreign key) (references) |
NUMBER | 20 | No | Foreign key of USER table. When a user adds a new folder, the system stores the corresponding user ID in this field. This field will be NULL only for four default entries. |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
lastModifiedBy (foreign key)
(references) |
NUMBER | 20 | Yes | Foreign key of USER table, which tells who modified the record |
folderDescription |
VARCHAR2 | 1024 | Yes | Description for folder |
parentFolderId |
NUMBER | 20 | Yes | Id of parent folder for given folder which is foreign key of FOLDERS table, Reference column name ID |
hitCount |
NUMBER | 20 | Yes | Count that indicates how many times folder get referenced for creating/updating/moving entities inside it |
folderType |
NUMBER | 20 | Yes |
Type of folder indicated by integer value Values can be: 0: DATA_DEFINITION 1: ENTRY_SOURCE, 2: JOURNEY |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
organisationId (foreign key) |
NUMBER | 20 | Yes | Foregin key of ORGANISATION table, Reference column name ID |
folderId (foreign key) |
NUMBER | 20 | Yes | Foregin key of FOLDER table, Reference column name ID |
dataDefinitionName |
VARCHAR2 | 250 | Yes | Display Data Definition name |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy (foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, displays who created this record |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
lastModifiedBy (foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, displays who modified the record |
dataDefinitionDescription |
VARCHAR2 | 1024 | Yes | Display description of Data Definition |
version |
NUMBER | 20 | Yes | Maintains updated count |
code |
VARCHAR2 | 11 | Yes | Unique identifier for DD. every DD have a unique code for identification. |
createdDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format | ||
lastModifiedDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
fieldName |
VARCHAR2 | 250 | Yes | DataDefinition field name that tells what will be the field name inside EntrySource data when data will come to Unica Journey. |
significantFieldType |
NUMBER | 20 | Yes |
Ordinal number that tells about the type of significant field of Journey, currently significant field supported by Journey with their ordinal value are as follows : 1. MOBILE_NUMBER - 0 (ordinal value) 2. EMAIL_ID - 1 (ordinal value) |
fieldDataType |
NUMBER | 20 | Yes |
Ordinal number that tells about the data type of Datadefinition field, Currently datatype supported for DataDefinition field by Journey with their ordinal value are as follows 1. String - 0 (ordinal value) 2. Numeric - 1 (ordinal value) 2. Date - 2 (ordinal value) |
fieldLength |
NUMBER | 20 | Yes | Display size of Datadefinition Filed that tells what will be the length of entry source field data when it comes to Journey. |
dateFormat |
VARCHAR2 | 50 | Yes | It contain a date format of Date type datadefnition field that tells in which format Date value will come in entry source data example (dd/MM/yyyy) |
dataDefinitionId (Foreign key)
(References) |
NUMBER | 20 | Yes | Foregin key of Datadefinition table,Refrence column ID. |
required |
NUMBER | 1,0 | No | A boolean value contain only 0 or 1, if it's 1 then particular DataDefinition fileds is require in EntrySource data and if it's value is 0 then that particular datadefinition filed is not require in EntrySource data |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
organisationId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference Id from Organisation Table |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
originalFileName |
VARCHAR2 | 250 | Yes | Display name of uploaded File |
internalFileName |
VARCHAR2 | 250 | Yes | Display application created file Name |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
organisationId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference Id from Organisation Table |
folderId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference Id from Folder Table |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Entry Sources, which tell who created this record |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
lastModifiedBy (Foreign key) |
NUMBER | 20 | Yes | Foregin key of Entry Sources table, which tells who modified the record - Last modified by |
entrySourceDescription |
VARCHAR2 | 1024 | Yes | Textual Description given by User |
entrySourceType |
NUMBER | 20 | Yes |
Type of Source REST FORM FILE KAFKA |
entrySourceName |
VARCHAR2 | 250 | Yes | Display the entry source name given by User |
version |
NUMBER | 20 | Yes | Maintains updated count |
code |
VARCHAR2 | 11 | Yes | Unique code generated by application |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyFileId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference id of Journey File Table |
entrySourceId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference id of Primary Parent Table |
SUBENTRYSOURCETYPE |
NUMBER | 20,0 | Yes |
Type of Source CSV JSON TSV |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyFileId (Foreign key) (References) |
NUMBER | 20 | Yes | Foreign key of Entrysource table, Reference column name ID |
entrySourceId (Foreign key) (References) |
NUMBER | 20 | Yes | Foreign key of ENTRYSOURCES table, Reference column ID. |
|
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
urlPath |
VARCHAR2 | 250 | Yes | Display the complete url |
securityId |
NUMBER | 20 | Yes | Reference id of Security |
entrySourceId (Foreign key) (References) |
NUMBER | 20 | Yes | Reference id of Primary Parent Table |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
entrySourceId (Foreign key) (References) |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
name |
VARCHAR2 | 250 | Yes | Name of Journey |
description |
VARCHAR2 | 1024 | Yes | Description of Journey |
code |
VARCHAR2 | 11 | Yes | Unique identifier for Journey. Every Journey has a unique code for identification. e.g. JS-00000104 |
status |
VARCHAR2 | 30 | Yes |
This contain ordinal number for Journey status as below: 0 - DRAFT 1 - PUBLISHED 2 - COMPLETED 3 - PAUSED |
marketingStage |
VARCHAR2 | 30 | Yes |
This contain ordinal number for marketing stages as below: 0 - REFERRAL 1 - RETENTION 2 - CONVERSION 3 - ACTIVATION 4 - ACQUISITION 5 - AWARENESS |
timeZone |
VARCHAR2 | 50 | Yes | Timezone in which Journey needs to run, e.g. (UTC-04:00) America/New_York |
folderId (Foreign key) (References) |
NUMBER | 20 | Yes | Foreign key of FOLDER table, Reference column name ID |
journeyDesign CLOB |
Yes | It stores the whole Journey design i.e. Journey canvas in JSON | ||
conversions |
NUMBER | 20 | Yes | Not in use |
goalProgress |
NUMBER | 20 | Yes | Not in use |
dataDefinitionId (Foreign key)
(References) |
NUMBER | 20 | Yes | Foreign key of Datadefinition table, Reference column ID |
publishDate |
TIMESTAMP | Yes | Date and time when Journey was published | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdBy (Foreign key) |
NUMBER | 20 | Yes | Foreign key of USER table, which tell who created this record |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
lastModifiedBy (Foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, which tells who modified the record |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
pausedDate |
TIMESTAMP | Yes | Date and time at which Journey is paused | |
completedDate |
TIMESTAMP | Yes | Date and time at which Journey is completed (if goal is completed or manually by mark Journey as complete) | |
deduplicationStatus |
NUMBER | 2 | No | Contain ordinal values as below for how to deal with duplicate data from entry sources |
keyFields |
VARCHAR2 | 1500 | Yes | It is array of required fields in data definition used for deduplication |
isProcessed |
NUMBER | 1,0 | No | By default, value is 0 and when logging interaction scheduler job runs it set its value to 1 |
flagMilestoneAdded |
NUMBER | 1,0 | No | Tells if milestone added for a journey. Indicated by boolean value |
createdDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
publishDateEpoch |
NUMBER | Captures date and time in milliseconds when journey gets published for 1st time | ||
pausedDateEpoch |
NUMBER | Captures date and time in milliseconds when journey gets paused | ||
completedDateEpoch |
NUMBER | The date time stamp when the journey was completed |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Journeys table, Reference column ID. |
entrySourceId |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID. |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. | |
status |
NUMBER | 2 | ||
active |
NUMBER | 1 | No | Display Journey Associations active status |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NUMBER | No | Auto genrated unique value, work as a primary key | |
journeyId |
NUMBER | 20 | Yes | Foreign key of Journeys table, Reference column ID |
temporaryChildId |
NUMBER | 20 | Yes | It is pointId of temporary point, created when this point is updated after Journey paused (to keep updated changes) |
name |
VARCHAR2 | 250 | Yes | Display name of point |
description |
VARCHAR2 | 250 | Yes | Description of point |
hasTempData |
NUMBER | 1,0 | Yes | Store value as 0 by default, it is 1 if this point has a temporary data (if user updates this point) |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Foreign key of USER table, which tell who created this record |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
lastModifiedBy |
VARCHAR2 | 200 | Yes | Foregin key of USER table, which tells who modified the record |
version |
NUMBER | 20 | Yes | Maintains updated count |
isProcessed |
NUMBER | 1,0 | No | By default value is 0 and when logging interaction scheduler job runs it set it's value to 1 |
createdDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
status |
NUMBER | Latest status of Journey point | ||
active |
NUMBER | No | Display Journey points active status |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
conditions |
VARCHAR2 | 3000 | No | Decision split evaluation condition or criteria on which split processes incoming audiences and send them to YES or NO path |
days |
NUMBER | 20 | Value for days used while configuring DecisionSplitActionPoint | |
hours |
NUMBER | 20 | Value for hours used while configuring DecisionSplitActionPoint | |
minutes |
NUMBER | 20 | Value for minutes used while configuring DecisionSplitActionPoint | |
delayTypeEnum |
VARCHAR2 | 20 | Organisations |
Type of delay indicated by integer value Values can be: 0: DURATION 1: DATE |
waitTillDate |
NUMBER | Captures date and time till when delay is added for actionpoints |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
days |
NUMBER | 20 | Yes | Value for days used while configuring delay action point |
hours |
NUMBER | 20 | Yes | Value for hours used while configuring delay action point |
minutes |
NUMBER | 20 | Yes | Value for minutes used while configuring delay action point |
delayTypeEnum |
VARCHAR2 | 20 | Yes |
Type of delay indicated by integer value Values can be: 0: DURATION 1: DATE |
waitTillDate |
TIMESTAMP | Yes | This field is valid only if DELAYTYPEENUM value is 1 | |
waitTillDateEpoch |
NUMBER | Captures date and time in milliseconds till when delay is added for actionpoints | ||
useExpression |
NUMBER | 1 | ||
delayExpression |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
sourceTouchPointId (Foreign key) |
NUMBER | 20 | Yes | Foriegn key TouchPointId (Email/SMS) for which ES is configured |
event CLOB |
Yes | It is a json who has List of EventsIds which configured for the sourceTouchPoint and the linkid or linkurl in case of Link Event is configured. | ||
days |
NUMBER | 20 | Yes | Waiting time of ES to collect the responses, in terms of Days. Like 4 Days |
hours |
NUMBER | 20 | Yes | Waiting time of ES to collect the responses, in terms of Hours. Like 2 Hours |
minutes |
NUMBER | 20 | Yes | Waiting time of ES to collect the responses, in terms of Minutes. Like 10 Minutes |
delayTypeEnum |
VARCHAR2 | 20 | Yes | Delay Type Enum indicates whether the waiting time of ES is a Duration (like days, hours, minutes) OR a Fixed Date( like 25th Dec 2020). |
waitTillDate |
TIMESTAMP | Yes | Waiting time of ES to collect the responses, in terms of Fixed Date. Like 25-12-2020 | |
waitTillDateEpoch |
NUMBER | Captures date and time in milliseconds till when delay is added for actionpoints |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- Email Touch Point is not configured Yet. 1- Email Touch Point is Successfully Configured with mandate values. |
connectorInfo |
VARCHAR2 | 200 | Yes | Connection Name (Like: MailChimp, Mandril) |
dataFieldMapping |
CLOB | Yes | It has the Json value of Fields Mapping(Journey Fields Mapped with the Connector's Fields) based on Channel used to configure the Email Touch Point. | |
channelAgent |
VARCHAR2 | 50 | Yes | Channels Enum Value which indicates through which Channel the touch point is configured. |
isEdited |
NUMBER | 1,0 | No | A Boolean Flag to identify whether the TouchPoint is Edited after Publish the Journey or Not |
offerType |
VARCHAR2 | 50 |
Type of offer associated with email touchpoint indicated by integer value Values can be: 0: NOOFFER 1: COM 2: NBO 3: DELIVER |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointId (Foreign key) |
NUMBER | 20 | Yes | Foreign key TouchPoint for which Deliver is configured. |
metadata |
CLOB | Yes | Json used to save additional information of Journey-Deliver Association | |
state |
VARCHAR2 | 20 | Yes | Not in use |
mailingCode |
VARCHAR2 | 20 | Yes | Associated attribute for Journey and Deliver at Run Time |
documentID |
NUMBER | 20 | Yes | Associated attribute for Journey and Deliver at Design Time |
mailingID |
NUMBER | 20 | Yes | Associated attribute for Journey and Deliver at Run Time |
documentName |
VARCHAR2 | 200 | Yes | Associated attribute for Journey and Deliver at Design Time |
mailingInstanceId |
NUMBER | 20 | Yes | Associated attribute for Journey and Deliver at Run Time |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and Time of Record | |
VERSION |
NUMBER | 20,0 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- SMS Touch Point is not configured Yet. 1-SMS Touch Point is Successfully Configured with mandate values. |
connectorInfo |
VARCHAR2 | 200 | Yes | Connection Name (Like: Twillio) for which SMS touch Point is configured |
dataFieldMapping |
CLOB | Yes | It has the Json value of Fields Mapping(Journey Fields Mapped with the Connector's Fields) based on Channel used to configure the SMS Touch Point. | |
channelAgent |
VARCHAR | 50 | Channels Enum Value which indicates through which Channel the touch point is configured. | |
isEdited |
NUMBER | 1,0 | A Boolean Flag to identify whether the TouchPoint is Edited after Publish the Journey or Not | |
Field | Type | Length | NULL? | Description |
id (Primary key) (Foreign key) |
NUMBER | Auto genrated unique value, work as a primary key | ||
isConnectorConfigured |
NUMBER | 1,0 | 0- Email Touch Point is not configured Yet. 1- Email Touch Point is Successfully Configured with mandate values. | |
connectorInfo |
VARCHAR2 | 200 | Connection Name (Like: MailChimp, Mandril) | |
dataFieldMapping |
CLOB | Fields Mapped with the Connector's Fields) based on Channel used to configure the Email Touch Point. | ||
channelAgent |
VARCHAR | 50 | Channels Enum Value which indicates through which Channel the touch point is configured. | |
isEdited |
NUMBER | 1,0 | No |
Field | Type | Length | NULL? | Description |
id (Primary key) (Foreign key) |
NUMBER | Auto genrated unique value, work as a primary key | ||
isConnectorConfigured |
NUMBER | 1,0 | 0- Email Touch Point is not configured Yet. 1- Email Touch Point is Successfully Configured with mandate values. |
Field | Type | Length | NULL? | Description |
id (Primary key) (Foreign key) |
NUMBER | No | Auto genrated unique value, work as a primary key | |
isConnectorConfigured |
NUMBER | 1,0 | 0- Email Touch Point is not configured Yet. 1- Email Touch Point is Successfully Configured with mandate values. | |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Unique Id | ||
publishType |
VARCHAR2 | 20 | No |
Contains 0-CSV, 1-Kafka, 2-Kafka as Entry Source |
publishTypeDetail |
VARCHAR2 | 250 | Yes | Name of CsvFile /Topic |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
pointId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Pointtable, Reference column ID. |
entrySourceId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyId (Foreign key) |
NUMBER | 20 | Yes | Unique Identifier for Journey |
entrySourceId |
NUMBER | 20 | Yes | Unique Identifier for entrysource |
mobileNumber |
VARCHAR2 | 20 | Yes | Contact number of audience |
email |
VARCHAR2 | 100 | Yes | Email Id of audience |
createdDate |
Yes | Display the creation date and time of record | ||
keyField |
VARCHAR2 | 40 | Yes | SHA256 of key field used for de-duplication |
version |
NUMBER | 20 | Yes | Maintains updated count |
detail |
CLOB | Yes | Journey audience details in Json string format | |
status |
VARCHAR2 | 20 | Yes | Latest status of Journey audience |
goalStatus |
VARCHAR2 | 100 | Yes | Latest goal status of audience |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
entrysourceid |
NUMBER | 20 | Yes | Unique Identifier for entrysource |
journeyid |
NUMBER | 20 | Yes | Unique Identifier for Journey |
sourceTopic |
VARCHAR2 | 250 | No | Source kafka topic name for which error is recorded |
jsondata |
CLOB | No | Audience data in json format | |
errorMsg |
VARCHAR2 | 500 | No | Display the error message |
state |
VARCHAR2 | 20 | Yes | State of the error |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | User who create/update Journey data errors |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id |
No | Unique Id | ||
journeyStatusEnum |
NUMBER | Yes | Enum Int value for State of Journey DRAFT, PUBLISHED, COMPLETED, PAUSED, PARSED, MAPPED, DELETED, REPUBLISHED | |
journeyId |
NUMBER | 20 | Yes | Id of Journey |
createdDate |
TIMESTAMP | Yes | Record creation date | |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id |
No | Auto genrated unique value, work as a primary key | ||
journeyId |
NUMBER | 20 | Yes | Display the Journey id |
dataDefinitaionId |
NUMBER | 20 | Yes | Display the Datadefinition id |
entrySourceId |
NUMBER | 20 | Yes | Display the entry source Id |
status |
VARCHAR2 | 20 | Yes | Display whether the Journey is in Active state or not |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyId (Foreign key) |
NUMBER | 20 | Yes | Unique Identifier for Journey |
topicName |
VARCHAR2 | 50 | Yes | Name of destination topic |
pausedData |
CLOB | Yes | Json Data to be pushed to topic | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
displayName |
VARCHAR2 | 250 | Yes | Name of the event used for display |
statisticsLabel |
VARCHAR2 | 250 | Yes | Label for given event used for statistics related processing |
eventName |
VARCHAR2 | 250 | Yes | Display name of the event |
eventDescription |
VARCHAR2 | 250 | Yes | Description for event |
eventCategory |
VARCHAR2 | 250 | Yes | Category of events e.g. EMAIL/CRM/SMS |
flagDisplayForGoal |
NUMBER | 1,0 | Yes | Boolean value which indicates whether event is used in goal settings or not |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Foreign key of Audience Response, which tell who created this record |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
flagDisplayForStats |
NUMBER | 1,0 | No | To decide to display the event on Journey Canvas stats for the relative touchpoint indicated by boolean value |
acceptMultiple |
NUMBER | 1,0 | Yes | To decide whether we should log multiple responses. Default value is FALSE |
maxResponses |
NUMBER | Yes | Indicated by small integer, which is used ONLY if acceptMultiple is TRUE. Default is 0 | |
actedUpon |
NUMBER | 1,0 | Yes | This field is not currently used |
eventHandlingAction |
VARCHAR | 50 | Yes |
Tells action to be taken audience response. Indicated by string values among: NOACTION("NOACTION"), UNSUBSCRIBE("UNSUBSCRIBE"), UNSUBSCRIBE_MAXRESPONSES("UNSUBSCRIBE_MAXRESPONSES") |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointId (Foreign Key) |
NUMBER | 20 | No | Foreign key of TouchPoint ID, to whom response is related to |
audienceId (Foreign Key) |
NUMBER | 20 | No | Foreign key of Audience Id of JourneyAudience Table, to whom response is related to |
eventId (Foreign Key) |
NUMBER | 20 | No | Foriegn key of Event Id, for which event the response is received |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Foreign key of Audience Response, which tell who created this record |
version |
NUMBER | 20 | Yes | Maintains updated count |
isProcessed |
NUMBER | 1,0 | No | A Flag which idicates whether the record been processed for Reporting or not |
logTimeStampEpoch |
NUMBER | Captures date and time in milliseconds of arrival or exit at node for given audience id | ||
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
audienceId |
NUMBER | 20 | No | Display Id of audience record |
nodeId |
NUMBER | 20 | No | Display Id of point in Journey |
edge |
NUMBER | 20 | No | Display whether audience progressed on yes path or no path of node |
direction |
NUMBER | 1,0 | No | Display whether audience arrived at node or leaving from the node |
logTimeStamp |
TIMESTAMP | Yes | Date and time of arrival or exit at node for given audience id | |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
isProcessed |
NUMBER | 1,0 | No | Indicates whether record is picked by logging interaction scheduler job |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
nodeId |
NUMBER | 20 | No | Display id of point in Journey |
audienceCount |
NUMBER | Yes | Count of total audiences which are on given node for given stage | |
audienceStage |
NUMBER | 20 | No | Indicates stage of audiences for given node for given audience count |
edge |
NUMBER | 1,0 | Yes | Display whether audiences progressed on yes path or no path for given node |
isUpdated |
NUMBER | 1,0 | Yes | Indicates whether record is up to date with audience count or not |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
data |
CLOB | No | Message which is discarded in Journey | |
journeyId |
NUMBER | 20 | Yes | Display Id of Journey for which message is discarded |
entrysourceId |
NUMBER | 20 | Yes | Display Id of entrysource |
sourceTopic |
VARCHAR2 | 250 | No | Display Id of point in Journey for which message is discarded |
reason |
VARCHAR2 | 2000 | No | Reason for message discard |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Parimary key) |
No | Auto genrated unique value, work as a primary key | ||
entrySourceCode (Foreign key) |
VARCHAR2 | 11 | Yes | Foreign key EntrySource Id, for which the data is pushed into STREAMING_IMPORT topic of Kafka |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
data |
CLOB | Yes | The raw Json value which is pushed to the STREAMING_IMPORT topic for processing into Journey | |
status |
VARCHAR2 | 30 | Yes | Maintain Status of pushed Data |
version |
NUMBER | Yes | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
dataDefinitionId (Foreign key) |
NUMBER | 20 | Yes | Unique Identifier for data definition |
schema |
CLOB | Yes | Json schema details for data definition | |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | User who create/update data definition schema |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
name |
VARCHAR2 | 250 | No | Name of the third party application which want to access the Journey |
description |
VARCHAR2 | 1024 | Yes | Description of the third party application which want to access the Journey |
clientid |
VARCHAR2 | 148 | No | Id by which third party application can login |
clientsecret |
VARCHAR2 | 148 | No | Password by which third party application can login |
status |
VARCHAR2 | 30 | No | Status of that application which active or inactive active -1, inactive-0 |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy (Foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, which tells who created this record |
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and time of record | |
lastModifiedBy (Foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, which tells who modified the record |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
journeyId (Foreign key) |
NUMBER | 20 | No | Foreign key of ENTRYSOURCES table, Reference column ID. |
createdDate | TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
goalType |
NUMBER | 20 | No | 0-Date based, 1-Count Based |
flagMarkComplete |
NUMBER | 1,0 | Yes | If this flag is set to TRUE, Journey will be marked as completed as soon as goal is achieved. |
targetDateTime |
TIMESTAMP | Yes | Display target date for date based goal. | |
targetTouchPointId |
NUMBER | 20 | Yes | Display target touch point Id for Count based goal. |
targetEventId |
NUMBER | 20 | Yes | Display target event id for Count based goal. |
targetAudienceCount |
NUMBER | 20 | Yes | Display target audience count for Count based goal. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
CONNECTIONNAME |
VARCHAR2 | 250 | Yes | Link's connection name selected as default for Link integration |
CONNECTIONTYPE |
VARCHAR2 | 50 | Yes | Type of that connection whether CRM, Emaill or SMS |
CREATEDDATE |
TIMESTAMP | Yes | Display the creation date and time of record | |
CREATEDBY |
NUMBER | Yes | Foregin key of USER table, which tell who created this record | |
LASTMODIFIEDDATE |
TIMESTAMP | Yes | Display last modified date and time of record | |
LASTMODIFIEDBY |
NUMBNER | 20 | Yes | Foregin key of USER table, which tells who modified the record |
VERSION |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
audienceResponseId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of the AudienceResponse table of which record the extended information it relates to |
linkURL |
VARCHAR2 | 250 | Yes | URL of the Link which is clicked by the audience related to the responseId |
linkId |
NUMBER | 20 | Yes | LinkId of the Link which is clicked by the audience related to the responseId |
isProcessed |
NUMBER | 1,0 | No | A Flag which idicates whether the record been processed for Reporting or not |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
responseTimeEpoch |
NUMBER | No | The date time stamp of the response | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
entrySourceId |
NUMBER | 20 | No | Unique Identifier of entrysource |
entrySourceType |
VARCHAR2 | 250 | No | Type of entrysource |
entrySourceDetail |
VARCHAR2 | 2000 | Yes | Details of entrysource i.e. token for REST ES, file name for File ES, topic name for kafka ES etc |
audienceCount |
NUMBER | 15 | Yes | Total number of audiences entered in system for specific entrusource |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
batchID |
VARCHAR2 | 250 | No | Unique batchId generated by Java Code |
batchSize |
NUMBER | 20 | Yes | Size of the Audience List which send in this current batch |
touchPointID |
NUMBER | 20 | No | Refrence TouchPoint Id for which audience is procedding Further to Deliver Channel |
connectionType |
NUMBER | 20 | No | Enum Type Value to refer the type of touch Point |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointBatchId (Foreign key) |
NUMBER | No | Foreign key TouchPointId(Email/SMS/CRM) for which the Comunication is going to send for an audience List | |
audienceID |
NUMBER | 20 | No | RefrenceAudienceId related to the current batch |
audienceMetaData |
VARCHAR2 | 255 | Yes | Significat Field value based on the touchPoint for which audience is proceeding to the Delivery Channel to send the Notifications. |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
No | Auto genrated unique value, work as a primary key | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- Sales Force Touch Point is not configured Yet. 1-Sales Force Touch Point is Successfully Configured with mandate values. |
connectorInfo |
VARCHAR2 | 200 | Yes | Connection Name (Like: SalesForce) for which CRM touch Point is configured |
dataFieldMapping |
CLOB | Yes | It has the Json value of Fields Mapping(Journey Fields Mapped with the Connector's Fields) based on Channel used to configure the CRM Touch Point. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
format |
VARCHAR2 | 20 | No | Date format string e.g. dd-MM-yyyy |
description |
VARCHAR2 | 100 | Yes | Information about date format if any |
userCreated |
NUMBER | 1,0 | Yes | Indicates whether date format is system created or user created. Can be 0/1. If format is user created, its 1. If format is system created, its 0 |
isValid |
NUMBER | 1,0 | Yes | Display whether the given date format is valid or not. |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Name of the user who created this record |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointId |
NUMBER | 20 | No | Id of point for which deliver response is received |
audienceId |
NUMBER | 20 | No | Id of audience for which deliver response is received |
email |
VARCHAR2 | 100 | No | Display the email address |
responseTime |
TIMESTAMP | Yes | Response time received from deliver | |
mailingInstanceId |
NUMBER | 20 | No | Mailing instance id received from Deliver |
mailingSeqNum |
NUMBER | 20 | No | Mailing sequence number received from Deliver |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Stores the Thread name of Deliver sending this record to Journey. The possible values are Contact, Inet, or LinkMaster. This field is not related to the Deliver User, it is related to the Deliver Thread. |
updatedDate |
TIMESTAMP | Yes | Updation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
responseTimeEpoch |
NUMBER | The date time stamp of the response | ||
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. | |
updatedDateEpoch |
NUMBER | The date time stamp when the Goal was updated/edited |
Field | Type | Length | NULL? | Description |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointId |
NUMBER | 20 | No | Id of point for which deliver response is received |
audienceId |
NUMBER | 20 | No | Id of audience for which deliver response is received |
email |
VARCHAR2 | 100 | No | Display email address |
responseTime |
TIMESTAMP | Yes | Response time received from Deliver | |
mailingInstanceId |
NUMBER | 20 | No | Mailing instance id received from Deliver |
mailingSeqNum |
NUMBER | 20 | No | Mailing sequence number received from Deliver |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Stores the Thread name of Deliver sending this record to Journey. The possible values are Contact, Inet, or LinkMaster. This field is not related to the Deliver User, it is related to the Deliver Thread. |
updatedDate |
TIMESTAMP | Yes | Display updation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
touchPointId |
NUMBER | 20 | No | Id of point for which deliver response is received |
mailingInstanceId |
NUMBER | 20 | No | Mailing instance id received from Deliver |
linkId |
NUMBER | 20 | No | Display Id of Link for given event |
linkUrl |
VARCHAR2 | 500 | Yes | Display Link url for given Link id |
responseTime |
TIMESTAMP | Yes | Response time received from Deliver | |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Stores the Thread name of Deliver sending this record to Journey. The possible values are Contact, Inet, or LinkMaster. This field is not related to the Deliver User, it is related to the Deliver Thread. |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
responseTimeEpoch |
NUMBER | The date time stamp of the response |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key | ||
engagementSplitPointId |
NUMBER | 20 | No | Display EngagementSplitPointId |
audienceResponseId (Foreign key) |
NUMBER | 20 | No | Foregin key of AudienceResponse table, Refrence column is ID |
audienceResponseMetaDataId (Foreign key) |
NUMBER | 20 | Yes | Foregin key of JourneyAudiences table, Refrence column is ID |
isProcessed |
NUMBER | 1,0 | No | Foregin key of AudienceResponseMetaData table, Refrence column is ID |
eventId |
NUMBER | 20 | No | Display id of AudienceResponseEventMaster table |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
version |
NUMBER | 20 | Yes | Maintains updated count |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
id (Primary key) |
Auto genrated unique value, work as a primary key | |||
entrySourceId (Foreign key) |
NUMBER | 20 | Reference id of Primary Parent Table | |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
No | Auto genrated unique value, work as a primary key. | ||
touchPointId |
NUMBER | 20 | No | Display TouchPointId |
journeyId (Foreign key) |
NUMBER | 20 | YES | Foreign key of Journeys table, Reference column ID |
linkUrl
|
VARCHAR2 | 2000 | YES | URL of the Link which is clicked by the audience related to the responseId |
linkId |
NUMBER | 20 | YES | LinkId of the Link which is clicked by the audience related to the responseId |
templateId |
VARCHAR2 | 200 | No | The id of the template |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy |
VARCHAR2 | 200 | Yes | Foreign key of USER table, which tell who created this record |
version
|
NUMBER | 20 | YES | Maintains updated count |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
Id (Primary key) |
NO | Auto genrated unique value, work as a primary key | ||
journeyId (Foreign key) |
Number | 20 | YES | Foreign key of Journeys table, Reference column ID. |
touchPointTable |
VARCHAR | 32 | YES | The table which details of the Touch Point are available in |
touchPointId
|
NUMBER | 20 | YES | Foreign key TouchPoint for which Deliver is configured. |
isDirty |
NUMBER | 1,0 | YES | The record has been updated/edited |
status |
VARCHAR | 20 | Yes |
This contain ordinal number for Journey status as below: 0 - DRAFT 1 - PUBLISHED 2 - COMPLETED 3 - PAUSED |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
Id (Primary key) |
NO | Auto genrated unique value, work as a primary key | ||
journeyId |
NUMBER | 20 | YES | Foreign key of Journeys table, Reference column ID. |
name |
VARCHAR2 | 250 | Yes | Name of Journey |
description
|
VARCHAR2 | 512 | Yes | Description of Journey |
goalType |
NUMBER | 20 | NO | 0-Date based, 1-Count Based |
completedDate |
TIMESTAMP | Yes | Date and time at which journey is completed (if goal is completed or manually by mark Journey as complete) | |
flagMarkComplete |
NUMBER | 1,0 | Yes | If this flag is set to TRUE, Journey will be marked as completed as soon as goal is achieved. |
flagFrequencyEnabled |
NUMBER | 1,0 | YES | Indicates that the Goal is frequency based |
frequency |
NUMBER | 20 | YES | The frequency of the Goal - daily, weekly, monthly, quarterly or yearly |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
createdBy (Foreign key) |
NUMBER | 20 | YES | Foreign key of USER table, which tell who created this record |
updatedDate |
TIMESTAMP | Yes | Updation date and time of record | |
updatedBy (Foreign key) |
NUMBER | 20 | Yes | Name of the user who updated this record |
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
updatedDateEpoch |
NUMBER | The date time stamp when the Goal was updated/edited | ||
completedDateEpoch |
NUMBER | NO | The date time stamp when the journey was completed |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key | ||
targetDateTime |
TIMESTAMP | Yes | Display target date for date based goal. | |
targetDateTimeEpoch |
NUMBER | NO | The date time stamp when the Goal is valid until |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key | ||
targetTouchPointId |
NUMBER | 20 | Yes | Display target touch point Id for Count based goal. |
targetEventId |
NUMBER | 20 | Yes | Display target event id for Count based goal. |
targetLink
|
VARCHAR2 | 512 | YES | The link for which a contact Goal is defined |
targetAudienceCount |
NUMBER | 20 | Yes | Display target audience count for Count based goal. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key | ||
targetTouchPointId |
NUMBER | 20 | Yes | Display target touch point Id for Count based goal. |
targetAudienceCount |
NUMBER | 20 | Yes | Display target audience count for Count based goal. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key | ||
journeyGoalContactId (Foreign key) |
NUMBER | 20 | YES | A reference to JourneyGoalContact |
targetAudienceCount |
NUMBER` | 20 | Yes | Display target audience count for Count based goal. |
updatedDate
|
TIMESTAMP | Yes | Updation date and time of record | |
updatedBy (Foreign key) |
NUMBER | 20 | Yes | Name of the user who updated this record |
createdDate |
folderType | TIMESTAMP | Display the creation date and time of record | |
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
updatedDateEpoch |
NUMBER | The date time stamp when the Goal was updated/edited |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
journeyGoalSalesId (Foreign key) |
NUMBER` | 20 | A reference to JourneyGoalSales | |
targetAudienceCount |
NUMBER | 20 | Yes | Display target audience count for Count based goal. |
updatedDate
|
TIMESTAMP | Yes | Updation date and time of record | |
updatedBy (Foreign key) |
NUMBER | 20 | Yes | Name of the user who updated this record |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
updatedDateEpoch |
NUMBER | The date time stamp when the Goal was updated/edited |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
journeyGoalContactId (Foreign key) |
NUMBER | 20 | YES | A reference to JourneyGoalContact |
startDate |
DATE | Journey start date | ||
endDate
|
DATE | Journey end date | ||
currentAudienceCount |
NUMBER | 20 | The current number of audiences that have achieved the Goal | |
percentage |
NUMBER | 6,2 | Captures percentage of goal achieval | |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
journeyGoalSalesId (Foreign key) |
NUMBER | 20 | A reference to JourneyGoalSales | |
startDate |
DATE | Journey start date | ||
endDate
|
DATE | Journey end date | ||
currentAudienceCount |
NUMBER | 20 | Display count of exiting audiences | |
percentage |
NUMBER | 6,2 | Captures percentage of goal achieval | |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
audienceId (Foreign key) |
NUMBER | 20 | No | Foreign key of Aidience Id of JourneyAudience Table, to whom response is elated to |
goalId (Foreign key) |
NUMBER | 20 | Display goal id | |
goalStatus
|
VARCHAR2 | 100 | Yes | Latest goal status of audience |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
responsetime |
TIMESTAMP | Yes | Response time received from deliver | |
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
responsetimeEpoch |
NUMBER |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
entrySourceId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID. |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
|
NO | Auto genrated unique value, work as a primary key. | ||
entrySourceId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID. |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- Sales Force Touch Point is not configured Yet. 1-Sales Force Touch Point is Successfully Configured with mandate values. |
connectorInfo |
VARCHAR2 | 200 | Yes | Connection Name (Like: SalesForce) for which CRM touch Point is configured |
dataFieldMapping
|
CLOB | Yes | It has the Json value of Fields Mapping(Journey Fields Mapped with the Connector's Fields) based on Channel used to configure the CRM Touch Point. | |
channelAgent |
VARCHAR2 | 50 | Yes | Channels Enum Value which indicates through which Channel the touch point is configured. |
isEdited |
NUMBER | 1,0 | No | A Boolean Flag to identify whether the TouchPoint is Edited after Publish the Journey or Not |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
touchPointId (Foreign key) |
NUMBER | 20 | YES | Foreign key TouchPoint for which Deliver is configured. |
batchID |
NUMBER | 20 | NO | Unique batchId generated by Java Code |
eventId (Foreign key) |
NUMBER | 20 | NO | Display id of AudienceResponseEventMaster table |
responseJson |
CLOB | The JSON of the response for a request | ||
audienceCount |
NUMBER | 20 | NO | Count of total audiences which are on given node for given stage |
responseTime |
TIMESTAMP | Yes | Response time received from deliver | |
updateCount |
NUMBER | 20 | Display updated audience resonse count | |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
modifiedDate |
TIMESTAMP | Yes | Display last modified date and time of record | |
createdBy (Foreign key) |
NUMBER | 20 | YES | Foreign key of USER table, which tell who created this record |
version |
NUMBER | 20 | Maintains updated count | |
isProcessed |
NUMBER | 1,0 | NO | A Flag which idicates whether the record been processed for Reporting or not |
responseTimeEpoch |
NUMBER | NO | The date time stamp of the response | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
modifiedDateEpoch |
NUMBER | The date time stamp of when the data was modified |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
menuId |
NUMBER | NO | Display the menu id | |
locale |
VARCHAR2 | 32 | Yes | Display user's Platform locale |
linkUrl
|
VARCHAR2 | 250 | Yes | URL of the Link which is clicked by the audience related to the responseId |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
createdBy |
VARCHAR2 | 100 | YES | Foreign key of USER table, which tell who created this record |
modifiedDate |
TIMESTAMP | Yes | Display last modified date and time of records | |
modifiedBy |
VARCHAR2 | 100 | Yes | Foregin key of USER table, which tells who modified the record |
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
modifiedDateEpoch |
NUMBER | The date time stamp of when the data was modified |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
journeyId (Foreign key) |
NUMBER | 20 | YES | Foreign key of Journeys table, Reference column ID. |
name |
VARCHAR2 | 64 | NO | Name of Journey |
description
|
VARCHAR2 | 512 | Yes | Description of Journey |
milestoneCondition |
CLOB | NO | The condition JSON for the MileStone | |
milestoneType |
NUMBER | 20 | NO | The type of the MileStone |
targetCount |
NUMBER | 20 | NO | The target for the MileStone |
currentCount |
NUMBER | 20 | NO | The current count for the MileStone |
status |
NUMBER | 20 |
This contain ordinal number for Journey status as below: 0 - DRAFT 1 - PUBLISHED 2 - COMPLETED 3 - PAUSED |
|
createdBy (Foreign key) |
NUMBER | 20 | YES | Foreign key of USER table, which tell who created this record |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
targetAchievedDate |
TIMESTAMP | NO | The date that the target was achieved (will be deprecated in the future) | |
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
targetAchievedDateEpoch |
NUMBER | NO | The date time stamp when the target was achieved |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
milestoneId |
NUMBER | 20 | Yes | Display set milestone id |
entrySourceId |
NUMBER | 20 | Yes | Foreign key of Entrysources table, Reference column ID. |
version
|
NUMBER | 20 | Maintains updated count | |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
touchPointId (Foreign key) |
NUMBER | 20 | YES | Foreign key TouchPoint for which Deliver is configured. |
metadata |
CLOB | Yes | Json used to save additional information of Journey-Deliver Association | |
state
|
VARCHAR2 | 20 | Yes | Not in use |
deploymentId |
NUMBER | 20 | The deployment ID used with Link | |
documentID |
NUMBER | 20 | Yes | Associated attribute for Journey and Deliver at Design Time |
documentName |
VARCHAR | 200 | Yes | Associated attribute for Journey and Deliver at Design Time |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
lastModifiedDate |
TIMESTAMP | Yes | Display last modified date and Time of Record | |
VERSION |
NUMBER | 20,0 | YES | Maintains updated count |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
audienceId |
NUMBER | 20 | No | Display Id of audience record |
milestoneId |
NUMBER | 20 | Display the set milestone id | |
journeyId
|
NUMBER | 20 | YES | Foreign key of Journeys table, Reference column ID. |
achievedDate |
TIMESTAMP | NO | The date the MileStone was achieved | |
journeyEnteredDate |
TIMESTAMP | NO | The date when the audience entered the Journey | |
averageTimeTaken |
NUMBER | 20 | NO | The average time taken for the audience to complete the Journey |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
version |
NUMBER | 20 | Maintains updated count | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
achievedDateEpoch |
NUMBER | Captures date and time in milliseconds when given audience id achieves given milestone in a journey | ||
journeyEnteredDateEpoch |
NUMBER | Captures date and time in milliseconds when given audience id entered the Journey |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- Sales Force Touch Point is not configured Yet. 1-Sales Force Touch Point is Successfully Configured with mandate values. |
connectorInfo |
VARCHAR2 | 200 | Yes | Connection Name (Like: SalesForce) for which CRM touch Point is configured |
dataFieldMapping
|
CLOB | Yes | It has the Json value of Fields Mapping(Journey Fields Mapped with the Connector's Fields) based on Channel used to configure the CRM Touch Point. | |
channelAgent |
VARCHAR2 | 50 | Yes | Channels Enum Value which indicates through which Channel the touch point is configured. |
isEdited |
NUMBER | 1,0 | NO | A Boolean Flag to identify whether the TouchPoint is Edited after Publish the Journey or Not |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
isConnectorConfigured |
NUMBER | 1,0 | Yes | 0- Sales Force Touch Point is not configured Yet. 1-Sales Force Touch Point is Successfully Configured with mandate values. |
requestPayloadType |
NUMBER | 1,0 | NO | The type of the request payload in the REST touchpoint |
requestPayload
|
CLOB | The request paylooad in the REST touchpoint | ||
responseFieldMapping |
CLOB | YES | The field mapping for the response field | |
authId |
NUMBER | 20 | NO | The ID for the authentication mechanism used by the REST touchpoint |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
restUrl |
VARCHAR2 | 1000 | NO | The URL for the REST touchpoint |
apiMethod |
NUMBER | 1,0 | NO | The verb to be used with the REST touchpoint |
authType
|
NUMBER | 1,0 | NULL | The authorization type for the REST touchpoint |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
userName |
VARCHAR2 | 250 | No | Display Platform user name |
password |
VARCHAR2 | 250 | No | Display Platform password |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
userName |
VARCHAR2 | 250 | No | Display Platform user name |
password |
VARCHAR2 | 250 | No | Display Platform password |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
keyName |
VARCHAR2 | 250 | The key nanme field used with the REST touchpoint for authentication | |
header |
VARCHAR2 | 250 | The header field used with the REST touchpoint for authentication |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) (Foreign key) |
NO | Auto genrated unique value, work as a primary key. | ||
clientId |
VARCHAR2 | 250 | No | Id by which third party application can login |
clientSecret |
VARCHAR2 | 250 | No | Password by which third party application can login |
accessTokenUrl
|
VARCHAR2 | 1000 | The access token url for OAuth used with the REST touchpoint | |
userName |
VARCHAR2 | 250 | No | Display Platform user name |
Password |
VARCHAR2 | 250 | No | Display Platform password |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
audienceResponseId (Foreign key) |
NUMBER | 10 | Yes | Foreign key of the AudienceResponse table of which record the extended information it relates to |
httpresponsecode |
NUMBER | 4 | The HTTP response code | |
errorMessage
|
VARCHAR2 | 3000 | The error message associated with a HTTP response | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
id (Primary key) |
Auto genrated unique value, work as a primary key | |||
audienceResponseId (Foreign key) |
NUMBER | 10 | Foregin key of AudienceResponse table, Refrence column is ID | |
httpresponsecode |
NUMBER | 4 | The HTTP response code | |
errorMessage |
VARCHAR2 | 3000 | The error message associated with a HTTP response | |
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format | |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
cacheName |
VARCHAR2 | 255 | NO | The name of the cache used by the Journey application |
cacheKey |
VARCHAR2 | 255 | NO | The key used by the cache |
cacheValue
|
CLOB | The value associated with the key | ||
sourcePoint |
VARCHAR2 | 255 | The point which uses the cache | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedEpochDate |
NUMBER | |||
version |
NUMBER | 20 | Maintains updated count | |
active |
NUMBER | 1 | NO | Display cache backup active status |
cacheKeyNameHash |
NUMBER | 30 | NO | The had used for the name and key of the cache |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
audienceResponseId (Foreign key) |
NUMBER | 20 | NO | Foreign key of the AudienceResponse table of which record the extended information it relates to |
associatedAttributes |
CLOB | The attributes avialable with an audience response | ||
isProcessed
|
NUMBER | 1,0 | NO | A Flag which idicates whether the record been processed for Reporting or not |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
createdBy |
VARCHAR2 | 200 | YES | Foreign key of USER table, which tell who created this record |
version |
NUMBER | 20 | Maintains updated count | |
responseTimeEpoch |
NUMBER | NO | The date time stamp of the response | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
emailId |
VARCHAR2 | 200 | NO | Display User's Platform email-id |
status |
VARCHAR2 | 200 | Yes |
This contain ordinal number for Journey status as below: 0 - DRAFT 1 - PUBLISHED 2 - COMPLETED 3 - PAUSED |
channelAgent
|
VARCHAR2 | 50 | Yes | Channels Enum Value which indicates through which Channel the touch point is configured. |
eventID (Foreign key) |
Number | 20 | NO | Foriegn key of Event Id, for which event the response is received |
audienceResponseId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of the AudienceResponse table of which record the extended information it relates to |
audienceResponseExtendedId |
NUMBER | 20 | NO | The ID of the audience response extended data |
createdBy |
VARCHAR2 | 200 | NO | Foreign key of USER table, which tell who created this record |
version |
NUMBER | 20 | YES | Maintains updated count |
createdDate |
TIMESTAMP | Display the creation date and time of record | ||
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
modifiedDateTimeEpoch |
NUMBER |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
name |
VARCHAR2 | 250 | Yes | Name of Journey |
description |
VARCHAR2 | 1024 | Yes | Description of Journey |
code
|
VARCHAR2 | 11 | Yes | Unique identifier for DD. every DD have a unique code for identification. |
timeZone |
VARCHAR2 | 50 | Yes | Timezone in which journey needs to run, e.g. (UTC-04:00) America/New_York |
journeyDesign |
CLOB | Yes | It stores the whole Journey design i.e. Journey canvas in JSON | |
dataDefinitionId (Foreign key) |
NUMBER | 20 | Yes | Foreign key of Datadefinition table, Reference column ID |
version |
NUMBER | 20 | Maintains updated count | |
deduplicationStatus |
NUMBER | 2 | NO | Contain ordinal values as below for how to deal with duplicate data from entry sources |
keyfields |
VARCHAR2 | 1500 | Yes | It is array of required fields in data definition used for deduplication |
link |
CLOB | Yes | Link which is clicked by the audience related to the responseId | |
sourceJourneyId |
NUMBER | 20 | Yes | Unique Identifier for source Journey |
folderId (Foreign key) |
NUMBER | 20 | Yes | Foregin key of FOLDER table, Reference column name ID |
status |
NUMBER | 20 | Yes |
This contain ordinal number for Journey status as below: 0 - DRAFT 1 - PUBLISHED 2 - COMPLETED 3 - PAUSED |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
createdBy (Foreign key) |
NUMBER | 20 | YES | Foreign key of USER table, which tell who created this record |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
lastModifiedBy (Foreign key) |
NUMBER | 20 | Yes | Foregin key of USER table, which tells who modified the record |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
journeyId (Foreign key) |
NUMBER | 20 | YES | Foreign key of Journeys table, Reference column ID. |
mappingJSON |
CLOB | The JSON used for mapping of the partition settings | ||
createdDateEpoch
|
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
createdBy (Foreign key) |
NUMBER | 20 | YES | Foreign key of USER table, which tell who created this record |
lastModifiedBy (Foreign key) |
NUMBER | 20 | Yes | Foreign key of USER table, which tells who modified the record |
version |
NUMBER | 20 | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
touchPointId (Foreign key) |
NUMBER | 20 | YES | Foreign key TouchPoint for which Deliver is configured. |
offerId |
NUMBER | 20 | NO | The ID of the offer |
varientId
|
VARCHAR2 | 200 | The ID of the variant used by the offer | |
offerCode |
VARCHAR2 | 200 | NO | The offer code |
offerName |
VARCHAR2 | 200 | The offer name | |
offerURL |
VARCHAR2 | 500 | NO | The offer url |
offerLinkId |
NUMBER | 20 | YES | The ID of the Link URL associated with the offer |
offerAttributeJson |
CLOB | YES | The JSON of the offer attributes | |
offerStaticAttributeJson |
CLOB | The JSON of the static attributed of the offer | ||
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDateEpoch |
NUMBER | Date time stamp when the record was added in UTC timezone and Epoch format. | ||
VERSION |
NUMBER | 20,0 | YES | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
offerMetaDataId (Foreign key) |
NUMBER | 20 | NO | The ID of the metadata associated with the offer |
offerId |
NUMBER | 20 | NO | The ID of the offer |
offerCRC
|
NUMBER | 20 | YES | The CRC generated for CHRH |
treatmentCode |
VARCHAR2 | 200 | The treatment code generated used for Contact History, Response History (CHRH) tracking | |
offerAttributeJson |
CLOB | YES | The JSON of the offer attributes | |
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
VERSION |
NUMBER | 20,0 | YES | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
batchId (Foreign key) |
NUMBER | 20 | No | Unique batchId generated by Java Code |
offerHistoryId (Foreign key) |
NUMBER | 20 | NO | The ID for the offer history |
createdDateEpoch
|
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
VERSION |
NUMBER | 20,0 | YES | Maintains updated count |
Field | Type | Length | NULL? | Description |
---|---|---|---|---|
id (Primary key) |
NO | Auto genrated unique value, work as a primary key. | ||
touchPointId (Foreign key) |
NUMBER | 20 | YES | Foreign key TouchPoint for which Deliver is configured. |
channel |
VARCHAR2 | 250 | Name of interactive channel associated with NBO (Next Best Offer) | |
audienceLevel
|
VARCHAR2 | 250 | The audience level used for Next Best Offer (NBO) | |
interactionPoint |
VARCHAR2 | 250 | The interaction point associated with NBO | |
event |
VARCHAR2 | 250 | No | It is a json who has List of EventsIds which configured for the sourceTouchPointand the linkid or linkurl in case of Link Event is configured. |
runtimeUrl |
VARCHAR2 | 250 | the runtime URL associated with NBO | |
interactFieldMapping |
CLOB | The field mapping used for NBO | ||
createdDateEpoch |
NUMBER | NO | Date time stamp when the record was added in UTC timezone and Epoch format | |
lastModifiedDate |
NUMBER | Yes | Display last modified date and time of records | |
VERSION |
NUMBER | 20,0 | YES | Maintains updated count |
Field | Type | Length | NULL? | Description |
id (Primary key) |
NUMBER | Auto genrated unique value, work as a primary key | ||
templateId (Foreign key) |
NUMBER | 20 | ||
entrySourceId (Foreign key) |
NUMBER | 20 | Reference id of Primary Parent Table | |
version |
NUMBER | 20 | Maintains updated count | |
status |
INT | |||
createdDateEpoch |
NUMBER | No | Date time stamp when the record was added in UTC timezone and Epoch format. |
CREATE INDEX IDX_CB_CACHENAME ON CACHEBACKUP(CACHENAME);
CREATE INDEX INDEX_JA_JOURNEYID_STATUS ON JOURNEYAUDIENCES ("JOURNEYID", "STATUS") ;
CREATE INDEX INDEX_JAF_NODEID_DIR_ISPROC ON JOURNEYAUDIENCEFLOW ("NODEID", "DIRECTION", "ISPROCESSED");
CREATE INDEX JGM_JOURNEYID ON JOURNEYGOALMASTER(JOURNEYID);
CREATE INDEX JGCV_JOURNEYGOALCONTACTID ON JOURNEYGOALCONTACTVERSIONS(JOURNEYGOALCONTACTID);
CREATE INDEX JGCT_JOURNEYGOALCONTACTID ON JOURNEYGOALCONTACTTRANSACTION(JOURNEYGOALCONTACTID);
CREATE INDEX JGSV_JOURNEYGOALSALESID ON JOURNEYGOALSALESVERSIONS(JOURNEYGOALSALESID);
CREATE INDEX JGST_JOURNEYGOALSALESID ON JOURNEYGOALSALESTRANSACTION(JOURNEYGOALSALESID);
CREATE INDEX JAG_GOALID ON JOURNEYAUDIENCEGOAL(GOALID);
CREATE INDEX IDX_JAM_MID_AUDID ON JOURNEYAUDIENCEMILESTONE(MILESTONEID, AUDIENCEID);
CREATE INDEX IDX_JAM_MID ON JOURNEYAUDIENCEMILESTONE(MILESTONEID);
CREATE INDEX IDX_EUL_EID ON EmailUnsubscribedList(status,emailId);
Field | Type | Length | NULL? | Description |
id (Primary key) (Foreign key) |
NUMBER | No | Auto genrated unique value, work as a primary key | |
isConnectorConfigured |
NUMBER | 1,0 | 0- Email Touch Point is not configured Yet. 1- Email Touch Point is Successfully Configured with mandate values. | |
connectorInfo |
VARCHAR2 | 200 | Connection Name (Like: MailChimp, Mandril) | |
dataFieldMapping |
CLOB | Fields Mapped with the Connector's Fields) based on Channel used to configure the Email Touch Point. | ||
channelAgent |
VARCHAR | 50 | Channels Enum Value which indicates through which Channel the touch point is configured. | |
isEdited |
NUMBER | 1,0 | No | A Boolean Flag to identify whether the TouchPoint is Edited after Publish the Journey or Not |
Field | Type | Length | NULL? | Description |
id (Primary key) (Foreign key) |
NUMBER | No | Auto genrated unique value, work as a primary key | |
touchPointId |
NUMBER | 20 | No | Id of touchpoint |
audienceId |
NUMBER | 20 | No | Id of audience |
reason |
VARCHAR2 | 2000 | No | Shows why audience is in wait state for particular touchpoint |
createdDateEpoch |
NUMBER | NO | Captures date and time in milliseconds when record is created | |
version |
Number | 20 | No | Maintains updated count |
EndJourneyAudience - This table is used to save audience details of completed or ended journeys. When journey ends or is completed, audiences belong to that journey get deleted from journeyaudiences table and saved to endjourneyaudience table.
Id |
No |
Auto generated unique value, work as a primary key |
||
journeyId |
Number | 20 | Yes |
Foreign key of Journeys table,Reference column ID |
entrySourceId |
Number | 20 | Yes | Unique Identifier for entry source |
mobileNumber |
VARCHAR2 | 20 | Yes | Contact number of audience |
email |
VARCHAR2 | 100 | Yes | Email of audience |
createdDate |
TIMESTAMP | Yes | Display the creation date and time of record | |
keyField |
VARCHAR2 | 40 | Yes | SHA256 of key field used for de-duplication |
version |
Number | 20 | Yes | Maintains updated count |
detail |
JSON | Yes | Journeyaudience details in Json string format | |
status |
VARCHAR2 | 20 | Yes | Latest status of Journeyaudience |
goalStatus |
VARCHAR2 | Yes | Latest goal status of audience | |
createdDateEpoch |
Number | No | Date time stamp when the record was added in UTC timezone and Epoch format. |