表名：ZL_DocModel












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2DocNamenvarchar2550   是 项目名称
3AddUsernvarchar500   是 创建者
4AddTimedatetime83   是 创建时间
5AllowGroupnvarchar100   是 会员组权限
6Statusint40   是 状态1为模板组,2为模板组下模组
7Formnvarchar40000   是 表单格式
8TemUrlnvarchar2550   是 模版地址
9Priorityvarchar200   是 优先级
10ParentIDvarchar500   是 所属模板组

简要说明：

项目模型表

GO
CREATE TABLE [dbo].[ZL_DocModel] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[DocName] [nvarchar]  (255) NULL,
[AddUser] [nvarchar]  (50) NULL,
[AddTime] [datetime]  NULL,
[AllowGroup] [nvarchar]  (10) NULL,
[Status] [int]  NULL,
[Form] [nvarchar]  (4000) NULL,
[TemUrl] [nvarchar]  (255) NULL,
[Priority] [varchar]  (20) NULL,
[ParentID] [varchar]  (50) NULL)
ALTER TABLE [ZL_DocModel] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_DocModel] PRIMARY KEY  NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [ZL_DocModel] ON
INSERT [ZL_DocModel] ([ID],[DocName],[AddUser],[AddTime],[AllowGroup],[Status]) VALUES ( 1,N'公司合同',N'admin',N'2013/8/2 11:08:44',N'1',1)
INSERT [ZL_DocModel] ([ID],[DocName],[AddUser],[AddTime],[AllowGroup],[Status]) VALUES ( 2,N'法律文函',N'admin',N'2013/8/2 11:09:16',N'1',1)
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 3,N'购销合同.doc',N'2013/8/14 14:34:19',N'1',2,N'~/UploadFiles/DocTemp/First购销合同.doc',N'1')
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 4,N'劳动合同书.doc',N'2013/8/14 14:34:19',N'1',2,N'~/UploadFiles/DocTemp/First劳动合同书.doc',N'1')
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 5,N'试用员工考核表.doc',N'2013/8/14 14:34:19',N'1',2,N'~/UploadFiles/DocTemp/First试用员工考核表.doc',N'1')
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 6,N'团体培训申请表.doc',N'2013/8/14 14:34:19',N'1',2,N'~/UploadFiles/DocTemp/First团体培训申请表.doc',N'1')
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 7,N'继承权证明书.doc',N'2013/8/14 14:34:33',N'1',2,N'~/UploadFiles/DocTemp/第二个测试继承权证明书.doc',N'2')
INSERT [ZL_DocModel] ([ID],[DocName],[AddTime],[AllowGroup],[Status],[TemUrl],[ParentID]) VALUES ( 8,N'诉讼财产保全申请.doc',N'2013/8/14 14:34:33',N'1',2,N'~/UploadFiles/DocTemp/第二个测试诉讼财产保全申请.doc',N'2')
SET IDENTITY_INSERT [ZL_DocModel] OFF

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

detele from ZL_DocModel

--注意：将删除整个表

drop table ZL_DocModel

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

TRUNCATE table ZL_DocModel