人事工資考勤管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)

TOC\o"1-5"\h\z目00 11^4( 1??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????1參考資料 12. ?????? 1類型劃分 1標(biāo)識符和約定 1數(shù)據(jù)庫表設(shè)計(jì)格式說明 2支持軟件 2結(jié)構(gòu)設(shè)計(jì) 3運(yùn)用設(shè)計(jì) 3數(shù)據(jù)字典設(shè)計(jì) 3安全保密設(shè)計(jì) 9引言1.1編寫目的本數(shù)據(jù)庫設(shè)計(jì)說明書是為了概要設(shè)計(jì)的數(shù)據(jù)結(jié)構(gòu)進(jìn)行設(shè)計(jì)的，為后期工作打下的目的，指出預(yù)期的讀者。1.2背景1.3定義無1.4參考資料《人事工資考勤管理系統(tǒng)用戶需求說明書》外部設(shè)計(jì)2.1類型劃分表格清單序名稱代碼號

1上班簽到ChecklnRecord2下班簽離CheckOutRecord3獎(jiǎng)懲記錄IncentivcPenalty4獎(jiǎng)懲配置表IncentivePenaltyDisposition5簽到類型CheckType6機(jī)構(gòu)層次Department7離職Dimmision8職務(wù)工資表Duty9員工Employee10請假登記LeaveRecord11請假類型Leaveiype12公文流動(dòng)FileFlow13請假單LEAVEBILLS14請假單審批LEAVE.CHECK15請假流程配置LEAVEFLOWSCONFIG16批準(zhǔn)標(biāo)識Ratify17調(diào)動(dòng)Move18民族Nation19政治面貌Status20學(xué)歷Title21工資結(jié)算Wage22工資類型VVageType23雇用類型Workiype24表名職稱TechnicalPost25配置表config2.2標(biāo)識符和約定無2.3數(shù)據(jù)庫表設(shè)計(jì)格式說明數(shù)據(jù)庫表的要素包括表名、表描述、字段名、字段類型、主鍵。字段描述是否允許為空、長度。2.4支持軟件無

3.結(jié)構(gòu)設(shè)計(jì)4.ER圖PKOul>DtfylDDus^fKWWWPKRtwMIDFK2DnHDCtetMAah^FKIO?lTwPKCMT?pelI>OxvkTjpcOKainRccmlFK2E"IDQwkD次MUChdlfl^pe|_gIPKSutssIDHdtmTktelDTitleMuKgw幢 InxntfveFault}IncPtn(MI)^IhNMKj、"個(gè)FiWlg噸SDLcatrTypePKUa^Isptll)FK4Empkyoli：IDGrd?KItnpIDOfiprUVXpMmv阪IK2FK3WWI：Wc<kT3.結(jié)構(gòu)設(shè)計(jì)4.ER圖PKOul>DtfylDDus^fKWWWPKRtwMIDFK2DnHDCtetMAah^FKIO?lTwPKCMT?pelI>OxvkTjpcOKainRccmlFK2E"IDQwkD次MUChdlfl^pe|_gIPKSutssIDHdtmTktelDTitleMuKgw幢 InxntfveFault}IncPtn(MI)^IhNMKj、"個(gè)FiWlg噸SDLcatrTypePKUa^Isptll)FK4Empkyoli：IDGrd?KItnpIDOfiprUVXpMmv阪IK2FK3WWI：Wc<kT?reH心W?ccBmmUk：Mni*Eir1>lxawMhts/Vb^xeMniB氾心rMiiRcviAiAmPuifthTNilW#岫飯ErdX(Xrt>W^YtiM)dh\DtftfwetiI'KDtpIDkjwtJTCTilDDefonnmiFKIHgDtfUUKMlDSoA*NMkolDNifiwPbghyTcduS響DWofVTJBDDuylDSuiatIDFdklDGraitAie&ftMlbigPktircluiyliWcrdUjidUatfdPKFKIF心KccnNIDED心叫KcpnlXcLadkie岫ctmxEgtocR:t￡hsT}pciirfVrnivYraExinhdDbuniutfiDL^wTjprlD喚VgyFikl>)<rt(h>FikRAtifyfl)RiiifyRitify>>.rjhsdIMmaiOKiinFKILnpU)ikfurweuTide財(cái)W(rnif.kaT}fvhDik：IXrrmwailWcTcctms^bUTNineT*小PKW5rcWuxMorcy5.運(yùn)用設(shè)計(jì)5.1數(shù)據(jù)字典設(shè)計(jì)1.表名上班簽到(ChecklnRecord)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1RecordID流水號Int是2EmpID員工編號Int外鍵

3CheckDate簽到時(shí)間datatime否4Checkl>pe簽到類型int外鍵2.表名下班簽髙ICheckOutRecord)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1RecordID自動(dòng)編號Int是2EmpID員工編號Int外鍵3CheckOutDate簽離時(shí)間datatime否4CheckType簽離類型int外鍵3.獎(jiǎng)懲記錄表(IncentivePenalty)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1IncPenDisID獎(jiǎng)懲流水號Int主鍵2EmpID員工流水號Int員工外鍵3IncPenDisType獎(jiǎng)懲類型Varchar(50)4IncPenDisCount獎(jiǎng)懲金額money5IncPenDisYear獎(jiǎng)懲年月日datatime6DepID部門標(biāo)識int部門表外鍵4,獎(jiǎng)懲配置表(IncentivePenaltyDisposition)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1IncPenDisID獎(jiǎng)懲編號int主鍵2IncPenDisType獎(jiǎng)懲類型Varchar(50)3IncPenDisCount獎(jiǎng)懲金額money5.表名簽到類型（CheckType）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1CheckTypelD簽到編號Int是2CheckType簽到類型varchar(50)否6.表名機(jī)構(gòu)層次表（Department）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1DepID部門流水號int2DepartmentID部門編號int是3Department部門名稱varchar(50)否4Higher上級標(biāo)識int上級流水號7.表名高職(Dimmision)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）DimniisionlD流水號Int（員工表外鍵）

