创建存储流程引擎模板数据表

定义数据结构,用于存储流程模板信息.分四张表(流程模板基本信息表workflowmodel,流程步骤表workflowstepModel,流程责任人表workflowbrandModel,流程分支表workflowRealtionModel).

一.流程模板基本信息表workflowmodel

CREATE TABLE [dbo].[WorkflowProcessModule](
 [ProcessGUID] [uniqueidentifier] NOT NULL,
 [ProcessKindGUID] [uniqueidentifier] NULL,
 [ProcessKindName] [nvarchar](50) NULL,
 [ProcessName] [nvarchar](50) NULL,
 [IsActive] [int] NULL,
 [WatchMemberGUID] [uniqueidentifier] NULL,
 [WatchMembersName] [nvarchar](50) NULL,
 [BusinessType] [nvarchar](20) NULL,
 [Description] [nvarchar](200) NULL,
 [BusinessURL] [nvarchar](300) NULL,
 [ProcessQueryDomain] [nvarchar](500) NULL,
 [ProcessGrap] [ntext] NULL,
 [StationGUID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_WorkflowProcessModule] PRIMARY KEY CLUSTERED
(
 [ProcessGUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
二.流程步骤表workflowstepModel

CREATE TABLE [dbo].[WorkflowStepModule](
 [StepGUID] [uniqueidentifier] NOT NULL,
 [NextStepGUID] [uniqueidentifier] NULL,
 [StepName] [nvarchar](50) NULL,
 [StepID] [int] NULL,
 [StepType] [int] NULL,
 [IsMulti] [int] NULL,
 [ProcessGUID] [uniqueidentifier] NULL,
 [IsCanRollBack] [int] NULL,
 [IsCanCancel] [int] NULL,
 [IsCanAssign] [int] NULL,
 [IsCanRevolution] [int] NULL,
 [IsCanClose] [int] NULL,
 [Description] [nvarchar](200) NULL,
 [DispBusinessDomain] [ntext] NULL,
 [EditBusinessDomain] [ntext] NULL,
 [AuditorNameCC] [varbinary](200) NULL,
 [AuditorNameCCGUID] [ntext] NULL,
 [AuditorType] [nvarchar](50) NULL,
 [AuditorGUID] [varchar](300) NULL,
 [AuditorName] [nvarchar](200) NOT NULL,
 CONSTRAINT [PK_WorkflowStepModule] PRIMARY KEY CLUSTERED
(
 [StepGUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

三.流程责任人表workflowbrandModel

CREATE TABLE [dbo].[WorkflowBandModule](
 [BandGUID] [uniqueidentifier] NOT NULL,
 [StepGUID] [uniqueidentifier] NULL,
 [AuditorGUID] [uniqueidentifier] NULL,
 [AuditorName] [nvarchar](50) NULL,
 [AuditorType] [int] NULL,
 [ProcessGUID] [uniqueidentifier] NULL,
 CONSTRAINT [PK_WORKFLOWBANDMODULE] PRIMARY KEY CLUSTERED
(
 [BandGUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
四.流程分支表workflowRealtionModel

CREATE TABLE [dbo].[WorkflowRelationModule](
 [RelationGUID] [uniqueidentifier] NOT NULL,
 [StartStepGUID] [uniqueidentifier] NULL,
 [EndStepGUID] [uniqueidentifier] NULL,
 [Expression] [nvarchar](100) NULL,
 [ExpressionStru] [ntext] NULL,
 [ProcessGUID] [uniqueidentifier] NULL,
 [Source] [int] NULL,
 [Target] [int] NULL,
 CONSTRAINT [PK_WorkflowRelationModule] PRIMARY KEY CLUSTERED
(
 [RelationGUID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]