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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE [dbo].[a_cn] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zhmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kjkm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_cn_dzd] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[zh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[rq] [datetime] NULL ,
	[sr] [money] NULL ,
	[zc] [money] NULL ,
	[ye] [money] NULL ,
	[zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfzh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfhm] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[drsj] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_cn_dzd_dygx] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[mc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bth] [int] NULL ,
	[tzz] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[rq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfzh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfhm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[skrzh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[skrhm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fkrzh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fkrhm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sztl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[dfzhtl] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_cn_mxz] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[y] [int] NULL ,
	[r] [int] NULL ,
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[jsfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jsh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jf] [money] NULL ,
	[df] [money] NULL ,
	[zt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_cn_ye] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[ye] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_copy] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[jfje] [money] NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[dfje] [money] NULL ,
	[jfwb] [decimal](18, 6) NULL ,
	[dfwb] [decimal](18, 6) NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fjzs] [int] NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_czrz] (
	[dlsj] [datetime] NULL ,
	[lksj] [datetime] NULL ,
	[dlr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cwsj] [datetime] NULL ,
	[czmk] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_dzd_pzmb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ywlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jdfh] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjkmdydfzh] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[fpl] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[yhckkm] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_dzd_ywlx] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[ywlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gjz] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[jdfh] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[lb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yz] [money] NULL ,
	[yjsyqjs] [int] NULL ,
	[yjgzzl] [money] NULL ,
	[yjcz] [money] NULL ,
	[yzjl] [money] NULL ,
	[ljzj] [money] NULL ,
	[ljjzzb] [money] NULL ,
	[xh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jjyt] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cfdd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sccj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[scrq] [datetime] NULL ,
	[bz] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[rzrq] [datetime] NULL ,
	[zjfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[syqk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sybm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zjfykm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kssyrq] [datetime] NULL ,
	[rzsytzj] [money] NULL ,
	[zjff] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gzljldw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tybj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tysj] [datetime] NULL ,
	[tyfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ytzjqjs] [int] NULL ,
	[jzzbkm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzpz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[byzd_hb] [money] NULL ,
	[byzd_wb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jldw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl] [int] NULL ,
	[km_gdzc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[km_ljzj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[km_jzzb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_bdfs] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bdlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bdfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_fssb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl] [decimal](18, 6) NULL ,
	[je] [money] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_gzl] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gzljldw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[gzl] [decimal](18, 6) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_km] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[nf] [int] NULL ,
	[gdzc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ljzj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzzb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_lb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_gdzc_mxz] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yz_jf] [money] NULL ,
	[yz_df] [money] NULL ,
	[yz_ye] [money] NULL ,
	[zj_jf] [money] NULL ,
	[zj_df] [money] NULL ,
	[zj_ye] [money] NULL ,
	[jzzb_jf] [money] NULL ,
	[jzzb_df] [money] NULL ,
	[jzzb_ye] [money] NULL ,
	[zcsj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zjbj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl_jf] [decimal](18, 6) NULL ,
	[sl_df] [decimal](18, 6) NULL ,
	[sjlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_jsfs] (
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[jsfs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_jz] (
	[kjqj] [datetime] NOT NULL ,
	[bj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzsj] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_jzrq] (
	[kjnd] [int] NOT NULL ,
	[jzrq] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_kjkm] (
	[kjkm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pym] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmxz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[slhs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[nf] [int] NOT NULL ,
	[zkjkm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[zpym] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[mjkm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[wb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yefx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sldw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[wbzl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_kjkm_all] (
	[kjzd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kjkm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pym] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmxz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mjkm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yefx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_kmxz] (
	[kmxz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_mb] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[jfje] [money] NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[dfje] [money] NULL ,
	[jfwb] [decimal](18, 6) NULL ,
	[dfwb] [decimal](18, 6) NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fjzs] [int] NULL ,
	[mbmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kjj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_mxz] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[jfje] [money] NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[dfje] [money] NULL ,
	[byzd_wb] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[byzd_hb] [money] NULL ,
	[jfwb] [decimal](18, 6) NULL ,
	[dfwb] [decimal](18, 6) NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_mxz_pz] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[zpr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[shr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fjzs] [int] NULL ,
	[lrsj] [datetime] NULL ,
	[xgsj] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_pzlx] (
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzlx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[nf] [int] NOT NULL ,
	[syqk] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ys] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_user] (
	[yhm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_user_qx] (
	[yhm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qxdm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_user_qxlb] (
	[dm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qxmc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qxxz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_wb] (
	[wb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[hl] [decimal](18, 6) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_xm] (
	[xm] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[xmbm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[nf] [int] NOT NULL ,
	[lb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_ye] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[jfje] [money] NULL ,
	[dfje] [money] NULL ,
	[ye] [money] NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[jcsl] [decimal](18, 6) NULL ,
	[jdfh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[byzd1_hb] [money] NULL ,
	[byzd2_hb] [money] NULL ,
	[byzd1_wb] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfwb] [decimal](18, 6) NULL ,
	[dfwb] [decimal](18, 6) NULL ,
	[jcwb] [decimal](18, 6) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_ye_xm] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[xmbm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[jfje] [money] NULL ,
	[dfje] [money] NULL ,
	[ye] [money] NULL ,
	[jdfh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[jcsl] [decimal](18, 6) NULL ,
	[lb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_zdzz] (
	[xz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sxh] [int] NULL ,
	[zy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ykm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[mdkm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dygx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzxscb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[srkm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] IDENTITY (1, 1) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_zdzz_hb] (
	[bh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mb] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[xz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_ztcs] (
	[ztmc] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bmgz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[qysj] [datetime] NULL ,
	[slxsw] [int] NULL ,
	[djxsw] [int] NULL ,
	[zdjz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzhyxxg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[csdyj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dymb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dyyl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_sl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_wb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_dj] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[mxzzbxsye] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bgx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zy_yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[swdjh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[khyhjzh] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[dh] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[kjzd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zxsjfs] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzxscb_kcsp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzxscb_zyywcb] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzxscb_zyywsr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzxscb_gs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[tcbf] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbmbd] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbmbd_sx] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmbmbd_sx_ws] [int] NULL ,
	[qhsrf] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmgz_bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmgz_xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmgz_dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmgz_yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmgz_xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzzddp] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzmrrq] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[dzdpdywlxlmgjz] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[zyjs] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[zyjs_fw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[zyjs_dyl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_zy] (
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pym] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sc_a_mxz] (
	[kmbm] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[zy] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfsl] [decimal](18, 6) NULL ,
	[jfje] [money] NULL ,
	[dfsl] [decimal](18, 6) NULL ,
	[dfje] [money] NULL ,
	[jfwb] [decimal](18, 6) NULL ,
	[dfwb] [decimal](18, 6) NULL ,
	[bm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xm] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[yg] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xjl] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[xgsj] [datetime] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[sc_a_mxz_pz] (
	[sj] [datetime] NULL ,
	[pzz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[zpr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[shr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jzr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[fjzs] [int] NULL ,
	[lrsj] [datetime] NULL ,
	[xgsj] [datetime] NULL ,
	[czy] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[a_cn] ADD 
	CONSTRAINT [PK_a_cn] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_cn_dzd] ADD 
	CONSTRAINT [PK_a_cn_dzd] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_cn_dzd_dygx] ADD 
	CONSTRAINT [PK_a_cn_dzd_dygx] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_cn_mxz] ADD 
	CONSTRAINT [PK_a_cn_mxz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_cn_ye] ADD 
	CONSTRAINT [PK_a_cn_ye] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_copy] ADD 
	CONSTRAINT [PK_a_copy] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_czrz] ADD 
	CONSTRAINT [PK_a_czrz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_dzd_pzmb] ADD 
	CONSTRAINT [PK_a_dzd_pzmb] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_dzd_ywlx] ADD 
	CONSTRAINT [PK_a_dzd_ywlx] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc] ADD 
	CONSTRAINT [PK_a_gdzc] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_bdfs] ADD 
	CONSTRAINT [PK_a_gdzc_bdfs] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_fssb] ADD 
	CONSTRAINT [PK_a_gdzc_fssb] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_gzl] ADD 
	CONSTRAINT [PK_a_gdzc_gzl] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_km] ADD 
	CONSTRAINT [PK_a_gdzc_km] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_lb] ADD 
	CONSTRAINT [PK_a_gdzc_lb] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_gdzc_mxz] ADD 
	CONSTRAINT [PK_a_gdzc_mxz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_jsfs] ADD 
	CONSTRAINT [PK_a_jsfs] PRIMARY KEY  CLUSTERED 
	(
		[bm]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_jz] ADD 
	CONSTRAINT [PK_a_jz] PRIMARY KEY  CLUSTERED 
	(
		[kjqj]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_jzrq] ADD 
	CONSTRAINT [PK_a_jzrq] PRIMARY KEY  CLUSTERED 
	(
		[kjnd]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_kjkm] ADD 
	CONSTRAINT [PK_a_kjkm] PRIMARY KEY  CLUSTERED 
	(
		[kmbm],
		[nf]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_kjkm_all] ADD 
	CONSTRAINT [PK_a_kjkm_all] PRIMARY KEY  CLUSTERED 
	(
		[kjzd],
		[kmbm]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_kmxz] ADD 
	CONSTRAINT [PK_a_kmxz] PRIMARY KEY  CLUSTERED 
	(
		[kmxz]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_mb] ADD 
	CONSTRAINT [PK_a_mb] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_mxz] ADD 
	CONSTRAINT [PK_a_mxz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_mxz_pz] ADD 
	CONSTRAINT [PK_a_mxz_pz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_pzlx] ADD 
	CONSTRAINT [PK_a_pzlx] PRIMARY KEY  CLUSTERED 
	(
		[pzlx],
		[nf]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_user] ADD 
	CONSTRAINT [PK_a_user] PRIMARY KEY  CLUSTERED 
	(
		[yhm]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_user_qx] ADD 
	CONSTRAINT [PK_a_user_qx] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_user_qxlb] ADD 
	CONSTRAINT [PK_a_user_qxlb] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_wb] ADD 
	CONSTRAINT [PK_a_wb] PRIMARY KEY  CLUSTERED 
	(
		[wb]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_xm] ADD 
	CONSTRAINT [PK_a_xm] PRIMARY KEY  CLUSTERED 
	(
		[xmbm],
		[nf],
		[lb]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_ye] ADD 
	CONSTRAINT [PK_a_ye] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_ye_xm] ADD 
	CONSTRAINT [PK_a_ye_xm] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_zdzz] ADD 
	CONSTRAINT [PK_a_zdzz] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_zdzz_hb] ADD 
	CONSTRAINT [PK_a_zdzz_hb] PRIMARY KEY  CLUSTERED 
	(
		[bh]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_ztcs] ADD 
	CONSTRAINT [PK_a_ztcs] PRIMARY KEY  CLUSTERED 
	(
		[ztmc]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[a_zy] ADD 
	CONSTRAINT [PK_a_zy] PRIMARY KEY  CLUSTERED 
	(
		[zy]
	)  ON [PRIMARY] 
GO

