⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 mssql70_sunmis30.sql

📁 做的比较好的人力资源管理。数据库：MS SQL 7。可以很方便的移植到MS sql SERVER 2000上
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[fhdlb] [char] (2) NOT NULL ,
	[htbh] [char] (20) NULL ,
	[zcck] [char] (2) NULL ,
	[jzr] [char] (10) NULL ,
	[shr] [char] (10) NULL ,
	CONSTRAINT [PK_fhd_ld] PRIMARY KEY  NONCLUSTERED ([yf],[ckdm],[fhdh])  )
GO



CREATE TABLE [dbo].[fhmx] (
	[ckdm] [char] (2) NOT NULL ,
	[fhdh] [char] (12) NOT NULL ,
	[fhmxbh] [char] (4) NOT NULL ,
	[cpdm] [char] (10) NOT NULL ,
	[pch] [char] (12) NOT NULL ,
	[fhsl] [decimal](14, 3) NOT NULL ,
	[fhdj] [decimal](14, 3) NOT NULL ,
	[xlh] [char] (20) NULL ,
	[old_fhrq] [datetime] NULL ,
	[old_zcrq] [datetime] NULL ,
	[old_fhdh] [char] (12) NULL ,
	[old_fckdm] [char] (2) NULL ,
	[gcbh] [char] (10) NULL ,
	[old_khbh] [char] (10) NULL ,
	[old_xssbh] [char] (10) NULL ,
	[old_fhbz] [char] (20) NULL ,
	[yf] [char] (6) NULL ,
	CONSTRAINT [PK_fhmx] PRIMARY KEY  NONCLUSTERED ([ckdm],[fhdh],[fhmxbh]) )
GO






CREATE TABLE [dbo].[fhmx_ld] (
	[yf] [char] (6) NOT NULL ,
	[ckdm] [char] (2) NOT NULL ,
	[fhdh] [char] (12) NOT NULL ,
	[fhmxbh] [char] (4) NOT NULL ,
	[cpdm] [char] (10) NOT NULL ,
	[pch] [char] (12) NOT NULL ,
	[fhsl] [decimal](14, 3) NOT NULL ,
	[fhdj] [decimal](14, 3) NOT NULL ,
	[xlh] [char] (20) NULL ,
	[old_fhrq] [datetime] NULL ,
	[old_zcrq] [datetime] NULL ,
	[old_fhdh] [char] (12) NULL ,
	[old_fckdm] [char] (2) NULL ,
	[gcbh] [char] (10) NULL ,
	[old_khbh] [char] (10) NULL ,
	[old_xssbh] [char] (10) NULL ,
	[old_fhbz] [char] (20) NULL ,
	CONSTRAINT [PK_fhmx_ld] PRIMARY KEY  NONCLUSTERED ([yf],[ckdm],[fhdh],[fhmxbh])  )
GO







CREATE TABLE [dbo].[fkfs] (
	[fkfs] [char] (16) NOT NULL ,
	CONSTRAINT [pk_fkfs] PRIMARY KEY  NONCLUSTERED ([fkfs]) )
GO



CREATE TABLE [dbo].[gcjd] (
	[gcbh] [varchar] (10) NOT NULL ,
	[ztbh] [varchar] (2) NOT NULL ,
	[dqz] [decimal](14, 3) NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[bz] [varchar] (1) NULL ,
	[lry] [char] (10) NOT NULL ,
	[xh] [char] (8) NOT NULL ,
	[ztmc] [char] (12) NOT NULL ,
	CONSTRAINT [PK_gcjd] PRIMARY KEY  NONCLUSTERED ([gcbh],[ztbh],[xh]) )
GO


CREATE TABLE [dbo].[gcjd_ld] (
	[gcbh] [varchar] (10) NOT NULL ,
	[ztbh] [varchar] (2) NOT NULL ,
	[dqz] [decimal](14, 3) NOT NULL ,
	[rq] [datetime] NOT NULL ,
	[bz] [varchar] (1) NULL ,
	[lry] [char] (10) NOT NULL ,
	[xh] [char] (8) NOT NULL ,
	[ztmc] [char] (12) NOT NULL ,
	CONSTRAINT [PK_gcjd_ld] PRIMARY KEY  NONCLUSTERED ([gcbh],[ztbh],[xh]) )
GO



