人力资源管理.sql

使用的人力资源管理系统

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同变动子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同变动子集] DROP CONSTRAINT 合同变动子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同补充子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同补充子集] DROP CONSTRAINT 合同补充子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同解除子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同解除子集] DROP CONSTRAINT 合同解除子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同续签子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同续签子集] DROP CONSTRAINT 合同续签子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同终止子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同终止子集] DROP CONSTRAINT 合同终止子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[劳动争议子集_劳动合同编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[劳动争议子集] DROP CONSTRAINT 劳动争议子集_劳动合同编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[干部调整与交流子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[干部调整与交流子集] DROP CONSTRAINT 干部调整与交流子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人简历子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[个人简历子集] DROP CONSTRAINT 个人简历子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[个人年度汇总台帐子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[个人年度汇总台帐子集] DROP CONSTRAINT 个人年度汇总台帐子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[合同管理子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[合同管理子集] DROP CONSTRAINT 合同管理子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[兼任职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[兼任职务子集] DROP CONSTRAINT 兼任职务子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[军转干部子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[军转干部子集] DROP CONSTRAINT 军转干部子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[离休退休子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[离休退休子集] DROP CONSTRAINT 离休退休子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[社会保险子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[社会保险子集] DROP CONSTRAINT 社会保险子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[生育保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[生育保险信息子集] DROP CONSTRAINT 生育保险信息子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[失业保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[失业保险信息子集] DROP CONSTRAINT 失业保险信息子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政党派职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政党派职务子集] DROP CONSTRAINT 行政党派职务子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及党内惩罚_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及党内惩罚] DROP CONSTRAINT 行政及党内惩罚_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[行政及党内奖励_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[行政及党内奖励] DROP CONSTRAINT 行政及党内奖励_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[学历及学位子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[学历及学位子集] DROP CONSTRAINT 学历及学位子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[养老保险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[养老保险信息子集] DROP CONSTRAINT 养老保险信息子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[医疗保险子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[医疗保险子集] DROP CONSTRAINT 医疗保险子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[政治面貌及党籍情况_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[政治面貌及党籍情况] DROP CONSTRAINT 政治面貌及党籍情况_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职工参险信息子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职工参险信息子集] DROP CONSTRAINT 职工参险信息子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_职员离职登记表_职员基本信息表]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职员离职登记表] DROP CONSTRAINT FK_职员离职登记表_职员基本信息表
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[职员主要关系人信息表_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[职员主要关系人信息表] DROP CONSTRAINT 职员主要关系人信息表_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[主要论文著作子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[主要论文著作子集] DROP CONSTRAINT 主要论文著作子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[住房公积金子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[住房公积金子集] DROP CONSTRAINT 住房公积金子集_职员编号_fk
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[专业技术职务子集_职员编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[专业技术职务子集] DROP CONSTRAINT 专业技术职务子集_职员编号_fk
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

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].[教育经历证书列表]