人力資源管理人力資源管理系統(tǒng)數(shù)據(jù)庫說明

1、（人力資源管理）人力資源 管理系統(tǒng)數(shù)據(jù)庫說明20XX年XX月多年的企業(yè)咨詢豉問經(jīng)驗(yàn).經(jīng)過實(shí)戰(zhàn)驗(yàn)證可以落地機(jī)行的卓越管理方案，值得您下載擁有數(shù)據(jù)庫名：Hr表名：bestirinfo（激勵(lì)信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位說明1bestirldint40主鍵，自增2bestirTypevarchar500激勵(lì)管理的類型3BestirContextvarchar50000激勵(lì)管理的內(nèi)容4human_idint40激勵(lì)的人編號(hào)5humanNamevarchar500激勵(lì)的人的名字表名：bonus表名：config_file_first_kind（系統(tǒng)管理中，壹級(jí)機(jī)構(gòu)）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵

2、允許空默認(rèn)值 說明1bon_idint40是是否獎(jiǎng)金信息2major_idchar20是職位ID3major_namevarchar600是職位名稱4human_idvarchar300是獎(jiǎng)勵(lì)人ID5human_nam evarchar600是獎(jiǎng)勵(lì)人名字6bonus_itemvarchar600是獎(jiǎng)勵(lì)項(xiàng)目7bonus_wort hmoney84是獎(jiǎng)金金額9remarktext160是備注信息10registervarchar600是注冊人11checkervarchar600是復(fù)核人12regist_timedatetime83是注冊時(shí)間13check_timedatetime83是復(fù)合時(shí)間1

3、4check_statu ssmallint20是復(fù)合狀態(tài)（0未通 過，1通過）序號(hào)列名數(shù)據(jù)類型長度小數(shù) 位標(biāo)識(shí)主鍵允許 空說明1ffk_idint40是是否壹級(jí)機(jī)構(gòu)編號(hào)2first_kind_namevarchar600是壹級(jí)機(jī)構(gòu)名字3key_manvarchar500是機(jī)構(gòu)負(fù)責(zé)人4first_descvarchar8000是機(jī)構(gòu)描述5isdeletebit10是（1）否（0）刪除6salary_grant_ma nvarchar500薪酬發(fā)放負(fù)責(zé)人表名：config_file_second_kind（二級(jí)機(jī)構(gòu)）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1second_kind_idint40是

4、是二級(jí)機(jī)構(gòu)編號(hào)2second_kind_na mevarchar600二級(jí)機(jī)構(gòu)名稱3second_kind_desvarchar50000二級(jí)機(jī)構(gòu)描述4isdeletebit10是（1）否（0）刪除5first_kind_idint40所屬壹級(jí)結(jié)構(gòu)編號(hào)6salary_grant_ma nvarchar500薪資發(fā)放人表名：config_file_third_kind（三級(jí)結(jié)構(gòu)）序 號(hào)列名數(shù)據(jù)類型長度小數(shù) 位標(biāo)識(shí)主鍵說明1third_kind_idint40是是三級(jí)機(jī)構(gòu)編號(hào)2second_kind_idint40所屬二級(jí)機(jī)構(gòu)編號(hào)3third_kind_namevarchar600三級(jí)機(jī)構(gòu)名稱4t

5、hird_kind_desvarchar30000三級(jí)機(jī)構(gòu)描述5third_kind_is_deletebit10是（1）否（0）刪除6salary_grant_manvarchar500薪資發(fā)放人表名：config_major（職位信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1major_idint40是是職位編號(hào)2major_namevarchar600職位名稱3major_desvarchar5000職位描述4Third_kind_idint4所屬部門表名：config_msg（系統(tǒng)消息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1msgidint40是是消息編號(hào)2msgcontextv

6、archar50000消息內(nèi)容3nsgSendMa nIdint40消息發(fā)送人4msgSnendManvarchar500消息發(fā)送人名稱5msgRceiveManvarchar500消息接受人6nsgRceiveIdint40消息接受人編號(hào)7sendTimedatetime83消息發(fā)送時(shí)間8isPublicbit10是否為共有消息（招聘考試題目分類）表名：config_question_first_kind序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1qfk_idint40是是題目大類編號(hào)2first_kind_namevarchar600細(xì)目大類名字3first_kind_desvarchar50