CREATE TABLE [dbo].[gcjdlj] (
	[gcbh] [char] (10) NOT NULL ,
	[sgdlj01] [decimal](14, 3) NULL ,
	[sgdlj02] [decimal](14, 3) NULL ,
	[sgdlj03] [decimal](14, 3) NULL ,
	[sgdlj04] [decimal](14, 3) NULL ,
	[sgdlj05] [decimal](14, 3) NULL ,
	[sgdlj06] [decimal](14, 3) NULL ,
	[sgdlj07] [decimal](14, 3) NULL ,
	[sgdlj08] [decimal](14, 3) NULL ,
	[sgdlj09] [decimal](14, 3) NULL ,
	[sgdlj10] [decimal](14, 3) NULL ,
	[ndlj01] [decimal](14, 3) NULL ,
	[ndlj02] [decimal](14, 3) NULL ,
	[ndlj03] [decimal](14, 3) NULL ,
	[ndlj04] [decimal](14, 3) NULL ,
	[ndlj05] [decimal](14, 3) NULL ,
	[ndlj06] [decimal](14, 3) NULL ,
	[ndlj07] [decimal](14, 3) NULL ,
	[ndlj08] [decimal](14, 3) NULL ,
	[ndlj09] [decimal](14, 3) NULL ,
	[ndlj10] [decimal](14, 3) NULL ,
	[bqlj01] [decimal](14, 3) NULL ,
	[bqlj02] [decimal](14, 3) NULL ,
	[bqlj03] [decimal](14, 3) NULL ,
	[bqlj04] [decimal](14, 3) NULL ,
	[bqlj05] [decimal](14, 3) NULL ,
	[bqlj06] [decimal](14, 3) NULL ,
	[bqlj07] [decimal](14, 3) NULL ,
	[bqlj08] [decimal](14, 3) NULL ,
	[bqlj09] [decimal](14, 3) NULL ,
	[bqlj10] [decimal](14, 3) NULL ,
	CONSTRAINT [PK_gcjdlj] PRIMARY KEY  NONCLUSTERED ([gcbh])  )
GO




CREATE TABLE [dbo].[gcjdxlh] (
	[gcbh] [char] (10) NOT NULL ,
	[ztbh] [char] (2) NOT NULL ,
	[xlh] [char] (20) NOT NULL ,
	[xh] [char] (8) NOT NULL ,
	CONSTRAINT [PK_gcjdxlh] PRIMARY KEY  NONCLUSTERED ([gcbh],[ztbh],[xlh],[xh]) )
GO

CREATE TABLE [dbo].[gcjdxlh_ld] (
	[gcbh] [char] (10) NOT NULL ,
	[ztbh] [char] (2) NOT NULL ,
	[xlh] [char] (20) NOT NULL ,
	[xh] [char] (8) NOT NULL ,
	CONSTRAINT [PK_gcjdxlh_ld] PRIMARY KEY  NONCLUSTERED ([gcbh],[ztbh],[xlh],[xh]) )
GO





CREATE TABLE [dbo].[htlb] (
	[htlb] [varchar] (4) NOT NULL ,
	[htlbmc] [varchar] (24) NOT NULL ,
	CONSTRAINT [pk_htlb] PRIMARY KEY  NONCLUSTERED ([htlb]) )
GO





CREATE TABLE [dbo].[htmx] (
	[htbh] [varchar] (20) NOT NULL ,
	[xmbh] [varchar] (2) NOT NULL ,
	[xmmc] [varchar] (24) NOT NULL ,
	[gcbh] [varchar] (10) NULL ,
	[cpdm] [varchar] (10) NOT NULL ,
	[dhsl] [decimal](14, 3) NOT NULL ,
	[xsdj] [decimal](13, 3) NOT NULL ,
	[cbdj] [decimal](13, 3) NULL ,
	[ydjhrq] [datetime] NOT NULL ,
	[kxsdsl] [decimal](14, 3) NOT NULL ,
	[kxsdrq] [datetime] NULL ,
	[fhsl] [decimal](14, 3) NOT NULL ,
	[fhrq] [datetime] NULL ,
	[hl] [decimal](18, 7) NULL DEFAULT (1) ,
	CONSTRAINT [pk_htmx] PRIMARY KEY  NONCLUSTERED ([htbh],[xmbh]) )
GO

CREATE TABLE [dbo].[htmx_ld] (
	[htbh] [varchar] (20) NOT NULL ,
	[xmbh] [varchar] (2) NOT NULL ,
	[xmmc] [varchar] (24) NOT NULL ,
	[gcbh] [varchar] (10) NULL ,
	[cpdm] [varchar] (10) NOT NULL ,
	[dhsl] [decimal](14, 3) NOT NULL ,
	[xsdj] [decimal](13, 3) NOT NULL ,
	[cbdj] [decimal](13, 3) NULL ,
	[ydjhrq] [datetime] NOT NULL ,
	[kxsdsl] [decimal](14, 3) NOT NULL ,
	[kxsdrq] [datetime] NULL ,
	[fhsl] [decimal](14, 3) NOT NULL ,
	[fhrq] [datetime] NULL ,
	[hl] [decimal](18, 7) NULL DEFAULT (1) ,
	CONSTRAINT [pk_htmx_ld] PRIMARY KEY  NONCLUSTERED ([htbh],[xmbh]) )
GO


CREATE TABLE [dbo].[htqybm] (
	[ckdm] [varchar] (2) NULL ,
	[qybmmc] [varchar] (12) NOT NULL ,
	[qybmdm] [varchar] (2) NOT NULL ,
	CONSTRAINT [pk_htqybm] PRIMARY KEY  NONCLUSTERED ([qybmdm])  )
GO




CREATE TABLE [dbo].[hydm] (
	[sshy] [char] (10) NOT NULL ,
	CONSTRAINT [pk_hydm] PRIMARY KEY  NONCLUSTERED ([sshy])  )
GO




CREATE TABLE [dbo].[khda] (
	[khbh] [char] (12) NOT NULL ,
	[khmc] [char] (40) NOT NULL ,
	[yzbm] [char] (10) NULL ,
	[txdz] [char] (60) NULL ,
	[lxr] [char] (6) NULL ,
	[lxdh] [char] (15) NULL ,
	[sshy] [char] (10) NULL ,
	[dqdm] [char] (4) NULL ,
	[khgh] [char] (2) NOT NULL ,
	[khqt] [text] NULL ,
	[lry] [char] (6) NULL ,
	[khywmc] [char] (40) NULL ,
	[khxyjb] [char] (2) NULL ,
	[khxl] [char] (20) NULL ,
	[lxrzw] [char] (20) NULL ,
	[email] [char] (40) NULL ,
	[Homepage] [char] (40) NULL ,
	CONSTRAINT [pk_khda] PRIMARY KEY  NONCLUSTERED ([khbh])  )
GO


CREATE TABLE [dbo].[khlb] (
	[khdl] [char] (2) NOT NULL ,
	[khxl] [char] (20) NOT NULL ,
	CONSTRAINT [pk_khlb] PRIMARY KEY  NONCLUSTERED ([khdl], [khxl])  )
GO



CREATE TABLE [dbo].[khxyjb] (
	[xyjb] [char] (2) NOT NULL ,
	[jbmc] [char] (16) NOT NULL ,
	CONSTRAINT [pk_khxyjb] PRIMARY KEY  NONCLUSTERED ([xyjb])  )
GO




CREATE TABLE [dbo].[mbcb] (
	[gcbh] [char] (10) NOT NULL ,
	[xmbh] [char] (4) NOT NULL ,
	[djcb] [decimal](12, 2) NOT NULL ,
	[zmbcb] [decimal](12, 2) NOT NULL ,
	CONSTRAINT [pk_mbcb] PRIMARY KEY  NONCLUSTERED ([gcbh],[xmbh]) )
GO




CREATE TABLE [dbo].[PassWord] (
	[pass] [char] (20) NULL ,
	[ID] [char] (10) NOT NULL ,
	CONSTRAINT [PK_PassWord] PRIMARY KEY  NONCLUSTERED ([ID])  )
GO




CREATE TABLE [dbo].[qxqd] (
	[zxt] [varchar] (4) NOT NULL ,
	[qxbzf] [varchar] (8) NOT NULL ,
	[qxmc] [varchar] (30) NULL ,
	[sel_yn] [varchar] (1) NULL ,
	CONSTRAINT [pk_qxqd] PRIMARY KEY  NONCLUSTERED ([zxt],[qxbzf]) )
GO




CREATE TABLE [dbo].[scjdms] (
	[msbh] [varchar] (2) NOT NULL ,
	[ztbh] [varchar] (2) NOT NULL ,
	[ztmc] [varchar] (12) NOT NULL ,
	[xlh_bz] [varchar] (1) NOT NULL ,
	[ztzly] [varchar] (1) NOT NULL ,
	[jsgs] [varchar] (30) NULL ,
	[ztzbz] [varchar] (1) NOT NULL ,
	CONSTRAINT [pk_scjdms] PRIMARY KEY  NONCLUSTERED ([msbh],[ztbh]) )
GO



CREATE TABLE [dbo].[sgdwj] (
	[gcbh] [varchar] (10) NOT NULL ,
	[gcmc] [varchar] (40) NOT NULL ,
	[gczz] [decimal](14, 3) NULL ,
	[khbh] [varchar] (10) NOT NULL ,
       [htbh] [varchar] (20) NULL,
	[cpdm] [varchar] (10) NOT NULL ,
	[sczsl] [decimal](14, 3) NOT NULL ,
	[wgsl] [decimal](14, 3) NOT NULL ,
	[zzsl] [decimal](14, 3) NULL ,
	[kgrq] [datetime] NULL ,
	[jhwgrq] [datetime] NULL ,
	[sjwgrq] [datetime] NULL ,
	[jsrq] [datetime] NULL ,
	[lry] [varchar] (8) NOT NULL ,
	[bz] [text] NULL ,
	[bzjhrq] [datetime] NULL ,
	[ybdm] [char] (6) NOT NULL ,
        CONSTRAINT [pk_sgdwj] PRIMARY KEY  NONCLUSTERED ([gcbh]) )
        TEXTIMAGE_ON [Primary]
GO

CREATE TABLE [dbo].[sgdwj_ld] (
	[gcbh] [varchar] (10) NOT NULL ,
	[gcmc] [varchar] (40) NOT NULL ,
	[gczz] [decimal](14, 3) NULL ,
	[khbh] [varchar] (10) NOT NULL ,
       [htbh] [varchar] (20)  NULL,
	[cpdm] [varchar] (10) NOT NULL ,
	[sczsl] [decimal](14, 3) NOT NULL ,
	[wgsl] [decimal](14, 3) NOT NULL ,
	[zzsl] [decimal](14, 3) NULL ,
	[kgrq] [datetime] NULL ,
	[jhwgrq] [datetime] NULL ,
	[sjwgrq] [datetime] NULL ,
	[jsrq] [datetime] NULL ,
	[lry] [varchar] (8) NOT NULL ,
	[bz] [text] NULL ,
	[bzjhrq] [datetime] NULL ,
	[ybdm] [char] (6) NOT NULL ,
       CONSTRAINT [pk_sgdwj_ld] PRIMARY KEY  NONCLUSTERED ([gcbh]) )
       TEXTIMAGE_ON [Primary]
GO



CREATE TABLE [dbo].[sjcb] (
	[gcbh] [char] (10) NOT NULL ,
	[xmbh] [char] (4) NOT NULL ,
	[dqcb] [decimal](13, 2) NOT NULL ,
	[zsjcb] [decimal](13, 2) NOT NULL ,
	[djcb] [decimal](13, 2) NOT NULL ,
	[kjq] [char] (6) NOT NULL ,
	CONSTRAINT [pk_sjcb] PRIMARY KEY  NONCLUSTERED ([gcbh],[xmbh],[kjq]) )
GO



CREATE TABLE [dbo].[skjl] (
	[xsdh] [char] (12) NOT NULL ,
	[yskxh] [char] (2) NOT NULL ,
	[skxh] [char] (2) NOT NULL ,
	[skrq] [datetime] NOT NULL ,
	[skje] [decimal](13, 3) NOT NULL ,
	[bz] [char] (20) NULL ,
	CONSTRAINT [PK_skjl] PRIMARY KEY  NONCLUSTERED ([xsdh],[yskxh],[skxh]) )
GO

CREATE TABLE [dbo].[skjl_ld] (
	[xsdh] [char] (12) NOT NULL ,
	[yskxh] [char] (2) NOT NULL ,
	[skxh] [char] (2) NOT NULL ,
	[skrq] [datetime] NOT NULL ,
	[skje] [decimal](13, 3) NOT NULL ,
	[bz] [char] (20) NULL ,
	CONSTRAINT [PK_skjl_ld] PRIMARY KEY  NONCLUSTERED ([xsdh],[yskxh],[skxh]) )
GO


CREATE TABLE [dbo].[xsd] (
	[xsdh] [varchar] (12) NOT NULL ,
	[kdrq] [datetime] NOT NULL ,
	[htbh] [char] (20) NOT NULL ,
	[zdr] [char] (8) NOT NULL ,
	[bz] [char] (30) NULL ,
	[fhwcrq] [datetime] NULL ,
	[skwcrq] [datetime] NULL ,
	[ysfs] [char] (10) NULL ,
	[ysbh] [char] (15) NULL ,
	[ysgs] [char] (20) NULL ,
	[ysr] [char] (10) NULL ,
	[yjthrq] [datetime] NULL ,
	[pjjcrq] [datetime] NULL ,
	[kfprq] [datetime] NULL ,
	[hsrq] [datetime] NULL ,
	CONSTRAINT [pk_xsd] PRIMARY KEY  NONCLUSTERED ([xsdh]) )
GO

CREATE TABLE [dbo].[xsd_ld] (
	[xsdh] [varchar] (12) NOT NULL ,
	[kdrq] [datetime] NOT NULL ,
	[htbh] [char] (20) NOT NULL ,
	[zdr] [char] (8) NOT NULL ,
	[bz] [char] (30) NULL ,
	[fhwcrq] [datetime] NULL ,
	[skwcrq] [datetime] NULL ,
	[ysfs] [char] (10) NULL ,
	[ysbh] [char] (15) NULL ,
	[ysgs] [char] (20) NULL ,
	[ysr] [char] (10) NULL ,
	[yjthrq] [datetime] NULL ,
	[pjjcrq] [datetime] NULL ,
	[kfprq] [datetime] NULL ,
	[hsrq] [datetime] NULL ,
	CONSTRAINT [pk_xsd_ld] PRIMARY KEY  NONCLUSTERED ([xsdh]) )
GO
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -