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_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] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[bj] [char] (1) 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_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] (
	[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 ,
	[id] [int] IDENTITY (1, 1) NOT 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] [char] (10) 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] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[a_yhmx] (
	[kmbm] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[sj] [smalldatetime] NULL ,
	[pzz] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzh] [int] NULL ,
	[jsh] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jsfs] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[jfje] [money] NULL ,
	[dfje] [money] NULL ,
	[jsrq] [smalldatetime] NULL ,
	[dzbj] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dzsj] [smalldatetime] NULL ,
	[pzid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[id] [int] NOT 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] (50) 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] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[pzmrrq] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[bbh] [char] (10) 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 
	 PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