7、000題目大類描述（招聘考試題目小類）表名：config_question_second_kind表名：engage_answer（考試結(jié)果信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù) 位標(biāo)識(shí)主鍵說明1qsk_idint40是是題目小類編號(hào)2second_kind_na mevarchar600題目小類名稱3first_kind_idint40所屬大類編號(hào)序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1ans_idint40是是2exam_numb ervarchar300試卷編號(hào)3human_idint40考試人編號(hào)4human_nam evarchar600考試人名字5human_idca rdvarchar

8、300身份證號(hào)6major_idchar100職位I D7major_namechar100職位名字8test_timedatetime83測試時(shí)間9answersvarchar5000答案不同的題目的答案用| 隔開10total_pointnumeric52總分表名：engage_exam（試卷信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1exam_num berint40是是試卷編號(hào)2exam_nam evarchar500試卷名稱3subjectIdsvarchar500考題編號(hào)，所有的考題號(hào)碼， 用|隔開4usertimeint40考試用時(shí)5margeIdint40所屬職位表名：en

9、gage_interview（面試信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1ein_idsmallint20是是面試信息編號(hào)2human_idint40面試人3human_major_namevarchar300面試職位4native_language_degrevarchar200母語程度e5foreign_language_degr eevarchar200外語程度6response_speed_degreevarchar200反映程度7EQ_degreevarchar200EQ程度8IQ_degreevarchar200IQ程度9registervarchar600面試人10reg

10、iste_timedatetime83面試時(shí)間11interview_commenttext160面試評(píng)價(jià)12resultvarchar200面試結(jié)果13interview_numberint40面試次數(shù)14markvarchar200綜合素質(zhì)表名：engage_major_release（職位發(fā)布信息表）序號(hào)列名數(shù)據(jù)類型長度小數(shù) 位標(biāo)識(shí)主鍵說明1mre_idsmallint20是是主鍵2first_kind_idchar20職位所屬壹級(jí)結(jié)構(gòu)3first_kind_namevarchar600所屬壹級(jí)機(jī)構(gòu)名字4second_kind_idchar20所屬二級(jí)機(jī)構(gòu)編號(hào)5second_kind_n

11、a mevarchar600所屬二級(jí)機(jī)構(gòu)名字6third_kind_idchar20三級(jí)機(jī)構(gòu)編號(hào)7third_kind_namevarchar600三級(jí)機(jī)構(gòu)名字10major_idchar20職位ID11major_namevarchar600職位名稱12human_amountsmallint20招聘人數(shù)13engage_typevarchar600招聘類型14deadlinedatetime83截至?xí)r間15registervarchar600發(fā)布人16changervarchar600變更人17regist_timedatetime83發(fā)布時(shí)間18change_timedatetime83

12、修改時(shí)間19major_describetext160職位描述20engage_require dtext160招聘描述表名： engage_subjects（考試題目）序號(hào)列名數(shù)據(jù)類型長度小數(shù)標(biāo)識(shí)主鍵說明1sub_idint40是是考題編號(hào)2first_kind_idint40壹級(jí)機(jī)構(gòu)編號(hào)3first_kind_namevarchar600壹級(jí)機(jī)構(gòu)名字4second_kind_idint40二級(jí)機(jī)構(gòu)編號(hào)5second_kind_na mevarchar600二級(jí)機(jī)構(gòu)名字6registervarchar600出題人7regist_timedatetime83出題時(shí)間8contextvarcha

13、r10000題干部分9key_avarchar5000選項(xiàng)A10key_bvarchar5000選項(xiàng)B11key_cvarchar5000選項(xiàng)C12key_dvarchar5000選項(xiàng)D13key_evarchar5000選項(xiàng)E14correct_keyvarchar100正確答案表名：human_file序號(hào)列名數(shù)據(jù)類型長度標(biāo)識(shí)說明1huf_idint4是職員ID2first_kind_idvarchar50所屬壹級(jí)機(jī)構(gòu)編號(hào)3first_kind_namevarchar60所屬壹級(jí)機(jī)構(gòu)名字4second_kind_idvarchar50所屬二級(jí)機(jī)構(gòu)編號(hào)5second_kind_namevar

