【文章內(nèi)容簡介】 L , [dm] [varchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL , [fzr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [whr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[clerk] ( [no] [int] NOT NULL , [name] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [gh] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[czy1] ( [name] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [gh] [varchar] (5) COLLATE Chinese_PRC_CI_AS NULL , 26 [sex] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [birth] [smalldatetime] NULL , [xl] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL , [bm] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [cjgz] [smalldatetime] NULL , [zw] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [dh] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [mm] [varchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[fact] ( [no] [int] NOT NULL , [mc] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [dm] [int] NULL , [dz] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL , [lxr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [dh1] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL , [sj1] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL , [dh2] [varchar] (14) COLLATE Chinese_PRC_CI_AS NULL , [sj2] [varchar] (13) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[fdj] ( [xh] [int] NOT NULL , [tybh] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [rq1] [smalldatetime] NULL , [sc] [decimal](18, 0) NULL , [addre] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [oil] [int] NULL , [moil] [int] NULL , [pxr] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[gd] ( 27 [lb] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [start] [smalldatetime] NULL , [slr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [pxr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [device1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [status1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [tybh1] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [yt] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [shqk] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [device2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [tybh2] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL , [status2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [pcf] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL , [ch] [varchar] (9) COLLATE Chinese_PRC_CI_AS NULL , [driver] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [address] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [appe] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [report] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [jssj] [smalldatetime] NULL , [gdno] [int] NOT NULL , [xq] [image] NULL , [bf] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL , [rq] [smalldatetime] NULL , [djf] [int] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[gdlb] ( [no] [int] NOT NULL , [mc] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [gdlb] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[haocai] ( [no] [int] NOT NULL , [bh] [int] NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , 28 [sl] [int] NULL , [dj] [decimal](18, 0) NULL , [lqr] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [rq] [smalldatetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[hc] ( [mc] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [bh] [int] NOT NULL , [dj] [decimal](18, 0) NULL , [fact] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [addre] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [tel] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[jglb] ( [no] [int] NOT NULL , [jg] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [dm] [int] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[mrgz] ( [no] [int] NOT NULL , [rq] [smalldatetime] NULL , [job] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [addre] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [device] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [pxr] [varchar] (8) COLLATE Chinese_PRC_CI_AS NULL , [relay] [varchar] (2) COLLATE Chinese_PRC_CI_AS NULL , [bz] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatcol] ( [pbc_tnam] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , 29 [pbc_tid] [int] NULL , [pbc_ownr] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [pbc_am] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [pbc_cid] [smallint] NULL , [pbc_labl] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_lpos] [smallint] NULL , [pbc_hdr] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_hpos] [smallint] NULL , [pbc_jtfy] [smallint] NULL , [pbc_mask] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_case] [smallint] NULL , [pbc_hght] [smallint] NULL , [pbc_wdth] [smallint] NULL , [pbc_ptrn] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_bmap] [char] (1) COLLATE Chinese_PRC_CI_AS NULL , [pbc_init] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_cmnt] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbc_edit] [varchar] (31) COLLATE Chinese_PRC_CI_AS NULL , [pbc_tag] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[pbcatedt] ( [pbe_name] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [pbe_edit] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL , [pbe_type] [smallint] NOT NULL , [pbe_tr] [int] NULL , [pbe_seqn] [smallint] NOT NULL , [pbe_