Database Report: WEBCON BPS 2019.1.2

2019-03-29 09:32:11

Table Of Contents


Table of Contents

Table: AdminAPILogs

Description:Table contains web service methods execution log.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WSAL_ID int Yes       Identyfikator 
WSAL_Version varchar(10)         Wersja WebService'u 
WSAL_MethodName varchar(100)          
WSAL_TSInsert datetime       (getdate())  Czas wywołania metody 
WSAL_CreatedBy varchar(100)         zwa użytkownika wywołującego metodę w postaci login#nazwa_wyswietlana 
WSAL_IP varchar(50)   Yes     IP komputera wywołującego metodę 
WSAL_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminAPILogs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AdminDBMigrationLogs

Description:Stores BPS databases migration logs.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DML_ID int Yes       Identifier 
DML_TSInsert datetime       (getdate())  Creation date 
DML_TSUpdate datetime       (getdate())  Last modification date 
DML_RowVersion timestamp     Yes   Timestamp 
DML_CreatedBy varchar(50)         Author 
DML_BranchNumber varchar(50)         Branch number at the start of migration 
DML_DBVersion int         Version number at the start of migration 
DML_InstallerVersion varchar(50)         Installer version 
DML_ScriptID int         Migration script ID 
DML_ScriptBranchNumber varchar(50)         Migration script branch number 
DML_DBType int         Database type: 0 - Configuration, 1 - Content, 2 - Attachments 
DML_DBName varchar(250)         Database on which the script is executed 
DML_ScriptExecutionStatus int         Script execution status: 0 - Success, 1 - Error, 2 - Info 
DML_ScriptMessage varchar(MAX)   Yes     Executed script message 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminDBMigrationLogs Yes Yes BTREE ASCENDING 0

Table of Contents

Table: AdminDebugLogs

Description:Table contains diagnostic data. System writes to this table only is global parameter IsDebugMode is set to 1.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ID int Yes        
Name varchar(MAX)   Yes      
Description varchar(MAX)   Yes      
StackTrace varchar(MAX)   Yes      
TSInsert datetime   Yes   (getdate())   
ManagedThreadId int   Yes     Id wątku 
Category nvarchar(200)   Yes     Kategoria 
AdditionalMessage nvarchar(MAX)   Yes      
ElementId int   Yes     WFD_ID 
Duration int   Yes     Czas wykonania 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminDebugLogs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AdminFileProcessingLogs

Description:Table contains logs from Hotfolders processing, Hotmailboxes processing and asynchronous OCR processing.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
FLO_ID int Yes        
FLO_FolderType int         Flaga oznaczająca czy wpis dotyczy hotmailboxa czy hotfolderu (DicHotType) 
FLO_Status int         Flaga oznaczajaca rodzaj informacji (DicStatus) 
FLO_FolderName varchar(500)          
FLO_TSInsert datetime       (getdate())  Data wstawienia wiersza 
FLO_TSUpdate datetime       (getdate())  Data aktualizacji wiersza 
FLO_Message varchar(MAX)          
FLO_Description varchar(MAX)   Yes      
FLO_PageCount int   Yes      
FLO_ExecutionID varchar(100)   Yes      
FLO_ActivityID int   Yes      
FLO_HFID int   Yes     Column contains hotfolder id. 
FLO_HMID int   Yes     Column contains hotmailbox id. 
FLO_ServiceID int   Yes     Service's ID 
FLO_HostName varchar(MAX)   Yes     Name of the machine on which service was running 
FLO_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminFileProcessingLogs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AdminHotMailboxLogs

Description: Table contains data about processed mail attachments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
HMPI_ID int Yes        
HMPI_TSInsert datetime       (getdate())   
HMPI_TSUpdate datetime       (getdate())   
HMPI_RowVersion timestamp     Yes    
HMPI_CreatedBy varchar(50)          
HMPI_ModifiedBy varchar(50)          
HMPI_HMID int          
HMPI_MailID varchar(MAX)   Yes      
HMPI_AttachmentID varchar(MAX)          
HMPI_ProcessingFinishedDate datetime          
HMPI_ProcessingStatus int          

Foreign Keys

Name Foreign Table Primary Key
FK_AdminHotMailboxLogs_HotMailBoxes AdminHotMailboxLogs PK_HotMailBoxs

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminHotMailboxLogs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AdminPluginLogs

Description:Stores logs for all plugins

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PL_ID bigint Yes       Identifier 
PL_TSInsert datetime       (getdate())  Creation date 
PL_PluginID int         Plugin id 
PL_OperationGuid varchar(36)   Yes     Guid for same operation logs 
PL_SourceID int   Yes     Source id which triggered the plugin 
PL_ElementID int   Yes     Element id 
PL_LogType int         Int value of logtype enum 
PL_LogMessage varchar(MAX)   Yes     String value of logs 
PL_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_AdminPluginLogs_ElementID     BTREE ASCENDING 70
IX_AdminPluginLogs_PluginID     BTREE ASCENDING 70
PK_AdminPluginLogs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AdminServiceLogs

Description:Stores logs for all services.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SL_ID bigint Yes       Log id. 
SL_ServiceID int         Service id. 
SL_ManagedThreadID int         Thread id. 
SL_Title varchar(1000)   Yes     Title of log. 
SL_Message nvarchar(MAX)   Yes     Main content of log. 
SL_TSInsert datetime       (getdate())  Time of insert. 
SL_Category varchar(200)   Yes     Category of log. 
SL_Role int   Yes     Role of service. 
SL_Status varchar(100)         Status of log. 
SL_ContentDbId int   Yes     Column shows content database id 
SL_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminServiceLogs Yes Yes BTREE ASCENDING 0

Table of Contents

Table: AdminWFEventLogs

Description:Table containing event logs

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WEL_ID int Yes       Identifier 
WEL_RowVersion timestamp     Yes   Timestamp 
WEL_IsDeleted bit       ((0))  Is record deleted 
WEL_CreatedBy varchar(50)         Author 
WEL_UpdatedBy varchar(50)         Last modifier 
WEL_WFDID int   Yes     ID of element connected with log 
WEL_Level int         Level of importance 
WEL_Source int         Event category 
WEL_Category int         Category 
WEL_Name varchar(1000)         Name of event 
WEL_Details varchar(MAX)   Yes     Log details 
WEL_DateAndTime datetime       (getdate())  Time of occurrence 
WEL_ManagedThreadID int         Managed thread ID 
WEL_DEFID int   Yes     Definios ID 
WEL_CDID int   Yes     Content database ID 
WEL_ErrorGuid varchar(36)   Yes     Error identifier 
WEL_LogMetadata varchar(MAX)   Yes     Stores log metadata, e.g. used by user list cache 

Foreign Keys

Name Foreign Table Primary Key
FK_AdminWFEventLogs_DicLogCategories AdminWFEventLogs PK_DicLogCategories
FK_AdminWFEventLogs_DicLogSources AdminWFEventLogs PK_DicLogSources

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AdminWFEventLogs Yes Yes BTREE ASCENDING 0

Table of Contents

Table: AIAnalysisConfigurations

Description:Stores configurations of AI Analysis

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AIA_ID int Yes       Identifier 
AIA_Configuration varchar(MAX)   Yes     Analysis configuration 
AIA_TSInsert datetime       (getdate())  Creation date 
AIA_TSUpdate datetime       (getdate())  Last modification date 
AIA_RowVersion timestamp     Yes   Timestamp 
AIA_IsDeleted bit       ((0))  Is record deleted 
AIA_CreatedBy varchar(50)         Author 
AIA_UpdatedBy varchar(50)         Last modifier 
AIA_Guid varchar(36)       (newid())  BPS environment (DEV/TEST/PROD) independent identifier 
AIA_ASSID int         DocTypeAssocciations ForeignKey 

Foreign Keys

Name Foreign Table Primary Key
FK_AIAnalysisConfigurations_DocTypeAssocciations AIAnalysisConfigurations PK_DocTypeAssocciation

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AIAnalysisConfigurations Yes Yes BTREE ASCENDING 0

Table of Contents

Table: AiAnalysisQueueItems

Description:Service queue for AI analysis indexing operations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AIQ_ID int Yes       Identifier 
AIQ_TSInsert datetime       (getdate())  Insert date 
AIQ_TSUpdate datetime       (getdate())  Update date 
AIQ_RowVersion timestamp     Yes   Row version 
AIQ_DEFID int   Yes     Analyzed process 
AIQ_Operation int         Performed operation 
AIQ_Priority int         Priority 
AIQ_Status int         Processing status 
AIQ_ServiceName varchar(255)   Yes     Processing service name 
AIQ_AttemptsNumber int       ((0))  Processing attempts number 
AIQ_LastAttemptTime datetime   Yes     Last Attempt Time 
AIQ_LastError varchar(MAX)   Yes     Last Error 
AIQ_ThreadId int   Yes     Processing Thread Id 
AIQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
AIQ_DateFrom datetime   Yes     Analyzed items start date 
AIQ_DateTo datetime   Yes     Analyzed items end date 

Foreign Keys

Name Foreign Table Primary Key
FK_AiAnalysisQueueItems_WFDefinitions AiAnalysisQueueItems PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AiAnalysisQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: AnalyticsSteps

Description:KPI analytics per step

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ASTP_ID int Yes        
ASTP_Name varchar(50)          
ASTP_STPID int          
ASTP_AvgStepDurationByHours int   Yes      
ASTP_AvgEditDurationBySec int   Yes      
ASTP_Count int   Yes      
ASTP_AvgStepDurationInLast365DaysByHours int   Yes      
ASTP_AvgEditDurationInLast365DaysBySec int   Yes      
ASTP_CountLast365Days int   Yes      
ASTP_AvgStepDurationInCurrentYearByHours int   Yes      
ASTP_AvgEditDurationInCurrentYearBySec int   Yes      
ASTP_CountCurrentYear int   Yes      
ASTP_AvgStepDurationInLast30daysByHours int   Yes      
ASTP_AvgEditDurationInLast30daysBySec int   Yes      
ASTP_CountLast30Days int   Yes      
ASTP_AvgStepDurationInMonthBeforeByHours int   Yes      
ASTP_AvgEditDurationInMonthBeforeBySec int   Yes      
ASTP_CountMonthBefore int   Yes      
ASTP_Trend int   Yes      
ASTP_TSInsert datetime       (getdate())   
ASTP_TSUpdate datetime       (getdate())   
ASTP_RowVersion timestamp     Yes    
ASTP_IsDeleted bit       ((0))   
ASTP_AvgStepDurationInWorkingDays decimal(20,2)   Yes     Average step duration in working days 
ASTP_AvgStepDurationInLast365DaysInWorkingDays decimal(20,2)   Yes     Average step duration in the last 365 days in working days  
ASTP_AvgStepDurationInCurrentYearInWorkingDays decimal(20,2)   Yes     Average step duration in the current year in working days 
ASTP_AvgStepDurationInLast30daysInWorkingDays decimal(20,2)   Yes     Average step duration in the last 30 days in working days 
ASTP_AvgStepDurationInMonthBeforeInWorkingDays decimal(20,2)   Yes     Average step duration in the previous month in working days 

Foreign Keys

Name Foreign Table Primary Key
FK_AnalyticsSteps_WFSteps AnalyticsSteps PK_WFSteps

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AnalyticsSteps Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AnalyticsUsers

Description:KPI analytics per user

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AUSR_ID int Yes        
AUSR_Name varchar(50)          
AUSR_STPID int          
AUSR_UserName varchar(255)   Yes      
AUSR_UserLogin varchar(255)   Yes      
AUSR_AvgStepDurationByHours int   Yes      
AUSR_AvgEditDurationBySec int   Yes      
AUSR_Count int   Yes      
AUSR_AvgStepDurationInLast365DaysByHours int   Yes      
AUSR_AvgEditDurationInLast365DaysBySec int   Yes      
AUSR_CountLast365Days int   Yes      
AUSR_AvgStepDurationInCurrentYearByHours int   Yes      
AUSR_AvgEditDurationInCurrentYearBySec int   Yes      
AUSR_CountCurrentYear int   Yes      
AUSR_AvgStepDurationInLast30daysByHours int   Yes      
AUSR_AvgEditDurationInLast30daysBySec int   Yes      
AUSR_CountLast30Days int   Yes      
AUSR_AvgStepDurationInMonthBeforeByHours int   Yes      
AUSR_AvgEditDurationInMonthBeforeBySec int   Yes      
AUSR_CountMonthBefore int   Yes      
AUSR_Trend int   Yes      
AUSR_TSInsert datetime       (getdate())   
AUSR_TSUpdate datetime       (getdate())   
AUSR_RowVersion timestamp     Yes    
AUSR_IsDeleted bit       ((0))   
AUSR_AvgStepDurationInWorkingDays decimal(20,2)   Yes     Average step duration in working days 
AUSR_AvgStepDurationInLast365DaysInWorkingDays decimal(20,2)   Yes     Average step duration in the last 365 days in working days  
AUSR_AvgStepDurationInCurrentYearInWorkingDays decimal(20,2)   Yes     Average step duration in the current year in working days 
AUSR_AvgStepDurationInLast30daysInWorkingDays decimal(20,2)   Yes     Average step duration in the last 30 days in working days 
AUSR_AvgStepDurationInMonthBeforeInWorkingDays decimal(20,2)   Yes     Average step duration in the previous month in working days 

Foreign Keys

Name Foreign Table Primary Key
FK_AnalyticsUsers_WFSteps AnalyticsUsers PK_WFSteps

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AnalyticsUsers Yes Yes BTREE ASCENDING 70

Table of Contents

Table: AppDashboards

Description:Dashboards definitions

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ADS_ID int Yes       Identifier 
ADS_APPID int         WFApplications foreign key 
ADS_Name varchar(50)         Name of dashboard 
ADS_Description varchar(500)         Description of dashboard 
ADS_TSInsert datetime       (getdate())  Creation date 
ADS_TSUpdate datetime       (getdate())  Last modification date 
ADS_RowVersion timestamp     Yes   Timestamp 
ADS_Guid varchar(36)       (newid())  Guid of dashboard 
ADS_CreatedBy varchar(255)         Author 
ADS_UpdatedBy varchar(255)         Last modifier 
ADS_Configuration varchar(MAX)   Yes     Dashboard configuration 
ADS_BreakSecurityInheritance bit       ((0))  Tells if security inheritance is broken 
ADS_SaveStamp varchar(36)       (newid())  Save stamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurationSecurities_AppDashboards WFConfigurationSecurities PK_AppDashboards
FK_AppDashboards_WFApplications AppDashboards PK_WFApplications

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AppDashboards Yes Yes BTREE ASCENDING 0
UQ_AppDashboards_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: AppExploreDefinitions

Description:Table contains parameters for transition structure definition.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AED_ID int Yes        
AED_Name varchar(50)          
AED_TSInsert datetime       (getdate())   
AED_TSUpdate datetime       (getdate())   
AED_UserName varchar(255)          
AED_RowVersion timestamp     Yes   Row version 
AED_Guid varchar(36)       (newid())  Entry unique identifier for import export mechanism 
AED_UpdatedBy varchar(255)         Last modifier 
AED_CreatedBy varchar(255)         Author 
AED_BreakSecurityInheritance bit       ((0))  Tells if security inheritance is broken 
AED_UserLogin varchar(255)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_AppExploreLevels_AppExploreDefinitions AppExploreLevels PK_AppExploreDefinitions
FK_OutlookFavorites_MoveDefinitions OutlookFavorites PK_AppExploreDefinitions
FK_WFConfigurationSecurities_AppExploreDefinitions WFConfigurationSecurities PK_AppExploreDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AppExploreDefinitions Yes Yes BTREE ASCENDING 70
UQ_AppExploreDefinitions_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: AppExploreLevels

Description:Table contains individual steps in transition structure definition.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AEL_ID int Yes        
AEL_AEDID int          
AEL_Level int          
AEL_ObjectType int          
AEL_ObjectID int       ((0))   
AEL_Modifier int       ((0))   
AEL_FilterType int       ((0))   
AEL_Filter int       ((0))   
AEL_TSInsert datetime       (getdate())   
AEL_TSUpdate datetime       (getdate())   
AEL_RowVersion timestamp     Yes   Row version 
AEL_Guid varchar(36)       (newid())  Entry unique identifier for import export mechanism 
AEL_UpdatedBy varchar(255)         Last modifier 
AEL_CreatedBy varchar(255)         Author 

Foreign Keys

Name Foreign Table Primary Key
FK_AppExploreLevels_AppExploreDefinitions AppExploreLevels PK_AppExploreDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AppExploreLevels Yes Yes BTREE ASCENDING 70
UQ_AppExploreLevels_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: AppReports

Description:Table that contains definitions of BPS Views

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ARP_ID int Yes       Identifier 
ARP_Name varchar(100)         Name of BPS View 
ARP_Description varchar(500)         Description of BPS View 
ARP_APPID int         WFApplications foreign key 
ARP_TypeID int         DicWebPartTypes foreign key 
ARP_Configuration varchar(MAX)         Configuration of BPS View as XML 
ARP_Guid varchar(36)       (newid())  Guid of application 
ARP_TSInsert datetime       (getdate())  Creation date 
ARP_TSUpdate datetime       (getdate())  Last modification date 
ARP_RowVersion timestamp     Yes   Timestamp 
ARP_UpdatedBy varchar(255)         Last modifier 
ARP_CreatedBy varchar(255)         Author 
ARP_BreakSecurityInheritance bit       ((0))  Tells if security inheritance is broken 
ARP_SaveStamp varchar(36)       (newid())  Save stamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AppReportViews_AppReports AppReportViews PK_AppReports
FK_WFConfigurationSecurities_AppReports WFConfigurationSecurities PK_AppReports
FK_AppReports_DicWebPartTypes AppReports PK_DicWebPartTypes
FK_AppReports_WFApplications AppReports PK_WFApplications

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AppReports Yes Yes BTREE ASCENDING 0
UQ_AppReports_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: AppReportViews

Description:UserViews definitions

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ARV_ID int Yes       Identifier 
ARV_ARPID int         BpsViewDefinitions foreign key 
ARV_Name varchar(50)         Name of view 
ARV_Description varchar(500)         Description of view 
ARV_Filters varchar(MAX)         Filters 
ARV_Sorting varchar(MAX)         Sorting information 
ARV_TSInsert datetime       (getdate())  Creation date 
ARV_TSUpdate datetime       (getdate())  Last modification date 
ARV_RowVersion timestamp     Yes   Timestamp 
ARV_CreatedBy varchar(255)         Author 
ARV_UpdatedBy varchar(255)         Last modifier 
ARV_UserLogin varchar(256)   Yes     Stores login of user which owns that view 
ARV_Guid varchar(36)       (newid())  Entry unique identifier for import export mechanism 
ARV_IsDefault bit       ((0))  Is view default view for report 
ARV_Order int   Yes     Oder of the view 

Foreign Keys

Name Foreign Table Primary Key
FK_AppReportViews_AppReports AppReportViews PK_AppReports

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_AppReportViews_ARV_ARPID     BTREE ASCENDING 70
PK_AppReportViews Yes Yes BTREE ASCENDING 0
UQ_AppReportViews_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: AppStarts

Description:Workflow instances start parameters

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AST_ID int Yes       Identifier 
AST_APPID int   Yes     WFApplications foreign key 
AST_Name varchar(50)         Name of start 
AST_Description varchar(500)         Description of start 
AST_TSInsert datetime       (getdate())  Creation date 
AST_TSUpdate datetime       (getdate())  Last modification date 
AST_RowVersion timestamp     Yes   Timestamp 
AST_Guid varchar(36)       (newid())  Guid of start 
AST_CreatedBy varchar(255)         Author 
AST_UpdatedBy varchar(255)         Last modifier 
AST_Configuration varchar(MAX)   Yes     Configuration of start definiton as XML 
AST_Order int       ((0))  Order 
AST_BreakSecurityInheritance bit       ((0))  Tells if security inheritance is broken 
AST_SaveStamp varchar(36)       (newid())  Save stamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurationSecurities_AppStarts WFConfigurationSecurities PK_AppStarts
FK_AppStarts_WFApplications AppStarts PK_WFApplications

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AppStarts Yes Yes BTREE ASCENDING 0
UQ_AppStarts_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: ArchiveQueueItems

Description:Table contains archive queue for elements

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ARQ_ID int Yes       Identifier 
ARQ_WFDID int         NOT foreign key reference to WFElements 
ARQ_ACTID int         Foreign key to WFActions 
ARQ_TSInsert datetime       (getdate())  Creation date 
ARQ_TSUpdate datetime       (getdate())  Last modification date 
ARQ_RowVersion timestamp     Yes   Timestamp 
ARQ_Priority int         Priority 
ARQ_ServiceName varchar(255)   Yes     Processing service name 
ARQ_Status int       ((0))  Status 
ARQ_AttemptsNumber int       ((0))  Attempts number 
ARQ_LastAttemptTime datetime   Yes     Last attempt time 
ARQ_LastError varchar(MAX)   Yes     Last error 
ARQ_ThreadId int   Yes     Processing Thread Id for Archivisation 
ARQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
ARQ_SectionGuid varchar(36)   Yes     Action section GUID 

Foreign Keys

Name Foreign Table Primary Key
FK_ArchiveQueueItems_WFActions ArchiveQueueItems PK_WFActions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ArchiveQueueItems Yes Yes BTREE ASCENDING 0
UQ_ArchiveQueueItems_WFDID Yes   BTREE ASCENDING 0

Table of Contents

Table: ArchivingDatabases

Description:Table containing archiving databases

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ARD_ID int Yes       Identifier 
ARD_Name varchar(255)         Name 
ARD_TSInsert datetime       (getdate())  Creation date 
ARD_TSUpdate datetime       (getdate())  Last modification date 
ARD_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFElementSignatures_ArchivingDatabases WFElementSignatures PK_ArchivingDatabases

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ArchivingDatabases Yes Yes BTREE ASCENDING 0
UQ_ArchivingDatabases_Name Yes   BTREE ASCENDING 0

Table of Contents

Table: AttributeDocTypeAssocs

Description:Attribute with document type associations. Table also contains information about attribute visibility per document type.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ADA_ID int Yes       Identyfikator powiązania 
ADA_DTYPEID int         Identyfikator typu dokumentu 
ADA_WFCONID int         Identyfikator atrybutu 
ADA_IsVisible bit       ((1))  Czy atrybut jest widoczny dla typu dokumentu 
ADA_TSInsert datetime       (getdate())  Data wstawienia wiersza 
ADA_TSUpdate datetime       (getdate())  Data aktualizacji wiersza 
ADA_RowVersion timestamp     Yes   Wersja wiersza 
ADA_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_AttributeDocTypeAssocs_WFConfigurations AttributeDocTypeAssocs PK_WFConfigurations
FK_AttributeDocTypeAssocs_WFDocTypes AttributeDocTypeAssocs PK_WFDocTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__AttributeDocType__40AF57D0 Yes Yes BTREE ASCENDING 70
UQ_AttributeDocTypeAssocs_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: BinaryTemporaryDatas

Description:Temporary table use for storing binary data.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
BTD_ID int Yes        
BTD_Data varbinary(MAX)          
BTD_Name varchar(255)   Yes      
BTD_Description varchar(MAX)   Yes      
BTD_TSInsert datetime       (getdate())   
BTD_TSUpdate datetime       (getdate())   
BTD_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_BinaryTemporaryDatas Yes Yes BTREE ASCENDING 70

Table of Contents

Table: CacheOrganizationStructure

Description:Active Directory organization structure data. Column names starting with 'COS_AD_' prefix contains original information got from Active Directory. Other columns contains information computed by BPS. This table contains users, group and computer objects from Active Directory both active and disabled.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COS_ID int Yes       Identyfikator 
COS_Login varchar(255)         Login użytkownika 
COS_ManagerID int   Yes     Identyfikator przełożonego - ID tabeli CacheOrganizationStructure 
COS_ManagerLogin varchar(50)   Yes     Login przełożonego 
COS_ManagerDisplayName varchar(255)   Yes     Nazwa wyświetlana użytkownika 
COS_IsActive bit   Yes      
COS_AD_accountexpires datetime   Yes     Data wygaśnięcia konta 
COS_AD_adspath varchar(MAX)   Yes      
COS_AD_company varchar(255)   Yes      
COS_AD_comment varchar(MAX)   Yes      
COS_AD_countrycode int   Yes      
COS_AD_department varchar(255)   Yes      
COS_AD_description varchar(1025)   Yes      
COS_AD_displayname varchar(255)   Yes      
COS_AD_distinguishedname varchar(MAX)   Yes      
COS_AD_givenname varchar(255)   Yes      
COS_AD_homedirectory varchar(260)   Yes      
COS_AD_homephone varchar(255)   Yes      
COS_AD_info varchar(MAX)   Yes      
COS_AD_ipphone varchar(255)   Yes      
COS_AD_iscriticalsystemobject bit   Yes      
COS_AD_localeid int   Yes      
COS_AD_mail varchar(MAX)   Yes      
COS_AD_manager varchar(MAX)   Yes      
COS_AD_memberOf varchar(MAX)   Yes      
COS_AD_mobile varchar(255)   Yes      
COS_AD_name varchar(255)   Yes      
COS_AD_objectcategory varchar(MAX)   Yes      
COS_AD_objectclass varchar(MAX)   Yes      
COS_AD_objectguid binary(16)   Yes      
COS_AD_objectsid varbinary(100)   Yes      
COS_AD_objectversion int   Yes      
COS_AD_ou varchar(MAX)   Yes      
COS_AD_pager varchar(255)   Yes      
COS_AD_postalcode varchar(255)   Yes      
COS_AD_postofficebox varchar(255)   Yes      
COS_AD_primarygroupid int   Yes      
COS_AD_samaccountname varchar(MAX)   Yes      
COS_AD_samaccounttype int   Yes      
COS_AD_securityidentifier varbinary(100)   Yes      
COS_AD_showinaddressbook varchar(MAX)   Yes      
COS_AD_sn varchar(255)   Yes      
COS_AD_st varchar(255)   Yes      
COS_AD_streetaddress varchar(MAX)   Yes      
COS_AD_telephonenumber varchar(255)   Yes      
COS_AD_title varchar(255)   Yes      
COS_AD_useraccountcontrol int   Yes      
COS_AD_userparameters varchar(MAX)   Yes      
COS_AD_userprincipalname varchar(MAX)   Yes      
COS_AD_whencreated datetime   Yes      
COS_AD_wwwhomepage varchar(MAX)   Yes      
COS_ExtensionAttribute01 varchar(MAX)   Yes      
COS_ExtensionAttribute02 varchar(MAX)   Yes      
COS_ExtensionAttribute03 varchar(MAX)   Yes      
COS_ExtensionAttribute04 varchar(MAX)   Yes      
COS_ExtensionAttribute05 varchar(MAX)   Yes      
COS_ExtensionAttribute06 varchar(MAX)   Yes      
COS_ExtensionAttribute07 varchar(MAX)   Yes      
COS_ExtensionAttribute08 varchar(MAX)   Yes      
COS_ExtensionAttribute09 varchar(MAX)   Yes      
COS_ExtensionAttribute10 varchar(MAX)   Yes      
COS_ExtensionAttribute11 varchar(MAX)   Yes      
COS_ExtensionAttribute12 varchar(MAX)   Yes      
COS_ExtensionAttribute13 varchar(MAX)   Yes      
COS_ExtensionAttribute14 varchar(MAX)   Yes      
COS_ExtensionAttribute15 varchar(MAX)   Yes      
COS_ExtensionAttribute16 varchar(MAX)   Yes      
COS_ExtensionAttribute17 varchar(MAX)   Yes      
COS_ExtensionAttribute18 varchar(MAX)   Yes      
COS_ExtensionAttribute19 varchar(MAX)   Yes      
COS_ExtensionAttribute20 varchar(MAX)   Yes      
COS_ExtensionAttribute21 varchar(MAX)   Yes      
COS_ExtensionAttribute22 varchar(MAX)   Yes      
COS_ExtensionAttribute23 varchar(MAX)   Yes      
COS_ExtensionAttribute24 varchar(MAX)   Yes      
COS_ExtensionAttribute25 varchar(MAX)   Yes      
COS_ExtensionAttribute26 varchar(MAX)   Yes      
COS_ExtensionAttribute27 varchar(MAX)   Yes      
COS_ExtensionAttribute28 varchar(MAX)   Yes      
COS_ExtensionAttribute29 varchar(MAX)   Yes      
COS_ExtensionAttribute30 varchar(MAX)   Yes      
COS_TSInsert datetime       (getdate())   
COS_TSUpdate datetime       (getdate())   
COS_RowVersion timestamp     Yes    
COS_AD_physicalDeliveryOfficeName varchar(255)   Yes      
COS_DomainPath varchar(256)   Yes      
COS_SID varchar(100)   Yes     SID obiektu AD w postaci tekstowej 
COS_Domain varchar(255)   Yes     User domain 
COS_BpsID varchar(255)         Stores user login in bps format 
COS_Department varchar(250)   Yes     Stores department as in SPUser profile 
COS_JobTitle varchar(250)   Yes     Stores job title as in SPUser profile 
COS_Email varchar(MAX)   Yes     Stores email of the user from SPUser profile 
COS_DisplayName varchar(255)   Yes     Stores display name of the user from SPUser profile 
COS_AccountType int         Holds value for account type 
COS_ManagerBpsID varchar(255)   Yes     Stores manager login in bps format 
COS_AD_cn varchar(MAX)   Yes     Stores common name from AD 
COS_AD_proxyaddresses varchar(MAX)   Yes     Stores proxy adresses from AD 
COS_ProviderType int         Stores type of provider from which entity origins 
COS_LastSuccessfulSyncTime datetime       (getdate())  Stores last successful time of synchronization 
COS_SynchronizationError bit       ((0))  Determines if error occurred during synchronization of object 
COS_OnPremisesSyncEnabled bit       ((0))  Informs whether the user is to be replicated to on premises ActiveDirectory or regarded as a cloud only account. 
COS_AzureADID varchar(36)   Yes     GUID of the Azure Active Directory user object. 
COS_UserType int   Yes     ID of user type, pertaining to the source of user data. 
COS_GroupType int   Yes     ID of group type, pertaining to the source of group data. 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructureExtendedTokens_CacheOrganizationStructure CacheOrganizationStructureExtendedTokens PK__CacheOrganizationStructure
FK_CacheOrganizationStructureGroupRelations CacheOrganizationStructureGroupRelations PK__CacheOrganizationStructure
FK2_CacheOrganizationStructureGroupRelations CacheOrganizationStructureGroupRelations PK__CacheOrganizationStructure
FK_CacheOrganizationStructurePictures_CacheOrganizationStructure CacheOrganizationStructurePictures PK__CacheOrganizationStructure
FK_CacheOrganizationStructureSubordinates_CacheOrganizationStructure CacheOrganizationStructureSubordinates PK__CacheOrganizationStructure
FK_CacheOrganizationStructure_DicGroupTypes CacheOrganizationStructure PK_DicADGroupTypes
FK_CacheOrganizationStructure_DicUserTypes CacheOrganizationStructure PK_DicADUserTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_CacheOrganizationStructure_COS_BpsID     BTREE ASCENDING 70
IX_CacheOrganizationStructure_COS_Login     BTREE ASCENDING 70
IX_CacheOrganizationStructure_COS_ManagerBpsID     BTREE ASCENDING 70
IX_CacheOrganizationStructure_COS_ManagerLogin     BTREE ASCENDING 70
PK__CacheOrganizationStructure Yes Yes BTREE ASCENDING 70

Table of Contents

Table: CacheOrganizationStructureExtendedTokens

Description:List of user permissions. Each user has listed all Active Directory, SharePoint groups he belongs and his login in separated rows. This information is used for permission based on organization structure.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COSET_ID bigint Yes        
COSET_COSID int          
COSET_TokenPart varchar(255)   Yes      
COSET_Site varchar(193)   Yes      
COSET_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructureExtendedTokens_CacheOrganizationStructure CacheOrganizationStructureExtendedTokens PK__CacheOrganizationStructure

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_CacheOrganizationStructureExtendedTokens_TokenPartSiteCOSID     BTREE ASCENDING 70
PK__CacheOrganizationStructureExtendedTokens Yes Yes BTREE ASCENDING 70

Table of Contents

Table: CacheOrganizationStructureGroupRelations

Description:Informations about group membership. User and group columns corresponds to records in CacheOrganizationStructure table. Each relation between user and group has information whether this is user's primary group, user is direct member of the group or is member of some group nested in this group.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COSGR_ID bigint Yes       Identyfikator 
COSGR_UserID int         Identyfikator użytkownika 
COSGR_GroupID int         Identyfikator grupy 
COSGR_IsDirect bit         Czy użytkownik jest przypisany do tej grupy bezpośrednio, czy też jest to grupa nadrzędna w stosunku do grupy, do której należy użytkownik 
COSGR_IsPrimary bit   Yes     Czy grupa jest grupą główną użytkownika (primary group) 
COSGR_TSInsert datetime       (getdate())  Data utworzenia rekordu 
COSGR_TSUpdate datetime       (getdate())  Data ostatniej modyfikacji rekordu 
COSGR_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructureGroupRelations CacheOrganizationStructureGroupRelations PK__CacheOrganizationStructure
FK2_CacheOrganizationStructureGroupRelations CacheOrganizationStructureGroupRelations PK__CacheOrganizationStructure

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_CacheOrganizationStructureGroupRelations_COSGR_GroupID     BTREE ASCENDING 0
IX_CacheOrganizationStructureGroupRelations_COSGR_UserID     BTREE ASCENDING 0
PK__CacheOrganizationStructureGroupRelations Yes Yes BTREE ASCENDING 70

Table of Contents

Table: CacheOrganizationStructurePictures

Description:Table containing user pictures of organization structure members

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COSP_ID int Yes       Identifier 
COSP_Picture varbinary(MAX)   Yes     Picture bytes 
COSP_TSInsert datetime       (getdate())  Creation date 
COSP_TSUpdate datetime       (getdate())  Last modification date 
COSP_RowVersion timestamp     Yes   Timestamp 
COSP_COSID int         Cache organization structure foreign key 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructurePictures_CacheOrganizationStructure CacheOrganizationStructurePictures PK__CacheOrganizationStructure

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_CacheOrganizationStructurePictures Yes Yes BTREE ASCENDING 0
UQ_CacheOrganizationStructurePictures_COSID Yes   BTREE ASCENDING 0

Table of Contents

Table: CacheOrganizationStructureSubordinates

Description:Manager subordinates. Each record is relation between manager and his subordinates. Subordinates are stored in two column divided by comma - all subordinates and direct subordinates.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COSSUB_ID bigint Yes        
COSSUB_COSID int          
COSSUB_WFDSID int          
COSSUB_SubordinatesList varchar(MAX)          
COSSUB_TSInsert datetime       (getdate())  Data utworzenia rekordu 
COSSUB_TSUpdate datetime       (getdate())  Data ostatniej modyfikacji rekordu 
COSSUB_DirectSubordinatesList varchar(MAX)          
COSSUB_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructureSubordinates_CacheOrganizationStructure CacheOrganizationStructureSubordinates PK__CacheOrganizationStructure

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__CacheOrganizationStructureHierarchy Yes Yes BTREE ASCENDING 70

Table of Contents

Table: Calendars

Description:Table contains all working days in a year

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CAL_ID int Yes       Identifier 
CAL_TSInsert datetime       (getdate())  Creation date 
CAL_TSUpdate datetime       (getdate())  Last modification date 
CAL_RowVersion timestamp     Yes   Timestamp 
CAL_IsDeleted bit       ((0))  Is record deleted 
CAL_CreatedBy varchar(50)         Author 
CAL_UpdatedBy varchar(50)         Last modifier 
CAL_WorkingDate date         Working day date 
CAL_IsWorkingDay bit         Is working day 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_Calendars_IsWorkingDay     BTREE ASCENDING 0
PK_Calendars Yes Yes BTREE ASCENDING 0
UQ_Calendars_CAL_WorkingDate Yes   BTREE ASCENDING 70

Table of Contents

Table: ChangeDetails

Description:All changed columns in rows in all configuration tables. Each entry has one corresponding row in ChangeRows table and one corresponding row in ConfigurationColumns table.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CHD_ID bigint Yes        
CHD_CHRID bigint          
CHD_CFCID int          
CHD_OldValue varchar(MAX)   Yes      
CHD_NewValue varchar(MAX)   Yes      
CHD_IsDeleted bit       ((0))   
CHD_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeDetails_ChangeRows ChangeDetails PK_ChangeRows
FK_ChangeDetails_ConfigurationColumns ChangeDetails PK_ConfigurationColumns

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_ChangeDetails_CHRID     BTREE ASCENDING 70
PK_ChangeDetails Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ChangeOperations

Description:Single save in Studio Designer on any object is a single record in this table. This contains information about object type (table DicObjectTypes). Column CHO_ObjectID stores corresponding primary key from particular table.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CHO_ID bigint Yes        
CHO_ObjectTypeID int          
CHO_ObjectID int   Yes      
CHO_DBBranchNumber varchar(20)          
CHO_DBVersion varchar(20)          
CHO_StateXml xml   Yes      
CHO_TSInsert datetime       (getdate())   
CHO_TSUpdate datetime       (getdate())   
CHO_CreatedBy varchar(50)   Yes      
CHO_IsDeleted bit       ((0))   
CHO_RowVersion timestamp     Yes    
CHO_CHTID int          
CHO_AppVersion varchar(20)          

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeRows_ChangeOperations ChangeRows PK_ChangeOperations
FK_ChangeOperations_ChangeTransports ChangeOperations PK_ChangeTransports
FK_ChangeOperations_DicSaveObjectTypes ChangeOperations PK_DicSaveObjectTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_ChangeOperations_ObjectTypeID_ObjectID     BTREE ASCENDING 70
PK_ChangeOperations Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ChangeProjects

Description:Group of features (processes, workflows) that collects functionality that can be exported to another environment (test, production)

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CHP_ID int Yes        
CHP_Name varchar(50)          
CHP_TSInsert datetime       (getdate())   
CHP_TSUpdate datetime       (getdate())   
CHP_CreatedBy varchar(50)   Yes      
CHP_UpdatedBy varchar(50)   Yes      
CHP_IsDeleted bit       ((0))   
CHP_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeTransports_ChangeProjects ChangeTransports PK_ChangeProjects

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ChangeProjects Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ChangeRows

Description:List of rows in SQL database tables which has been modified via particular save in Sudio Designer. Column CHR_CFTID contains identifier of table (ConfigurationTables table). Column CHR_ChangeTypeID contains type of change (DicSaveObjectTypes table value - i.e. save, edit, insert)

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CHR_ID bigint Yes        
CHR_CHOID bigint          
CHR_CFTID int          
CHR_ChangeTypeID int          
CHR_RowID varchar(20)          
CHR_TSInsert datetime       (getdate())   
CHR_IsDeleted bit       ((0))   
CHR_RowVersion timestamp     Yes    
CHR_Guid varchar(36)   Yes     Identifier for batch insert 

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeDetails_ChangeRows ChangeDetails PK_ChangeRows
FK_ChangeRows_ChangeOperations ChangeRows PK_ChangeOperations
FK_ChangeRows_ConfigurationTables ChangeRows PK_ConfigurationTables
FK_ChangeRows_DicChangeTypes ChangeRows PK_DicChangeTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_ChangeRows_CHOID     BTREE ASCENDING 70
PK_ChangeRows Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ChangeTransports

Description:Part of ChangeProject. Smaller amount of features within big project prepared for export to another environment. This can be some change request, bug fix.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CHT_ID int Yes        
CHT_Name varchar(50)          
CHT_CHPID int          
CHT_TSInsert datetime       (getdate())   
CHT_TSUpdate datetime       (getdate())   
CHT_CreatedBy varchar(50)   Yes      
CHT_UpdatedBy varchar(50)   Yes      
CHT_IsDeleted bit       ((0))   
CHT_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeOperations_ChangeTransports ChangeOperations PK_ChangeTransports
FK_ChangeTransports_ChangeProjects ChangeTransports PK_ChangeProjects

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ChangeTransports Yes Yes BTREE ASCENDING 70

Table of Contents

Table: Claims

Description:Stores identity user claims values

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CLM_ID int Yes       Identifier 
CLM_IUID int         Identity user identifier 
CLM_Type varchar(250)         Claim type 
CLM_ValueType varchar(250)         Type of claim value 
CLM_Value varchar(250)         Claim value 
CLM_TSInsert datetime       (getdate())  Creation date 
CLM_TSUpdate datetime       (getdate())  Last modification date 
CLM_CreatedBy varchar(50)         Author 
CLM_UpdatedBy varchar(50)         Last modifier 
CLM_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_Claims_IdentityUsers_IUID Claims PK_IdentityUsers

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_Claims Yes Yes BTREE ASCENDING 0

Table of Contents

Table: Companies

Description:List of companies

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COM_ID int Yes        
COM_Code varchar(20)          
COM_Name varchar(50)          
COM_Description varchar(1000)   Yes      
COM_Users text   Yes      
COM_TSInsert datetime       (getdate())   
COM_TSUpdate datetime       (getdate())   
COM_RowVersion timestamp     Yes    
COM_IsDeleted bit       ((0))   
COM_FullNameLine1 varchar(250)   Yes      
COM_FullNameLine2 varchar(250)   Yes      
COM_AddressLine1 varchar(250)   Yes      
COM_AddressLine2 varchar(250)   Yes      
COM_AddressLine3 varchar(250)   Yes      
COM_LogoURL varchar(1000)   Yes      
COM_NIP varchar(50)   Yes      
COM_Phone varchar(50)   Yes      
COM_DefaultFor varchar(MAX)   Yes      
COM_AdditionalFor varchar(MAX)   Yes      
COM_REGON varchar(50)   Yes      
COM_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_HotFolders_Companies HotFolders PK_Companies
FK_HotMailBoxs_Companies HotMailBoxs PK_Companies
FK_PersonalDataRemovalQueueItems_Companies PersonalDataRemovalQueueItems PK_Companies
FK_TilesConfigurations_Companies TilesConfigurations PK_Companies
FK_WFCovers_Companies WFCovers PK_Companies
FK_WFDataSources_Companies WFDataSources PK_Companies
FK_WFElements_Companies WFElements PK_Companies
FK_WFSecurities_Companies WFSecurities PK_Companies

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_Companies Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ConfigurationChangeTimestamps

Description:Stores info about refreshing caches

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CCT_ID int Yes       Identifier 
CCT_GroupID int         Cache group from DicCaheGroups 
CCT_TSUpdate datetime       (getdate())  Last modification date 
CCT_RowVersion timestamp     Yes   Timestamp 
CCT_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_ConfigurationChangeTimestamps_DicCacheGroups ConfigurationChangeTimestamps PK_DicCacheGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ConfigurationChangeTimestamps Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ConfigurationColumns

Description:All columns from all configuration tables. Contents are updated via store procedure when user saves correspoding object in Studio Designer.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CFC_ID int Yes        
CFC_CFTID int          
CFC_ColumnName varchar(255)          
CFC_TSInsert datetime       (getdate())   
CFC_TSUpdate datetime       (getdate())   
CFC_IsDeleted bit       ((0))   
CFC_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeDetails_ConfigurationColumns ChangeDetails PK_ConfigurationColumns
FK_ConfigurationColumns_ConfigurationTables ConfigurationColumns PK_ConfigurationTables

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ConfigurationColumns Yes Yes BTREE ASCENDING 70
UQ_ConfigurationColumns_CFTID_Name Yes   BTREE ASCENDING 70

Table of Contents

Table: ConfigurationTables

Description:List of all configuration tables. Contents are updated via store procedure when user saves correspoding object in Studio Designer.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CFT_ID int Yes        
CFT_Name varchar(255)          
CFT_Prefix varchar(10)          
CFT_TSInsert datetime       (getdate())   
CFT_TSUpdate datetime       (getdate())   
CFT_IsDeleted bit       ((0))   
CFT_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeRows_ConfigurationTables ChangeRows PK_ConfigurationTables
FK_ConfigurationColumns_ConfigurationTables ConfigurationColumns PK_ConfigurationTables

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ConfigurationTables Yes Yes BTREE ASCENDING 70
UQ_ConfigurationTables_Name Yes   BTREE ASCENDING 70
UQ_ConfigurationTables_Prefix Yes   BTREE ASCENDING 70

Table of Contents

Table: ConfiguredWebServices

Description:Holds information and data about dynamic dll for webservises

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CWS_ID int Yes       Identifier 
CWS_Wsdl varbinary(MAX)         Wsdl 
CWS_Assembly varbinary(MAX)         Assembly 
CWS_Guid varchar(36)       (newid())  Guid 
CWS_TSInsert datetime       (getdate())  Creation date 
CWS_TSUpdate datetime       (getdate())  Last modification date 
CWS_RowVersion timestamp     Yes   Timestamp 
CWS_IsDeleted bit       ((0))  Is record deleted 
CWS_CreatedBy varchar(50)         Author 
CWS_UpdatedBy varchar(50)         Last modifier 
CWS_CacheKey varchar(36)   Yes     Key(guid) used for cache dlls for webservice action and datasource 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActions_ConfiguredWebServices WFActions PK_ConfiguredWebServices
FK_WFDataSources_ConfiguredWebServices WFDataSources PK_ConfiguredWebServices

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ConfiguredWebServices Yes Yes BTREE ASCENDING 0
UQ_ConfiguredWebServices_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: ContentDatabases

Description:List of content databases connected to current configuration database. Content databases and configuration database must function on the same SQL server.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CD_ID int Yes        
CD_Name varchar(200)          
CD_TSInsert datetime       (getdate())   
CD_TSUpdate datetime       (getdate())   
CD_RowVersion timestamp     Yes    
CD_Login varchar(200)   Yes     Database login 
CD_Password varchar(200)   Yes     Database password 
CD_Type int       ((1))  Database type 
CD_Prefix varchar(200)   Yes     Solr index prefix 

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceDatabases_SD_ContentDatabaseID ServiceDatabases PK_ContentDatabases
FK_ContentDatabases_ContentDatabaseType ContentDatabases PK_DicDatabaseTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ContentDatabases Yes Yes BTREE ASCENDING 70
UQ_ContentDatabases_Name Yes   BTREE ASCENDING 70

Table of Contents

Table: DatabaseAcronyms

Description:Stores current and historical acronyms for the content database. Last one is the current value.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DAC_ID int Yes       Acronym id. 
DAC_Acronym varchar(6)         Acronym of the database. 
DAC_TSInsert datetime       (getdate())  Time of insert. 
DAC_TSUpdate datetime       (getdate())  Time of update. 
DAC_RowVersion timestamp     Yes   Row version. 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_DatabaseAcronyms_Acronym     BTREE ASCENDING 70
PK_DatabaseAcronyms Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicActionKinds

Description:Dictionary table that contains kinds of actions available in the system, e.g. generate PDF, change field value, send an e-mail.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name varchar(50)         Nazwa PL 
ObjectName varchar(50)          
Description varchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)          

Foreign Keys

Name Foreign Table Primary Key
FK_WFActions_DicActionKinds WFActions PK_DicActionKinds

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicActionKinds Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicActionTypes

Description:Dictionary table that contains action types available in system. Determines the moment of execution of the action e.g.: on exit, on timeout, on path, on menu button.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name varchar(50)         Nazwa PL 
ObjectName varchar(50)          
Description varchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_WFActionExecutions_DicActionTypes WFActionExecutions PK_DicActionTypes
FK_WFActions_DicActionTypes WFActions PK_DicActionTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicActionTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicADGroupTypes

Description:Dictionary table containing available synchronized group types pertaining to the source of group information.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Active Directory group type ID. 
Name varchar(50)         Type name presented to user. 
EnglishName varchar(50)         Type name presented to user. (English equivalent) 
ObjectName varchar(50)         Enum member 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructure_DicGroupTypes CacheOrganizationStructure PK_DicADGroupTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicADGroupTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicADUserTypes

Description:Dictionary table containing available synchronized user types pertaining to the source of user information.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Active Directory user type ID. 
Name varchar(50)         Type name presented to user. 
EnglishName varchar(50)         Type name presented to user. (English equivalent) 
ObjectName varchar(50)         Enum member 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_CacheOrganizationStructure_DicUserTypes CacheOrganizationStructure PK_DicADUserTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicADUserTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicApplicationTemplates

Description:Table containing application templates

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Application template ID 
Name varchar(50)         Application template name 
ObjectName varchar(50)         Enum member 
Description varchar(512)   Yes     Application template description 
TSInsert datetime       (getdate())  Creation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 
EnglishName varchar(50)         Application template name (English equivalent) 

Foreign Keys

Name Foreign Table Primary Key
FK_WFApplications_DicApplicationTemplates WFApplications PK_DicApplicationTemplates

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicApplicationTemplates Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicAssignTypes

Description:Dictionary table that contains types of task assignments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name varchar(50)         Nazwa PL 
ObjectName varchar(50)          
Description varchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_WFElementTasks_DicAssignTypes WFElementTasks PK_DicAssignTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicAssignTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicAuthenticationTypes

Description:Dictionary table that contains available authentication types.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name presented to user. 
ObjectName varchar(50)         Name of enum representation in code. 
TSInsert datetime       (getdate())  Insert time. 
TSUpdate datetime       (getdate())  Update time. 
RowVersion timestamp     Yes   Timestamp. 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__DicAuthenticatio__676197DF Yes Yes BTREE ASCENDING 0

Table of Contents

Table: DicBusinessRulesEditModeTypes

Description:Dictionary table that contains available business rules return types.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFBusinessRuleDefinitions_DicBusinessRulesEditModeTypes WFBusinessRuleDefinitions PK_DicBusinessRulesEditModeTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicBusinessRulesEditModeTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicBusinessRulesReturnedValueTypes

Description:Dictionary table that contains available business rules return types.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFBusinessRuleDefinitions_DicBusinessRulesReturnedValueTypes WFBusinessRuleDefinitions PK_DicBusinessRulesReturnedValueTypes
FK_WFBusinessRuleParameters_DicBusinessRulesReturnedValueTypes WFBusinessRuleParameters PK_DicBusinessRulesReturnedValueTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicBusinessRulesReturnedValueTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicBusinessRulesTypes

Description:Dictionary table that contains business rules types.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  Creation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFBusinessRuleDefinitions_DicBusinessRulesTypes WFBusinessRuleDefinitions PK_DicBusinessRulesTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicBusinessRulesTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicCacheGroups

Description:Stores cache groups

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Cache group identifier 
Name varchar(50)         Name for cache group 
EnglishName varchar(50)         Name for cache group (English equivalent) 
ObjectName varchar(50)         Enum member 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_ConfigurationChangeTimestamps_DicCacheGroups ConfigurationChangeTimestamps PK_DicCacheGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicCacheGroups Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicChangeTypes

Description:Dictionary table that contains types of changes. It is used in history of configuration changes.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeRows_DicChangeTypes ChangeRows PK_DicChangeTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicChangeTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicChoiceFieldTypes

Description:Dictionary table that contains subtypes for choice field

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name presented to user 
EnglishName varchar(50)         Name presented to user (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  Creation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurations_DicChoiceFieldTypes WFConfigurations PK_DicChoiceFieldTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicChoiceFieldTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicConfigurationSecurityLevels

Description:Dictionary table that contains security access levels that can be defined for applications and BPS Studio.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Enum name 
TSInsert datetime       (getdate())  Creation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 
Name varchar(50)         Name 
ObjectName varchar(50)         Object name 
Description varchar(512)   Yes     Description 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurationSecurities_DicConfigurationSecurityLevels WFConfigurationSecurities PK_DicConfigurationSecurityLevel

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicConfigurationSecurityLevel Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicConfigurationTemplates

Description:Dictionary table that contains types of form fields. It also defines types of form field used in predefined process.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
DefinitionTemplateID int   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)          
IsRequied bit       ((0))   
FTID int   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurations_DicConfigurationTemplates WFConfigurations PK_DicConfigurationTemplates
FK_DicConfigurationTemplates_FieldTemplates DicConfigurationTemplates PK_FieldTemplates

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicConfigurationTemplates Yes Yes BTREE ASCENDING 70
UQ_DicConfigurationTemplates_FTID Yes   BTREE ASCENDING 70

Table of Contents

Table: DicDataCacheGroups

Description:Stores data cache groups

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Data cahe group identifier 
ObjectName varchar(50)         Enum member 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_ExpiringObjectsConfigurations_DicDataCacheGroups ExpiringObjectsConfigurations PK_DicDataCacheGroups
FK_ResettableObjectsChangeTimestamps_DicDataCacheGroups ResettableObjectsChangeTimestamps PK_DicDataCacheGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicDataCacheGroups Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicDataSourceTemplates

Description:Dictionary table that contains types of data sources. It also defines predefined data sources available in system (with defined structure).

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)          

Foreign Keys

Name Foreign Table Primary Key
FK_WFDataSources_DicDataSourceTemplates WFDataSources PK_DicDataSourceTemplates

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicDataSourceTemplates Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicDefinitionTemplates

Description:Dictionary table that contains types of predefined processes.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)          

Foreign Keys

Name Foreign Table Primary Key
FK_FieldTemplates_DicDefinitionTemplates FieldTemplates PK_DicDefinitionTemplates
FK_WFDefinitions_DicDefinitionTemplates WFDefinitions PK_DicDefinitionTemplates

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicDefinitionTemplates Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicElementStatuses

Description:Dictionary table that contains statuses of elements.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name nvarchar(50)          
ObjectName varchar(50)          
Description nvarchar(MAX)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
WFElements_fk WFElements PK__DicElementStatus__59C4EC93

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__DicElementStatus__59C4EC93 Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicFieldDetailTypes

Description:Dictionary table that contains types of columns which can be defined within item lists.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_WFDetailConfigs_DicFieldDetailTypes WFDetailConfigs PK_DicFieldDetailTypes
FK_WFFieldDetailDefinitions_DicFieldDetailTypes WFFieldDetailDefinitions PK_DicFieldDetailTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicFieldDetailTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicIndexingOperations

Description:Dictionary table that contains operation types for SolrIndexerQueueItems

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_SolrIndexerQueueItems_DicIndexingOperations SolrIndexerQueueItems PK_DicIndexingOperations

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicIndexingOperations Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicLogCategories

