人事管理系統(tǒng)打印-資料下載頁
2025-04-08 08:00本頁面
【正文】 Dept] [int] references Dept(DeptId) NOT NULL, [InterPosition] [int] references Category(CategoryId) NOT NULL, [Speciality] [nchar](30) NOT NULL, [Sex] [int] references CategoryInfo(CategoryId) NOT NULL, [Education ] [int] references CategoryInfo(CategoryId) NOT NULL, [IdCardNo] [nchar](20) NOT NULL, [MobilePhone] [nchar](20) NOT NULL, [TelPhone] [nchar](20) NULL, [] [nchar](10) NULL, [Email] [nchar](30) NULL, [Remark] [nchar](200) NULL )//建立員工駕證信息表create table [dbo].[CertificateInfo]( [CertificateId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId)not null, [CeQuantity] [int] , [Remark] [nchar](200) )//建立員工家庭情況表create table [dbo].[FamilyInfo]( [FamilyId ] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [SpouseName] [nchar](20), [Telephone] [nchar](20), [ChildQuantity] [int])//建立員工住宿情況表create table [dbo].[InhabitInfo]( [InhabitId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [InhabitOrNot] [nchar](2) not null, [RoomNo] [int] ) //建立部門經(jīng)理列表create table [dbo].[DeptManager]( [DeMaId] [int] identity(1,1) primary key not null, [DeptId] [int] references Dept(DeptId) not null, [StaffId] [int] references Staff(StaffId) not null)//建立加薪升職統(tǒng)計表create table [dbo].[IncreasePromotion]( [InPrId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [IncreaseOrNot] [nchar](2), [Promotion] [nchar](2) , [Remark] [nchar](200) )//建立業(yè)務(wù)考核統(tǒng)計表create table [dbo].[Business]( [BusinessId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [AssignQuantity] [nchar](30) not null, [ReachQuantity] [nchar](30) not null, [Remark] [nchar](200) )//建立考勤表create table [dbo].[Attendence]( [AttendenceId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [AbsenceTime] [datetime], [AbsenceCategory] [int] references CategoryInfo(CategoryId))//建立自動提醒列表create table [dbo].[Attention]( [AttentionId] [int] identity(1,1) primary key not null, [AttentionCategory] [int] references CategoryInfo(CategoryId), [StaffId] [int] references Staff(StaffId) not null, [Remark] [nchar](100))//建立工資表create table [dbo].[Salary]( [SalaryId] [int] identity(1,1) primary key not null, [StaffId] [int] references Staff(StaffId) not null, [BasicSalary] [int] not null, [Prize] [int] not null, [TimingSalary] [int] not null, [PieceSalary] [int] not null, [Welfare] [int] not null, [Insurance] [int] not null, [Tax] [int] not null, [Sum] [int] not null)（備注：由于時間及技術(shù)問題，部分表格可能無法實(shí)現(xiàn)，如：考勤表、工資表、績效考勤表在此僅做最基本的功能實(shí)現(xiàn)，若是時間允許將做進(jìn)一步改善。）32 / 32
公司管理相關(guān)推薦
鄂ICP備17016276號-1