人力資源管理系統(tǒng)數(shù)據(jù)庫(kù)說(shuō)明(編輯修改稿)
2025-05-05 08:43 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 000選項(xiàng)C12key_dvarchar5000選項(xiàng)D13key_evarchar5000選項(xiàng)E14correct_keyvarchar100正確答案表名：human_file序號(hào)列名數(shù)據(jù)類型長(zhǎng)度標(biāo)識(shí)說(shuō)明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開(kāi)戶銀行17human_accountvarchar30銀行卡號(hào)18human_qqvarchar1519human_varchar5020human_hobbyvarchar60業(yè)余愛(ài)好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面試通過(guò)員工3帶筆試員工4筆試通過(guò)員工5待入職員工6準(zhǔn)入職員工7正式員工8完整員工952hu_Numbervarchar5053human_typenvarchar50表名：major_change（職位變更）序號(hào)列名數(shù)據(jù)類型長(zhǎng)度標(biāo)識(shí)主鍵說(shuō)明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_id
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1