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 .....