14、char60所屬二級(jí)機(jī)構(gòu)名字6third_kind_idvarchar50所屬三級(jí)機(jī)構(gòu)編號(hào)7third_kind_namevarchar60所屬三級(jí)機(jī)構(gòu)名字8human_namevarchar60員工名字9human_addressvarchar200員工地址10human_postcodevarchar10員工郵編11human_pro_designatio nvarchar6012human_major_idvarchar50職位編號(hào)13hunma_major_namevarchar60員工職位名稱14human_telephonevarchar20職工電話15human_mobileph

15、onevarchar50手機(jī)號(hào)碼16human_bankvarchar50開戶銀行17human_accountvarchar30銀行卡號(hào)18human_qqvarchar1519human_emailvarchar5020human_hobbyvarchar60業(yè)余愛好21human_specialityvarchar60專業(yè)，特長22human_sexvarchar5023human_religionvarchar50宗教信仰24human_partyvarchar50黨籍25human_nationalityvarchar50國籍26human_racevarchar50名族27huma

16、n_birthdaydatetim e8生日28human_birthplacevarchar50出生地29human_agesmallint2年齡30human_educated_degr eevarchar60教育程度31human_educated_yearssmallint2教育年限32human_educated_majo rvarchar60所學(xué)專業(yè)33human_society_securit y_idvarchar30社保號(hào)碼34human_id_cardvarchar20身份證號(hào)35remarkvarchar5000備注36salary_standard_idint4工資標(biāo)準(zhǔn)

17、編號(hào)37salary_standard_namevarchar60工資標(biāo)準(zhǔn)名稱38salary_summoney8基本工資39human_histroy_recordstext16職員履歷表40human_family_membe rshiptext16家庭關(guān)系41human_picturevarchar255員工圖片42registervarchar60登記人43checkervarchar60復(fù)核人44changervarchar60更改人45regist_timedatetim e8注冊時(shí)間46check_timedatetim e8(getdate()復(fù)核時(shí)間47change_time

18、datetim e8(getdate()更改時(shí)間48lastly_change_timedatetim e8(getdate()最后修改的時(shí)間49delete_timedatetim e8(getdate()刪除時(shí)間50recovery_timedatetim e8(getdate()恢復(fù)時(shí)間51human_file_statusint4待刪除員工0注冊員工1待面試員工2面試通過員工3帶筆試員工4筆試通過員工5待入職員工6準(zhǔn)入職員工7正式員工8完整員工952hu_Numbervarchar5053human_typenvarchar50表名：major_change (職位變更)序 號(hào)列名數(shù)據(jù)

19、類型長 度標(biāo) 識(shí)主 鍵說明1mch_idsmallint2是是主鍵2first_kind_idchar2原所于壹級(jí)機(jī)構(gòu)3first_kind_namevarchar60原壹級(jí)機(jī)構(gòu)名稱4second_kind_idchar2原二級(jí)機(jī)構(gòu)編號(hào)5second_kind_namevarchar60原二級(jí)機(jī)構(gòu)名字6third_kind_idchar2原三級(jí)機(jī)構(gòu)編號(hào)7third_kind_namevarchar60原三級(jí)機(jī)構(gòu)名字8major_idchar2原職位編號(hào)9major_namevarchar60原職位名字10new_first_kind_idchar2新壹級(jí)機(jī)構(gòu)編號(hào)11new_first_kind

20、_namevarchar60新壹級(jí)機(jī)構(gòu)名字12new_second_kind_idchar2新二級(jí)機(jī)構(gòu)編號(hào)13new_second_kind_namevarchar60新二級(jí)機(jī)構(gòu)名字14new_third_kind_idchar2新三級(jí)機(jī)構(gòu)編號(hào)15new_third_kind_namevarchar60新三級(jí)機(jī)構(gòu)名字16new_major_idchar2新職位ID17new_major_namevarchar60新職位名字18human_idvarchar30員工編號(hào)19human_namevarchar60員工名字20salary_standard_idvarchar30原工資標(biāo)準(zhǔn)ID21s

21、alary_standard_namevarchar60原工資標(biāo)準(zhǔn)名字22salary_summoney8原工資總額23new_salary_standard_idvarchar30新工資標(biāo)準(zhǔn)ID24new_salary_standard_na mevarchar60新工資標(biāo)準(zhǔn)名字25new_salary_summoney8新工資總額26change_reasontext16轉(zhuǎn)職原因27check_reasontext16復(fù)合意見28check_statussmallint2復(fù)核狀態(tài)29registervarchar60登記人30checkervarchar60復(fù)核人31regist_time

22、datetime8登記時(shí)間32check_timedatetime8復(fù)核時(shí)間表名：pay_delails序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵說明1base_paymoney84基本工資2standard dint40是主鍵，自增3traffic_paymoney84交通補(bǔ)助4msg_paymoney84通訊補(bǔ)助5direft_paymoney84浮動(dòng)工資6commonmoney84常規(guī)7lunch_paymoney84午餐步驟8year_paymoney84交通補(bǔ)助9car_paymoney84車補(bǔ)表名：salary_grant（工資發(fā)放信息）表名：salary_grant_details（薪資

23、發(fā)放明細(xì)）序號(hào)列名數(shù)據(jù)類型長度標(biāo)識(shí)主鍵說明1sgr_idsmallint2是主鍵自增2salary_grant_idvarchar30發(fā)放編號(hào)按照時(shí)間自動(dòng)生成4first_kind_idchar2壹級(jí)機(jī)構(gòu)編號(hào)5first_kind_namevarchar60壹級(jí)機(jī)構(gòu)名稱6second_kind_idchar2二級(jí)結(jié)構(gòu)編號(hào)7second_kind_namevarchar60二級(jí)機(jī)構(gòu)名稱8third_kind_idchar2三級(jí)機(jī)構(gòu)編號(hào)9third_kind_namevarchar60三級(jí)機(jī)構(gòu)名稱10human_amountsmallint2職工人數(shù)11salary_standard_su mmo

24、ney8標(biāo)準(zhǔn)工資總數(shù)12salary_paid_summoney8實(shí)際發(fā)放總數(shù)13registervarchar60登記人數(shù)14regist_timedatetime8登記時(shí)間15checkervarchar60復(fù)核人16check_timedatetime8復(fù)核時(shí)間17check_statussmallint2狀態(tài)（復(fù)核1未復(fù)核0）序 號(hào)列名數(shù)據(jù)類型長度標(biāo)識(shí)主鍵說明1grd_idsmallint2是明細(xì)主鍵2salary_grant_idvarchar30發(fā)放明細(xì)編號(hào)3human_idvarchar30員工ID4human_namevarchar60員工名稱6sale_summoney8個(gè)人

25、工資總額7deduct_summoney8扣除總額8salary_standard_su mmoney8標(biāo)準(zhǔn)總額salary_paid_summoney8實(shí)際工資總額表名：salary_standard序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1standard_idint40是是否2standard_na mevarchar600是工資標(biāo) 準(zhǔn)名稱3designervarchar600是制定人5checkervarchar600是復(fù)核人6changervarchar600是修改人7regist_timedatetime83是制定時(shí) 間8check_timedatetime83是復(fù)核時(shí)間

26、9change_timedatetime83是修改時(shí) 間10salary_summoney84是總金額11check_statussmallint20是狀態(tài)13check_comm enttext160是復(fù)核說 明14remarktext160是備注表名：salary_standard_details序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1standard_idvarchar300否2standard_na mevarchar600是標(biāo)準(zhǔn)名 稱3item_namevarchar600是項(xiàng)目名稱4salarymoney84否總金額5S_idint40是是否表名：training序號(hào)列

27、名數(shù)據(jù)類型長度小數(shù) 位標(biāo)識(shí)主鍵允許 空默認(rèn) 值說明1tra_idint40是是否課程名稱2trining_humanNamevarchar500是培訓(xùn) 師3training_itemvarchar600是培訓(xùn)項(xiàng)目4training_timedatetime83是培訓(xùn) 時(shí)間5training_hourint40是培訓(xùn)周期6training_degreevarchar600是培訓(xùn) 方式7registervarchar600是歷史 培訓(xùn) 記錄8regist_timedatetime83是歷史培訓(xùn) 時(shí)間9remarktext160是培訓(xùn) 反饋表名：training_feedback序號(hào)列名數(shù)據(jù)類型長度小數(shù)位標(biāo)識(shí)主鍵允許 空默認(rèn) 值說明1t_idint40是否2h_idint40否3Satisfactionint40否此次 培訓(xùn) 滿意 程度 等級(jí) 1-54interestin