if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cw_shenpi]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cw_shenpi]
GO

CREATE TABLE [dbo].[cw_shenpi] (
		[id] [int] IDENTITY (1, 1) NOT NULL ,
		[shenqingren] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
		[dept] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[shenqingriqi] [datetime] NOT NULL ,
		[caozuoren] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[shenqingjiner] [money] NOT NULL ,
֧ʽ	[payway] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
տλ	[shoukuandanwei] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
˻		[zhanghao] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
		[kaihuhang] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
		[shenpiRen] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
	[shenpiJiner] [money] NOT NULL ,
״̬	[shenpiState] [int] NOT NULL ,
	[shenpiRiqi] [datetime] NULL ,
		[shenheren] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
˽	[shenhejiner] [money] NULL ,
	[shenheRiqi] [datetime] NULL ,
״̬	[shenhestate] [int] NOT NULL ,
֧	[paydate] [datetime] NOT NULL ,
Ȩ		[shouQuanShenPiRen] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
Ȩ־	[isauth] [int] NULL ,
;	[dowhat] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NOT NULL ,
״̬,0δ1ɣ2ʧ	[isOk] [int] NOT NULL 


) ON [PRIMARY]
GO

