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

📄 人力资源管理.sql

📁 使用的人力资源管理系统
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
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].[用户清单]') 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].[职员工资项目表]') 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].[请假历史表]') 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].[上年工资统计] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[年度] [int] NULL ,
	[上一年月平均工资] [decimal](26, 2) NULL ,
	[本市职工平均工资] [decimal](26, 2) NULL ,
	[社会保险基数] [decimal](26, 2) NULL ,
	[基数下限] [decimal](26, 2) NULL ,
	[基数上限] [decimal](26, 2) NULL ,
	[备注] [char] (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 ,
	[专业技术资格名称] [varchar] (100) NULL ,
	[取得资格途径] [varchar] (50) NULL ,
	[取得资格时间] [int] NULL ,
	[聘任专业技术职务名称] [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].[个人年度汇总台帐子集] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[年度] [int] NULL ,
	[养老险个人缴费额] [decimal](26, 2) NULL ,
	[养老险企业缴费额] [decimal](26, 2) NULL ,
	[养老险企业划入额] [decimal](26, 2) NULL ,
	[医疗险个人缴费额] [decimal](26, 2) NULL ,
	[医疗险企业缴费额] [decimal](26, 2) NULL ,
	[医疗险企业划入额] [decimal](26, 2) NULL ,
	[失业险个人缴费额] [decimal](26, 2) NULL ,
	[失业险企业缴费额] [decimal](26, 2) NULL ,
	[工伤险企业缴费额] [decimal](26, 2) NULL ,
	[生育险企业缴费额] [decimal](26, 2) NULL ,
	[操作员] [char] (10) NULL ,
	[修改标记] [char] (1) NULL ,
	[修改日期] [int] NULL ,
	[接收登记] [binary] (30) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[个人所得税表] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[级数] [char] (2) NOT NULL ,
	[不计税工资] [decimal](26, 2) NOT NULL ,
	[工资下限] [decimal](26, 2) NOT NULL ,
	[工资上限] [decimal](26, 2) NOT NULL ,
	[个人所得税率] [decimal](26, 2) NOT NULL ,
	[速算扣除数] [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].[个人简历子集] (
	[内部编号] [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].[主要论文著作子集] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[发表时间] [int] NULL ,
	[论文著作名称] [varchar] (100) NULL ,
	[所属学科专业类别] [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 ,
	[职务调动日期] [int] NULL ,
	[调动前部门编号] [char] (10) NOT NULL ,
	[调动前部门名称] [varchar] (100) NULL ,
	[调动前职务编号] [char] (10) NOT NULL ,
	[调动前职务名称] [varchar] (100) NULL ,
	[调动后部门编号] [char] (10) NOT NULL ,
	[调动后部门名称] [varchar] (100) NULL ,
	[调动后职务编号] [char] (10) NOT NULL ,
	[调动后职务名称] [varchar] (100) NULL ,
	[调动原因] [varchar] (50) NULL ,
	[调动类型] [varchar] (20) NULL ,
	[人事部门意见] [varchar] (200) NULL ,
	[审批情况] [varchar] (20) NULL ,
	[填单记帐人] [char] (10) NULL ,
	[审批记帐人] [char] (10) NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[住房公积金子集] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[基数计算方式] [varchar] (50) NULL ,
	[缴费基数] [decimal](26, 2) NULL ,
	[个人支付比率] [decimal](26, 2) NULL ,
	[个人缴费额] [decimal](26, 2) NULL ,
	[企业支付比率] [decimal](26, 2) NULL ,
	[企业缴费额] [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].[养老保险信息子集] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[开始缴费时间] [int] NULL ,
	[视同缴费年限] [decimal](26, 2) NULL ,
	[职工月缴费基数] [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].[兼任职务子集] (
	[内部编号] [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].[军转干部子集] (
	[内部编号] [int] IDENTITY (1, 1) NOT NULL ,
	[职员编号] [varchar] (30) NOT NULL ,
	[入伍地] [varchar] (100) NULL ,
12345

⌨️ 快捷键说明

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