【正文】
nchar](30)可為空Remark備注[nchar](200)可為空Dept(部門表)DeptID部門編號(hào)int不為空,自動(dòng)增長(zhǎng),主鍵DeptName部門名字[nchar](10)不為空DeptManager部門經(jīng)理[nchar](20)不為空Introduction部門簡(jiǎn)介[nchar](200)可為空StaffQuantity員工數(shù)量[nchar](10)不為空Position(職務(wù)表)PositionId職務(wù)編號(hào)int不為空,自動(dòng)增長(zhǎng),主鍵PositionName職務(wù)名稱[nchar](10)不為空Introduction職務(wù)簡(jiǎn)介[nchar](200)可為空RewardPunishment(獎(jiǎng)懲表)RePunId獎(jiǎng)懲編號(hào)int不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)int不為空,Staff表外鍵ReOrPu獎(jiǎng)懲類別int不為空,CategoryInfo表外鍵Time獎(jiǎng)懲時(shí)間[datetime]不為空Title主題[nchar](30)不為空Content獎(jiǎng)懲內(nèi)容[nchar](200)不為空TrainItem(培訓(xùn)課程表)ItemId課程編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵ItemName課程名稱[nchar](20)不為空CategoryId類別編號(hào)[int]不為空,Category表外鍵StartTime開始時(shí)間[datetime]不為空FinishTime結(jié)束時(shí)間[datetime]不為空Cost費(fèi)用[nchar](10)可為空Place地點(diǎn)[nchar](20)可為空Sponsor主辦方[nchar](30)可為空Lecturer講師[nchar](30)可為空TrainScore(培訓(xùn)成績(jī)表ScoreId成績(jī)編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵ItemId課程編號(hào)[int]不為空,TrainItem表外鍵Score成績(jī)[int]不為空Contract(合同表)ContractId合同編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵StartTime開始時(shí)間[datetime]不為空FinishTime結(jié)束時(shí)間[datetime]不為空 Remark備注[nchar](200)可為空Dimission(離職表)DimissionId離職編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[nchar](20)不為空,Staff表外鍵DimissionTime離職時(shí)間[datetime]不為空DimissionReason離職理由[nchar](200)不為空PositionTransfer(員工調(diào)動(dòng)表)TransferId調(diào)動(dòng)編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵PresentDept調(diào)后部門[int]不為空,Category表外鍵PastDept調(diào)前部門[int]不為空,Category表外鍵PresentPosition調(diào)后職務(wù)[int]不為空,Category表外鍵PastPosition調(diào)前職務(wù)[int]不為空,Category表外鍵TransfeTime調(diào)動(dòng)時(shí)間[datetime]不為空TransferReason調(diào)動(dòng)原因[nchar](100)可為空LackPosition(缺員表)LackPositionId缺員編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵 DeptId缺員部門[int]不為空,Dept表外鍵LackPosition缺員職務(wù)[int]不為空,Position表外鍵LackQuantity缺員總量[nchar](20)不為空OtherRequire其他要求[nchar](100)可為空RecuitRecord(招聘記錄表)RecordId招聘記錄編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵RecruitTime招聘時(shí)間[datetime]不為空DeptId部門編號(hào)[int]不為空,Dept表外鍵NeedQuantity需要總量[int]不為空Remark備注[nchar](200)可為空TrainRecord(培訓(xùn)記錄表)RecordId培訓(xùn)記錄編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵ItemId培訓(xùn)項(xiàng)目編號(hào)[int]不為空,TrainItem表外鍵JoinQuantity參加人數(shù)[nchar](30)不為空Remark備注[nchar](200)可為空Interviewer(應(yīng)聘者信息表)InterviewerId應(yīng)聘者編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵InterviewerName應(yīng)聘者姓名[nchar](20)不為空InterDept應(yīng)聘部門[int]不為空,Dept表外鍵InterPosition應(yīng)聘職務(wù)[int]不為空,Position表外鍵Speciality專業(yè)[nchar](30)不為空Sex性別[int]不為空,CategoryInfo表外鍵Education學(xué)歷[int]不為空,CategoryInfo表外鍵IdCardNo身份證號(hào)碼[nchar](20)不為空MobilePhone移動(dòng)電話[nchar](20)不為空TelPhone固話[nchar](20)可為空號(hào)碼[nchar](10)可為空Email電子郵件[nchar](30)可為空Remark備注[nchar](200)可為空CertificateInfo(員工駕證信息表)CertificateId駕證編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵CeQuantity駕證數(shù)量[int]不為空Remark備注[nchar](200)可為空FamilyInfo(員工家庭情況信息表)FamilyId家庭情況表編號(hào)[int] 不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int] 不為空,Staff表外鍵SpouseName配偶姓名[nchar](20)可為空 Telephone聯(lián)系電話[nchar](20)可為空ChildQuantity小孩數(shù)量[int] 可為空InhabitInfo(員工住宿表)InhabitId住宿情況編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵InhabitOrNot是否住宿[nchar](2)不為空RoomNo房間號(hào)碼[int]可為空DeptManager(部門經(jīng)理列表)Id列表編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵 DeptId 部門編號(hào)[int]不為空,Dept表外鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵Remark備注[nchar](50)可為空IncreasePromotion(加薪升職統(tǒng)計(jì)表)InPrId加薪升職統(tǒng)計(jì)表編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵IncreaseOrNot是否加薪[nchar](2)不為空PromotionOrNot是否升職[nchar](2)不為空Remark備注[nchar](200)可為空Business(業(yè)務(wù)考核統(tǒng)計(jì)表)BusinessId編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵AssignQuantity預(yù)計(jì)業(yè)務(wù)量[nchar](30)不為空ReachQuantity達(dá)到業(yè)務(wù)量[nchar](30)不為空Remark備注[nchar](200)可為空Attendence(考勤表)AttendenceId考勤表編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵AbsenceTime缺勤時(shí)間[datetime]不為空AbsenceCategory缺勤類別[int]不為空Attention(自動(dòng)提醒列表)AttentionId自動(dòng)提醒列表編號(hào)[int]不為空,自動(dòng)增長(zhǎng),主鍵AttentionCategory提醒類別[int]不為空,CategoryInfo表外鍵StaffId員工編號(hào)[int]不為空,Staff表外鍵Remark備注[nchar](100)不為空,自動(dòng)增長(zhǎng),主鍵Salary(工資表)SalaryId工資表編號(hào)[int]不為空,Staff表外鍵StaffId員工編號(hào)[int]不為空BasicSalary基本工資[Float]不為空Prize獎(jiǎng)金[Float]不為空TimingSalary計(jì)時(shí)工資[Float]不為空PieceSalary計(jì)件工資[Float]不為空Welfare福利[Float]不為空Insurance保險(xiǎn)[Float]不為空Tax所得稅[Float]不為空FactSalary實(shí)發(fā)工資[Float]不為空//建數(shù)據(jù)庫(kù)create database Permanagement on primary( name=Permanagement_data1, filename=39。, SIZE=1MB, MAXSIZE=5MB, FILEGROWTH=1MB)GO//建用戶表create table UserInfo( UserId int not null identity(1,1) primary key, UserName nchar(30) not null, password nchar(30) not null, Confim nchar(30) not null, ScaptPassword nchar(50) not null, Answer nchar(30) not null, Sex char(2) not null, Email nchar(30) not null, MobilePhone char(11) not nul