序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | ProID | int | 4 | 0 | 是 | 签章的流程 | ||||
3 | Step | int | 4 | 0 | 是 | 签名步骤 | ||||
4 | SignID | int | 4 | 0 | 是 | 签名ID | ||||
5 | SignName | nvarchar | 200 | 0 | 是 | 同样存SignName,UserName和VPath,方便后期验证 | ||||
6 | VPath | nvarchar | 300 | 0 | 是 | 虚拟路径 | ||||
7 | UserID | int | 4 | 0 | 是 | 用户ID | ||||
8 | CDate | datetime | 8 | 3 | 是 | 创建时间 | ||||
9 | AppID | int | 4 | 0 | 是 | 公文ID | ||||
10 | CUName | nvarchar | 100 | 0 | 是 | 创建用户用户名 |
签章日志表
GO
CREATE TABLE [dbo].[ZL_OA_DocSigned](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ProID] [int] NULL,
[Step] [int] NULL,
[SignID] [int] NULL,
[SignName] [nvarchar](200) NULL,
[VPath] [nvarchar](300) NULL,
[UserID] [int] NULL,
[CDate] [datetime] NULL,
[AppID] [int] NULL,
[CUName] [nvarchar](100) NULL,
CONSTRAINT [PK_ZL_OA_DocSigned] PRIMARY KEY CLUSTERED
([ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
detele from ZL_OA_DocSigned
drop table ZL_OA_DocSigned
TRUNCATE table ZL_OA_DocSigned