📄 mssql70_sunmis30.sql
字号:
CREATE TABLE [dbo].[xsdmx] (
[xsdh] [char] (12) NOT NULL ,
[xmbh] [char] (2) NOT NULL ,
[cpdm] [varchar] (10) NOT NULL ,
[xssl] [decimal](18, 3) NOT NULL ,
[fhsl] [decimal](14, 3) NOT NULL ,
[gcbh] [char] (10) NULL ,
[xsje] [decimal](14, 3) NOT NULL DEFAULT (0),
[htbh] [char] (20) NOT NULL ,
[mbcbje] [decimal](14, 3) NULL ,
[fhcbje] [decimal](14, 3) NULL ,
[mbml] [decimal](14, 3) NULL ,
[fhml] [decimal](14, 3) NULL ,
CONSTRAINT [pk_xsdmx] PRIMARY KEY NONCLUSTERED ([xsdh],[xmbh],[htbh]) )
GO
CREATE TABLE [dbo].[xsdmx_ld] (
[xsdh] [char] (12) NOT NULL ,
[xmbh] [char] (2) NOT NULL ,
[cpdm] [varchar] (10) NOT NULL ,
[xssl] [decimal](18, 3) NOT NULL ,
[fhsl] [decimal](14, 3) NOT NULL ,
[gcbh] [char] (10) NULL ,
[xsje] [decimal](14, 3) NOT NULL DEFAULT (0),
[htbh] [char] (20) NOT NULL ,
[mbcbje] [decimal](14, 3) NULL ,
[fhcbje] [decimal](14, 3) NULL ,
[mbml] [decimal](14, 3) NULL ,
[fhml] [decimal](14, 3) NULL ,
CONSTRAINT [pk_xsdmx_ld] PRIMARY KEY NONCLUSTERED ([xsdh],[xmbh],[htbh]) )
GO
CREATE TABLE [dbo].[xsht] (
[htbh] [varchar] (20) NOT NULL ,
[htmc] [varchar] (40) NOT NULL ,
[khbh] [varchar] (12) NOT NULL ,
[qydm] [varchar] (10) NOT NULL ,
[xssbh] [varchar] (12) NOT NULL ,
[qyrq] [datetime] NOT NULL ,
[ydjhrq] [datetime] NOT NULL ,
[htze] [decimal](14, 3) NOT NULL ,
[jbr] [varchar] (8) NULL ,
[htlb] [varchar] (4) NOT NULL ,
[lxr] [varchar] (8) NULL ,
[lxdh] [varchar] (20) NULL ,
[scwgrq] [datetime] NULL ,
[htzzrq] [datetime] NULL ,
[qybmdm] [varchar] (2) NOT NULL ,
[lry] [varchar] (8) NOT NULL ,
[xsdje] [decimal](14, 3) NULL ,
[dybz] [varchar] (4) NULL ,
[xh] [decimal](6, 0) NULL ,
[htbz] [text] NULL ,
[skwcrq] [datetime] NULL ,
[kxsdrq] [datetime] NULL ,
[fhwcrq] [datetime] NULL ,
[zdfhwc] [char] (1) NULL ,
[zdskwc] [char] (1) NULL ,
[zdxswc] [char] (1) NULL ,
[ybdm] [char] (6) NOT NULL ,
[zxwcrq] [datetime] NULL ,
[xyzbh] [char] (15) NULL ,
[fkfs] [char] (16) NULL ,
CONSTRAINT [pk_xsht] PRIMARY KEY NONCLUSTERED ([htbh]) )
TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[xsht_ld] (
[htbh] [varchar] (20) NOT NULL ,
[htmc] [varchar] (40) NOT NULL ,
[khbh] [varchar] (12) NOT NULL ,
[qydm] [varchar] (10) NOT NULL ,
[xssbh] [varchar] (12) NOT NULL ,
[qyrq] [datetime] NOT NULL ,
[ydjhrq] [datetime] NOT NULL ,
[htze] [decimal](14, 3) NOT NULL ,
[jbr] [varchar] (8) NULL ,
[htlb] [varchar] (4) NOT NULL ,
[lxr] [varchar] (8) NULL ,
[lxdh] [varchar] (20) NULL ,
[scwgrq] [datetime] NULL ,
[htzzrq] [datetime] NULL ,
[qybmdm] [varchar] (2) NOT NULL ,
[lry] [varchar] (8) NOT NULL ,
[xsdje] [decimal](14, 3) NULL ,
[dybz] [varchar] (4) NULL ,
[xh] [decimal](6, 0) NULL ,
[htbz] [text] NULL ,
[skwcrq] [datetime] NULL ,
[kxsdrq] [datetime] NULL ,
[fhwcrq] [datetime] NULL ,
[zdfhwc] [char] (1) NULL ,
[zdskwc] [char] (1) NULL ,
[zdxswc] [char] (1) NULL ,
[ybdm] [char] (6) NOT NULL ,
[zxwcrq] [datetime] NULL ,
[xyzbh] [char] (15) NULL ,
[fkfs] [char] (16) NULL ,
CONSTRAINT [pk_xsht_ld] PRIMARY KEY NONCLUSTERED ([htbh]) )
TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[xsqydm] (
[qydm] [char] (10) NOT NULL ,
CONSTRAINT [PK_xsqydm] PRIMARY KEY NONCLUSTERED ([qydm]) )
GO
CREATE TABLE [dbo].[yhk] (
[yhm] [varchar] (8) NOT NULL ,
[fullname] [varchar] (8) NOT NULL ,
[pass] [varchar] (8) NULL ,
[ssckdm] [varchar] (2) NULL ,
[ssxsbm] [char] (2) NULL ,
CONSTRAINT [pk_yhk] PRIMARY KEY NONCLUSTERED ([yhm]) )
GO
CREATE TABLE [dbo].[yhqx] (
[yhm] [varchar] (8) NOT NULL ,
[zxt] [varchar] (4) NOT NULL ,
[qxbzf] [varchar] (8) NOT NULL ,
CONSTRAINT [pk_yhqx] PRIMARY KEY NONCLUSTERED ([yhm],[zxt],[qxbzf]) )
GO
CREATE TABLE [dbo].[yskjl] (
[xsdh] [char] (12) NOT NULL ,
[xh] [char] (2) NOT NULL ,
[yskrq] [datetime] NOT NULL ,
[yskje] [decimal](13, 3) NOT NULL ,
[skje] [decimal](13, 3) NOT NULL ,
[qkje] [decimal](13, 3) NOT NULL ,
CONSTRAINT [PK_yskjl] PRIMARY KEY NONCLUSTERED ([xsdh],[xh]) )
GO
CREATE TABLE [dbo].[yskjl_ld] (
[xsdh] [char] (12) NOT NULL ,
[xh] [char] (2) NOT NULL ,
[yskrq] [datetime] NOT NULL ,
[yskje] [decimal](13, 3) NOT NULL ,
[skje] [decimal](13, 3) NOT NULL ,
[qkje] [decimal](13, 3) NOT NULL ,
CONSTRAINT [PK_yskjl_ld] PRIMARY KEY NONCLUSTERED ([xsdh],[xh]) )
GO
CREATE TABLE [dbo].[DataVerision] (
[Flag] [char] (20) NOT NULL ,
[Verision] [char] (10) NOT NULL ,
[SubSys] [char] (20) NOT NULL ,
CONSTRAINT [PK_DataVerision] PRIMARY KEY NONCLUSTERED ([Flag],[SubSys],[Verision]) )
GO
CREATE TABLE [dbo].[Account] (
[ID] [char] (20) NOT NULL ,
[SubSys] [char] (20) NOT NULL ,
CONSTRAINT [PK_Account] PRIMARY KEY NONCLUSTERED ([SubSys],[ID]) )
GO
CREATE TABLE [dbo].[SysArg] (
[Name] [char] (10) NOT NULL,
[Value] [char] (20) NULL,
CONSTRAINT [pk_sysarg] PRIMARY KEY NONCLUSTERED ([name]) )
GO
CREATE TABLE [dbo].[wldm] (
[wldm] [char] (24) NOT NULL ,
[wlmc] [char] (32) NOT NULL ,
[wlxh] [char] (32) NULL ,
[wllb] [char] (8) NOT NULL ,
[jkbz] [char] (1) NOT NULL DEFAULT 'N',
[hgspbh] [char] (20) NULL,
[jldw1] [char] (6) NOT NULL,
[jldw2] [char] (6) NOT NULL,
[zhxs] [decimal] (10, 4) NOT NULL DEFAULT (1.0),
[jjff] [char] (2) NOT NULL DEFAULT 'YP',
[pcbz] [char] (1) NOT NULL DEFAULT 'N',
[zgkc] [decimal] (13,3) NULL,
[zdkc] [decimal] (13,3) NULL,
[jjpl] [decimal] (13,3) NULL,
[tqq] [decimal] (3,0) NULL,
[gs] [decimal] (10,3) NULL,
[jhdj] [decimal] (12,2) NULL,
[zjdj] [decimal] (16,7) NULL,
[zjdjrq] [datetime] NULL,
[scdj] [decimal] (14,2) NULL,
[scdjrq] [datetime] NULL,
[rxhl] [decimal] (13,3) NULL,
[tjxm] [char] (4) NOT NULL,
[abc] [char] (1) NOT NULL,
CONSTRAINT [pk_wldm] PRIMARY KEY NONCLUSTERED ([wldm]) )
GO
CREATE TABLE [dbo].[wltz] (
[ckdm] [char] (2) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[kcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[zjflrq] [datetime] NULL,
[cfdz] [char] (40) NULL,
[sqkcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcjecy] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcsl1cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[yf] [char] (6) NULL,
[jjbz] [char] (2) NULL,
CONSTRAINT [pk_wltz] PRIMARY KEY NONCLUSTERED ([ckdm],[wldm]) )
GO
CREATE TABLE [dbo].[wltz_ld] (
[ckdm] [char] (2) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[kcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[zjflrq] [datetime] NULL,
[cfdz] [char] (40) NULL,
[sqkcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcjecy] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcsl1cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[yf] [char] (6) NOT NULL,
[jjbz] [char] (2) NOT NULL,
CONSTRAINT [pk_wltz_ld] PRIMARY KEY NONCLUSTERED ([yf],[ckdm],[wldm]) )
GO
CREATE TABLE [dbo].[wlpc] (
[ckdm] [char] (2) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NOT NULL,
[rkdh] [char] (12) NULL,
[rkrq] [datetime] NOT NULL,
[rksl1] [decimal] (13,3) NULL,
[rksl2] [decimal] (13,3) NULL,
[rkje] [decimal] (12,2) NULL,
[cgdj] [decimal] (13,3) NULL,
[kcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[sqkcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcjecy] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcsl1cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[scrq] [datetime] NULL,
[sxrq] [datetime] NULL,
[bgsch] [char] (20) NULL,
[zjflrq] [datetime] NULL,
[ghsbh] [char] (12) NULL,
[yf] [char] (6) NULL,
CONSTRAINT [pk_wlpc] PRIMARY KEY NONCLUSTERED ([ckdm],[wldm],[pch]) )
GO
CREATE TABLE [dbo].[wlpc_ld] (
[ckdm] [char] (2) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[pch] [char] (12) NOT NULL,
[rkdh] [char] (12) NULL,
[rkrq] [datetime] NOT NULL,
[rksl1] [decimal] (13,3) NULL,
[rksl2] [decimal] (13,3) NULL,
[rkje] [decimal] (12,2) NULL,
[cgdj] [decimal] (13,3) NULL,
[kcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[sqkcsl1] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcsl2] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[sqkcje] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcjecy] [decimal] (12,2) NOT NULL DEFAULT (0.00),
[kcsl1cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[kcsl2cy] [decimal] (13,3) NOT NULL DEFAULT (0.00),
[scrq] [datetime] NULL,
[sxrq] [datetime] NULL,
[bgsch] [char] (20) NULL,
[zjflrq] [datetime] NULL,
[ghsbh] [char] (12) NULL,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_wlpc_ld] PRIMARY KEY NONCLUSTERED ([yf],[ckdm],[wldm],[pch]) )
GO
CREATE TABLE [dbo].[rkdlb] (
[lb] [char] (2) NOT NULL ,
[lbmc] [char] (12) NOT NULL ,
[pcbz] [char] (1) NOT NULL DEFAULT 'Y',
[zkbz] [char] (1) NOT NULL DEFAULT 'N',
[mrbz] [char] (1) NOT NULL DEFAULT 'N',
CONSTRAINT [pk_rkdlb] PRIMARY KEY NONCLUSTERED ([lb]) )
GO
CREATE TABLE [dbo].[fldlb] (
[lb] [char] (2) NOT NULL ,
[lbmc] [char] (12) NOT NULL ,
[zkbz] [char] (1) NOT NULL DEFAULT 'N',
[mrbz] [char] (1) NOT NULL DEFAULT 'N',
CONSTRAINT [pk_fldlb] PRIMARY KEY NONCLUSTERED ([lb]) )
GO
CREATE TABLE [dbo].[wlxg] (
[xgrq] [datetime] NOT NULL ,
[xgr] [char] (10) NOT NULL ,
[wldm] [char] (24) NOT NULL ,
[xgnr] [text] NULL ,
[xglb] [char] (1) NOT NULL DEFAULT 'C',
CONSTRAINT [pk_wlxg] PRIMARY KEY NONCLUSTERED ([wldm],[xgrq],[xgr]) )
GO
CREATE TABLE [dbo].[wllb] (
[wllb] [char] (8) NOT NULL ,
[wllbmc] [char] (30) NOT NULL ,
[wldl] [char] (3) NOT NULL ,
[cbdm] [char] (4) NOT NULL,
CONSTRAINT [pk_wllb] PRIMARY KEY NONCLUSTERED ([wllb]) )
GO
CREATE TABLE [dbo].[tjxm] (
[tjxm] [char] (4) NOT NULL ,
[xmmc] [char] (30) NOT NULL ,
[tjsl] [char] (1) NOT NULL DEFAULT 'N',
[jldw] [char] (10) NULL ,
CONSTRAINT [pk_tjxm] PRIMARY KEY NONCLUSTERED ([tjxm]) )
GO
CREATE TABLE [dbo].[rkd] (
[ckdm] [char] (2) NOT NULL ,
[rkdh] [char] (12) NOT NULL ,
[rkrq] [datetime] NOT NULL ,
[lb] [char] (2) NOT NULL,
[bz] [char] (30) NULL,
[zdr] [char] (10) NOT NULL,
[cgy] [char] (10) NULL,
[slr] [char] (10) NULL,
[ghsbh] [char] (12) NOT NULL,
[jzr] [char] (10) NULL,
[shr] [char] (10) NULL,
[lyck] [char] (2) NULL,
[fph] [char] (20) NULL,
[cghth] [char] (20) NULL,
[cgdh] [char] (12) NULL,
[jksch] [char] (20) NULL,
[jjbz] [char] (2) NOT NULL,
[fkbz] [char] (1) NOT NULL,
[yfkrq] [datetime] NOT NULL,
[yf] [char] (6) NULL,
CONSTRAINT [pk_rkd] PRIMARY KEY NONCLUSTERED ([ckdm],[rkdh]) )
GO
CREATE TABLE [dbo].[rkd_ld] (
[ckdm] [char] (2) NOT NULL ,
[rkdh] [char] (12) NOT NULL ,
[rkrq] [datetime] NOT NULL ,
[lb] [char] (2) NOT NULL,
[bz] [char] (30) NULL,
[zdr] [char] (10) NOT NULL,
[cgy] [char] (10) NULL,
[slr] [char] (10) NULL,
[ghsbh] [char] (12) NOT NULL,
[jzr] [char] (10) NULL,
[shr] [char] (10) NULL,
[lyck] [char] (2) NULL,
[fph] [char] (20) NULL,
[cghth] [char] (20) NULL,
[cgdh] [char] (12) NULL,
[jksch] [char] (20) NULL,
[jjbz] [char] (2) NOT NULL,
[fkbz] [char] (1) NOT NULL,
[yfkrq] [datetime] NOT NULL,
[yf] [char] (6) NOT NULL,
CONSTRAINT [pk_rkd_ld] PRIMARY KEY NONCLUSTERED ([yf], [ckdm], [rkdh]) )
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -