?? 人力資源管理.sql
字號:
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[月工資統(tǒng)計表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[月工資統(tǒng)計表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[月考勤匯總表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[月考勤匯總表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案借用表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案借用表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案列表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案存入登記表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案存入登記表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案查詢歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案查詢歷史表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案查詢申請表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案查詢申請表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[檔案轉出表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[檔案轉出表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[津貼補助調(diào)整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[津貼補助調(diào)整表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生育保險信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[生育保險信息子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用戶清單]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[用戶清單]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[社會保險子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[社會保險子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[離休退休子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[離休退休子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[組織機構編碼表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[組織機構編碼表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[經(jīng)濟補償合同]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[經(jīng)濟補償合同]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[績效考核表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[績效考核表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職務工資調(diào)整表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職務工資調(diào)整表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員主要關系人信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員主要關系人信息表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員基本信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員基本信息表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員獎勵表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員獎勵表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員工資項目表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員工資項目表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員懲罰表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員懲罰表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員離職登記表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員離職登記表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職員考勤信息表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職員考勤信息表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[職工參險信息子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[職工參險信息子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[聘任合同列表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[聘任合同列表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政黨派職務子集]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[行政黨派職務子集]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及黨內(nèi)獎勵]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[行政及黨內(nèi)獎勵]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及黨內(nèi)懲罰]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[行政及黨內(nèi)懲罰]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[證件登記表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[證件登記表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[請假歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[請假歷史表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[請假申請表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[請假申請表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[轉入正式員工登記表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[轉入正式員工登記表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[面試歷史表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[面試歷史表]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[面試名單表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[面試名單表]
GO
CREATE TABLE [dbo].[上年工資統(tǒng)計] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[年度] [int] NULL ,
[上一年月平均工資] [decimal](26, 2) NULL ,
[本市職工平均工資] [decimal](26, 2) NULL ,
[社會保險基數(shù)] [decimal](26, 2) NULL ,
[基數(shù)下限] [decimal](26, 2) NULL ,
[基數(shù)上限] [decimal](26, 2) NULL ,
[備注] [char] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[專業(yè)技術職務子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[專業(yè)技術資格名稱] [varchar] (100) NULL ,
[取得資格途徑] [varchar] (50) NULL ,
[取得資格時間] [int] NULL ,
[聘任專業(yè)技術職務名稱] [varchar] (100) NULL ,
[聘任起始時間] [int] NULL ,
[聘任終止時間] [int] NULL ,
[聘任單位] [varchar] (100) NULL ,
[聘任情況] [varchar] (100) NULL ,
[有何種專長] [varchar] (100) NULL ,
[資格審批單位] [varchar] (100) NULL ,
[備注] [char] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[個人年度匯總臺帳子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[年度] [int] NULL ,
[養(yǎng)老險個人繳費額] [decimal](26, 2) NULL ,
[養(yǎng)老險企業(yè)繳費額] [decimal](26, 2) NULL ,
[養(yǎng)老險企業(yè)劃入額] [decimal](26, 2) NULL ,
[醫(yī)療險個人繳費額] [decimal](26, 2) NULL ,
[醫(yī)療險企業(yè)繳費額] [decimal](26, 2) NULL ,
[醫(yī)療險企業(yè)劃入額] [decimal](26, 2) NULL ,
[失業(yè)險個人繳費額] [decimal](26, 2) NULL ,
[失業(yè)險企業(yè)繳費額] [decimal](26, 2) NULL ,
[工傷險企業(yè)繳費額] [decimal](26, 2) NULL ,
[生育險企業(yè)繳費額] [decimal](26, 2) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[個人所得稅表] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[級數(shù)] [char] (2) NOT NULL ,
[不計稅工資] [decimal](26, 2) NOT NULL ,
[工資下限] [decimal](26, 2) NOT NULL ,
[工資上限] [decimal](26, 2) NOT NULL ,
[個人所得稅率] [decimal](26, 2) NOT NULL ,
[速算扣除數(shù)] [decimal](26, 2) NOT NULL ,
[備注] [varchar] (50) NULL ,
[操作員] [varchar] (10) NULL ,
[修改標記] [char] (1) NOT NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[個人簡歷子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[起始時間] [int] NULL ,
[終止時間] [int] NULL ,
[所在單位] [varchar] (100) NULL ,
[從事工作或擔任職務] [varchar] (100) NULL ,
[證明人] [varchar] (30) NULL ,
[備注] [char] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[主要論文著作子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[發(fā)表時間] [int] NULL ,
[論文著作名稱] [varchar] (100) NULL ,
[所屬學科專業(yè)類別] [varchar] (20) NULL ,
[出版社或刊物名稱] [varchar] (100) NULL ,
[備注] [varchar] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[人事變更歷史表] (
[序號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[職務調(diào)動日期] [int] NULL ,
[調(diào)動前部門編號] [char] (10) NOT NULL ,
[調(diào)動前部門名稱] [varchar] (100) NULL ,
[調(diào)動前職務編號] [char] (10) NOT NULL ,
[調(diào)動前職務名稱] [varchar] (100) NULL ,
[調(diào)動后部門編號] [char] (10) NOT NULL ,
[調(diào)動后部門名稱] [varchar] (100) NULL ,
[調(diào)動后職務編號] [char] (10) NOT NULL ,
[調(diào)動后職務名稱] [varchar] (100) NULL ,
[調(diào)動原因] [varchar] (50) NULL ,
[調(diào)動類型] [varchar] (20) NULL ,
[人事部門意見] [varchar] (200) NULL ,
[審批情況] [varchar] (20) NULL ,
[填單記帳人] [char] (10) NULL ,
[審批記帳人] [char] (10) NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[住房公積金子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[基數(shù)計算方式] [varchar] (50) NULL ,
[繳費基數(shù)] [decimal](26, 2) NULL ,
[個人支付比率] [decimal](26, 2) NULL ,
[個人繳費額] [decimal](26, 2) NULL ,
[企業(yè)支付比率] [decimal](26, 2) NULL ,
[企業(yè)繳費額] [decimal](26, 2) NULL ,
[開始繳費日期] [int] NULL ,
[累計繳費時間] [int] NULL ,
[繳費中斷時間] [int] NULL ,
[繳費中斷原因] [varchar] (100) NULL ,
[備注] [char] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[養(yǎng)老保險信息子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[開始繳費時間] [int] NULL ,
[視同繳費年限] [decimal](26, 2) NULL ,
[職工月繳費基數(shù)] [decimal](26, 2) NULL ,
[繳費記錄] [varchar] (1) NULL ,
[補繳] [varchar] (2) NULL ,
[增加原因] [varchar] (50) NULL ,
[人員類別] [varchar] (50) NULL ,
[備注] [char] (100) NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[兼任職務子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[兼職類別] [varchar] (20) NULL ,
[兼任職務名稱] [varchar] (100) NULL ,
[兼職時間] [int] NULL ,
[兼職單位] [varchar] (100) NULL ,
[兼職方式] [varchar] (20) NULL ,
[兼職原因] [varchar] (50) NULL ,
[兼職文號] [varchar] (30) NULL ,
[兼職批準單位] [varchar] (100) NULL ,
[兼職主管或從事工作] [varchar] (100) NULL ,
[兼職生效時間] [int] NULL ,
[免去兼職的時間] [int] NULL ,
[操作員] [char] (10) NULL ,
[修改標記] [char] (1) NULL ,
[修改日期] [int] NULL ,
[接收登記] [binary] (30) NULL ,
[備注] [char] (100) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[軍轉干部子集] (
[內(nèi)部編號] [int] IDENTITY (1, 1) NOT NULL ,
[職員編號] [varchar] (30) NOT NULL ,
[入伍地] [varchar] (100) NULL ,
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -