人事管理系統(tǒng)打印-wenkub
2023-04-23 08:00:03 本頁面
【正文】 Remark] [nchar](200) NULL)//建立離職表CREATE TABLE [dbo].[Dimission]( [DimissionId] [int] NOT NULL identity(1,1) primary key, [StaffId] [nchar](20) references Staff(StaffId) NOT NULL, [DimissionTime] [datetime] NOT NULL, [DimissionReason] [nchar](200) NOT NULL)//建立員工調(diào)動表CREATE TABLE [dbo].[PositionTransfer]( [TransferId] [int] NOT NULL identity(1,1) primary key, [StaffId] [int] references Staff(StaffId) NOT NULL, [PresentDept] [int] references Dept(DeptId) NOT NULL, [PastDept] [int] references Dept(DeptId)NOT NULL, [PresentPosition] [int] references Position(PositionId)NOT NULL, [PastPosition] [int] references Position(PositionId)NOT NULL, [TransfeTime] [datetime] NOT NULL, [TransferReason] [nchar](100))//建立缺員表CREATE TABLE [dbo].[LackPosition]( [LackPositionId] [int] identity(1,1) primary key NOT NULL, [DeptId] [int] references Dept(DeptId) NOT NULL, [LackPosition] [int] references Position(PositionId) NOT NULL, [LackQuantity] [nchar](20) NOT NULL, [OtherRequire] [nchar](100) NULL)//建立招聘記錄表create table [dbo].[RecuitRecord]( [RecordId] [int] identity(1,1) primary key not null, [RecruitTime] [datetime] not null, [DeptId] [int] references Dept(DeptId) not null, [NeedQuantity] [int] not null, [Remark] [nchar](200))//建立培訓(xùn)記錄表create table [dbo].[TrainRecord]( [RecordId] [int] identity(1,1) primary key not null, [ItemId] [int] references TrainItem(TrainId) not null, [JoinQuantity] [nchar](30), [Remark ] [nchar](200))//建立應(yīng)聘者信息表CREATE TABLE [dbo].[Interviewer]( [InterviewerId] [int] IDENTITY(1,1) NOT NULL, [InterviewerName] [nchar](20) NOT NULL, [InterDept] [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] [in
公司管理相關(guān)推薦
鄂ICP備17016276號-1