人力資源管理系統(tǒng)數(shù)據(jù)庫說明(編輯修改稿)
2025-05-05 08:43 本頁面
【文章內(nèi)容簡介】 000選項C12key_dvarchar5000選項D13key_evarchar5000選項E14correct_keyvarchar100正確答案表名：human_file序號列名數(shù)據(jù)類型長度標(biāo)識說明1huf_idint4是職員ID2first_kind_idvarchar50所屬一級機(jī)構(gòu)編號3first_kind_namevarchar60所屬一級機(jī)構(gòu)名字4second_kind_idvarchar50所屬二級機(jī)構(gòu)編號5second_kind_namevarchar60所屬二級機(jī)構(gòu)名字6third_kind_idvarchar50所屬三級機(jī)構(gòu)編號7third_kind_namevarchar60所屬三級機(jī)構(gòu)名字8human_namevarchar60員工名字9human_addressvarchar200員工地址10human_postcodevarchar10員工郵編11human_pro_designationvarchar6012human_major_idvarchar50職位編號13hunma_major_namevarchar60員工職位名稱14human_telephonevarchar20職工電話15human_mobilephonevarchar50手機(jī)號碼16human_bankvarchar50開戶銀行17human_accountvarchar30銀行卡號18human_qqvarchar1519human_varchar5020human_hobbyvarchar60業(yè)余愛好21human_specialityvarchar60專業(yè), 特長22human_sexvarchar5023human_religionvarchar50 宗教信仰24human_partyvarchar50黨籍25human_nationalityvarchar50國籍26human_racevarchar50名族27human_birthdaydatetime8生日28human_birthplacevarchar50出生地29human_agesmallint2年齡30human_educated_degreevarchar60教育程度31human_educated_yearssmallint2教育年限32human_educated_majorvarchar60所學(xué)專業(yè)33human_society_security_idvarchar30社保號碼34human_id_cardvarchar20身份證號35remarkvarchar5000備注36salary_standard_idint4工資標(biāo)準(zhǔn)編號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注冊時間46check_timedatetime8(getdate())復(fù)核時間47change_timedatetime8(getdate())更改時間48lastly_change_timedatetime8(getdate())最后修改的時間49delete_timedatetime8(getdate())刪除時間50recovery_timedatetime8(getdate())恢復(fù)時間51human_file_statusint4待刪除員工0注冊員工1待面試員工2面試通過員工3帶筆試員工4筆試通過員工5待入職員工6準(zhǔn)入職員工7正式員工8完整員工952hu_Numbervarchar5053human_typenvarchar50表名：major_change（職位變更）序號列名數(shù)據(jù)類型長度標(biāo)識主鍵說明1mch_idsmallint2是是主鍵2first_kind_idchar2原所在一級機(jī)構(gòu)3first_kind_namevarchar60原一級機(jī)構(gòu)名稱4second_kind_idchar2原二級機(jī)構(gòu)編號5second_kind_namevarchar60原二級機(jī)構(gòu)名字6third_kind_idchar2原三級機(jī)構(gòu)編號7third_kind_namevarchar60原三級機(jī)構(gòu)名字8major_id
公司管理相關(guān)推薦
鄂ICP備17016276號-1