人力資源管理系統(tǒng)數(shù)據(jù)庫說明-wenkub
2023-04-23 08:43:27 本頁面
【正文】 題目小類編號(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_menttext160面試評(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_cvarchar
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1