2EmpID員工流水號int自増3Department離職員工部門varchar(50)4Title高職員工職稱varchar(SO)5Duty離職員工職務(wù)varchar(50)6DimmisionType高職員工類型varchar(50)否7InDate入職時(shí)間datatime否8DimmisionDate離職時(shí)間datatime否8.表名職務(wù)工資表（Duty）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1Duty流水號int主鍵2DutylD職務(wù)編號Int3DutyName職務(wù)名稱varchar(50)否4BasicVVage職務(wù)基本工資money否9.表名員工(Employee)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1EmpID流水號int主鍵2EmployeelD員工編號varchar(lO)惟一標(biāo)識3IDCard身份證號碼varchar(18)否4EmployeeName員工姓名varchar(20)否5DepartmentlD部門流水號Int外鍵6Sex性別bit否7Age年齡Int否?NationID民族Int外鍵9NativePlaceday出生年月datatime否10TechnicalPostlD職稱Int外鍵11WorkTypelD雇用類型Int外鍵12DutylD職務(wù)Int外鍵13StatusII)政治面貌Int外鍵14TitlelD學(xué)歷Int外鍵15GraduateSchool畢業(yè)學(xué)校varchar(50)否16InDate入職時(shí)間datatime否17Picture員工相片image否18EmpIsVVord員工是否在職int(0,l,2)10.表名請假登記（LeaveRecord）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1RecordID編號Int主鍵

2EmpID員工流水號Int外?。▎T工表流水號）3LeaveType請假類型int外鍵4BeginDate請假時(shí)間datatime否5EndDate銷假時(shí)間datatime否6Days請假天數(shù)Int否7Remark請假事由varchar(50)否8LeaveDate核定請假天數(shù)float否9LeaveState請假狀態(tài)int0_申請，1—批準(zhǔn)2一終審,3一拒絕11.表名請假類型（LeaveType）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1LeaveTypelD編號Int主鍵2LeaveType請假類型varchar(50)否3LeaveDay額定請假天數(shù)int按年計(jì)算4LeaveMoney請假扣款float超出額定天數(shù)，每天所扣金額12.表名請假單(LEAVEBILLS)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1leavebillid流水號intPK2leavebillno編號varchar(50)唯一3leavebillbegindate假期開始日期datetime4leavebillbegintime開始時(shí)間int5leavebillenddate假期結(jié)束日期datetime6leavebillendtime結(jié)束時(shí)間int7leavebi1lproposerid申請人intFK8leavebillcause原由varchar(500)9leavebilldays請假天數(shù)int10leavebilltype請假類型intFK

13.哀名請假審批（LEAVECHECK）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1leavecheckid流水號intPK2leavebi11id編號varchar3leaveproposerid申請人intFK4checkemployeeid審批人intFK5checkemployeelevel審批級別int6check_type審批意見int1為同意，0為不同意14.表名請假單(LEAVEFLOWSCONFIG)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1Flowsid流水號uniqueidentifierPK2Duty職務(wù)intFK3Flows_Level級別int從1開始并為心級4Flows_Days可審批權(quán)限天數(shù)int5createUser創(chuàng)建人varchar6createDate創(chuàng)建日期datetime7modifyUser修改人varchar8modifyDate修改日期datetime15,公文流動(dòng)?(FileFlow)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1FileFlowID流水號Int主鍵2Examine考核《1*號Int3ExaminelD被考核考流水號Int4LeaveTypelD文件類型編號Int請假類型表外鍵5FileUppcrDay公文上交日期Datatime6FileDownDay公文批準(zhǔn)日期Datatime7FiieRatifylD公文批準(zhǔn)標(biāo)識int批準(zhǔn)標(biāo)識表外鍵16.批準(zhǔn)標(biāo)識表（Ratify）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1RatifylD批準(zhǔn)標(biāo)識Int2Ratify批準(zhǔn)內(nèi)容Varchar(SO)

17.表名調(diào)珈Move）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1MoveNO編號Int主鍵2EmpID員工流水號Int員工表（外鍵）3OriginalDep原來部門varchar(SO)否4PresentDepvarchar(SO)否5Date調(diào)走時(shí)間int否18.表名民族(Nation)序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1NationlD民族編號Int是2NationNanie民族名稱varchar(50)否19.哀名政治面貌（Status）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1StatusID編號Int是2StatusName政治面貌varchar(lO)否20.表名學(xué)歷（Title）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1TitlelD編號Int主鍵2TitleName學(xué)歷名稱varchar(50)否3TitleWage學(xué)歷工資money21.表名工資結(jié)算（Wage）序號列名含義數(shù)據(jù)類型是否主鍵（外鍵）1WagelD編號Int主鍵2EmpID員工編號Int外鍵3BasicWage基本工資money否4Bonus獎(jiǎng)金money否5LateMinus遲到罰款money6EarlyLeaveMinus早退罰款money7AbsenceMinus缺勤罰款money8SickLeaveMinus病假罰款money9AfTairLeaveMinus事假罰款money10RewardAndPunish獎(jiǎng)罰合計(jì)money否11TotaIVVage工資總計(jì)money否12BeginDate超始時(shí)間datatime否

13EndDate截止時(shí)間datatime否14Dates工作天數(shù)int否15WageYearMonDay年月日datatime22.表名工資類型（WageType）序號列名含義數(shù)據(jù)類型是否主?。ㄍ饨。?WageTypelD編號Int主鍵2WageType工資類型varchar(50)否3Money金額money否23.表名雇用類型（V