📄 mssql70_sunmis30.sql
字号:
CREATE TABLE [dbo].[rkmx] (
[ckdm] [char] (2) NOT NULL ,
[rkdh] [char] (12) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NULL,
[sssl1] [decimal] (14,3) NOT NULL DEFAULT (0.00),
[sssl2] [decimal] (14,3) NOT NULL DEFAULT (0.00),
[cgdj] [decimal] (12,3) NOT NULL DEFAULT (0.00),
[cgje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[zzsl] [decimal] (4,3) NOT NULL DEFAULT (0.17),
[zzsje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[yzf] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[rkdj] [decimal] (16,7) NOT NULL DEFAULT (0.00),
[rkje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[scrq] [datetime] NULL ,
[sxrq] [datetime] NULL ,
[yf] [char] (6) NULL,
CONSTRAINT [pk_rkmx] PRIMARY KEY NONCLUSTERED ([ckdm], [rkdh], [wldm]) )
GO
CREATE TABLE [dbo].[rkmx_ld] (
[ckdm] [char] (2) NOT NULL ,
[rkdh] [char] (12) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NULL,
[sssl1] [decimal] (14,3) NOT NULL DEFAULT (0.00),
[sssl2] [decimal] (14,3) NOT NULL DEFAULT (0.00),
[cgdj] [decimal] (12,3) NOT NULL DEFAULT (0.00),
[cgje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[zzsl] [decimal] (4,3) NOT NULL DEFAULT (0.17),
[zzsje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[yzf] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[rkdj] [decimal] (16,7) NOT NULL DEFAULT (0.00),
[rkje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[scrq] [datetime] NULL ,
[sxrq] [datetime] NULL ,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_rkmx_ld] PRIMARY KEY NONCLUSTERED ([ckdm], [rkdh], [wldm], [yf]) )
GO
CREATE TABLE [dbo].[fld] (
[ckdm] [char] (2) NOT NULL ,
[fldh] [char] (12) NOT NULL ,
[flrq] [datetime] NOT NULL ,
[lb] [char] (2) NOT NULL,
[zcck] [char] (2) NULL,
[gcbh] [char] (20) NOT NULL,
[wlhzbh] [char] (4) NULL,
[lybm] [char] (10) NULL,
[zdr] [char] (10) NOT NULL,
[lyr] [char] (10) NULL,
[flr] [char] (10) NULL,
[jzr] [char] (10) NULL,
[shr] [char] (10) NULL,
[bz] [char] (30) NULL,
[yf] [char] (6) NULL,
[jjbz] [char] (2) NOT NULL,
CONSTRAINT [pk_fld] PRIMARY KEY NONCLUSTERED ([ckdm], [fldh]) )
GO
CREATE TABLE [dbo].[fld_ld] (
[ckdm] [char] (2) NOT NULL ,
[fldh] [char] (12) NOT NULL ,
[flrq] [datetime] NOT NULL ,
[lb] [char] (2) NOT NULL,
[zcck] [char] (2) NULL,
[gcbh] [char] (20) NOT NULL,
[wlhzbh] [char] (4) NULL,
[lybm] [char] (10) NULL,
[zdr] [char] (10) NOT NULL,
[lyr] [char] (10) NULL,
[flr] [char] (10) NULL,
[jzr] [char] (10) NULL,
[shr] [char] (10) NULL,
[bz] [char] (30) NULL,
[yf] [char] (6) NOT NULL,
[jjbz] [char] (2) NOT NULL,
CONSTRAINT [pk_fld_ld] PRIMARY KEY NONCLUSTERED ([ckdm], [fldh], [yf]) )
GO
CREATE TABLE [dbo].[flmx] (
[ckdm] [char] (2) NOT NULL ,
[fldh] [char] (12) NOT NULL ,
[xh] [decimal] (3,0) NOT NULL,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NULL,
[sfsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sfsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[dj] [decimal] (16,7) NOT NULL DEFAULT (0.00),
[je] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[dewldm] [char] (24) NULL,
[yf] [char] (6) NULL,
CONSTRAINT [pk_flmx] PRIMARY KEY NONCLUSTERED ([ckdm], [fldh], [wldm], [xh]) )
GO
CREATE TABLE [dbo].[flmx_ld] (
[ckdm] [char] (2) NOT NULL ,
[fldh] [char] (12) NOT NULL ,
[xh] [decimal] (3,0) NOT NULL,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NULL,
[sfsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sfsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[dj] [decimal] (16,7) NOT NULL DEFAULT (0.00),
[je] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[dewldm] [char] (24) NULL,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_flmx_ld] PRIMARY KEY NONCLUSTERED ([yf], [ckdm], [fldh], [wldm], [xh]) )
GO
CREATE TABLE [dbo].[bltz] (
[gcbh] [char] (20) NOT NULL ,
[wlhzbh] [char] (4) NOT NULL ,
[klbh] [char] (10) NOT NULL,
[wldm] [char] (24) NOT NULL ,
[kljs] [decimal] (6,0) NOT NULL DEFAULT (0.00),
[fcjs] [decimal] (6,0) NOT NULL DEFAULT (0.00),
[klcc] [char] (30) NULL,
[dtjs] [decimal] (6,0),
CONSTRAINT [pk_bltz] PRIMARY KEY NONCLUSTERED ([gcbh], [wlhzbh], [klbh]) )
GO
CREATE TABLE [dbo].[slxm] (
[pgdh] [char] (12) NOT NULL ,
[dybz] [char] (2) NULL ,
[klbh] [char] (10) NULL,
[ysljs] [decimal] (8,1) NOT NULL DEFAULT (0.00),
[ssljs] [decimal] (8,0) NOT NULL DEFAULT (0.00),
[wldm] [char] (24) NOT NULL,
[klcc] [char] (30) NULL,
[gcbh] [char] (20) NOT NULL,
[wlqdbh] [char] (4) NOT NULL,
CONSTRAINT [pk_slxm] PRIMARY KEY NONCLUSTERED ([pgdh]) )
GO
CREATE TABLE [dbo].[wlhzbmc] (
[gcbh] [char] (20) NOT NULL ,
[wlhzbh] [char] (4) NOT NULL ,
[wlhzjc] [char] (20) NOT NULL,
[wlhzmc] [char] (60) NOT NULL,
[scts] [decimal] (10,1) NOT NULL DEFAULT (0.00),
[jldw] [char] (4) NOT NULL DEFAULT '台',
[wlqdbh] [char] (4) NULL,
[jhts] [decimal] (10,1) NULL,
[xqrq] [datetime] NULL,
CONSTRAINT [pk_wlhzbmc] PRIMARY KEY NONCLUSTERED ([gcbh], [wlhzbh]) )
GO
CREATE TABLE [dbo].[wlhzwlmx] (
[gcbh] [char] (20) NOT NULL ,
[wlhzbh] [char] (4) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[dtwlsl] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[fcsl] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[gybz] [char] (60) NULL,
[clsm] [char] (60) NULL,
[dywldm] [char] (24) NULL,
[sel_yn] [char] (1) NULL,
CONSTRAINT [pk_wlhzwlmx] PRIMARY KEY NONCLUSTERED ([gcbh], [wlhzbh], [wldm]) )
GO
CREATE TABLE [dbo].[cgdmain] (
[cgdh] [char] (12) NOT NULL ,
[kdrq] [datetime] NOT NULL ,
[zdr] [char] (10) NOT NULL ,
[jhdhrq] [datetime] NOT NULL ,
[sjwcrq] [datetime] NULL,
[jhzzrq] [datetime] NULL,
[cgy] [char] (10) NOT NULL ,
[cgbm] [char] (10) NULL,
[spr] [char] (10) NULL,
[lb] [char] (1) NOT NULL,
[bz] [char] (60) NULL,
CONSTRAINT [pk_cgdmain] PRIMARY KEY NONCLUSTERED ([cgdh]) )
GO
CREATE TABLE [dbo].[cgdwlmx] (
[cgdh] [char] (12) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[cgsl1] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[cgsl2] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[scdj] [decimal] (13,3) NULL ,
[cgdj] [decimal] (13,3) NULL ,
[dhsl1] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[dhsl2] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[rksl1] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[rksl2] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[gybz] [char] (60) NULL ,
[sjdhrq] [datetime] NULL,
[sel_yn] [char] (1) NULL,
CONSTRAINT [pk_cgdwlmx] PRIMARY KEY NONCLUSTERED ([cgdh], [wldm]) )
GO
CREATE TABLE [dbo].[cgdwlpt] (
[cgdh] [char] (12) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[gcbh] [char] (20) NOT NULL ,
[wlhzbh] [char] (4) NOT NULL ,
[cgsl1] [decimal] (13,3) NOT NULL,
[cgsl2] [decimal] (13,3) NOT NULL,
CONSTRAINT [pk_cgdwlpt] PRIMARY KEY NONCLUSTERED ([cgdh], [wldm], [gcbh], [wlhzbh]) )
GO
CREATE TABLE [dbo].[cghtmain] (
[cghth] [char] (20) NOT NULL ,
[qyrq] [datetime] NOT NULL ,
[jbr] [char] (10) NOT NULL ,
[ghsbh] [char] (12) NOT NULL ,
[lxr] [char] (10) NULL ,
[lxdh] [char] (20) NULL ,
[jsrq] [datetime] NULL ,
[htwcrq] [datetime] NULL ,
[cgdh] [char] (12) NULL ,
[jhdz] [char] (40) NULL ,
[lry] [char] (10) NOT NULL ,
[yfkje] [decimal] (13,2) NULL ,
[yfkfkrq] [datetime] NULL ,
[bz] [text] NULL ,
CONSTRAINT [pk_cghtmain] PRIMARY KEY NONCLUSTERED ([cghth]) )
GO
CREATE TABLE [dbo].[cghtmx] (
[cghth] [char] (20) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[dhsl1] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[dhsl2] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[dhdj] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[yddhrq] [datetime] NOT NULL,
[rksl1] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[rksl2] [decimal] (13,3) NOT NULL DEFAULT (0.000),
[sjdhrq] [datetime] NULL,
[sel_yn] [char] (1) NULL,
CONSTRAINT [pk_cghtmx] PRIMARY KEY NONCLUSTERED ([cghth], [wldm]) )
GO
CREATE TABLE [dbo].[yfk] (
[ckdm] [char] (2) NOT NULL,
[rkdh] [char] (12) NOT NULL,
[rq] [datetime] NOT NULL ,
[yfkje] [decimal] (12,2) NOT NULL DEFAULT (0.000),
[yfkrq] [datetime] NOT NULL ,
[ghsbh] [char] (12) NOT NULL ,
[jbr] [char] (10) NULL ,
[fkje] [decimal] (12,2) NOT NULL DEFAULT (0.000),
[fkwcrq] [datetime] NULL,
[bz] [char] (60) NULL,
[lry] [char] (10) NOT NULL,
[yf] [char] (6) NULL,
CONSTRAINT [pk_yfk] PRIMARY KEY NONCLUSTERED ([ckdm], [rkdh]) )
GO
CREATE TABLE [dbo].[yfk_ld] (
[ckdm] [char] (2) NOT NULL,
[rkdh] [char] (12) NOT NULL,
[rq] [datetime] NOT NULL ,
[yfkje] [decimal] (12,2) NOT NULL DEFAULT (0.000),
[yfkrq] [datetime] NOT NULL ,
[ghsbh] [char] (12) NOT NULL ,
[jbr] [char] (10) NULL ,
[fkje] [decimal] (12,2) NOT NULL DEFAULT (0.000),
[fkwcrq] [datetime] NULL,
[bz] [char] (60) NULL,
[lry] [char] (10) NOT NULL,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_yfk_ld] PRIMARY KEY NONCLUSTERED ([ckdm], [rkdh], [yf]) )
GO
CREATE TABLE [dbo].[sfk] (
[fkjlh] [char] (12) NOT NULL,
[ckdm] [char] (2) NOT NULL,
[rkdh] [char] (12) NOT NULL,
[fkrq] [datetime] NOT NULL ,
[fkje] [decimal] (12,2) NOT NULL,
[zffs] [char] (2) NOT NULL,
[ywlb] [char] (2) NOT NULL,
[ghsbh] [char] (12) NOT NULL ,
[lry] [char] (10) NOT NULL,
[bz] [char] (60) NULL,
[yf] [char] (6) NULL,
CONSTRAINT [pk_sfk] PRIMARY KEY NONCLUSTERED ([fkjlh], [ghsbh]) )
GO
CREATE TABLE [dbo].[sfk_ld] (
[fkjlh] [char] (12) NOT NULL,
[ckdm] [char] (2) NOT NULL,
[rkdh] [char] (12) NOT NULL,
[fkrq] [datetime] NOT NULL ,
[fkje] [decimal] (12,2) NOT NULL,
[zffs] [char] (2) NOT NULL,
[ywlb] [char] (2) NOT NULL,
[ghsbh] [char] (12) NOT NULL ,
[lry] [char] (10) NOT NULL,
[bz] [char] (60) NULL,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_sfk_ld] PRIMARY KEY NONCLUSTERED ([fkjlh],[ghsbh],[yf]) )
GO
CREATE TABLE [dbo].[yfktz] (
[khbh] [char] (12) NOT NULL,
[qcyfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[bqcgje] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[bqfkje] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[qmxfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[qmyfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[yf] [char] (6) NULL,
CONSTRAINT [pk_yfktz] PRIMARY KEY NONCLUSTERED ([khbh]) )
GO
CREATE TABLE [dbo].[yfktz_ld] (
[khbh] [char] (12) NOT NULL,
[qcyfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[bqcgje] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[bqfkje] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[qmxfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[qmyfkye] [decimal] (12,2) NOT NULL DEFAULT 0.00,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_yfktz_ld] PRIMARY KEY NONCLUSTERED ([khbh], [yf]) )
GO
CREATE TABLE [dbo].[gsdm] (
[gsdm] [char] (2) NOT NULL,
[gsjc] [char] (12) NOT NULL,
[gsmc] [char] (40) NOT NULL,
[gsdz] [char] (40) NULL,
[telno] [char] (30) NULL,
[fax] [char] (30) NULL,
[bz] [char] (1) NULL,
[yfkjzn] [decimal] (4,0) NULL,
[yfkjzy] [decimal] (2,0) NULL,
[yskjzn] [decimal] (4,0) NULL,
[yskjzy] [decimal] (2,0) NULL,
[yfkjzwc] [char] (1) NULL,
[yskjzwc] [char] (1) NULL,
[init] [char] (1) NULL,
CONSTRAINT [pk_gsdm] PRIMARY KEY NONCLUSTERED ([gsdm]) )
GO
CREATE TABLE [dbo].[jksc] (
[jksch] [char] (20) NOT NULL ,
[klrq] [datetime] NOT NULL ,
[jsrq] [datetime] NULL,
[bz] [char] (60) NULL,
CONSTRAINT [pk_jksc] PRIMARY KEY NONCLUSTERED ([jksch]) )
GO
CREATE TABLE [dbo].[wlcbxm] (
[xmbh] [char] (4) NOT NULL ,
[xmmc] [char] (20) NOT NULL ,
CONSTRAINT [pk_wlcbxm] PRIMARY KEY NONCLUSTERED ([xmbh]) )
GO
CREATE TABLE [dbo].[wlqdmc] (
[gcbh] [char] (20) NOT NULL,
[wlqdbh] [char] (4) NOT NULL,
[wlqdmc] [char] (60) NOT NULL,
[wlqdjc] [char] (20) NOT NULL,
[scts] [decimal] (6,0) NOT NULL DEFAULT (0),
CONSTRAINT [pk_wlqdmc]⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -