表名：ZL_Process












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否 主键
2PNamevarchar2000   否 步骤名称
3PDepcitvarchar50000   是 步骤描述
4PRolevarchar600   否 角色id
5PCodeint40   否 流程步骤序列号
6PPassNamevarchar2000   否 通过审核名称
7PPassCodeint40   否 进行号
8PNoPassNamevarchar2000   否 未通过审核名称
9PNoPassCodeint40   否 未通过审核码
10PFlowIdint40   否 流程号
11NeedCodeint40   否 步骤号

简要说明：

在线线程表

GO
CREATE TABLE [dbo].[ZL_Process](
[ID] [int] IDENTITY(1,1) NOT NULL,
[PName] [varchar](200) NOT NULL,
[PDepcit] [varchar](5000) NULL,
[PRole] [varchar](60) NOT NULL,
[PCode] [int] NOT NULL,
[PPassName] [varchar](200) NOT NULL,
[PPassCode] [int] NOT NULL,
[PNoPassName] [varchar](200) NOT NULL,
[PNoPassCode] [int] NOT NULL,
[PFlowId] [int] NOT NULL,
[NeedCode] [int] NOT NULL
CONSTRAINT [PK_ZM_Process] PRIMARY KEY CLUSTERED
([ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'id'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'步骤描述' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PDepcit'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色id' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PRole'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程步骤序列号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通过审核名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PPassName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'未通过审核名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PNoPassName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'未通过审核码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PNoPassCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Process', @level2type=N'COLUMN', @level2name=N'PFlowId'
GO
SET IDENTITY_INSERT [ZL_Process] ON
INSERT [ZL_Process] ([ID],[PName],[PRole],[PCode],[PPassName],[PPassCode],[PNoPassName],[PNoPassCode],[PFlowId],[NeedCode]) VALUES ( 1,N'初审',N'1,2,3,4,5,6,7,8,9,',1,N'初审',11,N'初审拒绝',-2,1,0)
INSERT [ZL_Process] ([ID],[PName],[PRole],[PCode],[PPassName],[PPassCode],[PNoPassName],[PNoPassCode],[PFlowId],[NeedCode]) VALUES ( 2,N'二审',N'1,2,',2,N'二审',12,N'二审拒绝',-2,1,11)
INSERT [ZL_Process] ([ID],[PName],[PRole],[PCode],[PPassName],[PPassCode],[PNoPassName],[PNoPassCode],[PFlowId],[NeedCode]) VALUES ( 3,N'终审',N'1,2,',3,N'已审核',99,N'不通过',-2,1,12)
SET IDENTITY_INSERT [ZL_Process] OFF

--注意：将清空全表数据

detele from ZL_Process

--注意：将删除整个表

drop table ZL_Process

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Process