CREATE TABLE [dbo].[ls_fdxxb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
        [yxms] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[jlrq] [datetime] NULL ,
	[gxrq] [datetime] NULL ,
	[fddz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fddh] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
        [fdbxsc] [bit] NULL ,
        [fdyxxzhp] [bit] NULL ,
        [fdyxxzhplb] [bit] NULL ,
        [fdyxxzscpl] [bit] NULL ,
        [fdyxxzzkfa] [bit] NULL ,
        [fdyxxzfar] [bit] NULL ,
        [qbxz] [bit] NULL ,
        [xzxz] [bit] NULL ,
        [xzxzbgx] [bit] NULL ,
        [jgx] [bit] NULL ,
        [qxksz] [bit] NULL ,
        [sslb] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[wym] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdqx] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdqx_lbqx] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdqx_cxxx] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [fdqx_zkxx] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [fdqx_scpl] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
        [sf1] [bit] NULL ,
        [sf2] [bit] NULL ,
        [sf3] [bit] NULL ,
        [sf4] [bit] NULL ,
        [sf5] [bit] NULL ,
        [sf6] [bit] NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [money] NULL 
) ON [PRIMARY]

CREATE TABLE [dbo].[ls_hpcrkhzb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
        [idh] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywrq1] [datetime] NULL ,
	[ywrq2] [datetime] NULL ,
        [rdrq] [datetime] NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdczy] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bm] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bm1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[jm] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[qm] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xh] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[gg] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl] [float] NULL ,
	[dj] [money] NULL ,
	[zhdj] [money] NULL ,
	[cbje] [money] NULL ,
        [zhje] [money] NULL ,
        [je] [money] NULL ,
	[yhje] [money] NULL ,
	[qtje] [money] NULL ,
	[hplx] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
        [zt] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ysc] [bit] NULL ,
	[sf1] [bit] NULL ,
	[sf2] [bit] NULL ,
        [bjjqh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[ls_hpcrklbhzb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
        [idh] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywrq1] [datetime] NULL ,
	[ywrq2] [datetime] NULL ,
        [rdrq] [datetime] NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdczy] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[hplb] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl] [float] NULL ,
	[dj] [money] NULL ,
	[zhdj] [money] NULL ,
	[cbje] [money] NULL ,
        [zhje] [money] NULL ,
        [je] [money] NULL ,
	[yhje] [money] NULL ,
	[qtje] [money] NULL ,
	[hplx] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ysc] [bit] NULL ,
	[sf1] [bit] NULL ,
	[sf2] [bit] NULL ,
        [bjjqh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[ls_qtsrfyskxxb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
        [idh] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywrq1] [datetime] NULL ,
	[ywrq2] [datetime] NULL ,
        [rdrq] [datetime] NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdczy] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[srzclx] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[srzcje] [money] NULL ,
	[lx] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ysc] [bit] NULL ,
	[sf1] [bit] NULL ,
	[sf2] [bit] NULL ,
        [bjjqh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[ls_xtxxb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
        [fddz] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[fddh] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[yxms] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[zdsjpath] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
        [1] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
        [2] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
        [zjmc] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
        [path_sa] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
        [ztmc] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
        [url] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
        [fdbxsc] [bit] NULL ,
        [ftpip] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [ftpuser] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [ftppwd] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sfzdftp] [bit] NULL ,
        [mail] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [mailuser] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [mailpwd] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sfzdmail] [bit] NULL ,
	[sf1] [bit] NULL ,
	[sf2] [bit] NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[ls_yyxxb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
        [idh] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywrq1] [datetime] NULL ,
	[ywrq2] [datetime] NULL ,
        [rdrq] [datetime] NULL ,
	[fdbh] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdmc] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[fdczy] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[krrs] [int] NULL ,
        [zdrs] [int] NULL ,
	[hyzs] [int] NULL ,
        [xzhys] [int] NULL ,
        [hyyxfje] [money] NULL ,
        [hysyje] [money] NULL ,
        [hysycs] [int] NULL ,
        [hyyxfcs] [int] NULL ,
        [hyxfcs] [int] NULL ,
        [hyzjf] [float] NULL ,
        [zds] [int] NULL ,
        [yyze] [money] NULL ,
	[zkze] [money] NULL ,
	[ysje] [money] NULL ,
	[mlyh] [money] NULL ,
	[ssje] [money] NULL ,
	[xj] [money] NULL ,
	[xyk] [money] NULL ,
	[djq] [money] NULL ,
	[qt] [money] NULL ,
        [hyhk] [money] NULL ,
        [qd] [money] NULL ,
        [gz] [money] NULL ,
        [yyxj] [money] NULL ,
        [skxj] [money] NULL ,
        [hycx] [money] NULL ,
        [yjje] [money] NULL ,
        [qtsrsk_xj] [money] NULL ,
        [qtsrsk_xyk] [money] NULL ,
        [qtsrsk_qt] [money] NULL ,
        [qtsrsk_hyhk] [money] NULL ,
        [zdjj] [money] NULL ,
        [pxze] [money] NULL ,
        [kjj] [money] NULL ,
        [pxjj] [money] NULL ,
        [rksl] [float] NULL ,
        [rkje] [money] NULL ,
        [cksl] [float] NULL ,
        [ckje] [money] NULL ,
        [kcsl] [float] NULL ,
        [kcje] [money] NULL ,
        [kcjj] [money] NULL ,
        [xssr] [money] NULL ,
        [qtsr] [money] NULL ,
        [rkzc] [money] NULL ,
        [xscb] [money] NULL ,
        [fykz] [money] NULL ,
        [ll_rkzc] [money] NULL ,
        [ll_xscb] [money] NULL ,
        [lll_rkzc] [float] NULL ,
        [lll_xscb] [float] NULL ,
        [ysc] [bit] NULL ,
	[sf1] [bit] NULL ,
        [sf2] [bit] NULL ,
        [bjjqh] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz1] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
        [pz2] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[pz3] [money] NULL 
) ON [PRIMARY]

ALTER TABLE [dbo].[ls_fdxxb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_fdxxb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[ls_hpcrkhzb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_hpcrkhzb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[ls_hpcrklbhzb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_hpcrklbhzb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[ls_qtsrfyskxxb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_qtsrfyskxxb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[ls_xtxxb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_xtxxb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 

ALTER TABLE [dbo].[ls_yyxxb] WITH NOCHECK ADD 
	CONSTRAINT [PK_ls_yyxxb] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY]