Description:Holds log category

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Enum name 
Name varchar(50)         Enum display name 
EnglishName varchar(50)         Enum display name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AdminWFEventLogs_DicLogCategories AdminWFEventLogs PK_DicLogCategories

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicLogCategories Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicLogSources

Description:Hold system sources

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Enum Name 
Name varchar(50)         Display Name 
EnglishName varchar(50)         Display Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AdminWFEventLogs_DicLogSources AdminWFEventLogs PK_DicLogSources

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicLogSources Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicPersonalDataCleaningModes

Description:Dictionary table containing personal data cleaning modes

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurations_DicPersonalDataCleaningModes WFConfigurations PK_DicPersonalDataCleaningModes
FK_WFDefinitions_DicPersonalDataCleaningModes WFDefinitions PK_DicPersonalDataCleaningModes
FK_WFDetailConfigs_DicPersonalDataCleaningModes WFDetailConfigs PK_DicPersonalDataCleaningModes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicPersonalDataCleaningModes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicPersonalDataTypes

Description:Dictionary table containing personal data types

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurations_DicPersonalDataTypes WFConfigurations PK_DicPersonalDataTypes
FK_WFDetailConfigs_DicPersonalDataTypes WFDetailConfigs PK_DicPersonalDataTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicPersonalDataTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicPersonalDataUsageModes

Description:Dictionary table that contains available personal data usage modes

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       ID 
Name varchar(50)         Name 
EnglishName varchar(50)         Name (English equivalent) 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFDataSources_DicPersonalDataUsageModes WFDataSources PK_DicPersonalDataUsageModes
FK_WFDefinitions_DicPersonalDataUsageModes WFDefinitions PK_DicPersonalDataUsageModes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicPersonalDataUsageModes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicRoles

Description:Dictionary table that contains roles that can be performed by Workflow (BPS) Services.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceRoles_RoleID_Roles_ID ServiceRoles PK_DicRoles

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicRoles Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicSaveObjectTypes

Description:Dictionary table that contains objects that are being configured and saved along with history of changes.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
RootEntity varchar(100)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ChangeOperations_DicSaveObjectTypes ChangeOperations PK_DicSaveObjectTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicSaveObjectTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicSecurityLevels

Description:Dictionary table that contains security access levels that can be defined for elements in the system.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name varchar(50)         Name 
ObjectName varchar(50)          
Description varchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_WFSecurity_DicSecurityLevel WFSecurities PK_DicSecurityLevel

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicSecurityLevel Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicStepTypes

Description:Dictionary table that contains types of steps that can be definedused in the system.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name nvarchar(50)         Nazwa PL 
ObjectName varchar(50)          
Description nvarchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
WFSteps_fk WFSteps PK__DicStepTypes__6FA940BA

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__DicStepTypes__6FA940BA Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicTaskFlags

Description:Table contains informations about task flags

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Flag identifier 
Name varchar(50)         Flag name 
ObjectName varchar(50)         Enum member 
TSInsert datetime       (getdate())  Insert date 
TSUpdate datetime       (getdate())  Last update date 
RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_WFElementTasks_DicTaskFlags WFElementTasks PK_DicTaskFlags

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicTaskFlags Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicTemplateTypes

Description:Dictionary table that contains types of templates e.g. for emails and notifications.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes        
Name varchar(50)          
ObjectName varchar(50)          
Description varchar(512)   Yes      
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_WFMessageTemplates_DicTemplateTypes WFMessageTemplates PK_DicTemplateTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicTemplateTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicWebPartTypes

Description:Dictionary contains WebPartTypes

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       WebPart Type Id 
Name varchar(70)         WebPart Name 
EnglishName varchar(70)         WebPart Name (English equivalent) 
ObjectName varchar(70)         Enum member 
TSInsert datetime       (getdate())  ICreation date 
TSUpdate datetime       (getdate())  Last modification date 
RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AppReports_DicWebPartTypes AppReports PK_DicWebPartTypes
FK_WebPartsConfigurations_DicWebPartTypes WebPartsConfigurations PK_DicWebPartTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicWebPartTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DicWFFieldTypes

Description:Table contains field type ID: 1-Varchar(255) 2-Text 3-Boolean 4.VarcharChoose 5-Int 6-Decimal 7-DateTime 10-DocType 11-AssignedPerson

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TypeID int Yes       Identyfikator 
Name varchar(50)         Nazwa PL 
ObjectName varchar(50)          
Description varchar(512)   Yes     Opis PL 
TSInsert datetime       (getdate())   
TSUpdate datetime       (getdate())   
RowVersion timestamp     Yes    
EnglishName varchar(50)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurations_DicWFFieldTypes WFConfigurations PK_DicWFFieldTypes
FK_WFFieldDefinitions_DicWFFieldTypes WFFieldDefinitions PK_DicWFFieldTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DicWFFieldTypes Yes Yes BTREE ASCENDING 70

Table of Contents

Table: DocTypeAssocciations

Description:Table connecting document types with workflows. Contains information which document types can be processed by particular workflows.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ASS_ID int Yes       Identyfikator 
ASS_DTYPEID int         Relacja do typu dokumentu 
ASS_WFID int         Relacja do tabeli Workflows  
ASS_Name varchar(50)   Yes     Nazwa 
ASS_Description varchar(500)   Yes     Opis 
ASS_TSInsert datetime       (getdate())  Data wstawienia wiersza 
ASS_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
ASS_RowVersion timestamp     Yes   Wersja wiersza 
ASS_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
ASS_IsMobileEnable bit       ((1))   
ASS_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_AIAnalysisConfigurations_DocTypeAssocciations AIAnalysisConfigurations PK_DocTypeAssocciation
FK_WFSecurities_DocTypeAssocciations WFSecurities PK_DocTypeAssocciation
FK_DocTypeAssocciation_WFDocTypes DocTypeAssocciations PK_WFDocTypes
FK_DocTypeAssocciation_WorkFlows DocTypeAssocciations PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_DocTypeAssocciation Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ElementDisplayConfigs

