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

數(shù)據(jù)庫(kù)名：Hr表名：bestirinfo（激勵(lì)信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位說明1bestirIdint40主鍵，自增2bestirTypevarchar500激勵(lì)管理的類型3BestirContextvarchar50000激勵(lì)管理的內(nèi)容4human_idint40激勵(lì)的人編號(hào)5humanNamevarchar500激勵(lì)的人的名字表名：bonus序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1bon_idint40是是否獎(jiǎng)金信息2major_idchar20是職位ID3major_namevarchar600是職位名稱4human_idvarchar300是獎(jiǎng)勵(lì)人ID5human_namevarchar600是獎(jiǎng)勵(lì)人名字6bonus_itemvarchar600是獎(jiǎng)勵(lì)項(xiàng)目7bonus_worthmoney84是獎(jiǎng)金金額9remarktext160是備注信息10registervarchar600是注冊(cè)人11checkervarchar600是復(fù)核人12regist_timedatetime83是注冊(cè)時(shí)間13check_timedatetime83是復(fù)合時(shí)間14check_statussmallint20是復(fù)合狀態(tài)（0未通過，1通過）表名：config_file_first_kind（系統(tǒng)管理中，一級(jí)機(jī)構(gòu)）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(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_manvarchar500薪酬發(fā)放負(fù)責(zé)人表名：config_file_second_kind（二級(jí)機(jī)構(gòu)）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1second_kind_idint40是是二級(jí)機(jī)構(gòu)編號(hào)2second_kind_namevarchar600二級(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_manvarchar500薪資發(fā)放人表名：config_file_third_kind（三級(jí)結(jié)構(gòu)）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(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)名稱4third_kind_desvarchar30000三級(jí)機(jī)構(gòu)描述5third_kind_is_deletebit10是（1）否（0）刪除6salary_grant_manvarchar500薪資發(fā)放人表名：config_major（職位信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1major_idint40是是職位編號(hào)2major_namevarchar600職位名稱3major_desvarchar5000職位描述4Third_kind_idint4所屬部門表名：config_msg（系統(tǒng)消息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1msgidint40是是消息編號(hào)2msgcontextvarchar50000消息內(nèi)容3nsgSendManIdint40消息發(fā)送人4msgSnendManvarchar500消息發(fā)送人名稱5msgRceiveManvarchar500消息接受人6nsgRceiveIdint40消息接受人編號(hào)7sendTimedatetime83消息發(fā)送時(shí)間8isPublicbit10是否為共有消息表名：config_question_first_kind（招聘考試題目分類）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1qfk_idint40是是題目大類編號(hào)2first_kind_namevarchar600細(xì)目大類名字3first_kind_desvarchar50000題目大類描述表名：config_question_second_kind（招聘考試題目小類）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1qsk_idint40是是題目小類編號(hào)2second_kind_namevarchar600題目小類名稱3first_kind_idint40所屬大類編號(hào)表名：engage_answer（考試結(jié)果信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1ans_idint40是是2exam_numbervarchar300試卷編號(hào)3human_idint40考試人編號(hào)4human_namevarchar600考試人名字5human_idcardvarchar300身份證號(hào)6major_idchar100職位7major_namechar100職位名字8test_timedatetime83測(cè)試時(shí)間9answersvarchar5000答案不同的題目的答案用|隔開10total_pointnumeric52總分表名：engage_exam（試卷信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1exam_numberint40是是試卷編號(hào)2exam_namevarchar500試卷名稱3subjectIdsvarchar500考題編號(hào)，所有的考題號(hào)碼，用|隔開4usertimeint40考試用時(shí)5margeIdint40所屬職位表名：engage_interview（面試信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1ein_idsmallint20是是面試信息編號(hào)2human_idint40面試人3human_major_namevarchar300面試職位4native_language_degreevarchar200母語程度5foreign_language_degreevarchar200外語程度6response_speed_degreevarchar200反映程度7EQ_degreevarchar200EQ程度8IQ_degreevarchar200IQ程度9registervarchar600面試人10registe_timedatetime83面試時(shí)間11interview_commenttext160面試評(píng)價(jià)12resultvarchar200面試結(jié)果13interview_numberint40面試次數(shù)14markvarchar200綜合素質(zhì)表名：engage_major_release（職位發(fā)布信息表）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(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_namevarchar600所屬二級(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修改時(shí)間19major_describetext160職位描述20engage_requiredtext160 招聘描述表名：engage_subjects（考試題目）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(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_namevarchar600二級(jí)機(jī)構(gòu)名字6registervarchar600出題人7regist_timedatetime83出題時(shí)間8contextvarchar10000題干部分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ù)類型長(zhǎng)度標(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_namevarchar60所屬二級(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_designationvarchar6012human_major_idvarchar50職位編號(hào)13hunma_major_namevarchar60員工職位名稱14human_telephonevarchar20職工電話15human_mobilephonevarchar50手機(jī)號(hào)碼16human_bankvarchar50開戶銀行17human_accountvarchar30銀行卡號(hào)18human_qqvarchar1519human_emailvarchar5020human_hobbyvarchar60業(yè)余愛好21human_specialityvarchar60專業(yè), 特長(zhǎng)22human_sexvarchar5023human_religionvarchar50 宗教信仰24human_partyvarchar50黨籍25human_nationalityvarchar50國(guó)籍26human_racevarchar50名族27human_birthdaydatetime8生日28human_birthplacevarchar50出生地29human_agesmallint2年齡30human_educated_degreevarchar60教育程度31human_educated_yearssmallint2教育年限32human_educated_majorvarchar60所學(xué)專業(yè)33human_society_security_idvarchar30社保號(hào)碼34human_id_cardvarchar20身份證號(hào)35remarkvarchar5000備注36salary_standard_idint4工資標(biāo)準(zhǔn)編號(hào)37salary_standard_namevarchar60工資標(biāo)準(zhǔn)名稱38salary_summoney8基本工資39human_histroy_recordstext16職員履歷表40human_family_membershiptext16家庭關(guān)系41human_picturevarchar255員工圖片42registervarchar60登記人43checkervarchar60復(fù)核人44changervarchar60更改人45regist_timedatetime8注冊(cè)時(shí)間46check_timedatetime8(getdate()復(fù)核時(shí)間47change_timedatetime8(getdate()更改時(shí)間48lastly_change_timedatetime8(getdate()最后修改的時(shí)間49delete_timedatetime8(getdate()刪除時(shí)間50recovery_timedatetime8(getdate()恢復(fù)時(shí)間51human_file_statusint4待刪除員工0注冊(cè)員工1待面試員工2面試通過員工3帶筆試員工4筆試通過員工5待入職員工6準(zhǔn)入職員工7正式員工8完整員工952hu_Numbervarchar5053human_typenvarchar50表名：major_change（職位變更）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度標(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_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)ID21salary_standard_namevarchar60原工資標(biāo)準(zhǔn)名字22salary_summoney8原工資總額23new_salary_standard_idvarchar30新工資標(biāo)準(zhǔn)ID24new_salary_standard_namevarchar60新工資標(biāo)準(zhǔn)名字25new_salary_summoney8新工資總額26change_reasontext16轉(zhuǎn)職原因27check_reasontext16復(fù)合意見28check_statussmallint2復(fù)核狀態(tài)29registervarchar60登記人30checkervarchar60復(fù)核人31regist_timedatetime8登記時(shí)間32check_timedatetime8復(fù)核時(shí)間表名：pay_delails序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵說明1base_paymoney84基本工資2standard_idint40是主鍵，自增3traffic_paymoney84交通補(bǔ)助4msg_paymoney84通訊補(bǔ)助5direft_paymoney84浮動(dòng)工資6commonmoney84常規(guī)7lunch_paymoney84午餐步驟8year_paymoney84交通補(bǔ)助9car_paymoney84車補(bǔ)表名：salary_grant（工資發(fā)放信息）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度標(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_summoney8標(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）表名：salary_grant_details（薪資發(fā)放明細(xì)）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度標(biāo)識(shí)主鍵說明1grd_idsmallint2是明細(xì)主鍵2salary_grant_idvarchar30發(fā)放明細(xì)編號(hào)3human_idvarchar30員工ID4human_namevarchar60員工名稱6sale_summoney8個(gè)人工資總額7deduct_summoney8扣除總額8salary_standard_summoney8標(biāo)準(zhǔn)總額 salary_paid_summoney8實(shí)際工資總額表名：salary_standard序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1standard_idint40是是否2standard_namevarchar600是工資標(biāo)準(zhǔn)名稱3designervarchar600是制定人5checkervarchar600是復(fù)核人6changervarchar600是修改人7regist_timedatetime83是制定時(shí)間8check_timedatetime83是復(fù)核時(shí)間9change_timedatetime83是修改時(shí)間10salary_summoney84是總金額11check_statussmallint20是狀態(tài)13check_commenttext160是復(fù)核說明14remarktext160是備注表名：salary_standard_details序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1standard_idvarchar300否2standard_namevarchar600是標(biāo)準(zhǔn)名稱3item_namevarchar600是項(xiàng)目名稱4salarymoney84否總金額5S_idint40是是否表名：training序號(hào)列名數(shù)據(jù)類型長(zhǎng)度小數(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ù)類型長(zhǎng)度小數(shù)位標(biāo)識(shí)主鍵允許空默認(rèn)值說明1t_idint40是否2h_idint40否3Satisfactionint40否此次培訓(xùn)滿意程度等級(jí)1-54