check.sql

软件外包人事综合管理系统,对员工的管理,部门管理,以及考勤管理和薪资管理.总得来说功能完全.

use master
GO

if exists (select * from dbo.sysdatabases where name = 'HrSys') 
drop database HrSys
GO

create database HrSys
GO

use HrSys
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Checkin]') and OBJECTPROPERTY(id,N'IsUserTable') = 1)
drop table [dbo].[Checkin]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Departments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Departments]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Employees]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Employees]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Evaluation]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Evaluation]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Experience]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Experience]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Family]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Family]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[v_SumCheck]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[v_SumCheck]
GO


CREATE TABLE [dbo].[Checkin] (
[CheckDate][nvarchar](10),
[Emp_Id][nvarchar](10),
[qqDays][nvarchar](10), 
[ccDays][nvarchar](10),
[bjDays][nvarchar](10),
[sjDays][nvarchar](10),
[kgDays][nvarchar](10),
[fdxjDays][nvarchar](10),
[nxjDays][nvarchar](10),
[dxjDays][nvarchar](10),
[cdMinutes][nvarchar](10),
[ztMinutes][nvarchar](10),
[ot1Days][nvarchar](10),
[ot2Days][nvarchar](10),
[ot3Days][nvarchar](10),
[Memo][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Departments] (
[Dep_Name][nvarchar](10),
[UpperId][nvarchar](10),
[Describe][nvarchar](10), 
[Dep_Id][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Employees] (
[Emp_Id][nvarchar](10),
[Emp_Name][nvarchar](10),
[Sex][nvarchar](10), 
[Nationnality][nvarchar](10),
[Birth][nvarchar](10),
[Political_Party][nvarchar](10),
[Culture_Level][nvarchar](10),
[Marital_Condition][nvarchar](10),
[Family_Place][nvarchar](10),
[Id_Card][nvarchar](10),
[BadgeID][nvarchar](10),
[Office_phone][nvarchar](10),
[Mobile][nvarchar](10),
[Files_Keep_Org][nvarchar](10),
[HuKou][nvarchar](10),
[HireDate][nvarchar](10),
[Dep_Id][nvarchar](10),
[Position][nvarchar](10),
[Title][nvarchar](10),
[State][nvarchar](10),
[UpperId][nvarchar](10),
[Contract_Duration][nvarchar](10),
[Memo][nvarchar](10),
[Fillin_Person][nvarchar](10),
[Fillin_Time][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Evaluation] (
[Emp_Id][nvarchar](10),
[EvaMonth][nvarchar](10),
[ztEva][nvarchar](10), 
[jlReason][nvarchar](10),
[jlAmount][nvarchar](10),
[cfReason][nvarchar](10),
[cfAmount][nvarchar](10),
[Memo][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Experience] (
[Id][nvarchar](10),
[Emp_Id][nvarchar](10),
[Start_Date][nvarchar](10), 
[End_Date][nvarchar](10),
[School_Org][nvarchar](10),
[Title][nvarchar](10),
[Memo][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Family] (
[Id][nvarchar](10),
[Emp_Id][nvarchar](10),
[Name][nvarchar](10), 
[Sex][nvarchar](10),
[Age][nvarchar](10),
[Relationship][nvarchar](10),
[WorkingOrg][nvarchar](10),
[Memo][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[Users] (
[UserName][nvarchar](10),
[Pwd][nvarchar](10),
[Memo][nvarchar](10)
)ON [PRIMARY]
GO
CREATE TABLE [dbo].[v_SumCheck] (
[Dep_Id][nvarchar](10),
[Emp_Id][nvarchar](10),
[Emp_Name][nvarchar](10),
[SumQq][nvarchar](10),
[SumCc][nvarchar](10),
[SumBj][nvarchar](10),
[SumSj][nvarchar](10),
[SumKg][nvarchar](10),
[SumFdxj][nvarchar](10),
[SumNxj][nvarchar](10),
[SumDxj][nvarchar](10),
[SumCd][nvarchar](10),
[SumZt][nvarchar](10),
[SumOt1][nvarchar](10),
[SumOt2][nvarchar](10),
[SumOt3][nvarchar](10),
[CheckMonth][nvarchar](10)
)ON [PRIMARY]
GO