Description:Stores IDs of attributes defined by user or system attributes for each process as displayed on tiles and lists in mobile applications.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
EDC_ID int Yes       Row ID. 
EDC_DEF_ID int         Stores process ID (foreign key to WFDefinitions.DEF_ID). 
EDC_Heading1WfconId int   Yes     Stores ID of attribute which will be displayed as heading (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Heading1SysAttId should be null. 
EDC_Heading1SysAttId int   Yes     Stores ID of system attribute which will be displayed as heading. If it is defined, EDC_Heading1WfconIdshould be null. 
EDC_Details1WfconId int   Yes     Stores ID of attribute which will be displayed as details row 1 (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Details1WfconId should be null. 
EDC_Details1SysAttId int   Yes     Stores ID of system attribute which will be displayed as details row 1. If it is defined, EDC_Details1WfconId be null. 
EDC_Details2WfconId int   Yes     Stores ID of attribute which will be displayed as details row 2 (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Details2WfconId should be null. 
EDC_Details2SysAttId int   Yes     Stores ID of system attribute which will be displayed as details row 2. If it is defined, EDC_Details2WfconId be null. 
EDC_Details3WfconId int   Yes     Stores ID of attribute which will be displayed as details row 3 (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Details3WfconId should be null. 
EDC_Details3SysAttId int   Yes     Stores ID of system attribute which will be displayed as details row 3. If it is defined, EDC_Details3WfconId be null. 
EDC_Details4WfconId int   Yes     Stores ID of attribute which will be displayed as details row 4 (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Details4WfconId should be null. 
EDC_Details4SysAttId int   Yes     Stores ID of system attribute which will be displayed as details row 4. If it is defined, EDC_Details2WfconId be null. 
EDC_Details5WfconId int   Yes     Stores ID of attribute which will be displayed as details row 5 (foreign key to WFConfigurations.WFCON_ID). If it is defined, EDC_Details5WfconId should be null. 
EDC_Details5SysAttId int   Yes     Stores ID of system attribute which will be displayed as details row 5. If it is defined, EDC_Details5WfconId be null. 
EDC_TSInsert datetime       (getdate())  Time of insert. 
EDC_TSUpdate datetime       (getdate())  Time of update. 
EDC_RowVersion timestamp     Yes   Row version. 
EDC_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_ElementDisplayConfigs_WFConfigurations_Heading1WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details1WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details2WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details3WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details4WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details5WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFDefinitions_DEF_ID ElementDisplayConfigs PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ElementDisplayConfigs Yes Yes BTREE ASCENDING 70
UQ_ElementDisplayConfigs_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: ExchangeRates

Description:Table that contains exchange rates from NBP’s (National Bank of Poland) service. Table is refreshed periodically.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
EXC_ID int Yes        
EXC_Code varchar(3)          
EXC_Conversion int          
EXC_PurchasePrice decimal(18,6)   Yes      
EXC_SellPrice decimal(18,6)   Yes      
EXC_PublicationDate datetime          
EXC_TSInsert datetime       (getdate())   
EXC_TSUpdate datetime       (getdate())   
EXC_RowVersion timestamp     Yes    
EXC_Name varchar(50)   Yes     Nazwa waluty 
EXC_Country varchar(100)   Yes     Nazwa kraju, w którym obowiązuje waluta 
EXC_EffectDate datetime         Data obowiązywania kursu 
EXC_AveragePrice decimal(18,6)   Yes      
EXC_AveragePriceSource nvarchar(100)   Yes     Nazwa tabeli, z której został pobrany kurs średni 
EXC_SellPurchasePriceSource nvarchar(100)   Yes     Nazwa tabeli, z której został pobrany kurs kupna i sprzedaży 
EXC_DataSource int         Currency exchange API identifier 
EXC_DirectQuotation int       ((0))  Currency exchange rate quotation type: direct 1 or indirect 0 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ExchangeRates Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ExpiringObjectsConfigurations

Description:Stores info about configuration of resettable objects

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
EOC_ID int Yes       Expirable group from DicDataCacheGroups 
EOC_ExpirationDuration int         Expiration duration in seconds 
EOC_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_ExpiringObjectsConfigurations_DicDataCacheGroups ExpiringObjectsConfigurations PK_DicDataCacheGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ExpiringObjectsConfigurations Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ExternalUsersProfiles

Description:Stores external user profiles from Bps Auth STS

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
EXU_ID int Yes       Identifier 
EXU_TSInsert datetime       (getdate())  Creation date 
EXU_TSUpdate datetime       (getdate())  Last modification date 
EXU_RowVersion timestamp     Yes   Timestamp 
EXU_CreatedBy varchar(50)         Author 
EXU_UpdatedBy varchar(50)         Last modifier 
EXU_SpInternalLogin varchar(350)         Stores user login in SharePoint 
EXU_Email varchar(255)         Stores external user email 
EXU_DisplayName varchar(255)         Stores external user display name 
EXU_Domain varchar(255)         Stores external user domain 
EXU_IsSynchronized bit       ((0))  Stores value indicating if user was synchronized 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ExternalUsersProfiles Yes Yes BTREE ASCENDING 0

Table of Contents

Table: FieldTemplates

Description:Table connects process templates with predefined form fields. Defines which predefined form fields are available in which processes.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
FT_ID int Yes        
FT_DefinitionTemplateID int          
FT_FDEFID int          
FT_TSInsert datetime       (getdate())   
FT_TSUpdate datetime       (getdate())   
FT_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_DicConfigurationTemplates_FieldTemplates DicConfigurationTemplates PK_FieldTemplates
FK_FieldTemplates_DicDefinitionTemplates FieldTemplates PK_DicDefinitionTemplates
FK_FieldTemplates_WFFieldDefinitions FieldTemplates PK_WFFieldDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_FieldTemplates Yes Yes BTREE ASCENDING 70
UQ_FT_DefinitionTemplateID_FT_FDEFID Yes   BTREE ASCENDING 70

Table of Contents

Table: FlexiCaptureProjects

Description:Table asynchronous contains Flexi Capture projects (in binary form) that were imported from Designer Studio.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
FCP_ID int Yes        
FCP_Name varchar(100)          
FCP_ProjectData varbinary(MAX)          
FCP_ProjectDirectoryPath varchar(255)          
FCP_ProjectName varchar(255)          
FCP_ProjectModificationDate datetime          
FCP_SourceComputerName varchar(255)          
FCP_TSInsert datetime       (getdate())   
FCP_TSUpdate datetime       (getdate())   
FCP_CreatedBy varchar(50)          
FCP_UpdatedBy varchar(50)          
FCP_RowVersion timestamp     Yes    
FCP_IsDeleted bit       ((0))   
FCP_DefinitionsBlocks varchar(MAX)   Yes      
FCP_Guid varchar(36)       (newid())   

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_FlexiCaptureProjects Yes Yes BTREE ASCENDING 70
UQ_FlexiCaptureProjects_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: FormPathAssocs

Description:Table connects paths with forms. Defines which paths are available in particular forms.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
FPA_ID int Yes       Identyfikator powiązania 
FPA_FRMID int         Identyfikator formularza 
FPA_PATHID int         Identyfikator ścieżki 
FPA_IsVisible bit       ((0))  Czy ścieżka jest widoczna na formularzu 
FPA_TSInsert datetime       (getdate())  Data wstawienia wiersza 
FPA_TSUpdate datetime       (getdate())  Data aktualizacji wiersza 
FPA_RowVersion timestamp     Yes   Wersja wiersza 
FPA_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_FormPathAssocs_WFAvaiblePaths FormPathAssocs PK_WFAvaiblePaths
FK_FormPathAssocs_WFStepForms FormPathAssocs PK_WFStepForms

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__FormPathAssocs__7552CCA2 Yes Yes BTREE ASCENDING 70
UQ_FormPathAssocs Yes   BTREE ASCENDING 70

Table of Contents

Table: GlobalParameters

Description:Global system parameters for any process in database. Store data as id, value (text).

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PRM_ID int Yes        
PRM_Name varchar(50)          
PRM_Value varchar(MAX)   Yes      
PRM_TSInsert datetime       (getdate())   
PRM_TSUpdate datetime       (getdate())   
PRM_RowVersion timestamp     Yes    
PRM_IsDeleted bit       ((0))   

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_GlobalParameters Yes Yes BTREE ASCENDING 70
UQ_GlobalParameters_Name Yes   BTREE ASCENDING 70

Table of Contents

Table: HistoryImports

Description:Table contains history of all exported processes

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IMPH_ID int Yes       Identifier 
IMPH_Name varchar(140)   Yes     Import name 
IMPH_Description varchar(MAX)   Yes     Import description 
IMPH_TSInsert datetime       (getdate())  Creation date 
IMPH_TSUpdate datetime       (getdate())  Last modification date 
IMPH_RowVersion timestamp     Yes   Timestamp 
IMPH_IsDeleted bit       ((0))  Is record deleted 
IMPH_CreatedBy varchar(50)         Author 
IMPH_UpdatedBy varchar(50)         Last modifier 
IMPH_Log varchar(MAX)   Yes     Import Log 
IMPH_IsSuccess bit       ((1))  Indicates whether the import was successful 
IMPH_APPID int         Application ID 

Foreign Keys

Name Foreign Table Primary Key
FK_HistoryImports_WFApplications HistoryImports PK_WFApplications

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_HistoryImports Yes Yes BTREE ASCENDING 0

Table of Contents

Table: HotFolders

Description:Table contains Hotfolders definitions.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
HF_ID int Yes        
HF_TSInsert datetime       (getdate())   
HF_TSUpdate datetime       (getdate())   
HF_RowVersion timestamp     Yes    
HF_CreatedBy varchar(50)          
HF_Name varchar(50)          
HF_IsActive bit          
HF_Priority int          
HF_SourceDirectory varchar(255)          
HF_ArchiveDirectory varchar(255)          
HF_ErrorDirectory varchar(255)          
HF_FileTypesFilter varchar(50)          
HF_ResultFileNameTemplate varchar(100)          
HF_WorkflowMode int          
HF_FindBarcodes bit          
HF_LookingForBarcodeMode int       ((0))   
HF_CustomBarcodeRegex varchar(50)   Yes      
HF_BarcodeFirstIteration int   Yes      
HF_BarcodeSecondIteration int   Yes      
HF_BarcodeThirdIteration int   Yes      
HF_BarcodeSearchDPIMode int       ((0))   
HF_SplitResultFileDataSource int       ((0))   
HF_StartingProcessID int   Yes      
HF_StartingDocTypeID int   Yes      
HF_StartingWorkflowID int   Yes      
HF_StartingPathID int   Yes      
HF_StartingCompanyID int   Yes      
HF_BarcodeMissingMode int       ((0))   
HF_ElementMissingMode int       ((0))   
HF_SplitResultFileByBarcode bit       ((0))   
HF_Description varchar(1000)   Yes      
HF_UpdatedBy varchar(50)          
HF_Guid varchar(36)       (newid())   
HF_AssignedServer varchar(255)   Yes      
HF_BarcodeMissingJoinToExistingErrorMode int       ((0))   
HF_SplitStartWorkflowMode int   Yes   ((0))  Mode for starting workflow documents after split 
HF_BarcodesOrder varchar(MAX)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_HotProcessingFieldsSettings_HotFolders HotProcessingFieldsSettings PK_HotFolders
FK_HotFolders_Companies HotFolders PK_Companies
FK_HotFolders_WFDefinitions HotFolders PK_WFDefinitions
FK_HotFolders_WFDocTypes HotFolders PK_WFDocTypes
FK_HotFolders_WorkFlows HotFolders PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_HotFolders Yes Yes BTREE ASCENDING 70
UQ_HotFolders_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: HotMailBoxs

Description:Table contains Hotmailboxes definitions.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
HM_ID int Yes        
HM_TSInsert datetime       (getdate())   
HM_TSUpdate datetime       (getdate())   
HM_RowVersion timestamp     Yes    
HM_CreatedBy varchar(50)          
HM_UpdatedBy varchar(50)          
HM_Name varchar(255)          
HM_Description varchar(1000)   Yes      
HM_IsActive bit          
HM_Priority int       ((5))   
HM_Type int          
HM_UseCustomExchangeParameters bit          
HM_CustomExchangeServerVersion varchar(50)   Yes      
HM_CustomExchangeServerAddress varchar(50)   Yes      
HM_ExchangeUserLogin varchar(50)   Yes      
HM_ExchangeUserPassword varchar(50)   Yes      
HM_SourceIsPublicFolder bit          
HM_ArchiveDirectory varchar(1000)          
HM_ErrorDirectory varchar(1000)          
HM_EmailSenderFilteringDataSourceID int   Yes      
HM_EmailSenderFilteringConfiguration varchar(MAX)   Yes      
HM_WorkflowMode int          
HM_AttachmentsFilterRegex varchar(MAX)   Yes      
HM_ResultFileNameTemplate varchar(100)   Yes      
HM_MoreThanOneToProcessMode int          
HM_LookingForIDMode int          
HM_LookingForIDRegex varchar(50)   Yes      
HM_ProcessEmailsWithoutAttachments bit          
HM_VerifyAttachmentExistence bit          
HM_UploadOriginalFile bit          
HM_UploadAdditionalAttachments bit          
HM_AdditionalAttachmentsRegex varchar(50)   Yes      
HM_LookingForBarcodeMode int          
HM_CustomBarcodeRegex varchar(50)   Yes      
HM_BarcodeFirstIteration int   Yes      
HM_BarcodeSecondIteration int   Yes      
HM_BarcodeThirdIteration int   Yes      
HM_SplitResultFileByBarcode bit          
HM_SplitResultFileDataSource int       ((0))   
HM_StartingProcessID int   Yes      
HM_StartingDocTypeID int   Yes      
HM_StartingWorkflowID int   Yes      
HM_StartingPathID int   Yes      
HM_StartingCompanyID int   Yes      
HM_SourceDirectory varchar(1000)          
HM_BarcodeSearchDPIMode int          
HM_OCRUploadMode int       ((0))   
HM_EmailsProcessingLimitPerDay int       ((0))   
HM_EmailsProcessingLimitInSingleRun int       ((10))   
HM_Guid varchar(36)       (newid())   
HM_IDNotFoundMode int       ((0))   
HM_BarcodeNotFoundMode int       ((0))   
HM_AssignedServer varchar(255)   Yes      
HM_UploadEmailContentMode int       ((0))  Determines mode in which mail should be uploaded from HotMailBox 
HM_DaysLimitToOutdate int       ((30))  Column contains number of days in past after which emails with older date will be ignored. 
HM_SplitStartWorkflowMode int   Yes   ((0))  Mode for starting workflow documents after split 
HM_BarcodesOrder varchar(MAX)   Yes      
HM_ArchiveIsPublicFolder bit       ((0))  Archive directory is public folder 
HM_ErrorIsPublicFolder bit       ((0))  Error directory is public folder 

Foreign Keys

Name Foreign Table Primary Key
FK_AdminHotMailboxLogs_HotMailBoxes AdminHotMailboxLogs PK_HotMailBoxs
FK_HotMailBoxs_Companies HotMailBoxs PK_Companies
FK_HotMailBoxs_WFAvaiblePaths HotMailBoxs PK_WFAvaiblePaths
FK_HotMailBoxs_WFDefinitions HotMailBoxs PK_WFDefinitions
FK_HotMailBoxs_WFDocTypes HotMailBoxs PK_WFDocTypes
FK_HotMailBoxs_WorkFlows HotMailBoxs PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_HotMailBoxs Yes Yes BTREE ASCENDING 70
UQ_HotMailBoxs_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: HotProcessingFieldsSettings

Description:Table contains data about values inserted to form fields on element start or on adding attachment to elements inside hotfolders and hotmailboxes.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
HPFS_ID int Yes        
HPFS_TSInsert datetime       (getdate())   
HPFS_TSUpdate datetime       (getdate())   
HPFS_RowVersion timestamp     Yes    
HPFS_CreatedBy varchar(50)          
HPFS_FDEFName varchar(50)          
HPFS_Value varchar(MAX)          
HPFS_HMID int   Yes      
HPFS_HFID int   Yes      
HPFS_SettingMode int          
HPFS_UpdatedBy varchar(50)          

Foreign Keys

Name Foreign Table Primary Key
FK_HotProcessingFieldsSettings_HotFolders HotProcessingFieldsSettings PK_HotFolders

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_HotProcessingFieldsSettings Yes Yes BTREE ASCENDING 70

Table of Contents

Table: IdentityLogins

Description:Stores identity user external providers logins

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IL_ID int Yes       Identifier 
IL_LoginProvider varchar(128)         External provider identifier 
IL_ProviderKey varchar(128)         External provider user identifier 
IL_IUID int         Identity user identifier 
IL_TSInsert datetime       (getdate())  Creation date 
IL_TSUpdate datetime       (getdate())  Last modification date 
IL_RowVersion timestamp     Yes   Timestamp 
IL_CreatedBy varchar(50)         Author 
IL_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_IdentityLogins_IdentityUsers_IUID IdentityLogins PK_IdentityUsers

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_IdentityLogins Yes Yes BTREE ASCENDING 70

Table of Contents

Table: IdentityRefreshTokens

Description:Stores refresh tokens for portal users

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IRT_ID int Yes       Identifier 
IRT_TokenIdentifier varchar(255)         Refresh token unique identifier 
IRT_UserName varchar(255)         User for which token is issued 
IRT_ExpirationUnixTimeMiliseconds bigint         Expiration time, in miliseconds in unix time 
IRT_TSInsert datetime       (getdate())  Creation date 
IRT_TSUpdate datetime       (getdate())  Last modification date 
IRT_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_IdentityRefreshTokens Yes Yes BTREE ASCENDING 0

Table of Contents

Table: IdentityRoles

Description:Stores identity roles

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IR_ID int Yes       Identifier 
IR_Name varchar(256)         Identity role name 
IR_TSInsert datetime       (getdate())  Creation date 
IR_TSUpdate datetime       (getdate())  Last modification date 
IR_RowVersion timestamp     Yes   Timestamp 
IR_CreatedBy varchar(50)         Author 
IR_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_IdentityUserRoles_IdentityRoles_IRID IdentityUserRoles PK_IdentityRoles

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_IdentityRoles Yes Yes BTREE ASCENDING 70

Table of Contents

Table: IdentityUserRoles

Description:Stores relation between users and roles

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IUR_ID int Yes       Identifier 
IUR_IUID int         Identity user id 
IUR_IRID int         Identity role id 
IUR_TSInsert datetime       (getdate())  Creation date 
IUR_TSUpdate datetime       (getdate())  Last modification date 
IUR_RowVersion timestamp     Yes   Timestamp 
IUR_CreatedBy varchar(50)         Author 
IUR_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_IdentityUserRoles_IdentityRoles_IRID IdentityUserRoles PK_IdentityRoles
FK_IdentityUserRoles_IdentityUsers_IUID IdentityUserRoles PK_IdentityUsers

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_IdentityUserRoles Yes Yes BTREE ASCENDING 70

Table of Contents

Table: IdentityUsers

Description:Stores identity users entities

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IU_ID int Yes       Identifier 
IU_Email varchar(256)   Yes     Users email 
IU_EmailConfirmed bit         Is email confirmed 
IU_PasswordHash varchar(MAX)   Yes     Password hash 
IU_SecurityStamp varchar(MAX)   Yes     Security stamp 
IU_PhoneNumber varchar(MAX)   Yes     Phone number 
IU_PhoneNumberConfirmed bit         Is phone number confirmed 
IU_TwoFactorEnabled bit         Is two factor auth enabled 
IU_LockoutEndDateUtc datetime   Yes     Account lockout end date 
IU_LockoutEnabled bit         Is lockout enabled 
IU_AccessFailedCount int         Access failed count 
IU_UserName varchar(256)         User name 
IU_TSInsert datetime       (getdate())  Creation date 
IU_TSUpdate datetime       (getdate())  Last modification date 
IU_RowVersion timestamp     Yes   Timestamp 
IU_CreatedBy varchar(50)         Author 
IU_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_Claims_IdentityUsers_IUID Claims PK_IdentityUsers
FK_IdentityLogins_IdentityUsers_IUID IdentityLogins PK_IdentityUsers
FK_IdentityUserRoles_IdentityUsers_IUID IdentityUserRoles PK_IdentityUsers

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_IdentityUsers Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ImportExportCompatibilities

Description:Table contains branch number and build version

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IECB_ID int Yes       Identifier 
IECB_BranchNumber varchar(50)         Column with branch number 
IECB_BuildVersion int         Column with build version 
IECB_TSInsert datetime       (getdate())  Creation date 
IECB_TSUpdate datetime       (getdate())  Last modification date 
IECB_RowVersion timestamp     Yes   Timestamp 
IECB_IsDeleted bit       ((0))  Is record deleted 
IECB_CreatedBy varchar(50)         Author 
IECB_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ImportExportCompatibilities Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ImportExportConfigurations

Description:Configuration table that contains data needed to perform import and export operations in BPS Designer Studio.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IEC_ID int Yes       Identifier 
IEC_TableName varchar(255)         Names of tables that will be imported/exported during import/export operation 
IEC_BracketsIdentificator varchar(10)         Identifications of brackets associated with imported/exported table 
IEC_TSInsert datetime       (getdate())  Creation date 
IEC_TSUpdate datetime       (getdate())  Last modification date 
IEC_RowVersion timestamp     Yes   Timestamp 
IEC_IsDeleted bit       ((0))  Is record deleted 
IEC_VisibleInRaport bit       ((0))  if column is visible on import raport 
IEC_NameColumn varchar(200)   Yes     entities' column table where you can find name 
IEC_IsCustomHandled bit       ((0))  If column should be custom handled during import/export 
IEC_AssocTable bit       ((0))  Is association table 
IEC_BulkSavable bit       ((0))  IS bulk insert enabled 
IEC_IsExportable bit       ((0))  Defines if table should be used by import export mechansim 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ImportExportConfigurations Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ImportExportSecurities

Description:Contains columns with security

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
IES_ID int Yes       Identifier 
IES_TableName varchar(255)         Table name 
IES_ColumnName varchar(255)         Security column name 
IES_TSInsert datetime       (getdate())  Creation date 
IES_TSUpdate datetime       (getdate())  Last modification date 
IES_RowVersion timestamp     Yes   Timestamp 
IES_IsDeleted bit       ((0))  Is record deleted 
IES_Guid varchar(36)       (newid())  BPS environment (DEV/TEST/PROD) independent identifier 
IES_ContainsXML bit       ((0))  Determines if column can contains security wrapped in xml 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ImportExportSecurities Yes Yes BTREE ASCENDING 0

Table of Contents

Table: KPIElements

Description:Table contains workflow usage data such as active task count per each day. Content is updated by BPS Service based on KPI schedule configuration.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
KPIELEM_ID int Yes       Identifier 
KPIELEM_TSInsert datetime       (getdate())  Creation date 
KPIELEM_TSUpdate datetime       (getdate())  Last modification date 
KPIELEM_RowVersion timestamp     Yes   Timestamp 
KPIELEM_IsDeleted bit       ((0))  Is record deleted 
KPIELEM_CreatedBy varchar(50)         Author 
KPIELEM_UpdatedBy varchar(50)         Last modifier 
KPIELEM_Date datetime         Day of analysis 
KPIELEM_DEFID int         Relation to process 
KPIELEM_WFID int   Yes     Relation to workflow 
KPIELEM_STPID int   Yes     Relation to step 
KPIELEM_AllItems int         All element count 
KPIELEM_AllActiveElems int         Active element count 
KPIELEM_AllActiveTasks int         Active task count 
KPIELEM_AllOverdueTasks int         Active task with exceeded execution time count 
KPIELEM_CreatedNewElemsInCurrentDay int         Element created in day of analysis count 
KPIELEM_FinishedElemsInCurrentDay int         Element finished in day of analysis count 
KPIELEM_FinishedTasksInCurrentDay int         Task finished in day of analysis count 

Foreign Keys

Name Foreign Table Primary Key
FK_KPIElements_WFDefinitions KPIElements PK_WFDefinitions
FK_KPIElements_WFSteps KPIElements PK_WFSteps
FK_KPIElements_WorkFlows KPIElements PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_KPIElements Yes Yes BTREE ASCENDING 0

Table of Contents

Table: KPIQueue

Description:Table contains queue usage data such as OCR AI, textlayer, emails and timeouts. Content is updated by BPS Service based on KPI schedule configuration.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
KPIQUE_ID int Yes       Identifier 
KPIQUE_TSInsert datetime       (getdate())  Creation date 
KPIQUE_TSUpdate datetime       (getdate())  Last modification date 
KPIQUE_RowVersion timestamp     Yes   Timestamp 
KPIQUE_IsDeleted bit       ((0))  Is record deleted 
KPIQUE_CreatedBy varchar(50)         Author 
KPIQUE_UpdatedBy varchar(50)         Last modifier 
KPIQUE_Date datetime         Day of analysis 
KPIQUE_TextLayer int         TextLayer queue item count 
KPIQUE_OCRAI int         OCR AI recognition queue item count 
KPIQUE_OCRAILearn int         OCR AI learn queue item count 
KPIQUE_Mail int         Email send queue item count 
KPIQUE_Timeouts int         Active timeout queue item count 
KPIQUE_TimeoutsInSleep int         TextLayer queue item count 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_KPIQueue Yes Yes BTREE ASCENDING 0

Table of Contents

Table: KPITops

Description:Table contains workflow usage data by users such as active task count per each day or top 100 users with task execution time exceeded. Content is updated by BPS Service based on KPI schedule configuration.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
KPITOP_ID int Yes       Identifier 
KPITOP_TSInsert datetime       (getdate())  Creation date 
KPITOP_TSUpdate datetime       (getdate())  Last modification date 
KPITOP_RowVersion timestamp     Yes   Timestamp 
KPITOP_IsDeleted bit       ((0))  Is record deleted 
KPITOP_CreatedBy varchar(50)         Author 
KPITOP_UpdatedBy varchar(50)         Last modifier 
KPITOP_TopTypeID int         Type of aggregation.
1 - tasks with exceed execution time
2 - delegated tasks
3 - actions in BPS, i.e. path transitions 
KPITOP_AggregationLevelID int         Aggregation level type. 0 - global level, 1 - Process level, 2 - WorkFlow level, 3 - Step level  
KPITOP_Date datetime         Day of analysis 
KPITOP_DEFID int   Yes     Relation to process 
KPITOP_WFID int   Yes     Relation to workflow 
KPITOP_STPID int   Yes     Relation to step 
KPITOP_Login varchar(255)         User login 
KPITOP_UserName varchar(255)         User display name 
KPITOP_Quantity int         Quantity of elements, tasks, etc. 

Foreign Keys

Name Foreign Table Primary Key
FK_KPITops_WFDefinitions KPITops PK_WFDefinitions
FK_KPITops_WFSteps KPITops PK_WFSteps
FK_KPITops_WorkFlows KPITops PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_KPITops Yes Yes BTREE ASCENDING 0

Table of Contents

Table: MobileFavorites

Description:Table contains user's favorites. Table is used by mobile applications.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
MFA_ID int Yes       Favorite's id 
MFA_Name varchar(50)         Favorite's name 
MFA_Type int         Favorite's type 
MFA_TSInsert datetime       (getdate())  Date of adding 
MFA_TSUpdate datetime       (getdate())  Modification date 
MFA_User varchar(255)         Favorite's user 
MFA_UserName varchar(255)         Favorite's user name 
MFA_AdditionalInfo varchar(MAX)         Favorite's additional info 
MFA_RowVersion timestamp     Yes   Row version 
MFA_DBID int   Yes     Database Id 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_MobileFavorites Yes Yes BTREE ASCENDING 70

Table of Contents

Table: MobilePushNotificationsQueueItems

Description:Table contains mobile push notifications queue

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PNQ_ID int Yes       Identifier 
PNQ_TSInsert datetime       (getdate())  Creation date 
PNQ_TSUpdate datetime       (getdate())  Last modification date 
PNQ_RowVersion timestamp     Yes   Timestamp 
PNQ_Priority int         Priority 
PNQ_ServiceName varchar(255)   Yes     Processing service name 
PNQ_ThreadId int   Yes     Processing Thread Id 
PNQ_Status int       ((0))  Status 
PNQ_AttemptsNumber int       ((0))  Attempts number 
PNQ_LastError varchar(MAX)   Yes     Last error 
PNQ_LastAttemptTime datetime   Yes     Last attempt time 
PNQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
PNQ_DEFID int         Process ID 
PNQ_UserLogin varchar(250)   Yes     Stores push receiver login 
PNQ_ForcePush bit       ((0))  Should force push notification 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_MobilePushNotificationsQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: OcrAiFieldDefinitions

Description:Table contains OCR AI field definitions.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAD_ID int Yes       Row ID 
OAD_TSInsert datetime       (getdate())  Time of insert 
OAD_TSUpdate datetime       (getdate())  Time of update 
OAD_RowVersion timestamp     Yes   Row version 
OAD_OAPID int         Project ID 
OAD_FieldId varchar(127)         OCR AI field key 
OAD_FieldName varchar(127)         OCR AI field friendly name 
OAD_IsCustom bit       ((0))  Marks if field was created by user 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiFields_OcrAiFieldDefinitions OcrAiFields PK_OcrAiFieldDefinitions
FK_OcrAiFieldDefinitions_OcrAiProjects OcrAiFieldDefinitions PK_OcrAiProjects

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiFieldDefinitions Yes Yes BTREE ASCENDING 0
UQ_OcrAiFieldDefinitions_OcrAiProjects Yes   BTREE ASCENDING 0

Table of Contents

Table: OcrAiFields

Description:Table contains OCR AI fields data.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAF_ID int Yes       Row ID 
OAF_TSInsert datetime       (getdate())  Time of insert 
OAF_TSUpdate datetime       (getdate())  Time of update 
OAF_RowVersion timestamp     Yes   Row version 
OAF_OADID int         Field Definition ID 
OAF_WagFile varchar(MAX)         OCR AI neural network 
OAF_FieldFile varchar(MAX)         OCR AI neural network configuration 
OAF_OAVID int         Project Version ID 
OAF_RecPositive int   Yes     Count of correctly recognized values in sample 
OAF_RecNegative int   Yes     Count of incorrectly recognized values in sample 
OAF_UnrecPositive int   Yes     Count of correctly unrecognized values in sample 
OAF_UnrecNegative int   Yes     Count of incorrectly unrecognized values in sample 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiFields_OcrAiFieldDefinitions OcrAiFields PK_OcrAiFieldDefinitions
FK_OcrAiFields_OcrAiProjectVersions OcrAiFields PK_OcrAiProjectVersionsDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiWeights Yes Yes BTREE ASCENDING 0
UQ_OcrAiFields_OcrAiFieldDefinitions_OcrAiProjectVersions Yes   BTREE ASCENDING 0

Table of Contents

Table: OcrAiLearnQueueItems

Description:Table contains OCR AI Learn queue for attachments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OALQ_ID int Yes       Row ID 
OALQ_ATTID int         Foreign key to WFDataAttachmets 
OALQ_ACTID int         Foreign key to WFActions 
OALQ_TSInsert datetime       (getdate())  Time of insert 
OALQ_TSUpdate datetime       (getdate())  Time of update 
OALQ_RowVersion timestamp     Yes   Row version 
OALQ_Priority int         Priority 
OALQ_ServiceName varchar(255)   Yes     Processing service name 
OALQ_Status int       ((0))  Status 
OALQ_AttemptsNumber int       ((0))  Attempts number 
OALQ_Fields varchar(MAX)         Workflow fields for learn (eg. AttText1) 
OALQ_LastAttemptTime datetime   Yes     Last attempt time 
OALQ_LastError varchar(MAX)   Yes     Last error 
OALQ_ThreadId int   Yes     Processing Thread Id for Ocr AI Learn 
OALQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
OALQ_LastUploadAttemptTime datetime   Yes     Last uplaod attempt time 
OALQ_UploadFinishedTime datetime   Yes     Upload finished time 
OALQ_SectionGuid varchar(36)   Yes     Action section GUID 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiLearnQueueItems_WFActions OcrAiLearnQueueItems PK_WFActions
FK_OcrAiLearnQueueItems_WFDataAttachmets OcrAiLearnQueueItems PK_WFDataAttachmets

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiLearnQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: OcrAiProjects

Description:Table contains OCR AI project files.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAP_ID int Yes       Row ID 
OAP_TSInsert datetime       (getdate())  Time of insert 
OAP_TSUpdate datetime       (getdate())  Time of update 
OAP_RowVersion timestamp     Yes   Row version 
OAP_Name varchar(127)         Project name 
OAP_File image         Project file 
OAP_FileName varchar(255)   Yes     Project file name 
OAP_FileVersion varchar(50)   Yes     Project file version 
OAP_Guid varchar(36)       (newid())  Guid 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiFieldDefinitions_OcrAiProjects OcrAiFieldDefinitions PK_OcrAiProjects
FK_OcrAiProjectsToAttachments_OcrAiProjects OcrAiProjectsToAttachments PK_OcrAiProjects
FK_OcrAiProjectVersions_OcrAiProjects OcrAiProjectVersions PK_OcrAiProjects

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiProjects Yes Yes BTREE ASCENDING 0
UQ_OcrAiProjects_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: OcrAiProjectsToAttachments

Description:Table contains OCR AI Learn Data

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAPA_ID int Yes       Row ID 
OAPA_ATTID int         Attachment ID 
OAPA_OAPID int         Project ID 
OAPA_TSInsert datetime       (getdate())  Time of insert 
OAPA_TSUpdate datetime       (getdate())  Time of update 
OAPA_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiProjectsToAttachments_OcrAiProjects OcrAiProjectsToAttachments PK_OcrAiProjects
FK_OcrAiProjectsToAttachments_WFDataAttachmets OcrAiProjectsToAttachments PK_WFDataAttachmets

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiProjectsToAttachments Yes Yes BTREE ASCENDING 0
UQ_OcrAiProjectsToAttachments_WFDataAttachmets_OcrAiProjects Yes   BTREE ASCENDING 0

Table of Contents

Table: OcrAiProjectVersions

Description:Table contains info about OCR AI projects versions.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAV_ID int Yes       Row ID 
OAV_OAPID int         Project ID 
OAV_DistinguisherValue varchar(127)   Yes     Distinguisher 
OAV_VersionNumber int         Project version number 
OAV_TSInsert datetime       (getdate())  Time of insert 
OAV_TSUpdate datetime       (getdate())  Time of update 
OAV_RowVersion timestamp     Yes   Row version 
OAV_ProjectName varchar(255)   Yes     Project name 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiFields_OcrAiProjectVersions OcrAiFields PK_OcrAiProjectVersionsDefinitions
FK_OcrAiProjectVersions_OcrAiProjects OcrAiProjectVersions PK_OcrAiProjects

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiProjectVersionsDefinitions Yes Yes BTREE ASCENDING 0
UQ_OcrAiProjectVersions Yes   BTREE ASCENDING 0

Table of Contents

Table: OcrAiQueueItems

Description:Table contains OCR AI queue for attachments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OAQ_ID int Yes       Row ID 
OAQ_TSInsert datetime       (getdate())  Time of insert 
OAQ_TSUpdate datetime       (getdate())  Time of update 
OAQ_RowVersion timestamp     Yes   Row version 
OAQ_Priority int         Priority 
OAQ_ServiceName varchar(255)   Yes     Processing service name 
OAQ_ATTID int         Foreign key to WFDataAttachmets 
OAQ_Status int       ((0))  Status 
OAQ_AttemptsNumber int       ((0))  Attempts number 
OAQ_LastAttemptTime datetime   Yes     Last attempt time 
OAQ_LastError varchar(MAX)   Yes     Last error 
OAQ_ThreadId int   Yes     Processing Thread Id for Text Layer in OCR 
OAQ_ACTID int         Foreign key to WFActions 
OAQ_LastUploadAttemptTime datetime   Yes     Last uplaod attempt time 
OAQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
OAQ_UploadFinishedTime datetime   Yes     Upload finished time 
OAQ_SectionGuid varchar(36)   Yes     Action section GUID 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiQueueItems_WFActions OcrAiQueueItems PK_WFActions
FK_OcrAiQueueItems_WFDataAttachmets OcrAiQueueItems PK_WFDataAttachmets

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OcrAiQueueItems Yes Yes BTREE ASCENDING 0
UQ_OcrAiQueueItems_WFDataAttachmets Yes   BTREE ASCENDING 0

Table of Contents

Table: OutlookFavorites

Description:Table contains user favorites places in structure. Table is used in Outlook add-in.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OFA_ID int Yes        
OFA_Name varchar(50)          
OFA_MoveType int          
OFA_MODID int   Yes      
OFA_TSInsert datetime       (getdate())   
OFA_TSUpdate datetime       (getdate())   
OFA_User varchar(255)          
OFA_UserName varchar(255)          
OFA_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_OutlookFavoritesParts_OutlookFavorites OutlookFavoritesParts PK_OutlookFavorites
FK_OutlookFavorites_MoveDefinitions OutlookFavorites PK_AppExploreDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OutlookFavorites Yes Yes BTREE ASCENDING 70

Table of Contents

Table: OutlookFavoritesParts

Description:Table contains individual selection in transition structure. Used in Outlook add-in.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
OFP_ID int Yes       Favorite part identifier 
OFP_OFAID int         Identifier of the related favorite 
OFP_Level int         Level in structure 
OFP_ChoiceValue varchar(255)   Yes     Chosen value 
OFP_ChoiceName varchar(255)   Yes     Display name of the chosen value 
OFP_TSInsert datetime       (getdate())  Date of adding 
OFP_TSUpdate datetime       (getdate())  Modification date 
OFP_Sort varchar(255)   Yes     Chosen sorting 
OFP_WFDID int   Yes     Identifier of the related element 
OFP_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_OutlookFavoritesParts_OutlookFavorites OutlookFavoritesParts PK_OutlookFavorites

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_OutlookFavoritesParts Yes Yes BTREE ASCENDING 70

Table of Contents

Table: PersonalDataRemovalQueueItems

Description:Service queue for personal data removal action

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PDQ_ID int Yes       Identifier 
PDQ_DictionaryTable varchar(255)         Personal data dictionary table name 
PDQ_DictionaryID int         Personal data dictionary identifier 
PDQ_SearchKey varchar(255)         Identifier of element in dictionary 
PDQ_ActionID int         Personal data removal action ID 
PDQ_Author varchar(50)         Person who triggered the action 
PDQ_TSInsert datetime       (getdate())  Creation date 
PDQ_TSUpdate datetime       (getdate())  Last modification date 
PDQ_RowVersion timestamp     Yes   Timestamp 
PDQ_Priority int         Priority 
PDQ_ServiceName varchar(255)   Yes     Processing service name 
PDQ_Status int       ((0))  Status 
PDQ_AttemptsNumber int       ((0))  Attempts number 
PDQ_LastAttemptTime datetime   Yes     Last attempt time 
PDQ_LastError varchar(MAX)   Yes     Last error 
PDQ_ThreadId int   Yes     Processing Thread Id 
PDQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
PDQ_SectionGuid varchar(36)   Yes     Action section GUID 
PDQ_ActionElementID int   Yes     ID of an element on which action was fired 
PDQ_COMID int         Company ID 

Foreign Keys

Name Foreign Table Primary Key
FK_PersonalDataRemovalQueueItems_Companies PersonalDataRemovalQueueItems PK_Companies
FK_PersonalDataRemovalQueueItems_WFActions PersonalDataRemovalQueueItems PK_WFActions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_PersonalDataRemovalQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: PluginFiles

Description:Table that stores the date of plugin files

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PLF_ID int Yes       Identifier 
PLF_FileName varchar(255)         Plugin file name 
PLF_FullName varchar(MAX)         Plugin full assembly name 
PLF_PLPID int         Related plugin package id 
PLF_Content image         File content 
PLF_Guid varchar(36)       (newid())  Global unique ID 
PLF_RowVersion timestamp     Yes   Timestamp 
PLF_TSInsert datetime       (getdate())  Creation date 
PLF_TSUpdate datetime       (getdate())  Last modification date 
PLF_ContentHash binary(32)   Yes     File content hash 

Foreign Keys

Name Foreign Table Primary Key
FK_WFPlugins_PluginFiles WFPlugIns PK_PluginFiles
FK_WFPlugins_PluginFiles_SP WFPlugIns PK_PluginFiles
FK_PluginFiles_PluginPackages PluginFiles PK_PluginPackages

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_PluginFiles Yes Yes BTREE ASCENDING 0

Table of Contents

Table: PluginPackages

Description:Table that stores the date of plugin packages

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PLP_ID int Yes       Identifier 
PLP_Name varchar(MAX)         Package name 
PLP_Guid varchar(36)       (newid())  Global unique ID 
PLP_Version int         Package version 
PLP_Metadata varchar(MAX)         Package metadata 
PLP_RowVersion timestamp     Yes   Timestamp 
PLP_TSInsert datetime       (getdate())  Creation date 
PLP_TSUpdate datetime       (getdate())  Last modification date 
PLP_IsSystem bit         Default package extension provided by bps 

Foreign Keys

Name Foreign Table Primary Key
FK_PluginFiles_PluginPackages PluginFiles PK_PluginPackages

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_PluginPackages Yes Yes BTREE ASCENDING 0

Table of Contents

Table: PortalAuthenticationProviders

Description:Stores credentials for authentication providers in portal

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PAP_ID int Yes       Identifier 
PAP_Type int         Type of provider 
PAP_Active bit       ((1))  Is provider active 
PAP_Name varchar(250)         Caption of provider 
PAP_ClientId varchar(MAX)   Yes     Client id 
PAP_ClientSecret varchar(MAX)   Yes     Client secret 
PAP_PublicHost varchar(MAX)   Yes     Public host 
PAP_Issuer varchar(MAX)   Yes     Issuer 
PAP_TSInsert datetime       (getdate())  Creation date 
PAP_TSUpdate datetime       (getdate())  Last modification date 
PAP_RowVersion timestamp     Yes   Timestamp 
PAP_CreatedBy varchar(50)         Author 
PAP_UpdatedBy varchar(50)         Last modifier 
PAP_IsMultiTenant bit       ((0))  Is provider configured for multi tenant 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_PortalAuthenticationProviders Yes Yes BTREE ASCENDING 0

Table of Contents

Table: PortalFavourites

Description:List of favourities for portal

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PFV_ID int Yes       Identifier 
PFV_TSInsert datetime       (getdate())  Date of row insertion 
PFV_TSUpdate datetime       (getdate())  Date of row update 
PFV_RowVersion timestamp     Yes   Row version 
PFV_Guid varchar(36)       (newid())  Entry unique identifier for import export mechanism 
PFV_UserLogin varchar(256)   Yes     Login of user 
PFV_Name varchar(50)         Favourite name 
PFV_Order int         Order 
PFV_Url varchar(255)         Favourite url 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_PortalFavourites Yes Yes BTREE ASCENDING 70

Table of Contents

Table: ProcessSites

Description:Table containing relations of processes to sites

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PRS_ID int Yes       Identifier 
PRS_DEFID int         Process ID 
PRS_SiteURL varchar(260)         Url of site 
PRS_IsMainSite bit         Information if site is current main site 
PRS_TSInsert datetime       (getdate())  Creation date 
PRS_TSUpdate datetime       (getdate())  Last modification date 
PRS_CreatedBy varchar(50)         Author 
PRS_UpdatedBy varchar(50)         Last modifier 
PRS_RowVersion timestamp     Yes   Timestamp 
PRS_Guid varchar(36)       (newid())  Guid of process site 

Foreign Keys

Name Foreign Table Primary Key
FK_ProcessSites_WFDefinitions ProcessSites PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ProcessSites Yes Yes BTREE ASCENDING 0
UQ_ProcessSites_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: RegisteredApps

Description:Stores apps registered on the server

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
RAP_ID int Yes       Identifier 
RAP_TSInsert datetime       (getdate())  Creation date 
RAP_TSUpdate datetime       (getdate())  Last modification date 
RAP_RowVersion timestamp     Yes   Timestamp 
RAP_IsDeleted bit       ((0))  Is record deleted 
RAP_CreatedBy varchar(50)         Author 
RAP_UpdatedBy varchar(50)         Last modifier 
RAP_ClientId varchar(50)         ClientId for the app 
RAP_ClientSecret varchar(250)   Yes     ClientSecret for the app 
RAP_AppLogin varchar(250)         Login for app when it is not impersonating 
RAP_AppEmail varchar(250)   Yes     Email of app (distribution group) 
RAP_AllowImpersonate bit       ((0))  If app is allowed to impersonate users 
RAP_AppName varchar(250)   Yes     Name for the app 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_RegisteredApps Yes Yes BTREE ASCENDING 0
UQ_RAP_AppLogin Yes   BTREE ASCENDING 0

Table of Contents

Table: RegisteredPhones

Description:Table contains phones IDs that were registered to receive PUSH notifications about new or changed tasks.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
REG_ID int Yes       Identifier 
REG_Type int       ((1))  Type 
REG_LastPushInfo datetime   Yes     Last push info 
REG_IsPushEnabled bit       ((1))  Is push enable 
REG_TSInsert datetime       (getdate())  Creation date 
REG_TSUpdate datetime       (getdate())  Last modification date 
REG_RowVersion timestamp     Yes   Timestamp 
REG_IsDeleted bit       ((0))  Is record deleted 
REG_Platform int       ((1))  Device platform 
REG_PhoneToken varchar(255)   Yes     Token for the device 
REG_DefinitionFilter varchar(255)   Yes     Definition filter 
REG_LoginName varchar(255)         Login 
REG_Description varchar(2000)   Yes     Description 
REG_PhoneUDID varchar(255)         Phones UDID 
REG_Hash varchar(255)   Yes     Phones unique hash 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_RegisteredPhones Yes Yes BTREE ASCENDING 70
UQ_RegisteredPhones Yes   BTREE ASCENDING 0

Table of Contents

Table: ResettableObjectsChangeTimestamps

Description:Stores info about refreshing resettable objects

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
RCT_ID int Yes       Resettable group from DicDataCacheGroups 
RCT_TSUpdate datetime       (getdate())  Last modification date 
RCT_RowVersion timestamp     Yes   Timestamp 
RCT_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_ResettableObjectsChangeTimestamps_DicDataCacheGroups ResettableObjectsChangeTimestamps PK_DicDataCacheGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ResettableObjectsChangeTimestamps Yes Yes BTREE ASCENDING 0

Table of Contents

Table: Schedules

Description:Table that contains schedules.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SCH_ID int Yes       Identifier 
SCH_Type int         Schedule type 
SCH_StartTime datetime         Start time 
SCH_EndTime datetime   Yes     End time 
SCH_DayOfWeek int   Yes     Day of week 
SCH_IsNextDay bit   Yes     Column wih information, if end time is on next day 
SCH_TSInsert datetime       (getdate())  Creation date 
SCH_TSUpdate datetime       (getdate())  Last modification date 
SCH_CreatedBy varchar(50)         Author 
SCH_UpdatedBy varchar(50)         Last modifier 
SCH_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_Schedules Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ServiceActivityInfos

Description:Stores information about service activites.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SAI_ID int Yes       Activity entry id. 
SAI_ServiceID int         Id of service to which information relates. 
SAI_RolesRunnerID int   Yes     Id of service which runs related service roles. 
SAI_CancelationTime datetime   Yes     Time of last cancelation. 
SAI_IsInSafeMode bit       ((0))  Information about running in safe mode. 
SAI_LicenceServiceLocation varchar(200)   Yes     Location of licence service. 
SAI_WCFServiceLocation varchar(200)   Yes     Location of WCF service. 
SAI_ReturnRequest bit       ((0))  Information whether service requests for return of its roles. 
SAI_TSInsert datetime       (getdate())  Time of insert. 
SAI_TSUpdate datetime       (getdate())  Time of last update. 
SAI_RowVersion timestamp     Yes    
SAI_IsInServiceHour bit       ((0))  Information about maintenance mode. 

Foreign Keys

Name Foreign Table Primary Key
FK_Services_ID_ServiceActivityInfos_RolesRunnerID ServiceActivityInfos Services_PK
FK_Services_ID_ServiceActivityInfos_ServiceID ServiceActivityInfos Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_U_ServiceActivityInfos_ServiceID Yes   BTREE ASCENDING 70
PK_ServiceActivityInfos Yes Yes BTREE ASCENDING 0

Table of Contents

Table: ServiceBackups

Description:Table contains backup data about service roles in case of service failure.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SB_ID int Yes        
SB_BackupServiceID int          
SB_SourceServiceID int          
SB_TSInsert datetime       (getdate())   
SB_TSUpdate datetime       (getdate())   
SB_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceBackups_BackupServiceID_Services_ID ServiceBackups Services_PK
FK_ServiceBackups_SourceServiceID_Services_ID ServiceBackups Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ServicesFailover Yes Yes BTREE ASCENDING 70
UQ_ServiceBackups_BackupServiceID_SourceServiceID Yes   BTREE ASCENDING 70

Table of Contents

Table: ServiceDatabases

Description:Table contains correlated content databases for services

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SD_ID int Yes       Row identifier 
SD_ServiceID int         Service identifier 
SD_ContentDatabaseID int         Content database identifier 
SD_TSInsert datetime       (getdate())  Creation date 
SD_TSUpdate datetime       (getdate())  Last modification date 
SD_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceDatabases_SD_ContentDatabaseID ServiceDatabases PK_ContentDatabases
FK_ServiceDatabases_SD_ServiceID ServiceDatabases Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ServiceDatabases Yes Yes BTREE ASCENDING 0
UQ_ServiceDatabases_ContentDatabaseID_ServiceID Yes   BTREE ASCENDING 0

Table of Contents

Table: ServiceEvents

Description:Table contains events related to communication between service and programs dependent on service.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SE_ID int Yes        
SE_ServiceID int          
SE_RestartRequest bit       ((0))   
SE_TSInsert datetime       (getdate())   
SE_TSUpdate datetime       (getdate())   
SE_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceEvents_Services ServiceEvents Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ServiceEvents Yes Yes BTREE ASCENDING 0
UQ_ServiceEvents_Services Yes   BTREE ASCENDING 0

Table of Contents

Table: ServiceHeartbeats

Description:Table contains last activation date (including time) for each service. If WorkFlow service is running constantly then column HB_Value is refreshed.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
HB_ID int Yes        
HB_ServiceID int          
HB_Value datetime       ('19000101')   
HB_TSInsert datetime       (getdate())   
HB_TSUpdate datetime       (getdate())   
HB_RowVersion timestamp     Yes    
HB_RestartRequest bit       ((0))   

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceHeartbeats_Services ServiceHeartbeats Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ServiceHeartbeats Yes Yes BTREE ASCENDING 70
UQ_ServiceHeartbeats_Services Yes   BTREE ASCENDING 70

Table of Contents

Table: ServiceRoles

Description:Table connects services with their roles. Defines active roles for each service.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SR_ID int Yes        
SR_RoleID int          
SR_ServiceID int          
SR_TSInsert datetime       (getdate())   
SR_TSUpdate datetime       (getdate())   
SR_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_ServiceRoles_RoleID_Roles_ID ServiceRoles PK_DicRoles
FK_ServiceRoles_ServiceID_Services_ID ServiceRoles Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_ServiceRoles Yes Yes BTREE ASCENDING 70
UQ_ServiceRoles_RoleID_ServiceID Yes   BTREE ASCENDING 70

Table of Contents

Table: Services

Description:Table contains WorkFlow services configuration installed on defined environment.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
S_ID int Yes        
S_Name varchar(200)          
S_IsBackup bit       ((1))   
S_MaxOcrThreadsCount int       ((1))   
S_TSInsert datetime       (getdate())   
S_TSUpdate datetime       (getdate())   
S_RowVersion timestamp     Yes    
S_LogDiagnostics bit       ((0))   
S_TemporaryFilesDirectory varchar(MAX)   Yes     Column contains path to directory in which service will keep its temporary files. 
S_OcrTextLayerThreads int       ((1))  Number of threads in service OCR Text Layer 
S_OcrMaestroThreads int       ((1))  Number of threads in service Maestro OCR 
S_OcrAiLearnThreads int       ((1))  Number of threads in service OCR AI Learn 
S_OcrAiLearnFieldThreads int       ((1))  Number of threads in service OCR AI for field parallel learn in one document 
S_RecurrentActionsThreads int       ((4))  Number of threads in service Recurrent actions 
S_ArchiveThreads int       ((1))  Number of threads in service Archive elements 
S_ArchivingDeleteTimeout int       ((300))  Archiving delete timeout in seconds 
S_UseHddInArchiving bit       ((0))  Archiving use hdd to store temp files 
S_MobilePushNotificationsThreads int       ((4))  Number of threads in service Mobile Push Notifications 
S_PersonalDataRemovalThreads int       ((1))  Number of threads for personal data removal action 
S_SolrIndexerThreads int       ((4))  Number of threads in service Solr Indexer 
S_SolrIndexerBatchSize int       ((500))  Number of workflow instances to download at once by service Solr Indexer 
S_SolrIndexerElementThreads int       ((4))  Number of threads processing one workflow instance in service Solr Indexer 
S_AiAnalysisThreads int       ((4))  Number of AI Analysis threads 
S_SolrIndexerSqlTimeout int       ((300))  SQL timeout in seconds for Solr Indexer 
S_SolrIndexerConnectionErrorAttemptsNumber int       ((10))  Number of attempts for thread when SOLR connection error occured 
S_SolrIndexerConnectionErrorThreadSleep int       ((60))  Time in seconds for thread to sleep when SOLR connection error occured 
S_ExecutionTimeout int       ((120))  Time in seconds to timeout for path transition or save operation 

Foreign Keys

Name Foreign Table Primary Key
FK_Services_ID_ServiceActivityInfos_RolesRunnerID ServiceActivityInfos Services_PK
FK_Services_ID_ServiceActivityInfos_ServiceID ServiceActivityInfos Services_PK
FK_ServiceBackups_BackupServiceID_Services_ID ServiceBackups Services_PK
FK_ServiceBackups_SourceServiceID_Services_ID ServiceBackups Services_PK
FK_ServiceDatabases_SD_ServiceID ServiceDatabases Services_PK
FK_ServiceEvents_Services ServiceEvents Services_PK
FK_ServiceHeartbeats_Services ServiceHeartbeats Services_PK
FK_ServiceRoles_ServiceID_Services_ID ServiceRoles Services_PK

Indexes

Name Unique Clustered Type Collation Fill Factor
Services_PK Yes Yes BTREE ASCENDING 70
UQ_Services_Name Yes   BTREE ASCENDING 70

Table of Contents

Table: SolrIndexerQueueItems

Description:Service queue for SOLR indexing operations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
SIQ_ID int Yes       Identifier 
SIQ_TSInsert datetime       (getdate())  Creation date 
SIQ_TSUpdate datetime       (getdate())  Last modification date 
SIQ_RowVersion timestamp     Yes   Timestamp 
SIQ_WFDID int   Yes     Element Id 
SIQ_Operation int         Operation type Id 
SIQ_DateFrom datetime   Yes     Date range from which elements will be indexed. 
SIQ_DateTo datetime   Yes     Date range to which elements will be indexed. 
SIQ_Config varchar(MAX)   Yes     Configuration 
SIQ_DateStart datetime   Yes     Date of indexing start 
SIQ_Priority int         Priority 
SIQ_Status int       ((0))  Status 
SIQ_ServiceName varchar(255)   Yes     Processing service name 
SIQ_AttemptsNumber int       ((0))  Attempts number 
SIQ_LastAttemptTime datetime   Yes     Last attempt time 
SIQ_LastError varchar(MAX)   Yes     Last error 
SIQ_ThreadId int   Yes     Processing Thread Id for SOLR indexing 
SIQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
SIQ_DEFID int   Yes     ID of process to index 
SIQ_ActivityXml varchar(MAX)   Yes     Additional data used when indexing BPS activities 

Foreign Keys

Name Foreign Table Primary Key
FK_SolrIndexerQueueItems_DicIndexingOperations SolrIndexerQueueItems PK_DicIndexingOperations

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_SolrIndexerQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: TempObjects

Description:Table contains serialized CLR objects which are used inside WorkFlow.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TO_ID int Yes        
TO_Key varchar(900)          
TO_Value varchar(MAX)          
TO_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
idx_ncl_tokey Yes   BTREE ASCENDING 70
PK_TempObjects Yes Yes BTREE ASCENDING 70

Table of Contents

Table: TemporaryFiles

Description:Table contains files generated by system which are available for user for limited period of time.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TMP_ID int Yes       Identyfikator rekordu 
TMP_TSInsert datetime       (getdate())  Data wstawienia rekordu 
TMP_TSUpdate datetime       (getdate())  Data ostatniej aktualizacji rekordu 
TMP_CreatedBy varchar(50)         Autor wpisu 
TMP_UpdatedBy varchar(50)         Osoba, która zaktualizowała rekord 
TMP_RowVersion timestamp     Yes   Wersja wiersza 
TMP_UniqueID varchar(36)       (newid())  Identyfikator pliku 
TMP_Content varbinary(MAX)         Zawartość pliku 
TMP_FileName varchar(255)         Nazwa pliku 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK__TemporaryFiles__2CDA6DBB Yes Yes BTREE ASCENDING 70

Table of Contents

Table: TextLayerLanguages

Description:Supported languages list for text layer engine

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TTL_ID int Yes       Identifier 
TTL_TSInsert datetime       (getdate())  Creation date 
TTL_TSUpdate datetime       (getdate())  Last modification date 
TTL_RowVersion timestamp     Yes   Timestamp 
TTL_IsDeleted bit       ((0))  Is record deleted 
TTL_FRInternalName varchar(50)         Fine Reader internal supported language name 
TTL_EnglishName varchar(50)         English supported language name 
TTL_PolishName varchar(50)         Polish supported language name 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TextLayerLanguages Yes Yes BTREE ASCENDING 0

Table of Contents

Table: TextLayerQueueItems

Description:Table contains text layer queue for attachments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TLQ_ID int Yes       Row ID 
TLQ_TSInsert datetime       (getdate())  Time of insert 
TLQ_TSUpdate datetime       (getdate())  Time of update 
TLQ_RowVersion timestamp     Yes   Row version 
TLQ_Priority int         Priority 
TLQ_ServiceName varchar(255)   Yes     Processing service name 
TLQ_ATTID int         Foreign key to WFDataAttachmets 
TLQ_Status int       ((0))  Status 
TLQ_AttemptsNumber int       ((0))  Attempts number 
TLQ_LastAttemptTime datetime   Yes     Last attempt name 
TLQ_LastError varchar(MAX)   Yes     Last error 
TLQ_ThreadId int   Yes     Processing Thread Id for Text Layer in OCR 
TLQ_LastUploadAttemptTime datetime   Yes     Last upload attempt time 
TLQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
TLQ_UploadFinishedTime datetime   Yes     Upload finished time 
TLQ_ACTID int         Foreign key to WFActions 
TLQ_SectionGuid varchar(36)   Yes     Action section GUID 

Foreign Keys

Name Foreign Table Primary Key
FK_TextLayerQueueItems_WFActions TextLayerQueueItems PK_WFActions
FK_TextLayerQueueItems_WFDataAttachmets TextLayerQueueItems PK_WFDataAttachmets

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TextLayerQueueItems Yes Yes BTREE ASCENDING 0
UQ_TextLayerQueueItems_WFDataAttachmets Yes   BTREE ASCENDING 0

Table of Contents

Table: Themes

Description:Contains color themes for BPS Portal.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
THE_ID int Yes       Identifier 
THE_TSInsert datetime       (getdate())  Creation date 
THE_TSUpdate datetime       (getdate())  Last modification date 
THE_RowVersion timestamp     Yes   Timestamp 
THE_CreatedBy varchar(50)         Author 
THE_UpdatedBy varchar(50)         Last modifier 
THE_Name varchar(30)         Name 
THE_Description varchar(1000)         Description 
THE_IsDefault bit       ((0))  Is a default theme 
THE_IsActive bit       ((1))  Is an active theme 
THE_Configuration varchar(MAX)   Yes     Configuration data in JSON 
THE_LogoContent varbinary(MAX)   Yes     Logo binary data 
THE_Guid varchar(36)       (newid())  BPS environment (DEV/TEST/PROD) independent identifier 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_Themes Yes Yes BTREE ASCENDING 0

Table of Contents

Table: TilesConfigurations

Description:Table contains tiles configuration used in Outlook add-in. It contains references to process, document, workflow and step.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TIL_ID int Yes       Tile identifier 
TIL_DEFID int         Identifier of the related process 
TIL_DTYPEID int         Identifier of the related document type 
TIL_WFID int         Identifier of the related workflow 
TIL_Name varchar(50)         Tile name 
TIL_Description varchar(MAX)   Yes     Tile description 
TIL_TSInsert datetime       (getdate())  Date of adding 
TIL_TSUpdate datetime       (getdate())  Modification date 
TIL_User varchar(255)         Login of user submitting the tile 
TIL_UserName varchar(255)         Name of user submitting the tile 
TIL_StartInBrowser bit       ((0))  Configuration of starting in browser 
TIL_Order int       ((0))  Order of the tile 
TIL_RowVersion timestamp     Yes   Row version 
TIL_PATHID int   Yes     Related path id from WFAvaiblePaths 
TIL_COMID int   Yes     Company ID 

Foreign Keys

Name Foreign Table Primary Key
FK_TilesMappings_TilesConfigurations TilesMappings PK_TilesConfigurations
FK_TilesConfigurations_Companies TilesConfigurations PK_Companies
FK_TilesConfigurations_WFAvaiblePaths TilesConfigurations PK_WFAvaiblePaths
FK_TilesConfigurations_WFDefinitions TilesConfigurations PK_WFDefinitions
FK_TilesConfigurations_WFDocTypes TilesConfigurations PK_WFDocTypes
FK_TilesConfigurations_WorkFlows TilesConfigurations PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TilesConfigurations Yes Yes BTREE ASCENDING 70

Table of Contents

Table: TilesMappings

Description:Table contains values that will be assigned to form fields after starting workflow using tile in Outlook add-in.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TIM_ID int Yes        
TIM_TILID int          
TIM_WFCONID int          
TIM_Value varchar(MAX)   Yes      
TIM_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_TilesMappings_TilesConfigurations TilesMappings PK_TilesConfigurations
FK_TilesMappings_WFConfigurations TilesMappings PK_WFConfigurations

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TilesMappings Yes Yes BTREE ASCENDING 70

Table of Contents

Table: TranslateLanguages

Description:Table contains list of languages that can be used to translate process configuration data in WEBCON BPS Designer Studio.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
LAN_ID int Yes        
LAN_Name varchar(50)   Yes      
LAN_TSInsert datetime       (getdate())   
LAN_TSUpdate datetime       (getdate())   
LAN_RowVersion timestamp     Yes    
LAN_IsDeleted bit       ((0))   
LAN_Guid varchar(36)         Global unique id for language based on MD5 from LAN_NAME 

Foreign Keys

Name Foreign Table Primary Key
FK_Transalates_TransalateLanguages Translates PK_TransalateLanguages
FK_TranslateUserLangs_TranslateLanguages TranslateUserLangs PK_TransalateLanguages

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TransalateLanguages Yes Yes BTREE ASCENDING 70
UQ_TranslateLanguages_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: Translates

Description:Table contains translations provided by users about process configuration.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
TRANS_ID int Yes        
TRANS_OBJID int          
TRANS_ELEMID int          
TRANS_LANID int          
TRANS_Name varchar(MAX)   Yes      
TRANS_Description varchar(2000)   Yes      
TRANS_TSInsert datetime       (getdate())   
TRANS_TSUpdate datetime       (getdate())   
TRANS_RowVersion timestamp     Yes    
TRANS_IsDeleted bit       ((0))   
TRANS_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_Transalates_TransalateLanguages Translates PK_TransalateLanguages

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_U_Translates_LANID_OBJID_ELEMID Yes   BTREE ASCENDING 70
IX_U_Translates_OBJID_ELEMID_LANID Yes   BTREE ASCENDING 70
PK_Transalates Yes Yes BTREE ASCENDING 70

Table of Contents

Table: TranslateUserLangs

Description:Table contains data about users’default language set in their browsers used to connect to the system.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
USRLAN_ID int Yes        
USRLAN_LANID int   Yes      
USRLAN_UserLogin varchar(255)          
USRLAN_Name varchar(50)   Yes      
USRLAN_Description varchar(2000)   Yes      
USRLAN_TSInsert datetime       (getdate())   
USRLAN_TSUpdate datetime       (getdate())   
USRLAN_IsDeleted bit       ((0))   
USRLAN_RowVersion timestamp     Yes   Row version 

Foreign Keys

Name Foreign Table Primary Key
FK_TranslateUserLangs_TranslateLanguages TranslateUserLangs PK_TransalateLanguages

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_TranslateUserLangs Yes Yes BTREE ASCENDING 70
UQ_USRLAN_UserLogin Yes   BTREE ASCENDING 0

Table of Contents

Table: UserSynchronizationQueueItems

Description:Table contains UserSynchronization queue for elements

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
USQ_ID int Yes       Identifier 
USQ_TSInsert datetime       (getdate())  Creation date 
USQ_TSUpdate datetime       (getdate())  Last modification date 
USQ_RowVersion timestamp     Yes   Timestamp 
USQ_Priority int         Priority 
USQ_ServiceName varchar(255)   Yes     Processing service name 
USQ_Status int       ((0))  Status 
USQ_AttemptsNumber int       ((0))  Attempts number 
USQ_LastAttemptTime datetime   Yes     Last attempt time 
USQ_LastError varchar(MAX)   Yes     Last error 
USQ_ThreadId int   Yes     Processing Thread Id for synchronization 
USQ_ProcessingFinishedTime datetime   Yes     Processing finished time 
USQ_Users varchar(MAX)   Yes     User logins to synchronize, or all users if NULL 
USQ_Mode int       ((0))  Synchronization mode:
0 - All users mode from config
1 - All users full
2 - All users diff
3 - Selected users 
USQ_IsDebug bit       ((0))  Debug mode is much slower but has additional logging 
USQ_Reason varchar(MAX)   Yes     The reason for starting given synchronization task 

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_UserSynchronizationQueueItems Yes Yes BTREE ASCENDING 0

Table of Contents

Table: WebDavLocks

Description:Stores lock for attachment file access

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DVL_ID int Yes       Identifier 
DVL_ATTID int         ID of locked attachment 
DVL_Token varchar(36)         Lock token 
DVL_Shared bit         Is lock shared 
DVL_Deep bit         Is lock deep 
DVL_UserName varchar(255)         Name of user who locked attachment 
DVL_Expires datetime         When lock expires 
DVL_TSInsert datetime       (getdate())  Creation date 
DVL_TSUpdate datetime       (getdate())  Last modification date 
DVL_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WebDavLocks_WFDataAttachmets_ATTID WebDavLocks PK_WFDataAttachmets

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WebDavLocks Yes Yes BTREE ASCENDING 0

Table of Contents

Table: WebPartsConfigurations

Description:Table contains WebParts configurations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WPC_ID int Yes       Identifier 
WPC_TSInsert datetime       (getdate())  Creation date 
WPC_TSUpdate datetime       (getdate())  Last modification date 
WPC_RowVersion timestamp     Yes   Timestamp 
WPC_CreatedBy varchar(50)         Author 
WPC_UpdatedBy varchar(50)         Last modifier 
WPC_IsVisibleOnMobile bit       ((0))  Is WebPart visible on mobile devices 
WPC_SiteUrl varchar(260)         Site that WebPart is displayed on 
WPC_WebUrl varchar(260)         Sharepoint web url that WebPart is displayed on 
WPC_ContextSite varchar(520)       ('')  WebPart context site (that contains db connection) 
WPC_Guid varchar(36)       (newid())  WebPart BPS Guid for ImportExport 
WPC_WebPartId varchar(36)   Yes     Sharepoint WebPart Id 
WPC_WebPartType int         Enum that determines webpart type 
WPC_XmlConfig varchar(MAX)   Yes     XML configuration used by WebPart 
WPC_Title varchar(255)   Yes     WebPart title 

Foreign Keys

Name Foreign Table Primary Key
FK_WebPartsConfigurations_DicWebPartTypes WebPartsConfigurations PK_DicWebPartTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WebPartsConfigurations Yes Yes BTREE ASCENDING 0
UQ_WebPartsConfigurations_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFActionBusinessRules

Description:Business rules used in action configurations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ABR_ID int Yes       Identifier 
ABR_ACTID int         Action identifier 
ABR_BRDID int         Business rule identifier 
ABR_PropertyID int         Action configuration property identifier 
ABR_PropertyOrder int   Yes     Action configuration property order 
ABR_Guid varchar(36)       (newid())  Global unique ID 
ABR_TSInsert datetime       (getdate())  Creation date 
ABR_TSUpdate datetime       (getdate())  Last modification date 
ABR_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActionBusinessRules_WFActions WFActionBusinessRules PK_WFActions
FK_WFActionBusinessRules_WFBusinessRuleDefinitions WFActionBusinessRules PK_WFBusinessRuleDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFActionBusinessRules Yes Yes BTREE ASCENDING 0
UQ_WFActionBusinessRules_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFActionButtonGroups

Description:Table contains groups for action buttons

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ABG_ID int Yes       Action button group identifier 
ABG_TSInsert datetime       (getdate())  Creation date 
ABG_TSUpdate datetime       (getdate())  Last modification date 
ABG_RowVersion timestamp     Yes   Timestamp 
ABG_Name nvarchar(256)   Yes     Group name 
ABG_WFID int   Yes     Related workflow Id for global actions group 
ABG_STPID int   Yes     Related step Id for step actions group 
ABG_Description nvarchar(512)   Yes     Group description 
ABG_Order int       ((0))  Order number 
ABG_IconMode int       ((0))  IconMode:
- 0 stands for custom icon url from IconUrl column,
- 1 stands for SP predefined icon. 
ABG_IconChoice int       ((0))  Predefined icon id. 
ABG_IconUrl nvarchar(256)   Yes     Custom icon url to display on group 
ABG_Guid nvarchar(36)   Yes   (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActionButtons_WFActionButtonGroups_ABGID WFActionButtons PK_WFActionButtonGroups
FK_WFActionButtonGroups_WFSteps WFActionButtonGroups PK_WFSteps
FK_WFActionButtonGroups_WorkFlows WFActionButtonGroups PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFActionButtonGroups Yes Yes BTREE ASCENDING 70
UQ_WFActionButtonGroups_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFActionButtons

Description:Table contains buttons for action

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ACB_ID int Yes       Action button identifier 
ACB_TSInsert datetime       (getdate())  Creation date 
ACB_TSUpdate datetime       (getdate())  Last modification date 
ACB_RowVersion timestamp     Yes   Timestamp 
ACB_STPID int   Yes     Related step Id for step action button 
ACB_WFID int   Yes     Related workflow Id for global actions button 
ACB_Name nvarchar(50)   Yes     Action button name 
ACB_Description nvarchar(1000)   Yes     Action button description name 
ACB_Order int         Button order 
ACB_Guid nvarchar(36)   Yes   (newid())  Global unique ID 
ACB_ConfirmExecutionMessage nvarchar(MAX)   Yes     A message that shows up after execution all actions in button 
ACB_ConfirmExecution bit       ((0))  Determines if should show message after button actions execution 
ACB_ConfirmBeforeExecutionMessage nvarchar(MAX)   Yes     A message that appears as a confirmation question before the actions are executed 
ACB_ConfirmBeforeExecution bit       ((0))  Determines if should show confirmation question before actions execution 
ACB_IconUrl nvarchar(200)   Yes     Icon button address 
ACB_IconMode int       ((0))  IconMode:
- 0 stands for custom icon url from IconUrl column,
- 1 stands for SP predefined icon. 
ACB_IconChoice int       ((0))  Predefined icon button identifier 
ACB_IsVisibleBRDID int   Yes     Business rule ID that determines button visibility 
ACB_ABGID int   Yes     Related action button group ID 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActions_WFActionButtons WFActions PK_WFActionButtons
FK_WFActionButtons_WFActionButtonGroups_ABGID WFActionButtons PK_WFActionButtonGroups
FK_WFActionButtons_WFBusinessRuleDefinitions_IsVisibleBRDID WFActionButtons PK_WFBusinessRuleDefinitions
FK_WFActionButtons_WFSteps WFActionButtons PK_WFSteps
FK_WFActionButtons_WorkFlows WFActionButtons PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFActionButtons Yes Yes BTREE ASCENDING 70
UQ_WFActionButtons_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFActionExecutions

Description:Contains logs about actions executed in the system and element processing operations. Descriptions can be compressed and are readable with Designer Studio.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
LOG_ID int Yes        
LOG_DEFID int   Yes      
LOG_WFDID int   Yes      
LOG_WTHID int   Yes     Pole relacji do elementu historycznego. Aby mozna bylo rozpoznac w jakim momencie dokladnie wykonanan byla akcja 
LOG_STPID int   Yes      
LOG_ACTID int   Yes      
LOG_Status int   Yes      
LOG_Name varchar(MAX)   Yes      
LOG_Description varchar(MAX)   Yes      
LOG_TSInsert datetime       (getdate())   
LOG_TSUpdate datetime       (getdate())   
LOG_RowVersion timestamp     Yes    
LOG_IsDeleted bit       ((0))   
LOG_WFID int   Yes     Identyfikator obiegu dokumentów 
LOG_AdditionalMessage nvarchar(MAX)   Yes     Dodatkowa komunikat. Pole ustawiane np. w wywołaniach custom akcji 
LOG_ActionSucceeded bit       ((1))  Czy akcja została wykonana poprawnie 
LOG_SectionGuid varchar(36)   Yes   (newid())   
LOG_Duration int   Yes      
LOG_ActionType int   Yes      
LOG_TransactionType int   Yes      
LOG_ParentActionID int   Yes      
LOG_ShowOnlyInAdminMode bit       ((0))   
LOG_CompressedDescription varbinary(MAX)   Yes      
LOG_CompressedAdditionalMessage varbinary(MAX)   Yes      
LOG_ACBID int   Yes     Column with action button id 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActionExecutions_DicActionTypes WFActionExecutions PK_DicActionTypes

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFLogs_ACTID     BTREE ASCENDING 70
IX_WFLogs_WFDID     BTREE ASCENDING 70
IX_WFLogs_WTHID     BTREE ASCENDING 70
PK_WFActionExecutions Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFActions

Description:Contains actions configuration. Stores all types and kinds of action that are available in the system.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ACT_ID int Yes        
ACT_STPID int   Yes     Identyfikator kroku jakiego dotyczy dana akcja 
ACT_PLUID int   Yes      
ACT_PATHID int   Yes      
ACT_Name varchar(50)         Nazwa akcji 
ACT_ActionKindID int         "1" - Wyslij Email
"2" -Zmień wartość
"3" -Przejdz do innego kroku
"4" -Ustaw Security
"5" -Uruchom procedurę SQL
"6" - Create Task in SPSList 
ACT_ActionTypeID int         "1" -START- Wywolywane w momencie wejscia do danego kroku
"2" -FINISH- Akcje wywolywane w momencie wyjscia z danego kroku
"3".- TIMEOUT- Akcje wywolywane w momencie przkroczenia czasu reakcji w danym kroku. 
ACT_Order int         Kolejnosć wykonania akcji 
ACT_Configuration varchar(MAX)   Yes     Konfiguracja danej akcji w formacie XML 
ACT_Description varchar(MAX)   Yes     Opis 
ACT_PluginControl varchar(100)   Yes      
ACT_PluginMethod varchar(50)   Yes      
ACT_TSInsert datetime       (getdate())  Data wstawienia wiersza 
ACT_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
ACT_RowVersion timestamp     Yes   Wersja wiersza 
ACT_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
ACT_WFID int   Yes      
ACT_LogExecution bit       ((1))  Określa czy wykonanie akcji ma być logowane. 
ACT_RADID int   Yes     Identyfikator cyklu akcji cyklicznych 
ACT_IsActive bit       ((1))   
ACT_Guid varchar(36)       (newid())   
ACT_IsPattern bit       ((0))  Determines if this action is a pattern 
ACT_ACTID int   Yes     Pattern action identifier 
ACT_DEFID int   Yes     The process to which the action belongs to 
ACT_ActivationBRDID int   Yes     Action activation business rule ID 
ACT_ACBID int   Yes     Related action button ID for action 
ACT_CWSID int   Yes     Stores id of related configured web service 

Foreign Keys

Name Foreign Table Primary Key
FK_ArchiveQueueItems_WFActions ArchiveQueueItems PK_WFActions
FK_OcrAiLearnQueueItems_WFActions OcrAiLearnQueueItems PK_WFActions
FK_OcrAiQueueItems_WFActions OcrAiQueueItems PK_WFActions
FK_PersonalDataRemovalQueueItems_WFActions PersonalDataRemovalQueueItems PK_WFActions
FK_TextLayerQueueItems_WFActions TextLayerQueueItems PK_WFActions
FK_WFActionBusinessRules_WFActions WFActionBusinessRules PK_WFActions
FK_WFActions_WFActions WFActions PK_WFActions
FK_WFTimeoutActions_WFActions WFTimeoutActions PK_WFActions
FK_WFActions_ConfiguredWebServices WFActions PK_ConfiguredWebServices
FK_WFActions_DicActionKinds WFActions PK_DicActionKinds
FK_WFActions_DicActionTypes WFActions PK_DicActionTypes
FK_WFActions_WFActionButtons WFActions PK_WFActionButtons
FK_WFActions_WFAvaiblePaths WFActions PK_WFAvaiblePaths
FK_WFActions_WFBusinessRuleDefinitions_ACT_ActivationBRDID WFActions PK_WFBusinessRuleDefinitions
FK_WFActions_WFDefinitions WFActions PK_WFDefinitions
FK_WFActions_WFPlugIns WFActions PK_WFPlugIns
FK_WFActions_WFRecurrentActionsDefinitions WFActions PK__WFRecurrentActio__3B85BA2C
FK_WFActions_WFSteps WFActions PK_WFSteps
FK_WFActions_WorkFlows WFActions PK_WorkFlows

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFActions Yes Yes BTREE ASCENDING 70
UQ_WFActions_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFApplications

Description:Table containing applications

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
APP_ID int Yes       Identifier 
APP_TSInsert datetime       (getdate())  Creation date 
APP_TSUpdate datetime       (getdate())  Last modification date 
APP_RowVersion timestamp     Yes   Timestamp 
APP_Guid varchar(36)       (newid())  Guid of application 
APP_AGRID int         WFApplicationsGroups foreign key 
APP_Name varchar(50)         Name of application 
APP_Description varchar(MAX)   Yes     Description of application 
APP_TemplateID int       ((1))  Defines type of application template 
APP_LANID int   Yes     Application language foreign key 
APP_ApplicationLanguageType int       ((1))  Column determines whether application language is set from global settings or directly from browser 
APP_Supervisor varchar(1000)   Yes     Application supervisor 
APP_IsCustomSupervisor bit       ((0))  Application has custom supervisor 
APP_Abbreviation varchar(3)   Yes     Application abbreviation 
APP_Color varchar(8)       ('FFFFA435')  Application color 
APP_CustomSupervisorImage varbinary(MAX)   Yes     Application custom supervisor image 
APP_CustomSupervisorName varchar(1000)   Yes     Application custom supervisor full name 
APP_CustomSupervisorJobTitle varchar(1000)   Yes     Application custom supervisor job title 
APP_CustomSupervisorDepartment varchar(1000)   Yes     Application custom supervisor department 
APP_CustomSupervisorPhone varchar(1000)   Yes     Application custom supervisor phone 
APP_CustomSupervisorMail varchar(1000)   Yes     Application custom supervisor mail 
APP_MobileViewMode int   Yes     Mode of mobile view informs about the source of report structure which is available on the mobile device. Value 0 means: Show report structure based on SharePoint Web Parts. Value 1 or null means: Show report structure based on application presentation settings.  
APP_SaveStamp varchar(36)       (newid())  Save stamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AppDashboards_WFApplications AppDashboards PK_WFApplications
FK_AppReports_WFApplications AppReports PK_WFApplications
FK_AppStarts_WFApplications AppStarts PK_WFApplications
FK_HistoryImports_WFApplications HistoryImports PK_WFApplications
FK_WFApplicationsLinkedProcesses_WFApplications WFApplicationsLinkedProcesses PK_WFApplications
FK_WFConfigurationSecurities_WFApplications WFConfigurationSecurities PK_WFApplications
FK_WFDefinitions_WFApplications WFDefinitions PK_WFApplications
FK_WFApplications_DicApplicationTemplates WFApplications PK_DicApplicationTemplates
FK_WFApplications_WFApplicationsGroups WFApplications PK_WFApplicationsGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFApplications Yes Yes BTREE ASCENDING 0
UQ_WFApplications_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFApplicationsGroups

Description:Table containing groups of applications

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
AGR_ID int Yes       Identifier 
AGR_TSInsert datetime       (getdate())  Creation date 
AGR_TSUpdate datetime       (getdate())  Last modification date 
AGR_RowVersion timestamp     Yes   Timestamp 
AGR_Guid varchar(36)       (newid())  Guid of application group 
AGR_Name varchar(50)         Name of application group 
AGR_IsSystem int       ((0))  Defines whether application group is a system group 

Foreign Keys

Name Foreign Table Primary Key
FK_WFApplications_WFApplicationsGroups WFApplications PK_WFApplicationsGroups

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFApplicationsGroups Yes Yes BTREE ASCENDING 0
UQ_WFApplicationsGroups_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFApprovalCommands

Description:Table contains command templates used in Mail Approval.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WAC_ID int Yes        
WAC_WADID int   Yes      
WAC_Values varchar(MAX)   Yes      
WAC_TSInsert datetime       (getdate())   
WAC_TSUpdate datetime       (getdate())   
WAC_UpdatedBy varchar(255)   Yes      
WAC_RowVersion timestamp     Yes    
WAC_IsDeleted bit       ((0))   
WAC_PATHID int   Yes      
WAC_Guid varchar(36)       (newid())  Guid 

Foreign Keys

Name Foreign Table Primary Key
FK_WFApprovalCommands_WFApprovalDefinitions WFApprovalCommands PK_WFApprovalDefinitions
FK_WFApprovalCommands_WFAvaiblePaths WFApprovalCommands PK_WFAvaiblePaths

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFApprovalCommands Yes Yes BTREE ASCENDING 70
UQ_WFApprovalCommands_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFApprovalDefinitions

Description:Table contains command definitions used in Mail Approval.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WAD_ID int Yes        
WAD_Name varchar(50)          
WAD_TSInsert datetime       (getdate())   
WAD_TSUpdate datetime       (getdate())   
WAD_UpdatedBy varchar(255)   Yes      
WAD_RowVersion timestamp     Yes    
WAD_Guid varchar(36)       (newid())   
WAD_IsDeleted bit       ((0))   
WAD_DefinitionType int       ((0))  Definition type base on UserEnums, 0 is standard type, 1 used for delegation commands 

Foreign Keys

Name Foreign Table Primary Key
FK_WFApprovalCommands_WFApprovalDefinitions WFApprovalCommands PK_WFApprovalDefinitions
FK_WFAvaiblePaths_WFApprovalDefinitions WFAvaiblePaths PK_WFApprovalDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFApprovalDefinitions Yes Yes BTREE ASCENDING 70
UQ_WFApprovalDefinitions_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFArchivedElementDatas

Description:Table containing data for archived elements

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WAE_ID int Yes       Identifier 
WAE_WFDID int         WFElement identifier 
WAE_TSInsert datetime       (getdate())  Creation date 
WAE_TSUpdate datetime       (getdate())  Last modification date 
WAE_RowVersion timestamp     Yes   Timestamp 
WAE_IsDeleted bit       ((0))  Is record deleted 
WAE_ArchivedElement varbinary(MAX)   Yes     Data of archived element 
WAE_ArchivedHistory varbinary(MAX)   Yes     Historical data of archived element 

Foreign Keys

Name Foreign Table Primary Key
FK_WFArchivedElementDatas_WFElements WFArchivedElementDatas PK_WFData

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFArchivedElementDatas Yes Yes BTREE ASCENDING 0

Table of Contents

Table: WFAttachmentConfigs

Description:Table contains form fields configuration in attachments.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ACN_ID int Yes        
ACN_DEFID int          
ACN_WFSID int   Yes      
ACN_Prompt varchar(50)   Yes      
ACN_SelectOrCaml varchar(MAX)   Yes      
ACN_Config varchar(MAX)   Yes      
ACN_Description varchar(3000)   Yes      
ACN_TSInsert datetime       (getdate())   
ACN_TSUpdate datetime       (getdate())   
ACN_InsertedBy varchar(255)   Yes      
ACN_UpdatedBy varchar(255)   Yes      
ACN_RowVersion timestamp     Yes    
ACN_IsDeleted bit       ((0))   
ACN_PromptStyle varchar(1000)   Yes      
ACN_ControlStyle varchar(1000)   Yes      
ACN_AddFormLink varchar(1000)   Yes      
ACN_JavaScriptOnChange varchar(MAX)   Yes      
ACN_DocumentationDescription varchar(500)   Yes      
ACN_FADID int          
ACN_SetDefaultValueAlsoOnPostback bit       ((0))   
ACN_FieldAttachmentTypeID int          
ACN_Guid varchar(36)          
ACN_ExpandDefaultGroup bit       ((0))  Column defines if default attachments' group should be always expanded. 
ACN_DefaultValueBRDID int   Yes     Foreign key to business rule defining attachments configuration default value 
ACN_WFCID int   Yes     Stores data connection id 
ACN_DataSourceFilterBRDID int   Yes     Foreign key to business rule defining a data source filter 

Foreign Keys

Name Foreign Table Primary Key
FK_WFAttachmentConfigs_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFAttachmentConfigs PK_WFBusinessRuleDefinitions
FK_WFAttachmentConfigs_WFBusinessRuleDefinitions_DefaultValueBRDID WFAttachmentConfigs PK_WFBusinessRuleDefinitions
FK_WFAttachmentConfigs_WFDataConnections WFAttachmentConfigs PK_WFDataConnections
FK_WFAttachmentConfigs_WFDataSources WFAttachmentConfigs PK_WFDataSources
FK_WFAttachmentConfigs_WFDefinitions WFAttachmentConfigs PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFAttachmentsConfigs Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFAttachmentDatabases

Description:Table contains list of attachments databases connected to current content database. Attachment databases store attachments binary data.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ADB_ID int Yes        
ADB_Name varchar(128)          
ADB_TSInsert datetime       (getdate())   
ADB_TSUpdate datetime       (getdate())   
ADB_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key
FK_WFElements_WFAttachmentDatabases_ADBID WFElements PK_AttachmentDatabases

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_AttachmentDatabases Yes Yes BTREE ASCENDING 70
UQ_WFAttachmentDatabases_Name Yes   BTREE ASCENDING 0

Table of Contents

Table: WFAttachmentFiles

Description:Contains binary data about attachments. Stores all versions of attachments. The table is held in main WEBCON BPS database and in attachment databases.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ATF_ID int Yes        
ATF_WFDID int   Yes      
ATF_ATTID int          
ATF_FileType varchar(20)       ('pdf')   
ATF_Value image   Yes      
ATF_TSInsert datetime       (getdate())   
ATF_TSUpdate datetime       (getdate())   
ATF_CreatedBy varchar(255)   Yes      
ATF_UpdatedBy varchar(255)   Yes      
ATF_RowVersion timestamp     Yes    
ATF_IsDeleted bit       ((0))   
ATF_Version int       ((0))   
ATF_AttachmentImage image   Yes      
ATF_FlexiData varchar(MAX)   Yes      
ATF_AttributesMapping varchar(MAX)   Yes      
ATF_OrginalValueHash binary(32)   Yes      
ATF_OrginalName varchar(255)   Yes      
ATF_FRData varchar(MAX)   Yes      

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFAttachmentFiles_ATF_ATTID     BTREE ASCENDING 0
IX_WFAttachmentFiles_ATTID     BTREE ASCENDING 70
IX_WFAttachmentFiles_OrginalValueHash_OrginalName     BTREE ASCENDING 70
PK_WFAttachmentFiles Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFAvaiblePaths

Description:Contains definitions of all avaliable paths bettwen steps with information where certain path leads and what is paths configuration.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
PATH_ID int Yes       Identyfikator 
PATH_Name varchar(50)         Nazwa formularza 
PATH_Description varchar(MAX)   Yes     Opis formularza 
PATH_STPID int         Identyfiator kroku ktorego dany formularz dotyczy 
PATH_SubmitJScript varchar(MAX)   Yes     Tresc skryptu ktory zostanie wykonany w momencie zakonczenia pracy nad formularzem. Dzieki temu mozemy ustawić pole informujace o tym do jakiego kroku przechodzimy.
 
PATH_NextSTPID int   Yes      
PATH_FinishOtherTaskTypeID int       ((0))  0 - default no action ; 1 - FinishAllOthers ; 2 - CancelAllOthers 
PATH_IsDynamicAssign bit       ((0))   
PATH_AssignCONFID int   Yes      
PATH_AssignColName varchar(50)   Yes      
PATH_Assigments varchar(2000)   Yes      
PATH_IsDynamicAssignDW bit       ((0))   
PATH_AssignDWCONFID int   Yes      
PATH_AssignDWColName varchar(50)   Yes      
PATH_AssigmentsDW varchar(2000)   Yes      
PATH_SendStandardEmails bit       ((1))  Jesli 'tak" to wysyla maila (alert) do osoby przypisanej oraz DW. ( W przypadku gdy osoba aktualizujac=przypisana) alert nie jest wysylany 
PATH_SendStandardEmailsDW bit       ((1))   
PATH_RestrictedToUsers varchar(2000)   Yes      
PATH_IsBackAction bit       ((0))   
PATH_ControlType int       ((0))   
PATH_AssigType int       ((0))  Rodzaj przypisań zadań dla ludzi, Dział lub PeopleEditor 
PATH_CausesValidation bit       ((1))   
PATH_TaskName varchar(255)   Yes      
PATH_TaskDescription varchar(MAX)   Yes      
PATH_TSInsert datetime       (getdate())  Data wstawienia wiersza 
PATH_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
PATH_RowVersion timestamp     Yes   Wersja wiersza 
PATH_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
PATH_Order int       ((0))  Określa kolejność wyświetlania przycisków ze ścieżkami przejścia 
PATH_ShowConfirm bit       ((1))   
PATH_StayInEditForm bit       ((0))   
PATH_MarkCurrentStepAsCompleted bit       ((1))   
PATH_CreateDWInformationTask bit       ((0))  Określa czy nowo tworzone przypisanie DW mają umożliwiać edycję i wykonywanie zadań (1 = można, 0 = tylko odczyt). 
PATH_DesignerData nvarchar(MAX)   Yes     Dane przechowywane przez graficzny designer workflow 
PATH_IsDefault bit       ((0))   
PATH_Guid varchar(36)       (newid())   
PATH_ShowInDiagram bit       ((1))   
PATH_ButtonStyle varchar(1000)   Yes      
PATH_IsEnableOnSmartPhone bit       ((0))   
PATH_MinFinishedTasksModeId int       ((1))  Tryb ilości wymaganych zadań zakończonych, które umożliwią przejście do następnego kroku 
PATH_MinFinishedTasks int       ((1))  Minimalna liczba zakończonych zadań umożliwiająca przejście do następnego kroku 
PATH_MinFinishedTasksPercent int       ((1))  Minimalna liczba zakończonych zadań umożliwiająca przejście do następnego kroku - wartość procentowa 
PATH_ApprovalCommandID int   Yes      
PATH_IsMailApprovalEnabled bit       ((0))   
PATH_ControlTypeDW int       ((0))   
PATH_AllowCover bit       ((1))   
PATH_CommentRequired bit       ((0))   
PATH_PredefinedAsgnEnabled bit       ((0))   
PATH_ConstAsgnEnabled bit       ((0))   
PATH_PredefinedAsgnEnabledDW bit       ((0))   
PATH_ConstAsgnEnabledDW bit       ((0))   
PATH_PredefinedAsgnCovers bit       ((1))   
PATH_ConstAsgnCovers bit       ((1))   
PATH_PredefinedAsgnCoversDW bit       ((1))   
PATH_ConstAsgnCoversDW bit       ((1))   
PATH_AllowCoverDW bit       ((1))   
PATH_TemplateID int   Yes      
PATH_DocumentationDescription varchar(MAX)   Yes     Description of the path for documentation 
PATH_LineNumber int       ((1))  Line number where transition path button will be displayed 
PATH_IsVisibleBRDID int   Yes     Path is visible business rule ID 
PATH_OnSubmitUxBRDID int   Yes     Foreign key to ux business rule defining a javascript function to be executed on submit 

Foreign Keys

Name Foreign Table Primary Key
FK_FormPathAssocs_WFAvaiblePaths FormPathAssocs PK_WFAvaiblePaths
FK_HotMailBoxs_WFAvaiblePaths HotMailBoxs PK_WFAvaiblePaths
FK_TilesConfigurations_WFAvaiblePaths TilesConfigurations PK_WFAvaiblePaths
FK_WFActions_WFAvaiblePaths WFActions PK_WFAvaiblePaths
FK_WFApprovalCommands_WFAvaiblePaths WFApprovalCommands PK_WFAvaiblePaths
FK_WFTimeouts_ValidationErrorPATHID_WFAvaiblePaths WFTimeouts PK_WFAvaiblePaths
FK_WFTimeouts_WFAvaiblePaths WFTimeouts PK_WFAvaiblePaths
FK_WFTimeouts_ErrorPATHID_WFAvaiblePaths WFTimeouts PK_WFAvaiblePaths
FK_WFAvaiblePaths_WFApprovalDefinitions WFAvaiblePaths PK_WFApprovalDefinitions
FK_WFAvaiblePaths_WFBusinessRuleDefinitions_OnSubmitUxBRDID WFAvaiblePaths PK_WFBusinessRuleDefinitions
FK_WFAvaiblePaths_WFBusinessRuleDefinitions_IsVisibleBRDID WFAvaiblePaths PK_WFBusinessRuleDefinitions
FK_WFAvaiblePaths_WFConfigurations WFAvaiblePaths PK_WFConfigurations
FK_WFAvaiblePaths_WFConfigurations1 WFAvaiblePaths PK_WFConfigurations
FK_WFAvaiblePaths_WFSteps WFAvaiblePaths PK_WFSteps
FK_WFAvaiblePaths_WFSteps_NextStep WFAvaiblePaths PK_WFSteps

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFAvaiblePaths Yes Yes BTREE ASCENDING 70
UQ_WFAvaiblePaths_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFBusinessRuleDefinitions

Description:Table contains bussines rules definitions

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
BRD_ID int Yes       Business rule ID 
BRD_DEFID int   Yes     ID of WFDefinition that business rule belongs to 
BRD_Name varchar(255)   Yes     Bussines rule name 
BRD_Documentation varchar(MAX)   Yes     Business rule description 
BRD_Value varchar(MAX)       ('')  Business rule value 
BRD_TSInsert datetime       (getdate())  Insert date. 
BRD_TSUpdate datetime       (getdate())  Last modification date 
BRD_RowVersion timestamp     Yes   Row version 
BRD_Guid varchar(36)       (newid())  Global unique ID 
BRD_GroupID int   Yes     Related business rules group id 
BRD_WFSID int   Yes     ID of WFDataSource that belongs to business rule 
BRD_ReturnedValueType int       ((1))  Business rule returned value type 
BRD_EditModeType int       ((1))  Business rule edit mode type 
BRD_IsLocal bit       ((0))  Is business rule local 
BRD_BasicDesignerXml varchar(MAX)   Yes     Basic rule design 
BRD_DataSourceColumn varchar(MAX)   Yes     Column for custom DataSource 
BRD_People varchar(MAX)   Yes     Store people list for rules that use it 
BRD_PluginID int   Yes     Stores plugin id for SDK Rules 
BRD_PluginConfig varchar(MAX)   Yes     Stores plugin xml configuration for SDK Rules 
BRD_RuleType int       ((1))  Business rule type 
BRD_BRDID int   Yes     Foreign key to parent rule 
BRD_WFCID int   Yes     Stores data connection id 

Foreign Keys

Name Foreign Table Primary Key
FK_WFActionBusinessRules_WFBusinessRuleDefinitions WFActionBusinessRules PK_WFBusinessRuleDefinitions
FK_WFActionButtons_WFBusinessRuleDefinitions_IsVisibleBRDID WFActionButtons PK_WFBusinessRuleDefinitions
FK_WFActions_WFBusinessRuleDefinitions_ACT_ActivationBRDID WFActions PK_WFBusinessRuleDefinitions
FK_WFAttachmentConfigs_WFBusinessRuleDefinitions_DefaultValueBRDID WFAttachmentConfigs PK_WFBusinessRuleDefinitions
FK_WFAttachmentConfigs_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFAttachmentConfigs PK_WFBusinessRuleDefinitions
FK_WFAvaiblePaths_WFBusinessRuleDefinitions_OnSubmitUxBRDID WFAvaiblePaths PK_WFBusinessRuleDefinitions
FK_WFAvaiblePaths_WFBusinessRuleDefinitions_IsVisibleBRDID WFAvaiblePaths PK_WFBusinessRuleDefinitions
FK_WFBusinessRuleDefinitions_WFBusinessRuleDefinitions WFBusinessRuleDefinitions PK_WFBusinessRuleDefinitions
FK_WFBusinessRuleParameters_WFBusinessRuleDefinition WFBusinessRuleParameters PK_WFBusinessRuleDefinitions
FK_WFConfigurationBusinessRules_WFBusinessRuleDefinitions WFConfigurationBusinessRules PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_SubelementsCallbackJsBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_DefaultBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_EditModeSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFDataSources_WFBusinessRuleDefinitions WFDataSources PK_WFBusinessRuleDefinitions
FK_WFDetailConfigBusinessRules_WFBusinessRuleDefinitions WFDetailConfigBusinessRules PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_EditModeSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFStepFormFieldDetails_WFBusinessRuleDefinitions_DefaultBRDID WFStepFormFieldDetails PK_WFBusinessRuleDefinitions
FK_WFStepFormFieldDetails_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFStepFormFieldDetails PK_WFBusinessRuleDefinitions
FK_WFStepFormFieldDetails_WFBusinessRuleDefinitions_EditModeSqlBRDID WFStepFormFieldDetails PK_WFBusinessRuleDefinitions
FK_WFStepFormFieldDetails_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFStepFormFieldDetails PK_WFBusinessRuleDefinitions
FK_WFStepFormFieldDetails_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFStepFormFieldDetails PK_WFBusinessRuleDefinitions
FK_WFStepFormFields_WFBusinessRuleDefinitions_FLD_DefaultBRDID WFStepFormFields PK_WFBusinessRuleDefinitions
FK_WFStepFormFields_WFBusinessRuleDefinitions_EditModeSqlBRDID WFStepFormFields PK_WFBusinessRuleDefinitions
FK_WFStepFormFields_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFStepFormFields PK_WFBusinessRuleDefinitions
FK_WFStepFormFields_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFStepFormFields PK_WFBusinessRuleDefinitions
FK_WFStepFormFields_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFStepFormFields PK_WFBusinessRuleDefinitions
FK_WFStepForms_WFBusinessRuleDefinitions_MobileJsOnLoadBRDID WFStepForms PK_WFBusinessRuleDefinitions
FK_WFStepForms_WFBusinessRuleDefinitions_JSOnLoadAndPostbackBRDID WFStepForms PK_WFBusinessRuleDefinitions
FK_WFStepForms_WFBusinessRuleDefinitions_JSOnLoadBRDID WFStepForms PK_WFBusinessRuleDefinitions
FK_WFSteps_WFBusinessRuleDefinitions_BranchConditionBRDID WFSteps PK_WFBusinessRuleDefinitions
FK_WFBusinessRuleDefinitions_DicBusinessRulesEditModeTypes WFBusinessRuleDefinitions PK_DicBusinessRulesEditModeTypes
FK_WFBusinessRuleDefinitions_DicBusinessRulesReturnedValueTypes WFBusinessRuleDefinitions PK_DicBusinessRulesReturnedValueTypes
FK_WFBusinessRuleDefinitions_DicBusinessRulesTypes WFBusinessRuleDefinitions PK_DicBusinessRulesTypes
FK_WFBusinessRuleDefinitions_WFBusinessRulesGroups WFBusinessRuleDefinitions PK_WFBusinessRulesGroups
FK_WFBusinessRuleDefinitions_WFDataConnections WFBusinessRuleDefinitions PK_WFDataConnections
FK_WFBusinessRuleDefinitions_WFDataSources WFBusinessRuleDefinitions PK_WFDataSources
FK_WFBusinessRuleDefinitions_WFDefinitions WFBusinessRuleDefinitions PK_WFDefinitions
FK_WFBusinessRuleDefinitions_WFPlugIns WFBusinessRuleDefinitions PK_WFPlugIns

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFBusinessRuleDefinitions_DEFID     BTREE ASCENDING 0
IX_WFBusinessRuleDefinitions_IsLocal     BTREE ASCENDING 0
PK_WFBusinessRuleDefinitions Yes Yes BTREE ASCENDING 70
UQ_WFBusinessRuleDefinitions_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFBusinessRuleParameters

Description:Table contains business rule parameters definitions

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
BRP_ID int Yes       Business rule parameter ID 
BRP_RuleID int         Business rule parameter related business rule id 
BRP_Name varchar(255)         Business rule parameter name 
BRP_Documentation varchar(MAX)   Yes     Business rule parameter description 
BRP_Type int       ((1))  Business rule parameter type 
BRP_TSInsert datetime       (getdate())  Insert date. 
BRP_TSUpdate datetime       (getdate())  Last modification date 
BRP_RowVersion timestamp     Yes   Row version 
BRP_Guid varchar(36)       (newid())  Global unique ID 

Foreign Keys

Name Foreign Table Primary Key
FK_WFBusinessRuleParameters_DicBusinessRulesReturnedValueTypes WFBusinessRuleParameters PK_DicBusinessRulesReturnedValueTypes
FK_WFBusinessRuleParameters_WFBusinessRuleDefinition WFBusinessRuleParameters PK_WFBusinessRuleDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFBusinessRuleParameters_RuleID     BTREE ASCENDING 0
PK_WFBusinessRuleParameters Yes Yes BTREE ASCENDING 70
UQ_WFBusinessRuleParameters_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFBusinessRulesGroups

Description:Table contains business rules group definitions

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
BRG_ID int Yes       Business rules group ID 
BRG_DEFID int   Yes     ID of WFDefinition that business rules group belongs to 
BRG_Name varchar(255)         Business rules group name 
BRG_Description varchar(MAX)   Yes     Business rules group description 
BRG_TSInsert datetime       (getdate())  Insert date. 
BRG_TSUpdate datetime       (getdate())  Last modification date 
BRG_RowVersion timestamp     Yes   Row version 
BRG_Guid varchar(36)       (newid())  Global unique ID 
BRG_IsUx bit       ((0))  Is ux business rules group 

Foreign Keys

Name Foreign Table Primary Key
FK_WFBusinessRuleDefinitions_WFBusinessRulesGroups WFBusinessRuleDefinitions PK_WFBusinessRulesGroups
FK_WFBusinessRulesGroups_WFDefinitions WFBusinessRulesGroups PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFBusinessRulesGroups_DEFID     BTREE ASCENDING 0
PK_WFBusinessRulesGroups Yes Yes BTREE ASCENDING 70
UQ_WFBusinessRulesGroups_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFConfigurationBusinessRules

Description:Business rules used in attributes configurations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CBR_ID int Yes       Identifier 
CBR_WFCONID int         Attribute identifier 
CBR_BRDID int         Business rule identifier 
CBR_PropertyID int         Attribute configuration property identifier 
CBR_PropertyOrder int   Yes     Attribute configuration property order 
CBR_Guid varchar(36)       (newid())  Global unique ID 
CBR_TSInsert datetime       (getdate())  Creation date 
CBR_TSUpdate datetime       (getdate())  Last modification date 
CBR_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurationBusinessRules_WFBusinessRuleDefinitions WFConfigurationBusinessRules PK_WFBusinessRuleDefinitions
FK_WFConfigurationBusinessRules_WFConfigurations WFConfigurationBusinessRules PK_WFConfigurations

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFConfigurationBusinessRules Yes Yes BTREE ASCENDING 0
UQ_WFConfigurationBusinessRules_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFConfigurations

Description:Contains configuration of form fields for every single process.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WFCON_ID int Yes       Identyfikator 
WFCON_FDEFID int         Relacja do definicji pola. czyli np elementu WFD_AttText1 z tabeli WFFieldDefinition 
WFCON_DEFID int         Relacja do definicji przeplywu. 
WFCON_WFSID int   Yes     Identyfikator zrodla danych (podawane list pole ma zawierac zamkieta liste elementow )(combobox) 
WFCON_PLUID int   Yes      
WFCON_Prompt varchar(50)         Domyslny prompt do pola 
WFCON_Description varchar(MAX)   Yes      
WFCON_SelectOrCaml varchar(MAX)   Yes     Zapytanie jakie ma być wykonane na danym zrodle danych. Select lub CAML 
WFCON_DefaultSelect varchar(255)   Yes     Zapytanie do danego zrodla danych ktore zwraca element ktory stanie sie wartoscia domyslna (II Etap) 
WFCON_DefaultOrder int   Yes      
WFCON_AdditionalHTMLAttrib text   Yes      
WFCON_IsMultiValue bit       ((0))  Czy pole umożliwia wybór wielu wartość. Jesli tak zapis jest w formacie elementów oddzielonych srednikiem 
WFCON_AddInCode varchar(250)   Yes     Nazwa pola jakie bedzie odwzorowane w ADDIn:
WFID
WFName1
WFName2
WFStreet
WFCode
WFCity
WFCountry
WFNIP 
WFCON_Config varchar(MAX)   Yes     le konfiguracyjne informujace o tym w jaki sposob maja byc wyswietlane pola w popupwindow oraz czy po wyborze danego elementu maja byc aktualizowane inne pola w formularzu. przyladem moze byc element adresat gdzie po wyborze do formularza powinny wpisac sie jego dane adresowe. Zawsze wymagane sa kolumny : ID oraz Nazwa. Format w jakiem zapisywana jest konfiguracja:
#.
Przyklady:
ID#ID#ID;
Nazwa#Title#Name;
Kod Pocztowy#Code#KodPocztowy;
Miasto#City#Miasto 
WFCON_AutoPostBack bit       ((0))   
WFCON_PromptStyle varchar(1000)   Yes      
WFCON_ControlStyle varchar(1000)   Yes      
WFCON_AddInControl varchar(500)   Yes      
WFCON_RestrictedRead varchar(2000)   Yes      
WFCON_TSInsert datetime       (getdate())  Data wstawienia wiersza 
WFCON_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
WFCON_RowVersion timestamp     Yes   Wersja wiersza 
WFCON_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
WFCON_SetDefaultValueAlsoOnPostback bit       ((0))  Czy wartość domyślna ma być ustawiana również na postbackach 
WFCON_ShowInTaskList bit       ((0))   
WFCON_ValidationExpression nvarchar(100)   Yes     Wyrażenie regularne do walidacji pól tekstowych formularza 
WFCON_Guid varchar(36)       (newid())   
WFCON_ValidationExpressionErrorMessage nvarchar(255)   Yes     Treść komunikatu jaki dostanie użytkownik w przypadku danych nieprzechodzących walidacji wyrażeniem regularnym 
WFCON_ShowAsHtmlInReadOnlyMode bit       ((0))  Czy atrybut ma zostać pokazany w trybie tylko do odczytu jako pole html 
WFCON_DocumentationDescription varchar(MAX)   Yes      
WFCON_FieldTypeID int       ((1))   
WFCON_IsArchival bit       ((0))   
WFCON_IsTechnical bit       ((0))   
WFCON_RestrictedVisibility varchar(1000)   Yes      
WFCON_FlexiVerificationMode int       ((3))   
WFCON_TemplateID int       ((1))   
WFCON_HistoryIgnoreSQLVisibilityRestrictions bit       ((0))   
WFCON_ShowInMobile bit       ((1))   
WFCON_ReportsIgnoreSQLVisibilityRestrictions bit       ((0))   
WFCON_GroupID int   Yes      
WFCON_GroupOrder int   Yes      
WFCON_BreakGlobalConfigurationInheritance bit       ((0))   
WFCON_GlobalFieldWFCON_ID int   Yes      
WFCON_ChoiceFieldType int       ((1))  Foreign key to choice field subtype dictionary 
WFCON_DefaultBRDID int   Yes      
WFCON_IsSystemField bit       ((0))  Is system field 
WFCON_IsVisibleSqlBRDID int   Yes     Is visible sql business rule ID 
WFCON_EditModeSqlBRDID int   Yes     Edit mode sql business rule ID 
WFCON_IsRequiredSqlBRDID int   Yes     Is required sql business rule ID 
WFCON_HideInEmails bit       ((0))  If attribute should be hidden in emails 
WFCON_JsOnValueChangeBRDID int   Yes     Foreign key to ux business rule defining a javascript function to be executed on value change 
WFCON_SubelementsCallbackJsBRDID int   Yes     Foreign key to ux business rule defining a javascript function to be executed on callback 
WFCON_WFCID int   Yes     Stores data connection id 
WFCON_DataSourceFilterBRDID int   Yes     Foreign key to business rule defining a data source filter 
WFCON_PersonalData_DEFID int   Yes     Foreign key to WFDefinitions table 
WFCON_PersonalData_WFSID int   Yes     Foreign key to WFDataSources table 
WFCON_PersonalData_WFCONID int   Yes     Foreign key to WFConfigurations table 
WFCON_PersonalDataType int   Yes     Foreign key to DicPersonalDataTypes table 
WFCON_PersonalDataCleaningMode int       ((2))  Foreign key to DicPersonalDataCleaningModes table 
WFCON_PersonalDataShouldCleanHistory bit       ((1))  Indicates if personal data cleaning action should also clean history versions 
WFCON_IncludeInAnalysis bit       ((1))  Determines whether this form field should be included in analysis 

Foreign Keys

Name Foreign Table Primary Key
FK_AttributeDocTypeAssocs_WFConfigurations AttributeDocTypeAssocs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Heading1WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details1WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details2WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details3WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details4WfconId ElementDisplayConfigs PK_WFConfigurations
FK_ElementDisplayConfigs_WFConfigurations_Details5WfconId ElementDisplayConfigs PK_WFConfigurations
FK_TilesMappings_WFConfigurations TilesMappings PK_WFConfigurations
FK_WFAvaiblePaths_WFConfigurations WFAvaiblePaths PK_WFConfigurations
FK_WFAvaiblePaths_WFConfigurations1 WFAvaiblePaths PK_WFConfigurations
FK_WFConfigurationBusinessRules_WFConfigurations WFConfigurationBusinessRules PK_WFConfigurations
FK_WFConfigurations_WFConfigurations_Group WFConfigurations PK_WFConfigurations
FK_WFConfigurations_WFConfigurations_PersonalData WFConfigurations PK_WFConfigurations
FK_WFConfigurations_WFConfigurations_GlobalFieldDef WFConfigurations PK_WFConfigurations
FK_WFDefinitions_WFConfigurations_AttachmentsDatabaseWFCONID WFDefinitions PK_WFConfigurations
FK_WFDetailConfigs_WFConfigurations WFDetailConfigs PK_WFConfigurations
FK_WFElementDetails_WFConfigurations WFElementDetails PK_WFConfigurations
FK_WFStepFormFields_WFConfigurations WFStepFormFields PK_WFConfigurations
FK_WFTimeouts_WFConfigurations WFTimeouts PK_WFConfigurations
FK_WFConfigurations_DicChoiceFieldTypes WFConfigurations PK_DicChoiceFieldTypes
FK_WFConfigurations_DicConfigurationTemplates WFConfigurations PK_DicConfigurationTemplates
FK_WFConfigurations_DicPersonalDataCleaningModes WFConfigurations PK_DicPersonalDataCleaningModes
FK_WFConfigurations_DicPersonalDataTypes WFConfigurations PK_DicPersonalDataTypes
FK_WFConfigurations_DicWFFieldTypes WFConfigurations PK_DicWFFieldTypes
FK_WFConfigurations_WFBusinessRuleDefinitions_SubelementsCallbackJsBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_DefaultBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_EditModeSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFConfigurations PK_WFBusinessRuleDefinitions
FK_WFConfigurations_WFDataConnections WFConfigurations PK_WFDataConnections
FK_WFConfigurations_WFDataSources WFConfigurations PK_WFDataSources
FK_WFConfigurations_WFDataSources_PersonalData WFConfigurations PK_WFDataSources
FK_WFConfigurations_WFDefinitions_PersonalData WFConfigurations PK_WFDefinitions
FK_WFConfigurations_WFDefinitions WFConfigurations PK_WFDefinitions
FK_WFConfigurations_WFFieldDefinitions WFConfigurations PK_WFFieldDefinitions
FK_WFConfigurations_WFPlugIns WFConfigurations PK_WFPlugIns

Indexes

Name Unique Clustered Type Collation Fill Factor
idx_ncl_DEFID_TemplateID_FDEFID     BTREE ASCENDING 70
PK_WFConfigurations Yes Yes BTREE ASCENDING 70
UQ_WFConfigurations_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFConfigurationSecurities

Description:List of permissions dependent on configuration

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
CSC_ID int Yes       Identifier 
CSC_LevelID int         Id of security level 
CSC_IsDomainGroup bit       ((0))  Is entity domain group 
CSC_TSInsert datetime       (getdate())  Date of row insertion 
CSC_TSUpdate datetime       (getdate())  Date of row update 
CSC_RowVersion timestamp     Yes   Row version 
CSC_Guid varchar(36)       (newid())  Entry unique identifier for import export mechanism 
CSC_IsGlobal bit       ((0))  Is entry defining global security 
CSC_USERGUID varchar(250)   Yes     User login 
CSC_UserLoginName varchar(250)   Yes     User login 
CSC_UserName varchar(50)   Yes     User display name 
CSC_APPID int   Yes     Stores app id if security entry applies to application 
CSC_ASTID int   Yes     Foreign key to AppStarts table 
CSC_ARPID int   Yes     Foreign key to AppReports table 
CSC_ADSID int   Yes     Foreign key to AppDashboards table 
CSC_AEDID int   Yes     Foreign key to AppExploreDefinitions table 

Foreign Keys

Name Foreign Table Primary Key
FK_WFConfigurationSecurities_AppDashboards WFConfigurationSecurities PK_AppDashboards
FK_WFConfigurationSecurities_AppExploreDefinitions WFConfigurationSecurities PK_AppExploreDefinitions
FK_WFConfigurationSecurities_AppReports WFConfigurationSecurities PK_AppReports
FK_WFConfigurationSecurities_AppStarts WFConfigurationSecurities PK_AppStarts
FK_WFConfigurationSecurities_DicConfigurationSecurityLevels WFConfigurationSecurities PK_DicConfigurationSecurityLevel
FK_WFConfigurationSecurities_WFApplications WFConfigurationSecurities PK_WFApplications

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFConfigurationSecurities_IsGlobal_LevelID     BTREE ASCENDING 70
IX_WFConfigurationSecurities_LevelID     BTREE ASCENDING 70
PK_WFConfigurationSecurities Yes Yes BTREE ASCENDING 70
UQ_WFConfigurationSecurities_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFCovers

Description:Stores definitions of replacements in the system, both general and specific for certain processes. Stores active and inactive replacements.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
COV_ID int Yes        
COV_TSInsert datetime       (getdate())   
COV_TSUpdate datetime       (getdate())   
COV_CreatedBy varchar(255)   Yes      
COV_UpdatedBy varchar(255)   Yes      
COV_RowVersion timestamp     Yes    
COV_IsDeleted bit       ((0))   
COV_Person varchar(255)          
COV_Cover varchar(255)          
COV_CoverStart datetime          
COV_CoverEnd datetime          
COV_IsActive bit       ((1))   
COV_DEFID int   Yes      
COV_COMID int   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_WFCovers_Companies WFCovers PK_Companies
FK_WFCovers_WFDefinitions WFCovers PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFCovers Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFDataAttachmets

Description:Contains attachement metadata like: name, description, added by, modified by, etc.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
ATT_ID int Yes       Identyfikator 
ATT_WFDID int   Yes     Relacja do tabeli WFData 
ATT_Name varchar(255)   Yes     Nazwa 
ATT_Value image   Yes     Zalacznik (binary) 
ATT_Description varchar(500)   Yes     Opis 
ATT_IsSecret bit   Yes   ((0))   
ATT_TSInsert datetime       (getdate())  Data wstawienia wiersza 
ATT_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
ATT_CreatedBy varchar(255)   Yes      
ATT_UpdatedBy varchar(255)   Yes      
ATT_RowVersion timestamp     Yes   Wersja wiersza 
ATT_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
ATT_WriteHistory bit       ((1))  Czy ma byc zapisywana historia elementu 
ATT_FileType varchar(20)       ('pdf')   
ATT_FileIsOcr int       ((0))   
ATT_OcrErrorCount int       ((0))  Liczba bledów przy próbie asynchronicznego OCR, lub -1 jeśli w konfiguracji serwisu nie ma węzła powiązanego z procesem w którym jest załącznik 
ATT_FileVersion int       ((0))   
ATT_Attribute1 varchar(255)   Yes      
ATT_IsBarcodeUnrecognized bit   Yes     Determines if barcode was unrecognized 
ATT_TypeID int       ((0))  Attachment type 
ATT_IsMailMessage bit       ((0))   
ATT_MessageTo varchar(MAX)   Yes      
ATT_MessageCc varchar(MAX)   Yes      
ATT_MessageSubject varchar(MAX)   Yes      
ATT_MessageFrom varchar(MAX)   Yes      
ATT_ContentLength int   Yes     Content length 
ATT_MessageSentDate datetime   Yes     Column contains informations about date of sent message 
ATT_MessageFromMail varchar(MAX)   Yes     Mail message attachment sender mail 
ATT_DEFID int   Yes     Stores process identifier if element id is null 
ATT_MessageId varchar(MAX)   Yes     Column contains mail message id 

Foreign Keys

Name Foreign Table Primary Key
FK_OcrAiLearnQueueItems_WFDataAttachmets OcrAiLearnQueueItems PK_WFDataAttachmets
FK_OcrAiProjectsToAttachments_WFDataAttachmets OcrAiProjectsToAttachments PK_WFDataAttachmets
FK_OcrAiQueueItems_WFDataAttachmets OcrAiQueueItems PK_WFDataAttachmets
FK_TextLayerQueueItems_WFDataAttachmets TextLayerQueueItems PK_WFDataAttachmets
FK_WebDavLocks_WFDataAttachmets_ATTID WebDavLocks PK_WFDataAttachmets
FK_WFDataAttachmets_WFData WFDataAttachmets PK_WFData

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFDataAttachmets_WFDID     BTREE ASCENDING 70
PK_WFDataAttachmets Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFDataConnections

Description:Contains definitions of all connections.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WFC_ID int Yes       Identifier 
WFC_Name varchar(50)         Connection name 
WFC_Description varchar(1000)   Yes     Connection description 
WFC_Type int         Connection type 
WFC_TSInsert datetime       (getdate())  Creation date 
WFC_TSUpdate datetime       (getdate())  Last modification date 
WFC_RowVersion timestamp     Yes   Timestamp 
WFC_DetachInheritance_PROD bit       ((0))  Do a production environment using a different data source configuration. 
WFC_DetachInheritance_TEST bit       ((0))  Do a test environment using a different data source configuration. 
WFC_DetachInheritance_DEV bit       ((0))  Do a developer environment using a different data source configuration. 
WFC_WebServiceBinding int   Yes     Binding for Web Service data source 
WFC_WebServiceBinding_PROD int   Yes     Binding for Web Service data source for production environment 
WFC_WebServiceBinding_TEST int   Yes     Binding for Web Service data source for test environment 
WFC_WebServiceBinding_DEV int   Yes     Binding for Web Service data source for developer environment 
WFC_WebServiceKeepAlive bit   Yes     Keep alive option for Web Service data source 
WFC_WebServiceKeepAlive_PROD bit   Yes     Keep alive option for Web Service data source for production environment 
WFC_WebServiceKeepAlive_TEST bit   Yes     Keep alive option for Web Service data source for test environment 
WFC_WebServiceKeepAlive_DEV bit   Yes     Keep alive option for Web Service data source for developer environment 
WFC_WebServiceValidateHttpsCert bit   Yes     Validate https cerificate option for Web Service data source 
WFC_WebServiceValidateHttpsCert_PROD bit   Yes     Validate https cerificate option for Web Service data source for production environment 
WFC_WebServiceValidateHttpsCert_TEST bit   Yes     Validate https cerificate option for Web Service data source for test environment 
WFC_WebServiceValidateHttpsCert_DEV bit   Yes     Validate https cerificate option for Web Service data source for developer environment 
WFC_ConnectString varchar(MAX)   Yes     ConnectString 
WFC_Guid varchar(36)       (newid())  Entity guid 
WFC_ConnectString_PROD varchar(MAX)   Yes     Connection string value for Production environment 
WFC_ConnectString_TEST varchar(MAX)   Yes     Connection string value for Test environment 
WFC_ConnectString_DEV varchar(MAX)   Yes     Connection string value for Develpoers environment 
WFC_WebServiceRestAuthenticationURL varchar(200)   Yes     Authentication url 
WFC_WebServiceRestAuthenticationURL_PROD varchar(200)   Yes     PROD authentication url 
WFC_WebServiceRestAuthenticationURL_TEST varchar(200)   Yes     TEST authentication url 
WFC_WebServiceRestAuthenticationURL_DEV varchar(200)   Yes     DEV authentication url 
WFC_WebServiceRestClientID varchar(200)   Yes     Client ID 
WFC_WebServiceRestClientID_PROD varchar(200)   Yes     PROD Client ID 
WFC_WebServiceRestClientID_TEST varchar(200)   Yes     TEST Client ID 
WFC_WebServiceRestClientID_DEV varchar(200)   Yes     DEV Client ID 
WFC_WebServiceRestClientSecret varchar(200)   Yes     Client secret 
WFC_WebServiceRestClientSecret_PROD varchar(200)   Yes     PROD Client secret 
WFC_WebServiceRestClientSecret_TEST varchar(200)   Yes     TEST Client secret 
WFC_WebServiceRestClientSecret_DEV varchar(200)   Yes     DEV Client secret 
WFC_IsHidden bit       ((0))  Is data connection hidden in user interface 
WFC_SharePointType int   Yes     SharePoint Type (On-Premises or Online) 
WFC_Credentials int   Yes     Credentials type based on enum 
WFC_SharePointType_DEV int   Yes     SharePoint Type (On-Premises or Online) 
WFC_SharePointType_TEST int   Yes     SharePoint Type (On-Premises or Online) 
WFC_SharePointType_PROD int   Yes     SharePoint Type (On-Premises or Online) 
WFC_Credentials_DEV int   Yes     Credentials type based on enum 
WFC_Credentials_TEST int   Yes     Credentials type based on enum 
WFC_Credentials_PROD int   Yes     Credentials type based on enum 
WFC_UserName varchar(200)   Yes     User name 
WFC_UserName_DEV varchar(200)   Yes     User name for developer environment 
WFC_UserName_TEST varchar(200)   Yes     User name for test environment 
WFC_UserName_PROD varchar(200)   Yes     User name for production environment 
WFC_UserPassword varchar(200)   Yes     User password 
WFC_UserPassword_DEV varchar(200)   Yes     User password for developer environment 
WFC_UserPassword_TEST varchar(200)   Yes     User password for test environment 
WFC_UserPassword_PROD varchar(200)   Yes     User password for production environment 
WFC_Url varchar(200)   Yes     Url 
WFC_Url_DEV varchar(200)   Yes     Url for developer environment 
WFC_Url_TEST varchar(200)   Yes     Url for test environment 
WFC_Url_PROD varchar(200)   Yes     Url for production environment 
WFC_OracleSessionParameters varchar(MAX)   Yes     XML with Oracle session parameters set explicitly by BPS when connecting to Oracle database server 
WFC_WebServiceRestConnectAs int   Yes     Auth Type (User/App) 
WFC_WebServiceRestConnectAs_DEV int   Yes     Auth Type (User/App) 
WFC_WebServiceRestConnectAs_TEST int   Yes     Auth Type (User/App) 
WFC_WebServiceRestConnectAs_PROD int   Yes     Auth Type (User/App) 

Foreign Keys

Name Foreign Table Primary Key
FK_WFAttachmentConfigs_WFDataConnections WFAttachmentConfigs PK_WFDataConnections
FK_WFBusinessRuleDefinitions_WFDataConnections WFBusinessRuleDefinitions PK_WFDataConnections
FK_WFConfigurations_WFDataConnections WFConfigurations PK_WFDataConnections
FK_WFDataSources_WFDataConnections WFDataSources PK_WFDataConnections
FK_WFDetailConfigs_WFDataConnections WFDetailConfigs PK_WFDataConnections

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDataConnections Yes Yes BTREE ASCENDING 70
UQ_WFDataConnections_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFDataSourceColumns

Description:Definitions of columns used in data sources

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WDC_ID int Yes       Identifier 
WDC_WFSID int         Identifier of data source to which this columns belongs to 
WDC_Name varchar(255)         Internal name of this column 
WDC_DisplayName varchar(255)   Yes     Display name of this column 
WDC_Type int         Type of data stored in this column 
WDC_IsUnicode bit       ((0))  Determines if the column stores text in unicode encoding 
WDC_FormatConfiguration varchar(MAX)   Yes     Column configuration as XML file 
WDC_TSInsert datetime       (getdate())  Creation date 
WDC_TSUpdate datetime       (getdate())  Last modification date 
WDC_RowVersion timestamp     Yes   Timestamp 
WDC_DecimalPrecision int   Yes     Precision for decimal columns 

Foreign Keys

Name Foreign Table Primary Key
FK_WFDataSourceColumns_WFDataSources WFDataSourceColumns PK_WFDataSources

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDataSourceColumns Yes Yes BTREE ASCENDING 0
UQ_WFDataSourceColumns Yes   BTREE ASCENDING 0

Table of Contents

Table: WFDataSources

Description:Contains definitions of all data sources (all types). Also stores system data sources, unavailable for users.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WFS_ID int Yes        
WFS_WFSID int   Yes      
WFS_COMID int   Yes      
WFS_Name varchar(50)         Nazwa źródła Danych 
WFS_Description varchar(1000)   Yes     Szczeglowy opis zrodla danych 
WFS_Type int         Typ Zrodla Danych:
1. MS SQL
2. SharePoint List
3. Domain Users 
WFS_ConnectString varchar(MAX)   Yes     ConnectString do bazy MSSQL  
WFS_SPList varchar(200)   Yes     Nazwa listy Sharepoint 
WFS_SPWeb varchar(200)   Yes     Nazwa witryny na ktorej znajduje sie lista 
WFS_SelectCommand varchar(MAX)   Yes      
WFS_SPWebService varchar(200)   Yes     Nazwa serwera i zbiory witryn gdzie znajduje sie lista. (czyli tam prawde adres webservice)
http://www.csharphelp.com/archives4/archive602.html 
WFS_TSInsert datetime       (getdate())  Data wstawienia wiersza 
WFS_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
WFS_RowVersion timestamp     Yes   Wersja wiersza 
WFS_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
WFS_Guid varchar(36)       (newid())   
WFS_ADQueryId int   Yes     Identyfikator zapytania do Active Directory 
WFS_ADProperties varchar(MAX)   Yes     Zwracane właściwości z Active Directory 
WFS_IsPublic bit       ((0))   
WFS_PluginId int   Yes     Identyfikator pluginu 
WFS_PluginConfiguration varchar(MAX)   Yes     Konfiguracja plugina 
WFS_ADOU nvarchar(200)   Yes     Organizational unit, w którym ma działać wyszukiwanie AD 
WFS_SPView varchar(200)   Yes     Opcjonalna nazwa widoku, na którym będzie wykonywane zapytanie 
WFS_SPGroup varchar(100)   Yes     Grupa SharePoint 
WFS_IsHidden bit       ((0))  Czy źródło danych jest ukryte w interfejsie użytkownika 
WFS_TemplateID int       ((1))   
WFS_RunInElevated bit       ((0))   
WFS_Configuration varchar(MAX)   Yes     Configuration of the data source 
WFS_ConnectString_PROD varchar(MAX)   Yes     Connection string value for Production environment 
WFS_SPList_PROD varchar(200)   Yes     Sharepoint list value for Production environment 
WFS_SPWeb_PROD varchar(200)   Yes     Sharepoint site value for Production environment 
WFS_SPWebService_PROD varchar(200)   Yes     Web service address value for Production environment 
WFS_SPGroup_PROD varchar(100)   Yes     Sharepoint group name value for Production environment 
WFS_ConnectString_TEST varchar(MAX)   Yes     Connection string value for Test environment 
WFS_SPList_TEST varchar(200)   Yes     Sharepoint list value for Test environment 
WFS_SPWeb_TEST varchar(200)   Yes     Sharepoint site value for Test environment 
WFS_SPWebService_TEST varchar(200)   Yes     Web service address value for Test environment 
WFS_SPGroup_TEST varchar(100)   Yes     Sharepoint group name value for Test environment 
WFS_ConnectString_DEV varchar(MAX)   Yes     Connection string value for Develpoers environment 
WFS_SPList_DEV varchar(200)   Yes     Sharepoint list value for Develpoers environment 
WFS_SPWeb_DEV varchar(200)   Yes     Sharepoint site value for Develpoers environment 
WFS_SPWebService_DEV varchar(200)   Yes     Web service address value for Develpoers environment 
WFS_SPGroup_DEV varchar(100)   Yes     Sharepoint group name value for Develpoers environment 
WFS_WebServiceUser varchar(200)   Yes     User name for Web Service data source 
WFS_WebServicePassword varchar(200)   Yes     User password for Web Service data source 
WFS_WebServiceUser_PROD varchar(200)   Yes     User name for Web Service data source for production environment 
WFS_WebServicePassword_PROD varchar(200)   Yes     User password for Web Service data source for production environment 
WFS_WebServiceUser_TEST varchar(200)   Yes     User name for Web Service data source for test environment 
WFS_WebServicePassword_TEST varchar(200)   Yes     User password for Web Service data source for test environment 
WFS_WebServiceUser_DEV varchar(200)   Yes     User name for Web Service data source for developer environment 
WFS_WebServicePassword_DEV varchar(200)   Yes     User password for Web Service data source for developer environment 
WFS_DetachInheritance_PROD bit       ((0))  Do a production environment using a different data source configuration. 
WFS_DetachInheritance_TEST bit       ((0))  Do a test environment using a different data source configuration. 
WFS_DetachInheritance_DEV bit       ((0))  Do a developer environment using a different data source configuration. 
WFS_WebServiceBinding int   Yes     Binding for Web Service data source 
WFS_WebServiceBinding_PROD int   Yes     Binding for Web Service data source for production environment 
WFS_WebServiceBinding_TEST int   Yes     Binding for Web Service data source for test environment 
WFS_WebServiceBinding_DEV int   Yes     Binding for Web Service data source for developer environment 
WFS_WebServiceKeepAlive bit   Yes     Keep alive option for Web Service data source 
WFS_WebServiceKeepAlive_PROD bit   Yes     Keep alive option for Web Service data source for production environment 
WFS_WebServiceKeepAlive_TEST bit   Yes     Keep alive option for Web Service data source for test environment 
WFS_WebServiceKeepAlive_DEV bit   Yes     Keep alive option for Web Service data source for developer environment 
WFS_WebServiceValidateHttpsCert bit   Yes     Validate https cerificate option for Web Service data source 
WFS_WebServiceValidateHttpsCert_PROD bit   Yes     Validate https cerificate option for Web Service data source for production environment 
WFS_WebServiceValidateHttpsCert_TEST bit   Yes     Validate https cerificate option for Web Service data source for test environment 
WFS_WebServiceValidateHttpsCert_DEV bit   Yes     Validate https cerificate option for Web Service data source for developer environment 
WFS_WebServiceRestAuthenticationURL varchar(200)   Yes      
WFS_WebServiceRestAuthenticationURL_PROD varchar(200)   Yes      
WFS_WebServiceRestAuthenticationURL_TEST varchar(200)   Yes      
WFS_WebServiceRestAuthenticationURL_DEV varchar(200)   Yes      
WFS_WebServiceRestClientID varchar(200)   Yes      
WFS_WebServiceRestClientID_PROD varchar(200)   Yes      
WFS_WebServiceRestClientID_TEST varchar(200)   Yes      
WFS_WebServiceRestClientID_DEV varchar(200)   Yes      
WFS_WebServiceRestClientSecret varchar(200)   Yes      
WFS_WebServiceRestClientSecret_PROD varchar(200)   Yes      
WFS_WebServiceRestClientSecret_TEST varchar(200)   Yes      
WFS_WebServiceRestClientSecret_DEV varchar(200)   Yes      
WFS_UseSsl bit   Yes     Use ssl 
WFS_UseAppPoolUser bit   Yes     Connect using application pool user data 
WFS_StaticValues varchar(MAX)   Yes     lumn contains id, name, description separated by # and ; e.g. id1#name1#description1;id2#name2#description2; 
WFS_WFCID int   Yes     Stores id of related data connection 
WFS_InternalViewConfiguration varchar(MAX)   Yes     Column stores configuration of SWE Data Source. 
WFS_AddinFilterMode bit       ((0))  Flag indicating whether filters should be applied on addin side. When set to false all the filters will be aplied on BPS side. 
WFS_CWSID int   Yes     Stores id of related configured web service 
WFS_PersonalDataUsageMode int   Yes     Foreign key to DicPersonalDataUsageModes table 
WFS_PersonalDataIdentifierColumn varchar(200)   Yes     Name of identifier column 
WFS_IsPersonalDataDictionary bit       ((0))  Determines whether it is a personal data dictionary 
WFS_FilterBRDID int   Yes     Foreign key to business rule defining a data source filter 

Foreign Keys

Name Foreign Table Primary Key
FK_WFAttachmentConfigs_WFDataSources WFAttachmentConfigs PK_WFDataSources
FK_WFBusinessRuleDefinitions_WFDataSources WFBusinessRuleDefinitions PK_WFDataSources
FK_WFConfigurations_WFDataSources WFConfigurations PK_WFDataSources
FK_WFConfigurations_WFDataSources_PersonalData WFConfigurations PK_WFDataSources
FK_WFDataSourceColumns_WFDataSources WFDataSourceColumns PK_WFDataSources
FK_WFDataSources_WFDataSources WFDataSources PK_WFDataSources
FK_WFDefinitions_WFDataSources WFDefinitions PK_WFDataSources
FK_WFDetailConfigs_WFDataSources WFDetailConfigs PK_WFDataSources
FK_WFDetailConfigs_WFDataSources_PersonalData WFDetailConfigs PK_WFDataSources
FK_WFDataSources_Companies WFDataSources PK_Companies
FK_WFDataSources_ConfiguredWebServices WFDataSources PK_ConfiguredWebServices
FK_WFDataSources_DicDataSourceTemplates WFDataSources PK_DicDataSourceTemplates
FK_WFDataSources_DicPersonalDataUsageModes WFDataSources PK_DicPersonalDataUsageModes
FK_WFDataSources_WFBusinessRuleDefinitions WFDataSources PK_WFBusinessRuleDefinitions
FK_WFDataSources_WFDataConnections WFDataSources PK_WFDataConnections
FK_WFDataSources_Plugins WFDataSources PK_WFPlugIns

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDataSources Yes Yes BTREE ASCENDING 70
UQ_WFDataSources_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFDefinitions

Description:Contains processes definitions.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DEF_ID int Yes       Identyfikator 
DEF_Name varchar(50)         Nazwa 
DEF_Acronym varchar(50)   Yes     Akronik jaki moze posluzyc do stworzenie Sygnatury 
DEF_Description varchar(MAX)   Yes     Opis 
DEF_TSInsert datetime       (getdate())  Data wstawienia wiersza 
DEF_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
DEF_RowVersion timestamp     Yes   Wersja wiersza 
DEF_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
DEF_UseSPCovers bit       ((0))  Określa czy w tym procesie mają być uwzględnianie zastępstwa definiowane na liście SharePoint 
DEF_LeaveCoverAccess bit       ((1))  Okresla czy po usunieciu zastepstwa ma pozostac prawo do odczytu dla tej osoby. 
DEF_AttachmentsDatabase varchar(255)   Yes      
DEF_TaskMailTitle varchar(255)   Yes      
DEF_TaskDWMailTitle varchar(255)   Yes      
DEF_Guid varchar(36)       (newid())   
DEF_DefaultMessageTemplate int   Yes      
DEF_DefaultMessageTemplateDW int   Yes      
DEF_DeploymentMode bit       ((0))   
DEF_DeploymentModeMailRecipient varchar(255)   Yes      
DEF_DocumentationDescription varchar(500)   Yes      
DEF_CoversNewTaskEmails bit       ((0))   
DEF_CoversExistTaskEmails bit       ((0))   
DEF_IsProductionProcess bit       ((1))   
DEF_SignEmailsByDefault bit       ((0))   
DEF_EmailSignCertificate varchar(200)   Yes      
DEF_TemplateID int       ((1))   
DEF_TemplateConfiguration varchar(MAX)   Yes      
DEF_Supervisor varchar(1000)   Yes      
DEF_Mapping varchar(MAX)   Yes      
DEF_CompanyStructureID int   Yes      
DEF_UseHierarchicalSecurity bit       ((0))   
DEF_MassNotificationConfiguration varchar(MAX)   Yes      
DEF_IsLicencedPerProcess bit       ((0))   
DEF_AsynchronousOCROn bit       ((0))   
DEF_AsynchronousKeepOriginalAttachment bit       ((0))   
DEF_AsynchronousOCRDaysBackLimit int       ((30))   
DEF_AsynchronousOCRMode int       ((0))   
DEF_EnableTimeouts bit       ((1))   
DEF_MailRecipientExceptions varchar(MAX)   Yes      
DEF_UseDifferentEmailCCTemplate bit       ((0))   
DEF_EnvironmentType int       ((0))  Environment for data sources used by process 
DEF_IsMobileEnable bit       ((1))   
DEF_IsOutlookEnable bit       ((1))   
DEF_IsWordEnable bit       ((1))   
DEF_CheckOutDate datetime   Yes     Date when process has been checked out 
DEF_CheckOutByUser varchar(1024)   Yes     Contains user login which CheckOut process 
DEF_CheckOutOnHost varchar(1024)   Yes     Contains host name on which process has been checked out 
DEF_IncludeWorkingDays bit       ((0))  Include working days defined in the working days calendar 
DEF_ArchiveExportLocation varchar(2000)   Yes     Path to location where archive packages will be extracted 
DEF_ArchiveAttachmentsMode int       ((0))  Mode of archiving attachments 
DEF_ArchivingDatabase varchar(255)   Yes     Archiving database 
DEF_APPID int         WFApplications foreign key 
DEF_BaseUrl varchar(255)   Yes      
DEF_WFDynamicMode int       ((1))  Web interface which will be used to display workflow instance edit form. WFDynamic (1) is currently used interface, WFDynamic Lite (2) is new modern interface 
DEF_PersonalDataUsageMode int   Yes     Foreign key to DicPersonalDataUsageModes table 
DEF_PersonalDataCleaningMode int       ((2))  Foreign key to DicPersonalDataCleaningModes table 
DEF_PersonalDataShouldCleanHistory bit       ((1))  Indicates if personal data cleaning action should also clean history versions 
DEF_AttachmentsDatabaseWFCONID int   Yes     Id of attribute chosen for attachments database 
DEF_AttachmentsDatabaseColName varchar(50)   Yes     Column name of attribute chosen for attachments database 
DEF_IsPersonalDataDictionary bit       ((0))  Determines whether it is a personal data dictionary 
DEF_IncludeInAnalysis bit       ((0))  Determines whether process is included in AI analysis 
DEF_SaveStamp varchar(36)       (newid())  Save stamp 

Foreign Keys

Name Foreign Table Primary Key
FK_AiAnalysisQueueItems_WFDefinitions AiAnalysisQueueItems PK_WFDefinitions
FK_ElementDisplayConfigs_WFDefinitions_DEF_ID ElementDisplayConfigs PK_WFDefinitions
FK_HotFolders_WFDefinitions HotFolders PK_WFDefinitions
FK_HotMailBoxs_WFDefinitions HotMailBoxs PK_WFDefinitions
FK_KPIElements_WFDefinitions KPIElements PK_WFDefinitions
FK_KPITops_WFDefinitions KPITops PK_WFDefinitions
FK_ProcessSites_WFDefinitions ProcessSites PK_WFDefinitions
FK_TilesConfigurations_WFDefinitions TilesConfigurations PK_WFDefinitions
FK_WFActions_WFDefinitions WFActions PK_WFDefinitions
FK_WFApplicationsLinkedProcesses_WFDefinitions WFApplicationsLinkedProcesses PK_WFDefinitions
FK_WFAttachmentConfigs_WFDefinitions WFAttachmentConfigs PK_WFDefinitions
FK_WFBusinessRuleDefinitions_WFDefinitions WFBusinessRuleDefinitions PK_WFDefinitions
FK_WFBusinessRulesGroups_WFDefinitions WFBusinessRulesGroups PK_WFDefinitions
FK_WFConfigurations_WFDefinitions_PersonalData WFConfigurations PK_WFDefinitions
FK_WFConfigurations_WFDefinitions WFConfigurations PK_WFDefinitions
FK_WFCovers_WFDefinitions WFCovers PK_WFDefinitions
FK_WFDefinitionVersions_WFDefinitions WFDefinitionVersions PK_WFDefinitions
FK_WFDetailConfigs_WFDefinitions_PersonalData WFDetailConfigs PK_WFDefinitions
FK_WFDocTypes_WFDefinitions WFDocTypes PK_WFDefinitions
FK_WFEnvironmentProcessVariables_WFDefinitions WFEnvironmentProcessVariables PK_WFDefinitions
FK_WFEnvironmentProcessVariablesGroups_WFDefinitions WFEnvironmentProcessVariablesGroups PK_WFDefinitions
FK_WFMessageTemplates_WFDefinitions WFMessageTemplates PK_WFDefinitions
FK_WFSecurities_WFDefinitions WFSecurities PK_WFDefinitions
FK_WorkFlows_WFDefinitions WorkFlows PK_WFDefinitions
FK_WFDefinitions_DicDefinitionTemplates WFDefinitions PK_DicDefinitionTemplates
FK_WFDefinitions_DicPersonalDataCleaningModes WFDefinitions PK_DicPersonalDataCleaningModes
FK_WFDefinitions_DicPersonalDataUsageModes WFDefinitions PK_DicPersonalDataUsageModes
FK_WFDefinitions_WFApplications WFDefinitions PK_WFApplications
FK_WFDefinitions_WFConfigurations_AttachmentsDatabaseWFCONID WFDefinitions PK_WFConfigurations
FK_WFDefinitions_WFDataSources WFDefinitions PK_WFDataSources
FK_WFDefinitions_WFMessageTemplates WFDefinitions PK_WFMessageTemplates
FK_WFDefinitions_WFMessageTemplates_DW WFDefinitions PK_WFMessageTemplates

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFDefinitions_Name     BTREE ASCENDING 70
PK_WFDefinitions Yes Yes BTREE ASCENDING 70
UQ_WFDefinitions_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFDefinitionVersions

Description:Versions of process

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DEFV_ID int Yes       Identifier 
DEFV_DEFID int         Process id 
DEFV_TSInsert datetime       (getdate())  Creation date 
DEFV_TSUpdate datetime       (getdate())  Last modification date 
DEFV_RowVersion timestamp     Yes   Timestamp 
DEFV_VersionImage image         Version content 
DEFV_IsDeleted bit       ((0))  Is record deleted 
DEFV_CreatedBy varchar(50)         Author 
DEFV_UpdatedBy varchar(50)         Last modifier 

Foreign Keys

Name Foreign Table Primary Key
FK_WFDefinitionVersions_WFDefinitions WFDefinitionVersions PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDefinitionVersions Yes Yes BTREE ASCENDING 0

Table of Contents

Table: WFDetailConfigBusinessRules

Description:Business rules used in subelement column configurations

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DBR_ID int Yes       Identifier 
DBR_DCNID int         Subelement column identifier 
DBR_BRDID int         Business rule identifier 
DBR_PropertyID int         Subelement column configuration property identifier 
DBR_PropertyOrder int   Yes     Subelement column configuration property order 
DBR_Guid varchar(36)       (newid())  Global unique ID 
DBR_TSInsert datetime       (getdate())  Creation date 
DBR_TSUpdate datetime       (getdate())  Last modification date 
DBR_RowVersion timestamp     Yes   Timestamp 

Foreign Keys

Name Foreign Table Primary Key
FK_WFDetailConfigBusinessRules_WFBusinessRuleDefinitions WFDetailConfigBusinessRules PK_WFBusinessRuleDefinitions
FK_WFDetailConfigBusinessRules_WFDetailConfigs WFDetailConfigBusinessRules PK_WFDetailConfigs

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDetailConfigBusinessRules Yes Yes BTREE ASCENDING 0
UQ_WFDetailConfigBusinessRules_Guid Yes   BTREE ASCENDING 0

Table of Contents

Table: WFDetailConfigs

Description:Contains configuration of all columns in items lists.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DCN_ID int Yes        
DCN_PLUID int   Yes      
DCN_FDDID int          
DCN_WFSID int   Yes      
DCN_FieldDetailTypeID int          
DCN_Prompt varchar(50)          
DCN_TSInsert datetime       (getdate())   
DCN_TSUpdate datetime       (getdate())   
DCN_RowVersion timestamp     Yes    
DCN_SelectOrCaml varchar(MAX)   Yes      
DCN_Config varchar(MAX)   Yes      
DCN_WFCONID int         Identyfikator atrybutu definiującego kontrolkę subelementów, do której należy ta definicja kolumny 
DCN_AutoCallback bit       ((0))   
DCN_Guid varchar(36)       (newid())   
DCN_DefaultWidth varchar(20)   Yes      
DCN_PresentReadOnlyAsLabel bit       ((0))   
DCN_UsePeopleDataSource bit       ((0))  Czy picker ma korzystać ze źródła danych people'a 
DCN_IsMultiValue bit       ((0))  Czy pole umożliwia wybór wielu wartości 
DCN_IsTechnical bit       ((0))   
DCN_ValidationExpression varchar(100)   Yes     Column contains regex expression used in data validation 
DCN_ValidationExpressionErrorMessage varchar(255)   Yes     Column contains error message displayed on validation error 
DCN_Order int         Order of subelement column 
DCN_DefaultBRDID int   Yes     Default business rule ID 
DCN_IsVisibleSqlBRDID int   Yes     Is visible sql business rule ID 
DCN_EditModeSqlBRDID int   Yes     Edit mode sql business rule ID 
DCN_IsRequiredSqlBRDID int   Yes     Is required sql business rule ID 
DCN_JsOnValueChangeBRDID int   Yes     Foreign key to ux business rule defining a javascript function to be executed on value change 
DCN_WFCID int   Yes     Stores data connection id 
DCN_DataSourceFilterBRDID int   Yes     Foreign key to business rule defining a data source filter 
DCN_HistoryIgnoreSQLVisibilityRestrictions bit       ((0))  Determines if ignore visibility restriction and always show column in the history 
DCN_PersonalData_DEFID int   Yes     Foreign key to WFDefinitions table 
DCN_PersonalData_WFSID int   Yes     Foreign key to WFDataSources table 
DCN_PersonalDataType int   Yes     Foreign key to DicPersonalDataTypes table 
DCN_PersonalDataCleaningMode int       ((2))  Foreign key to DicPersonalDataCleaningModes table 
DCN_PersonalDataShouldCleanHistory bit       ((1))  Indicates if personal data cleaning action should also clean history versions 
DCN_PersonalData_DCNID int   Yes     Foreign key to WFDetailConfigs table 
DCN_DocumentationDescription varchar(MAX)   Yes     Documentation for item list column.  

Foreign Keys

Name Foreign Table Primary Key
FK_WFDetailConfigBusinessRules_WFDetailConfigs WFDetailConfigBusinessRules PK_WFDetailConfigs
FK_WFDetailConfigs_PersonalData_WFDetailConfigs WFDetailConfigs PK_WFDetailConfigs
FK_WFStepFormFieldDetails_WFDetailConfigs WFStepFormFieldDetails PK_WFDetailConfigs
FK_WFDetailConfigs_DicFieldDetailTypes WFDetailConfigs PK_DicFieldDetailTypes
FK_WFDetailConfigs_DicPersonalDataCleaningModes WFDetailConfigs PK_DicPersonalDataCleaningModes
FK_WFDetailConfigs_DicPersonalDataTypes WFDetailConfigs PK_DicPersonalDataTypes
FK_WFDetailConfigs_WFBusinessRuleDefinitions_DataSourceFilterBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_IsVisibleSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_JsOnValueChangeBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_EditModeSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions_IsRequiredSqlBRDID WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFBusinessRuleDefinitions WFDetailConfigs PK_WFBusinessRuleDefinitions
FK_WFDetailConfigs_WFConfigurations WFDetailConfigs PK_WFConfigurations
FK_WFDetailConfigs_WFDataConnections WFDetailConfigs PK_WFDataConnections
FK_WFDetailConfigs_WFDataSources WFDetailConfigs PK_WFDataSources
FK_WFDetailConfigs_WFDataSources_PersonalData WFDetailConfigs PK_WFDataSources
FK_WFDetailConfigs_WFDefinitions_PersonalData WFDetailConfigs PK_WFDefinitions
FK_WFDetailConfigs_WFFieldDetailDefinitions WFDetailConfigs PK_WFFieldDetailDefinitions
FK_WFDetailConfigs_WFPlugIns WFDetailConfigs PK_WFPlugIns

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDetailConfigs Yes Yes BTREE ASCENDING 70
UQ_WFDetailConfigs_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFDocTypes

Description:Contains definitions of document types.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DTYPE_ID int Yes       Identyfikator 
DTYPE_PARID int   Yes      
DTYPE_DEFID int   Yes     Relacja do tabeli WFDefinitions. Informuje jakie typu dokumentow sa zwiazane z dana klasa 
DTYPE_Name varchar(250)         Nazwa 
DTYPE_Acronym varchar(50)         Akronim typu dokumentu. np do Faktury bedzie to FA a do korekty FAK 
DTYPE_SignatureDefinition varchar(4000)   Yes      
DTYPE_Description varchar(MAX)   Yes     Opis 
DTYPE_IconURL varchar(255)   Yes      
DTYPE_ArchivePageURL varchar(255)   Yes      
DTYPE_AutoPrintLabel bit       ((0))  Automatyczne drukowanie etykiety przy rejestracji 
DTYPE_TSInsert datetime       (getdate())  Data wstawienia wiersza 
DTYPE_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
DTYPE_RowVersion timestamp     Yes   Wersja wiersza 
DTYPE_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
DTYPE_Config varchar(2000)   Yes      
DTYPE_Order int       ((0))  Kolejność w jakiej typy dokumentów mają być wyświetlane na liście wyboru 
DTYPE_Guid varchar(36)       (newid())   
DTYPE_DocumentationDescription varchar(MAX)   Yes      

Foreign Keys

Name Foreign Table Primary Key
FK_AttributeDocTypeAssocs_WFDocTypes AttributeDocTypeAssocs PK_WFDocTypes
FK_DocTypeAssocciation_WFDocTypes DocTypeAssocciations PK_WFDocTypes
FK_HotFolders_WFDocTypes HotFolders PK_WFDocTypes
FK_HotMailBoxs_WFDocTypes HotMailBoxs PK_WFDocTypes
FK_TilesConfigurations_WFDocTypes TilesConfigurations PK_WFDocTypes
FK_WFDocTypes_WFDocTypes WFDocTypes PK_WFDocTypes
FK_WFElements_WFDocTypes WFElements PK_WFDocTypes
FK_WFDocTypes_WFDefinitions WFDocTypes PK_WFDefinitions

Indexes

Name Unique Clustered Type Collation Fill Factor
IX_WFDocTypes_DEFID     BTREE ASCENDING 0
IX_WFDocTypes_Name     BTREE ASCENDING 70
PK_WFDocTypes Yes Yes BTREE ASCENDING 70
UQ_WFDocTypes_Guid Yes   BTREE ASCENDING 70

Table of Contents

Table: WFDocxGenerations

Description:Table contains temporary data used to generate .docx files.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DCX_ID int Yes        
DCX_Condition varchar(MAX)   Yes      
DCX_TSInsert datetime       (getdate())   
DCX_TSUpdate datetime       (getdate())   
DCX_RowVersion timestamp     Yes    

Foreign Keys

Name Foreign Table Primary Key

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFDocxGenerations Yes Yes BTREE ASCENDING 70

Table of Contents

Table: WFElementCheckouts

Description:Contains information about documents that are checked out and unavailable for edit. Also contains information about expired check outs caused by session termination.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
WFDC_ID int Yes        
WFDC_WFDID int          
WFDC_UserLogin varchar(100)          
WFDC_Host varchar(100)   Yes      
WFDC_CheckoutTime datetime       (getdate())   
WFDC_RowVersion timestamp     Yes    
WFDC_TSInsert datetime       (getdate())   
WFDC_TSUpdate datetime       (getdate())   
WFDC_UserName varchar(255)   Yes      
WFDC_PageStartUpCount int   Yes     Counter of startups of WFDynamic 

Foreign Keys

Name Foreign Table Primary Key
FK_WFElementCheckouts_WFElements WFElementCheckouts PK_WFData

Indexes

Name Unique Clustered Type Collation Fill Factor
PK_WFElementCheckouts Yes Yes BTREE ASCENDING 70
uq_WFElementCheckouts_WFDC_WFDID Yes   BTREE ASCENDING 70

Table of Contents

Table: WFElementDetails

Description:Contains all rows from items lists including data put by user(s) andinformation to which item list an element belongs.

Columns
Column Name Data Type Key? Nullable? Computed? Default Description
DET_ID int Yes        
DET_Name varchar(50)   Yes     Nazwa 
DET_Description varchar(500)   Yes      
DET_DTYPEID int   Yes     Identyfikator Typu Dokumentu 
DET_WFDID int   Yes     Identyfikator relacji do elementu 
DET_Att1 varchar(1000)   Yes      
DET_Att2 varchar(1000)   Yes      
DET_Att3 varchar(1000)   Yes      
DET_Att4 varchar(1000)   Yes      
DET_Att5 varchar(1000)   Yes      
DET_Att6 varchar(1000)   Yes      
DET_Att7 varchar(1000)   Yes      
DET_Att8 varchar(1000)   Yes      
DET_Att9 varchar(1000)   Yes      
DET_Att10 varchar(1000)   Yes      
DET_Value decimal(25,10)       ((0))   
DET_Value1 decimal(25,10)   Yes      
DET_Value2 decimal(25,10)   Yes      
DET_Percent decimal(25,10)   Yes      
DET_Version int   Yes     Wersja elementu 
DET_CreatedBy varchar(50)   Yes      
DET_UpdatedBy varchar(50)   Yes      
DET_TSInsert datetime       (getdate())  Data wstawienia wiersza 
DET_TSUpdate datetime       (getdate())  Data Aktualizacji wiersza 
DET_RowVersion timestamp     Yes   Wersja wiersza 
DET_IsDeleted bit       ((0))  Flaga czy wiersz jest skasowany 
DET_WriteHistory bit       ((1))   
DET_PLUID int   Yes      
DET_WFCONID int   Yes     Identyfikator atrybutu definiującego kontrolkę subelementów, do której należy subelement 
DET_Att11 varchar(1000)   Yes      
DET_Att12 varchar(1000)   Yes      
DET_Att13 varchar(1000)   Yes      
DET_Att14 varchar(1000)   Yes      
DET_Att15 varchar(1000)   Yes      
DET_Value3 decimal(21,6)   Yes      
DET_Value4 decimal(21,6)   Yes      
DET_Value5 decimal(21,6)   Yes      
DET_Value6 decimal(21,6)   Yes      
DET_Value7 decimal(21,6)   Yes      
DET_Value8 decimal(21,6)   Yes      
DET_Value9 decimal(21,6)   Yes      
DET_Value10 decimal(21,6)   Yes      
DET_LongText1 text   Yes      
DET_LongText2 text   Yes      
DET_LongText3 text   Yes      
DET_LongText4 text   Yes      
DET_LongText5 text   Yes      
DET_Att16 nvarchar(1000)   Yes      
DET_Att17 nvarchar(1000)   Yes      
DET_Att18 nvarchar(1000)   Yes