continued ....
10:43:59.548 Std 05200 db2jcc4.jar. Version not available Path ./lib/db/ibm/db2jcc4.jar
10:43:59.549 Std 05200 postgresql.jar. Version not available Path ./lib/db/postgresql/postgresql.jar
10:43:59.549 Std 05200 log4j.jar. Version 1.2.16 Path ./lib/log/log4j.jar
10:43:59.550 Std 05200 slf4j-api.jar. Version 1.6.6 Path ./lib/log/slf4j-api.jar
10:43:59.550 Std 05200 slf4j-log4j12.jar. Version 1.6.6 Path ./lib/log/slf4j-log4j12.jar
10:43:59.550 Std 05200 metrics-core.jar. Version 3.0.2 Path ./lib/metrics/metrics-core.jar
10:43:59.551 Std 05200 metrics-healthchecks.jar. Version 3.0.2 Path ./lib/metrics/metrics-healthchecks.jar
10:43:59.551 Std 05200 metrics-jvm.jar. Version 3.0.2 Path ./lib/metrics/metrics-jvm.jar
10:43:59.552 Std 05200 metrics-log4j.jar. Version 3.0.2 Path ./lib/metrics/metrics-log4j.jar
10:43:59.552 Std 05200 metrics-servlet.jar. Version 3.0.2 Path ./lib/metrics/metrics-servlet.jar
10:43:59.553 Std 05200 metrics-servlets.jar. Version 3.0.2 Path ./lib/metrics/metrics-servlets.jar
10:43:59.553 Std 05200 metrics-ganglia.jar. Version 3.0.2 Path ./lib/metrics/metrics-ganglia.jar
10:43:59.554 Std 05200 gmetric4j.jar. Version not available Path ./lib/metrics/gmetric4j.jar
10:43:59.554 Std 05200 jrpcgen.jar. Version not available Path ./lib/remotetea/classes/jrpcgen.jar
10:43:59.555 Std 05200 oncrpc.jar. Version not available Path ./lib/remotetea/classes/oncrpc.jar
10:43:59.555 Std 05200 portmap.jar. Version not available Path ./lib/remotetea/classes/portmap.jar
10:43:59.556 Std 05200 org.springframework.beans.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.beans.jar
10:43:59.557 Std 05200 org.springframework.context.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.context.jar
10:43:59.557 Std 05200 org.springframework.core.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.core.jar
10:43:59.558 Std 05200 org.springframework.expression.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.expression.jar
10:43:59.558 Std 05200 org.springframework.jdbc.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.jdbc.jar
10:43:59.559 Std 05200 org.springframework.transaction.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.transaction.jar
10:43:59.559 Std 05200 org.springframework.aop.jar. Version 3.2.1.RELEASE Path ./lib/spring/org.springframework.aop.jar
10:43:59.560 Std 05200 org.restlet.jar. Version not available Path ./lib/restlet/org.restlet.jar
10:43:59.560 Std 05200 org.restlet.ext.json.jar. Version not available Path ./lib/restlet/org.restlet.ext.json.jar
10:43:59.561 Std 05200 org.restlet.ext.xml.jar. Version not available Path ./lib/restlet/org.restlet.ext.xml.jar
10:43:59.561 Std 05200 org.restlet.ext.jetty.jar. Version not available Path ./lib/restlet/org.restlet.ext.jetty.jar
10:43:59.561 Std 05200 org.restlet.ext.slf4j.jar. Version not available Path ./lib/restlet/org.restlet.ext.slf4j.jar
10:43:59.562 Std 05200 org.restlet.ext.ssl.jar. Version not available Path ./lib/restlet/org.restlet.ext.ssl.jar
10:43:59.562 Std 05200 org.restlet.ext.fileupload.jar. Version not available Path ./lib/restlet/org.restlet.ext.fileupload.jar
10:43:59.563 Std 05200 org.restlet.ext.net.jar. Version not available Path ./lib/restlet/org.restlet.ext.net.jar
10:43:59.563 Std 05200 commons-collections.jar. Version 2.1 Path ./lib/apache/commons-collections.jar
10:43:59.564 Std 05200 Jakarta Commons Logging. Version 1.1.1 Path ./lib/apache/commons-logging.jar
10:43:59.564 Std 05200 Commons FileUpload. Version 1.2.2 Path ./lib/apache/commons-fileupload.jar
10:43:59.564 Std 05200 Commons Pool. Version 1.5.6 Path ./lib/apache/commons-pool.jar
10:43:59.565 Std 05200 javax.servlet.jar. Version not available Path ./lib/servlet/javax.servlet.jar
10:43:59.566 Std 05200 org.eclipse.jetty.ajp.jar. Version 8.1.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.ajp.jar
10:43:59.566 Std 05200 org.eclipse.jetty.continuations.jar. Version 7.6.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.continuations.jar
10:43:59.567 Std 05200 org.eclipse.jetty.http.jar. Version 8.1.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.http.jar
10:43:59.567 Std 05200 org.eclipse.jetty.io.jar. Version 8.1.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.io.jar
10:43:59.568 Std 05200 org.eclipse.jetty.server.jar. Version 8.1.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.server.jar
10:43:59.568 Std 05200 org.eclipse.jetty.util.jar. Version 8.1.5.v20120716 Path ./lib/servlet/org.eclipse.jetty.util.jar
10:43:59.569 Std 05200 aopalliance.jar. Version not available Path ./lib/aop/aopalliance.jar
10:43:59.569 Std 05200 AspectJ Weaver Classes. Version 1.6.8 Path ./lib/aop/aspectj.weaver.jar
10:43:59.570 Std 05200 AspectJ Runtime Classes . Version 1.6.5 Path ./lib/aop/aspectjrt.jar
10:43:59.570 Std 05200 xstream.jar. Version not available Path ./lib/processing/xml/xstream.jar
10:43:59.571 Trc 29998 [Ucs-Main] Jar './lib/processing/json/json.jar' has no manifest
10:43:59.571 Std 05200 opencsv.jar. Version 2.3 Path ./lib/processing/csv/opencsv.jar
10:43:59.572 Std 05200 jericho-html.jar. Version not available Path ./lib/processing/html/jericho-html.jar
10:43:59.572 Std 20040 [Ucs-Main] Java: version 1.7.0_79 (Oracle Corporation).
10:43:59.572 Std 20041 [Ucs-Main] Java Runtime Environment: Java(TM) SE Runtime Environment, version 1.7.0_79-b15.
10:43:59.581 Std 20003 [Ucs-Main] Java Virtual Machine: Java HotSpot(TM) 64-Bit Server VM release 24.79-b02 (Oracle Corporation) - mixed mode.
10:43:59.581 Std 20004 [Ucs-Main] JVM default encoding: 'Cp1252'.
10:43:59.581 Trc 20007 [Ucs-Main] System information: 'Windows Server 2008 R2 version 6.1 (level Service Pack 1) - Platform amd64 (64 bits)'.
10:43:59.584 Trc 20008 [Ucs-Main] System locale: 'English (South Africa)'.
10:43:59.584 Trc 20009 [Ucs-Main] System timezone: 'Central African Time (Africa/Harare) / GMT+02:00'.
10:43:59.585 Std 29997 [Ucs-Main] Configured tenants:1 for application 'universalcontactserver'
10:43:59.585 Dbg 29999 [Ucs-Main] Server channel configuration (default)
10:43:59.586 Dbg 29999 [Ucs-Main] GCTI_CONN_IPV6_ON is not set, using configured value for port 6130
10:43:59.587 Dbg 29999 [Ucs-Main] Server channel configured (default) done.
10:43:59.587 Dbg 29999 [Ucs-Main] Using port 6130 for ESP Protocol
10:43:59.609 Dbg 29999 [Ucs-Main] GCTI_CONN_IPV6_ON is not set, Connection to LCA will use JVM options : java.net.preferIPv4Stack=false java.net.preferIPv6Addresses=false
10:43:59.615 Std 29997 [Ucs-Main] Can't setup LCA: Only loopback (localhost or ::1) connection is supported
com.genesyslab.platform.commons.protocol.ProtocolException: Only loopback (localhost or ::1) connection is supported
at com.genesyslab.platform.management.protocol.LocalControlAgentProtocol.<init>(LocalControlAgentProtocol.java:104)
at com.genesyslab.icc.util.localcontrolagent.LocalControlAgentPSDK.<init>(LocalControlAgentPSDK.java:131)
at com.genesyslab.icc.util.Server.setupLCA(Server.java:279)
at com.genesyslab.icc.contactserver.ContactServerEngine.initInstance(ContactServerEngine.java:523)
at com.genesyslab.icc.contactserver.ContactServerEngine$4.run(ContactServerEngine.java:1395)
at java.lang.Thread.run(Thread.java:745)
10:43:59.617 Dbg 29999 [Ucs-Main] Registering DataAccessPoint 'dapucs' with role 'Main'
10:43:59.622 Std 29997 [Ucs-Main] Ignoring invalid value 'null' for max-connections
10:43:59.624 Std 29997 [Ucs-Main] 'universalcontactserver' on 'dapucs' properties: (dbcase=any) (dbengine=mssql) (port=1433) (dbname=gen_ucs) (appname='universalcontactserver' on 'dapucs') (role=Main) (username=sa) (dbserver=demosrv) (Role=Main) (jdbc-debug=FALSE) (password=****) (query-timeout=15)
10:43:59.645 Std 29997 [Ucs-Main] DataSource(com.microsoft.sqlserver.jdbc.SQLServerDataSource) properties: (portnumber=1433) (databasename=gen_ucs) (applicationname='universalcontactserver' on 'dapucs') (servername=demosrv) (user=sa) (password=****)
10:43:59.692 Std 29997 [Ucs-Main] ConnectionPool(com.jolbox.bonecp.BoneCPDataSource) properties: (minconnectionsperpartition=1) (idleconnectiontestperiodinminutes=1) (maxconnectionsperpartition=40) (partitioncount=1) (jdbcurl=jdbc:sqlserver://demosrv:1433;databaseName=gen_ucs;) (poolname=Main) (acquireincrement=5) (disableconnectiontracking=true) (password=****) (statementscachesize=0) (username=sa) (connectionteststatement=select 1) (idlemaxageinminutes=5) (connectiontimeoutinms=30000) (user=sa)
10:43:59.692 Std 21136 [Ucs-Main] Using '7200' for transaction timeout to be consistent with query and long query timeout.
10:43:59.692 Trc 29998 [Ucs-Main] JDBC debug is off
10:43:59.693 Std 29997 [Ucs-Main] Checking DB schema for 'dapucs' with role 'Main'
10:43:59.693 Dbg 29999 [Ucs-Main] [Main DS] Acquiring new connection from pool (queue size: 1 )
10:43:59.694 Dbg 29999 [Ucs-Main] JDBC URL = jdbc:sqlserver://demosrv:1433;databaseName=gen_ucs;, Username = sa, partitions = 1, max (per partition) = 40, min (per partition) = 1, idle max age = 5 min, idle test period = 1 min, strategy = DEFAULT
10:43:59.886 Dbg 29999 [Ucs-Main] [Main DS] Acquired new connection (425099819@txn-null) from pool in 191 ms
10:43:59.933 Trc 29998 [Ucs-Main] Datasource configured with driver 'Microsoft JDBC Driver 4.0 for SQL Server' (4.0.2206.100) on 'Microsoft SQL Server' (10.00.1600) with txn isolation level 'TRANSACTION_READ_COMMITTED' as sa
10:43:59.934 Trc 29998 [Ucs-Main] NLS Parameters Dump:
10:43:59.946 Dbg 29999 [Ucs-Main] Executing request: SELECT convert(varchar(100), DATABASEPROPERTYEX (?, 'Collation'))
10:43:59.959 Trc 29998 [Ucs-Main] Collation used for non unicode character columns:Latin1_General_CI_AS
10:43:59.962 Dbg 29999 [Ucs-Main] Listing tables:
10:43:59.973 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Attachment'
10:43:59.976 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Callback'
10:43:59.980 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Category'
10:43:59.983 Dbg 29999 [Ucs-Main] Retrieving schema of table 'CategoryAttribute'
10:43:59.987 Dbg 29999 [Ucs-Main] Retrieving schema of table 'CategoryRoot'
10:43:59.989 Dbg 29999 [Ucs-Main] Retrieving schema of table 'CategoryStructure'
10:43:59.992 Dbg 29999 [Ucs-Main] Retrieving schema of table 'CategoryStructureData'
10:43:59.995 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Chat'
10:43:59.997 Dbg 29999 [Ucs-Main] Retrieving schema of table 'CoBrowseURL'
10:44:00.000 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Contact'
10:44:00.005 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ContactArchiveSynchro'
10:44:00.008 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ContactAttribute'
10:44:00.014 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ContactAttributeMetaData'
10:44:00.018 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Document'
10:44:00.020 Dbg 29999 [Ucs-Main] Retrieving schema of table 'EmailIn'
10:44:00.023 Dbg 29999 [Ucs-Main] Retrieving schema of table 'EmailOut'
10:44:00.026 Dbg 29999 [Ucs-Main] Retrieving schema of table 'EmRoute'
10:44:00.030 Dbg 29999 [Ucs-Main] Retrieving schema of table 'FieldCode'
10:44:00.032 Dbg 29999 [Ucs-Main] Retrieving schema of table 'FieldValue'
10:44:00.035 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IdGenerator'
10:44:00.037 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IdSequences'
10:44:00.039 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IndexEvent'
10:44:00.041 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IntegrityReport'
10:44:00.046 Dbg 29999 [Ucs-Main] Retrieving schema of table 'Interaction'
10:44:00.056 Dbg 29999 [Ucs-Main] Retrieving schema of table 'InteractionMergeHistory'
10:44:00.059 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IxnAttributeMetaData'
10:44:00.064 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IxnContent'
10:44:00.066 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IxnContentSentReceived'
10:44:00.069 Dbg 29999 [Ucs-Main] Retrieving schema of table 'IxnExtensionMetaData'
10:44:00.076 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_CategoryStatistics'
10:44:00.085 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_ConfusionMatrix'
10:44:00.116 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_EmailClassificationResult'
10:44:00.125 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_FAQObject'
10:44:00.134 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_FAQObjectCategories'
10:44:00.143 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_GlobalStatistics'
10:44:00.153 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_Model'
10:44:00.163 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_TestingResult'
10:44:00.179 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_TrainingDataObject'
10:44:00.188 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_TrainingEmail'
10:44:00.198 Dbg 29999 [Ucs-Main] Retrieving schema of table 'kt_TrainingJob'
10:44:00.208 Dbg 29999 [Ucs-Main] Retrieving schema of table 'LookupTableMetaData'
10:44:00.210 Dbg 29999 [Ucs-Main] Retrieving schema of table 'MergeHistory'
10:44:00.213 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PhoneCall'
10:44:00.216 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PIIGroup'
10:44:00.220 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PIIGroupContent'
10:44:00.222 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PIIRegEx'
10:44:00.224 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PIIRule'
10:44:00.226 Dbg 29999 [Ucs-Main] Retrieving schema of table 'PIITestMessage'
10:44:00.228 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ProfileExtensionMetaData'
10:44:00.231 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ResourceProperty'
10:44:00.233 Dbg 29999 [Ucs-Main] Retrieving schema of table 'SchemaHistory'
10:44:00.235 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ServiceCompleted'
10:44:00.237 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ServiceExtensionMetaData'
10:44:00.239 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ServiceStarted'
10:44:00.242 Dbg 29999 [Ucs-Main] Retrieving schema of table 'ServiceStartedAnonymous'
10:44:00.245 Dbg 29999 [Ucs-Main] Retrieving schema of table 'SNRelation'
10:44:00.247 Dbg 29999 [Ucs-Main] Retrieving schema of table 'SNRelationAction'
10:44:00.249 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StandardResponse'
10:44:00.253 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StandardResponseFavorite'
10:44:00.254 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StandardResponseUsage'
10:44:00.256 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StateCompleted'
10:44:00.258 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StateExtensionMetaData'
10:44:00.260 Dbg 29999 [Ucs-Main] Retrieving schema of table 'StateStarted'
10:44:00.263 Dbg 29999 [Ucs-Main] Retrieving schema of table 'SubTenantMetaData'
10:44:00.265 Dbg 29999 [Ucs-Main] Retrieving schema of table 'SystemParam'
10:44:00.267 Dbg 29999 [Ucs-Main] Retrieving schema of table 'TaskCompleted'
10:44:00.270 Dbg 29999 [Ucs-Main] Retrieving schema of table 'TaskExtensionMetaData'
10:44:00.272 Dbg 29999 [Ucs-Main] Retrieving schema of table 'TaskStarted'
10:44:00.277 Dbg 29999 [Ucs-Main]
Attachment:
Id nvarchar(16) nullable:false
DocumentId nvarchar(16) nullable:false
EntityId nvarchar(16) nullable:false
EntityTypeId tinyint(3) nullable:false
PK_ATTACHMENT on Id Attachment_EntityId_I on EntityId Attachment_EntType_I on EntityTypeId IsAttached_FK on DocumentId
Callback:
Id nvarchar(16) nullable:false
CallBackStatus int(10) nullable:true
DetailedDescription ntext(1073741823) nullable:true
CustomData ntext(1073741823) nullable:true
DesiredResponseType int(10) nullable:false
StartTime datetime(23) nullable:false
EndTime datetime(23) nullable:true
CustomerNumber varchar(32) nullable:false
Attempts int(10) nullable:false
DN varchar(32) nullable:true
Location nvarchar(32) nullable:true
CallbackServerID varchar(256) nullable:true
CallResult tinyint(3) nullable:true
TheType tinyint(3) nullable:true
PK_CALLBACK on Id
Category:
Id nvarchar(16) nullable:false
TheName nvarchar(254) nullable:false
OwnerId int(10) nullable:false
ModifiedDate datetime(23) nullable:false
Status varchar(64) nullable:false
TheType tinyint(3) nullable:false
Description nvarchar(254) nullable:true
PK_CATEGORY on Id Category_TheName_I on TheName
CategoryAttribute:
Id nvarchar(16) nullable:false
CategoryId nvarchar(16) nullable:true
TheName nvarchar(256) nullable:false
TheType tinyint(3) nullable:false
StrValue nvarchar(256) nullable:true
LongStrValue ntext(1073741823) nullable:true
BinValue image(2147483647) nullable:true
IntValue int(10) nullable:true
IdValue nvarchar(16) nullable:true
PK_CATEGORYATTRIBUTE on Id HasAttribute_FK on CategoryId
CategoryRoot:
Id nvarchar(16) nullable:false
CategoryId nvarchar(16) nullable:false
TheName nvarchar(254) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
PK_CATEGORYROOT on Id IsRootCategory_FK on CategoryId
CategoryStructure:
Id nvarchar(16) nullable:false
CategoryParentId nvarchar(16) nullable:false
CategoryChildId nvarchar(16) nullable:false
PK_CATEGORYSTRUCTURE on Id CategoryStructure_CategoryChildId_I on CategoryChildId CategoryStructure_CategoryParentId_I on CategoryParentId
CategoryStructureData:
Id nvarchar(16) nullable:false
OwnerId nvarchar(16) nullable:false
ObjectClassName varchar(256) nullable:false
ObjectId nvarchar(16) nullable:false
PK_CATEGORYSTRUCTUREDATA on Id CategoryStructureData_ObjectId_I on ObjectId CategoryStructureData_OwnerId_I on OwnerId
Chat:
Id nvarchar(16) nullable:false
EstablishedDate datetime(23) nullable:true
ReleasedDate datetime(23) nullable:true
PK_CHAT on Id
CoBrowseURL:
Id nvarchar(16) nullable:false
InteractionId nvarchar(16) nullable:false
URL varchar(255) nullable:false
VisitedDate datetime(23) nullable:false
PK_COBROWSEURL on Id Includes_FK on InteractionId
Contact:
Id nvarchar(16) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
IsExternalResource bit(1) nullable:true
StrAttribute1 nvarchar(256) nullable:true
StrAttribute2 nvarchar(256) nullable:true
StrAttribute3 nvarchar(256) nullable:true
StrAttribute4 nvarchar(256) nullable:true
StrAttribute5 nvarchar(256) nullable:true
StrAttribute6 nvarchar(256) nullable:true
StrAttribute7 nvarchar(256) nullable:true
StrAttribute8 nvarchar(256) nullable:true
StrAttribute9 nvarchar(256) nullable:true
StrAttribute10 nvarchar(256) nullable:true
DateAttribute1 datetime(23) nullable:true
DateAttribute2 datetime(23) nullable:true
DateAttribute3 datetime(23) nullable:true
CreatedDate datetime(23) nullable:true
ModifiedDate datetime(23) nullable:true
MergeId nvarchar(16) nullable:true
PK_CONTACT on Id
ContactArchiveSynchro:
Id nvarchar(16) nullable:false
OperationDate datetime(23) nullable:false
Operation smallint(5) nullable:false
SrcContactId nvarchar(16) nullable:true
DestinationContactId nvarchar(16) nullable:true
MergeId nvarchar(16) nullable:true
PK_CONTACTARCHIVESYNCHRO on Id DestinationContactId_I on DestinationContactId MergeId_I on MergeId OperationDate_I on OperationDate SrcContactId_I on SrcContactId
ContactAttribute:
Id nvarchar(16) nullable:false
ContactId nvarchar(16) nullable:true
AttributeId nvarchar(16) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
AttributeName nvarchar(256) nullable:true
MimeType varchar(256) nullable:true
StrValue nvarchar(256) nullable:true
StrValueLowerCase nvarchar(256) nullable:true
BinValue image(2147483647) nullable:true
DateValue datetime(23) nullable:true
Description nvarchar(256) nullable:true
IsPrimary bit(1) nullable:false
PK_CONTACTATTRIBUTE on Id ContactAttribute_StrValue_I on StrValue ContactAttribute_StrValueLowerCase_I on StrValueLowerCase HasAttrib_FK on ContactId
ContactAttributeMetaData:
Id nvarchar(16) nullable:false
TheName nvarchar(256) nullable:false
DisplayName nvarchar(256) nullable:true
TheType tinyint(3) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Active bit(1) nullable:false
ModifiedDate datetime(23) nullable:false
Format nvarchar(256) nullable:true
IsSearchable bit(1) nullable:false
IsCaseSensitive bit(1) nullable:false
IsSortable bit(1) nullable:false
MappingColumnName varchar(20) nullable:true
SearchLevel tinyint(3) nullable:true
Cardinality tinyint(3) nullable:true
PK_CONTACTATTRIBUTEMETADATA on Id
Document:
Id nvarchar(16) nullable:false
MimeType varchar(256) nullable:false
TheName nvarchar(256) nullable:false
Description nvarchar(256) nullable:true
TheSize int(10) nullable:false
Content image(2147483647) nullable:true
PK_DOCUMENT on Id
EmailIn:
Id nvarchar(16) nullable:false
FromAddress nvarchar(256) nullable:true
FromPersonal nvarchar(256) nullable:true
ReplyToAddress nvarchar(256) nullable:true
ToAddresses ntext(1073741823) nullable:true
CcAddresses ntext(1073741823) nullable:true
BccAddresses ntext(1073741823) nullable:true
SentDate datetime(23) nullable:true
Mailbox nvarchar(256) nullable:false
WhichRuleMatched nvarchar(16) nullable:true
EmailOutId nvarchar(16) nullable:true
Header image(2147483647) nullable:true
PK_EMAILIN on Id
EmailOut:
Id nvarchar(16) nullable:false
FromAddress nvarchar(256) nullable:true
FromPersonal nvarchar(256) nullable:true
ReplyToAddress nvarchar(256) nullable:true
ToAddresses ntext(1073741823) nullable:true
CcAddresses ntext(1073741823) nullable:true
BccAddresses ntext(1073741823) nullable:true
SentDate datetime(23) nullable:true
Forward int(10) nullable:false
ReferenceId varchar(255) nullable:true
ReviewerId int(10) nullable:true
StandardResponseId nvarchar(16) nullable:true
PK_EMAILOUT on Id
EmRoute:
Id nvarchar(16) nullable:false
AddressesToMatch ntext(1073741823) nullable:true
Description nvarchar(254) nullable:false
IsEnabled bit(1) nullable:false
MatchText ntext(1073741823) nullable:true
MatchTextInHeader bit(1) nullable:false
MatchTextInBody bit(1) nullable:false
MatchTextInSubject bit(1) nullable:false
TheOrder int(10) nullable:false
LogicalRule varchar(254) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
PK_EMROUTE on Id
FieldCode:
Id nvarchar(16) nullable:false
TheName nvarchar(128) nullable:false
Value nvarchar(1024) nullable:false
TheComment nvarchar(256) nullable:true
PK_FIELDCODE on Id
FieldValue:
Id nvarchar(16) nullable:false
TheName nvarchar(128) nullable:false
TheType tinyint(3) nullable:false
IsConstant bit(1) nullable:false
TheComment nvarchar(256) nullable:true
StrValue nvarchar(256) nullable:true
IntValue int(10) nullable:true
DoubleValue float(53) nullable:true
DateValue datetime(23) nullable:true
PK_FIELDVALUE on Id FieldValue_TheName_I on TheName
IdGenerator:
Id int(10) nullable:false
Ordinal int(10) nullable:false
PK_IDGENERATOR on Id
IdSequences:
Id int(10) nullable:false
Seed numeric(18) nullable:false
IndexEvent:
Id nvarchar(16) nullable:false
IndexName nvarchar(20) nullable:false
EventDate datetime(23) nullable:false
Operation tinyint(3) nullable:false
ProcessedPri bit(1) nullable:false
ProcessedBck bit(1) nullable:false
PK_Index_Event on Id
IntegrityReport:
Id nvarchar(16) nullable:false
IssueId tinyint(3) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
DetectionDate datetime(23) nullable:false
CorrectionDate datetime(23) nullable:true
FirstId nvarchar(16) nullable:false
SecondId nvarchar(16) nullable:true
Status bit(1) nullable:false
SessionId int(10) nullable:false
PK_INTEGRITYREPORT on Id IR_Composite_1 on FirstId IR_Composite_1 on IssueId IR_Composite_2 on IssueId IR_Composite_2 on TenantId IR_Composite_2 on Status IR_Composite_3 on SecondId IR_Composite_3 on IssueId
Interaction:
Id nvarchar(16) nullable:false
Status tinyint(3) nullable:false
EntityTypeId tinyint(3) nullable:false
MediaTypeId nvarchar(32) nullable:false
TypeId nvarchar(32) nullable:false
SubtypeId nvarchar(32) nullable:true
ExternalId nvarchar(256) nullable:true
OwnerId int(10) nullable:true
ContactId nvarchar(16) nullable:true
ParentId nvarchar(16) nullable:true
StartDate datetime(23) nullable:false
ModifiedDate datetime(23) nullable:true
EndDate datetime(23) nullable:true
ThreadId nvarchar(16) nullable:true
CategoryId nvarchar(16) nullable:true
Timeshift smallint(5) nullable:true
Subject nvarchar(512) nullable:true
Text ntext(1073741823) nullable:true
StructuredText ntext(1073741823) nullable:true
StructTextMimeType varchar(256) nullable:true
TheComment ntext(1073741823) nullable:true
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
ThreadHash int(10) nullable:true
CanBeParent bit(1) nullable:false
CreatorAppId int(10) nullable:false
QueueName nvarchar(64) nullable:true
AllAttributes image(2147483647) nullable:true
StrAttribute1 nvarchar(256) nullable:true
StrAttribute2 nvarchar(256) nullable:true
StrAttribute3 nvarchar(256) nullable:true
StrAttribute4 nvarchar(256) nullable:true
StrAttribute5 nvarchar(256) nullable:true
StrAttribute6 nvarchar(256) nullable:true
StrAttribute7 nvarchar(256) nullable:true
StrAttribute8 nvarchar(256) nullable:true
StrAttribute9 nvarchar(256) nullable:true
StrAttribute10 nvarchar(256) nullable:true
IntAttribute1 int(10) nullable:true
IntAttribute2 int(10) nullable:true
IntAttribute3 int(10) nullable:true
IntAttribute4 int(10) nullable:true
IntAttribute5 int(10) nullable:true
IsSpam bit(1) nullable:true
WebSafeEmailStatus nvarchar(32) nullable:true
IsCategoryApproved bit(1) nullable:true
StoppedReason nvarchar(64) nullable:true
Lang varchar(64) nullable:true
PK_INTERACTION on Id Assigned_FK on ContactId Interaction_ExternalId_I on ExternalId Interaction_ThreadHash_I on ThreadHash Interaction_ThreadId_I on ThreadId IsParent_FK on ParentId Ixn_Composite_1 on Status Ixn_Composite_1 on EntityTypeId Ixn_Composite_1 on TypeId Ixn_Composite_1 on CreatorAppId Ixn_Composite_1 on MediaTypeId Ixn_Composite_1 on StartDate Ixn_Composite_1 on TenantId Ixn_Composite_Arch1 on EndDate Ixn_Composite_Arch1 on Status Ixn_Composite_Arch1 on TenantId Ixn_Composite_Arch1 on ParentId Ixn_Composite_KM1 on EndDate Ixn_Composite_KM1 on CategoryId Ixn_Composite_KM1 on IsCategoryApproved Ixn_OwnerId on OwnerId Ixn_OwnerId on Status Ixn_OwnerId on StartDate
InteractionMergeHistory:
Id nvarchar(16) nullable:false
MergeId nvarchar(16) nullable:false
InteractionId nvarchar(16) nullable:false
PK_INTERACTIONMERGEHISTORY on Id InteractionId_I on InteractionId MergeHistoryHasInteraction_FK on MergeId
IxnAttributeMetaData:
Id nvarchar(16) nullable:false
TheName nvarchar(256) nullable:false
DisplayName nvarchar(256) nullable:true
TheType tinyint(3) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Active bit(1) nullable:false
ModifiedDate datetime(23) nullable:false
Format nvarchar(256) nullable:true
IsSortable bit(1) nullable:false
MappingColumnName varchar(20) nullable:true
PK_IXNATTRIBUTEMETADATA on Id
IxnContent:
Id nvarchar(16) nullable:false
MimeType varchar(256) nullable:false
TheSize int(10) nullable:false
Content image(2147483647) nullable:false
PK_IXNCONTENT on Id
IxnContentSentReceived:
Id nvarchar(16) nullable:false
MimeType varchar(256) nullable:false
TheSize int(10) nullable:false
Content image(2147483647) nullable:false
PK_IXNCONTENTSENTRECEIVED on Id
IxnExtensionMetaData:
ExtensionName varchar(32) nullable:false
ExtensionType varchar(32) nullable:false
ExtensionLength int(10) nullable:true
AttributeName varchar(32) nullable:false
AttributeType varchar(32) nullable:false
AttributeDefault varchar(32) nullable:true
AttributeLength int(10) nullable:false
AttributeEncrypt bit(1) nullable:false
AttributeUnique bit(1) nullable:false
AttributeNullable bit(1) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
kt_CategoryStatistics:
Id nvarchar(16) nullable:false
TestingResultId nvarchar(16) nullable:false
ConfidenceLevel float(53) nullable:false
ClassificationCategoryId nvarchar(16) nullable:false
ValueName varchar(64) nullable:false
Value float(53) nullable:false
PK_KT_CATEGORYSTATISTICS on Id TestingResultHasCatStatistics_FK on TestingResultId
kt_ConfusionMatrix:
Id nvarchar(16) nullable:false
TestingResultId nvarchar(16) nullable:false
ClassificationCategoryId1 nvarchar(16) nullable:false
ClassificationCategoryId2 nvarchar(16) nullable:false
Value float(53) nullable:false
TheSize float(53) nullable:false
PK_KT_CONFUSIONMATRIX on Id TestingResultHasConfusionMatrix_FK on TestingResultId
kt_EmailClassificationResult:
Id nvarchar(16) nullable:false
TestingResultId nvarchar(16) nullable:false
TrainingEmailId nvarchar(16) nullable:false
ClassificationCategoryId nvarchar(16) nullable:false
ConfidenceLevel float(53) nullable:true
PK_KT_EMAILCLASSIFICATIONRESUL on Id TestingResultHasEmailClassificationResult_FK on TestingResultId
kt_FAQObject:
Id nvarchar(16) nullable:false
FAQName nvarchar(16) nullable:false
RootCategoryId nvarchar(16) nullable:false
CreationDate datetime(23) nullable:false
OwnerId int(10) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
TOId nvarchar(16) nullable:true
ModelId nvarchar(16) nullable:true
Info nvarchar(255) nullable:true
PK_KT_FAQOBJECT on Id
kt_FAQObjectCategories:
Id nvarchar(16) nullable:false
FAQId nvarchar(16) nullable:false
CategoryId nvarchar(16) nullable:false
Info nvarchar(255) nullable:true
PK_KT_FAQOBJECTCATEGORIES on Id
kt_GlobalStatistics:
Id nvarchar(16) nullable:false
TestingResultId nvarchar(16) nullable:false
TheType varchar(64) nullable:false
ConfidenceLevel float(53) nullable:false
ValueName varchar(64) nullable:false
Value float(53) nullable:false
PK_KT_GLOBALSTATISTICS on Id TestingResultHasGlobalStatistics_FK on TestingResultId
kt_Model:
Id nvarchar(16) nullable:false
TheName nvarchar(255) nullable:false
Model image(2147483647) nullable:false
CreationDate datetime(23) nullable:false
TrainingDataObjectId nvarchar(16) nullable:false
IsActive bit(1) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
ModelSize int(10) nullable:true
RunDate datetime(23) nullable:true
RunDurationSec int(10) nullable:true
AppName varchar(64) nullable:true
Engine varchar(64) nullable:true
PersonId int(10) nullable:true
Params varchar(255) nullable:true
RootName nvarchar(255) nullable:true
AdvancedParams image(2147483647) nullable:true
PK_KT_MODEL on Id TrainingDataObjectHasModel_FK on TrainingDataObjectId
kt_TestingResult:
Id nvarchar(16) nullable:false
TheName nvarchar(255) nullable:false
CreationTime datetime(23) nullable:false
ModelId nvarchar(16) nullable:false
TrainingDataObjectId nvarchar(16) nullable:false
TheType varchar(64) nullable:false
PK_KT_TESTINGRESULT on Id TestingResultHasModel_FK on ModelId TrainingDataObjectHasTestingResult_FK on TrainingDataObjectId
kt_TrainingDataObject:
Id nvarchar(16) nullable:false
TheName nvarchar(255) nullable:false
CreationTime datetime(23) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
StartTime datetime(23) nullable:false
EndTime datetime(23) nullable:false
RootName nvarchar(255) nullable:false
PK_KT_TRAININGDATAOBJECT on Id
kt_TrainingEmail:
Id nvarchar(16) nullable:false
Subject nvarchar(512) nullable:false
AgentId int(10) nullable:true
ReceivedDate datetime(23) nullable:false
Text ntext(1073741823) nullable:false
CategoryId nvarchar(16) nullable:false
TrainingDataObjectId nvarchar(16) nullable:false
ResponseText ntext(1073741823) nullable:true
PK_KT_TRAININGEMAIL on Id TrainingDataHasEmail_FK on TrainingDataObjectId TrainingEmailHasCategory_FK on CategoryId
kt_TrainingJob:
Id nvarchar(16) nullable:false
TheType varchar(64) nullable:false
StartTime datetime(23) nullable:false
TrainingDataObjectId nvarchar(16) nullable:false
Status int(10) nullable:false
ErrorMsg varchar(255) nullable:true
ModelId nvarchar(16) nullable:false
ModelName nvarchar(64) nullable:false
TestingResultId nvarchar(16) nullable:false
TestingResultName nvarchar(255) nullable:false
Engine varchar(64) nullable:true
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Lang varchar(64) nullable:false
Params varchar(255) nullable:true
PersonId int(10) nullable:false
RootName nvarchar(255) nullable:true
AdvancedParams image(2147483647) nullable:true
InternalService nvarchar(255) nullable:true
PK_KT_TRAININGJOB on Id TestingResultHasTrainingJob_FK on TestingResultId TrainingDataObjectHasTrainingJob_FK on TrainingDataObjectId
LookupTableMetaData:
KeyName varchar(32) nullable:false
CreationDate datetime(23) nullable:false
ColumnName varchar(32) nullable:false
ColumnDataType varchar(32) nullable:false
ColumnFunction varchar(32) nullable:false
ColumnIndex int(10) nullable:false
ColumnSource varchar(32) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
MergeHistory:
Id nvarchar(16) nullable:false
AgentId int(10) nullable:true
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
MergeDate datetime(23) nullable:false
SourceContactId nvarchar(16) nullable:true
DestinationContactId nvarchar(16) nullable:true
SrcContactContent image(2147483647) nullable:false
DstContactContent image(2147483647) nullable:false
Validated bit(1) nullable:false
Reason nvarchar(512) nullable:true
Description nvarchar(512) nullable:true
PK_MERGEHISTORY on Id DstContactId_I on DestinationContactId SourceContactId_I on SourceContactId
PhoneCall:
Id nvarchar(16) nullable:false
Duration int(10) nullable:true
Outcome varchar(100) nullable:true
PhoneNumber nvarchar(30) nullable:true
TConnectionId nvarchar(16) nullable:true
PK_PHONECALL on Id TConnId_I on TConnectionId
PIIGroup:
Id nvarchar(16) nullable:false
Name nvarchar(254) nullable:false
Description nvarchar(254) nullable:true
Type nvarchar(16) nullable:false
CategoryId nvarchar(16) nullable:true
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
PK_PIIGroup on Id
PIIGroupContent:
Id nvarchar(16) nullable:false
PIIGroupId nvarchar(16) nullable:false
PIIRuleId nvarchar(16) nullable:false
PIIRuleStatus nvarchar(254) nullable:false
PIIRulePriority int(10) nullable:false
PK_PIIGroupContent on Id
PIIRegEx:
Id nvarchar(16) nullable:false
Name nvarchar(254) nullable:false
Description nvarchar(254) nullable:true
Properties ntext(1073741823) nullable:true
Expression ntext(1073741823) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
PK_PIIRegEx on Id
PIIRule:
Id nvarchar(16) nullable:false
Name nvarchar(254) nullable:false
Description nvarchar(254) nullable:true
RegExId nvarchar(16) nullable:false
ReplacementPattern ntext(1073741823) nullable:true
Actions ntext(1073741823) nullable:true
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
PK_PIIRule on Id
PIITestMessage:
Id nvarchar(16) nullable:false
RelatedObjectId nvarchar(16) nullable:false
RelatedObjectType nvarchar(64) nullable:false
Name nvarchar(254) nullable:false
Description nvarchar(254) nullable:true
Text ntext(1073741823) nullable:true
PK_PIITestMessage on Id
ProfileExtensionMetaData:
ExtensionName varchar(32) nullable:false
ExtensionType varchar(32) nullable:false
ExtensionLength int(10) nullable:true
AttributeName varchar(32) nullable:false
AttributeType varchar(32) nullable:false
AttributeDefault varchar(32) nullable:true
AttributeLength int(10) nullable:false
AttributeEncrypt bit(1) nullable:false
AttributeUnique bit(1) nullable:false
AttributeNullable bit(1) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
ResourceProperty:
Id nvarchar(16) nullable:false
PersonId int(10) nullable:false
TheKey nvarchar(256) nullable:false
IsString bit(1) nullable:false
StrValue nvarchar(256) nullable:true
BinValue image(2147483647) nullable:true
PK_RESOURCEPROPERTY on Id
SchemaHistory:
Id nvarchar(16) nullable:false
Timestamp datetime(23) nullable:false
Version char(11) nullable:false
Description varchar(256) nullable:true
PK_SCHEMAHISTORY on Id
ServiceCompleted:
ServiceId numeric(19) nullable:false
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
EndTime datetime(23) nullable:false
Disposition int(10) nullable:true
DispositionDescription nvarchar(64) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
PK_SERVICECOMPLETED on ServiceId
ServiceExtensionMetaData:
ExtensionName varchar(32) nullable:false
ExtensionType varchar(32) nullable:false
ExtensionLength int(10) nullable:true
AttributeName varchar(32) nullable:false
AttributeType varchar(32) nullable:false
AttributeDefault varchar(32) nullable:true
AttributeLength int(10) nullable:false
AttributeEncrypt bit(1) nullable:false
AttributeUnique bit(1) nullable:false
AttributeNullable bit(1) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
ServiceStarted:
ServiceId numeric(19) nullable:false
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
StartTime datetime(23) nullable:false
EstimatedDuration int(10) nullable:true
ServiceType int(10) nullable:false
CustomerId nvarchar(16) nullable:false
StartedAnonymousFlag tinyint(3) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
PK_SERVICESTARTED on ServiceId ServiceStarted_CustomerId_I on CustomerId
ServiceStartedAnonymous:
ServiceId numeric(19) nullable:false
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
StartTime datetime(23) nullable:false
EstimatedDuration int(10) nullable:true
ServiceType int(10) nullable:false
ContactKey nvarchar(16) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
PK_SERVICESTARTEDANONYMOUS on ServiceId ServiceStartedA_ContactKey_I on ContactKey
SNRelation:
Id nvarchar(16) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
SocialNetwork nvarchar(20) nullable:false
ServiceAccount nvarchar(100) nullable:false
ClientAccount nvarchar(100) nullable:false
Relation nvarchar(20) nullable:false
Source nvarchar(100) nullable:false
UpdatedAt datetime(23) nullable:false
PK_SNRelation on Id SNRCLTAccountI on ClientAccount
SNRelationAction:
Id nvarchar(16) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
SocialNetwork nvarchar(20) nullable:false
ServiceAccount nvarchar(100) nullable:false
Action nvarchar(20) nullable:false
Actor nvarchar(100) nullable:false
StartedAt datetime(23) nullable:false
FinishedAt datetime(23) nullable:true
Progress nvarchar(50) nullable:true
PK_SNRelationAction on Id
StandardResponse:
Id nvarchar(16) nullable:false
StandardResponseId nvarchar(16) nullable:false
Body ntext(1073741823) nullable:true
StructuredBody ntext(1073741823) nullable:true
TheName nvarchar(254) nullable:false
Description nvarchar(254) nullable:true
IsActive bit(1) nullable:false
AckUsageType tinyint(3) nullable:false
AutoRespUsageType tinyint(3) nullable:false
AgentDesktopUsageType tinyint(3) nullable:false
WSSUsageType tinyint(3) nullable:false
EmailOutUsageType tinyint(3) nullable:false
VoiceAutoRespUsageType tinyint(3) nullable:false
Version smallint(5) nullable:false
OwnerId int(10) nullable:false
ModifiedDate datetime(23) nullable:false
Status varchar(80) nullable:false
ExpirationDate datetime(23) nullable:true
Lang varchar(64) nullable:false
TenantId int(10) nullable:false
SubTenantId int(10) nullable:true
Subject nvarchar(512) nullable:true
StartDate datetime(23) nullable:true
MimeType varchar(256) nullable:true
CustomFieldCodes ntext(1073741823) nullable:true
AreFieldCodesParsed bit(1) nullable:false
PK_STANDARDRESPONSE on Id StandardResponse_StdRespId_I on StandardResponseId
StandardResponseFavorite:
Id nvarchar(16) nullable:false
StandardResponseId nvarchar(16) nullable:false
PersonId int(10) nullable:false
PK_STANDARDRESPONSEFAVORITE on Id CanBeA_FK on StandardResponseId
StandardResponseUsage:
Id nvarchar(16) nullable:false
StandardResponseId nvarchar(16) nullable:false
EntityTypeId tinyint(3) nullable:false
EntityId nvarchar(16) nullable:false
ResponseType int(10) nullable:false
PersonId int(10) nullable:false
StartDate datetime(23) nullable:false
PK_STANDARDRESPONSEUSAGE on Id
StateCompleted:
ServiceId numeric(19) nullable:false
StateId int(10) nullable:false
EndTime datetime(23) nullable:false
Disposition int(10) nullable:true
DispositionDescription nvarchar(64) nullable:true
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
StateCompleted_ServiceId_I on ServiceId
StateExtensionMetaData:
ExtensionName varchar(32) nullable:false
ExtensionType varchar(32) nullable:false
ExtensionLength int(10) nullable:true
AttributeName varchar(32) nullable:false
AttributeType varchar(32) nullable:false
AttributeDefault varchar(32) nullable:true
AttributeLength int(10) nullable:false
AttributeEncrypt bit(1) nullable:false
AttributeUnique bit(1) nullable:false
AttributeNullable bit(1) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
StateStarted:
ServiceId numeric(19) nullable:false
StateId int(10) nullable:false
StateType int(10) nullable:false
PreviousStateId int(10) nullable:true
StartTime datetime(23) nullable:false
EstimatedDuration int(10) nullable:true
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
StateStarted_ServiceId_I on ServiceId
SubTenantMetaData:
TenantId int(10) nullable:false
SubTenantId int(10) nullable:false
Id nvarchar(256) nullable:false
TheName nvarchar(256) nullable:false
FolderName nvarchar(256) nullable:true
Active bit(1) nullable:false
ModifiedDate datetime(23) nullable:false
PK_SUBTENANTEMETADATA on Id PK_SUBTENANTEMETADATA on TenantId
SystemParam:
KeyName nvarchar(256) nullable:false
Value nvarchar(1024) nullable:true
PK_SYSTEMPARAM on KeyName
TaskCompleted:
ServiceId numeric(19) nullable:false
TaskId int(10) nullable:false
StateId int(10) nullable:true
EndTime datetime(23) nullable:false
Disposition int(10) nullable:true
DispositionDescription nvarchar(64) nullable:true
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
TaskCompleted_ServiceId_I on ServiceId
TaskExtensionMetaData:
ExtensionName varchar(32) nullable:false
ExtensionType varchar(32) nullable:false
ExtensionLength int(10) nullable:true
AttributeName varchar(32) nullable:false
AttributeType varchar(32) nullable:false
AttributeDefault varchar(32) nullable:true
AttributeLength int(10) nullable:false
AttributeEncrypt bit(1) nullable:false
AttributeUnique bit(1) nullable:false
AttributeNullable bit(1) nullable:false
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
TaskStarted:
ServiceId numeric(19) nullable:false
TaskId int(10) nullable:false
StateId int(10) nullable:true
TaskType int(10) nullable:false
StartTime datetime(23) nullable:false
EstimatedDuration int(10) nullable:true
ApplicationId numeric(18) nullable:true
ApplicationType int(10) nullable:true
ResourceId numeric(18) nullable:true
ResourceType int(10) nullable:true
InteractionId nvarchar(50) nullable:true
MediaType int(10) nullable:true
SessionId nvarchar(32) nullable:true
TenantId int(10) nullable:true
SubTenantId int(10) nullable:true
TaskStarted_ServiceId_I on ServiceId
10:44:00.278 Dbg 29999 [Ucs-Main] Released connection (425099819@txn-null) to pool
10:44:00.278 Dbg 29999 [Ucs-Main] Additional Columns are allowed
10:44:00.278 Dbg 29999 [Ucs-Main] Missing Indexes are allowed
10:44:00.278 Dbg 29999 [Ucs-Main] [Main DS] Acquiring new connection from pool (queue size: 1 )
10:44:00.279 Dbg 29999 [Ucs-Main] [Main DS] Acquired new connection (480493110@txn-null) from pool in 0 ms
10:44:00.281 Trc 21103 [Ucs-Main] Schema information : [id: 8.5.200.09, timestamp: 2016-07-21T22:00:00Z, version: 8.5.200.00 , description: ]
10:44:00.282 Dbg 29999 [Ucs-Main] Released connection (480493110@txn-null) to pool
10:44:00.282 Trc 29998 [Ucs-Main] Checking tables and columns on 'dapucs'
10:44:00.282 Dbg 29999 [Ucs-Main] [Main DS] Acquiring new connection from pool (queue size: 1 )
10:44:00.282 Dbg 29999 [Ucs-Main] [Main DS] Acquired new connection (375957857@txn-null) from pool in 0 ms
To be continued .....