薪資廠商資訊:代號/招募客戶代號/名稱/備註/狀態/順序 create table account_customer( cus_no int(255) AUTO_INCREMENT PRIMARY KEY, cus_cus_no int(255), cus_name varchar(255), cus_note longtext, cus_state varchar(255), cus_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資欄位資訊:代號/類別/名稱/順序 create table account_column( col_no int(255) AUTO_INCREMENT PRIMARY KEY, col_kind varchar(255), col_name varchar(255), col_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資欄位歷史資訊:代號/薪資主資訊代號/類別/名稱/順序 create table account_column_history( his_no int(255) AUTO_INCREMENT PRIMARY KEY, his_main_no int(255), col_no int(255), col_kind varchar(255), col_name varchar(255), col_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資招募人員資訊:代號/廠商代號/姓名/身分證/密碼/登入狀態 create table account_employee( emp_no int(255) AUTO_INCREMENT PRIMARY KEY, emp_cus_no varchar(255), emp_name varchar(255), emp_id varchar(255), emp_password varchar(255), emp_login varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資資訊:代號/主資訊代號/人員資訊代號/廠商代號/欄位代號/薪資 create table account_data( data_no int(255) AUTO_INCREMENT PRIMARY KEY, data_main_no int(255), data_emp_no int(255), data_cus_no int(255), data_col_no int(255), data_value varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資發信紀錄資訊:代號/主資訊代號/人員資訊代號 create table account_data_log( log_no int(255) AUTO_INCREMENT PRIMARY KEY, log_main_no int(255), log_emp_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 薪資主資訊:代號/月份/類別/檔案名稱/檔案/上傳人員/上架日期/順序 create table account_main( main_no int(255) AUTO_INCREMENT PRIMARY KEY, main_month varchar(255), main_kind varchar(255), main_file_name varchar(255), main_file varchar(255), main_user_no int(255), main_date varchar(255), main_order_no varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 會計專案管理:代號/專案代號/專案名稱 create table account_project( pro_no int(255) AUTO_INCREMENT PRIMARY KEY, pro_pro_no varchar(255), pro_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 統包時薪轉檔欄位資訊:代號/客戶/月份/階段/檔案名稱/檔案/上傳人員 create table account_wage( wag_no int(255) AUTO_INCREMENT PRIMARY KEY, wag_cus_no varchar(255), wag_month varchar(255), wag_step varchar(255), wag_file_name varchar(255), wag_file varchar(255), wag_user_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 修改Log:代號/修改時間/修改來源/來源IP/修改人員/修改Control名稱/動作/修改資訊代號/修改內容 create table log( log_no int(255) AUTO_INCREMENT PRIMARY KEY, log_date varchar(255), log_ip varchar(255), log_source varchar(255), log_person varchar(255), log_control varchar(255), log_action varchar(255), log_data_no varchar(255), log_content longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 銀行資訊:代號/銀行代碼/分行代碼/分行名稱 create table bank( bank_no int(255) AUTO_INCREMENT PRIMARY KEY, bank_id varchar(255), bank_branck_id varchar(255), bank_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 管理者帳號:代號/職稱/主管/名稱/暱稱/帳號/E-mail/手機/大頭照/全身照/Googleid/系統選單/推播Token/備註/狀態/順序 求職者查薪資修改、刪除/求職者修改、刪除/履歷表刪除/加退保權限/切換人員/ create table user( user_no int(255) AUTO_INCREMENT PRIMARY KEY, user_sco_no int(255), user_leader varchar(255), user_name varchar(255), user_nickname varchar(255), user_id varchar(255), user_email varchar(255), user_mobile varchar(255), user_pic varchar(255), user_pic2 varchar(255), user_google_id varchar(255), user_menu_no varchar(255), user_token varchar(255), user_note longtext, user_state varchar(255), user_order_no int(255), EmployeeModify varchar(255), EmployeeDel varchar(255), RecruitModify varchar(255), RecruitDel varchar(255), ResumeDel varchar(255), InsuranceLevel varchar(255), UserChagne varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 使用者群組:代號/群組名稱 create table user_group( gro_no int(255) AUTO_INCREMENT PRIMARY KEY, gro_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 使用者下載欄位:代號/使用者代號/欄位名稱 create table user_column( col_no int(255) AUTO_INCREMENT PRIMARY KEY, col_user_no int(255) AUTO_INCREMENT PRIMARY KEY, col_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 職稱權限設定:代號/職稱/系統選單/求職者查薪資修改、刪除//求職者修改、刪除/履歷表刪除/加退保權限/切換人員/順序 create table scope( sco_no int(255) AUTO_INCREMENT PRIMARY KEY, sco_class varchar(255), sco_menu_no varchar(255), sco_order_no int(255), EmployeeModify varchar(255), EmployeeDel varchar(255), RecruitModify varchar(255), RecruitDel varchar(255), ResumeDel varchar(255), InsuranceLevel varchar(255), UserChagne varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 系統更新資訊:代號/版本/更新時間/更新內容 create table system_update( upd_no int(255) AUTO_INCREMENT PRIMARY KEY, upd_ver varchar(255), upd_date varchar(255), upd_content longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 職務類別:代號/名稱/階層/上一層代號/順序 create table job_class( cla_no int(255) AUTO_INCREMENT PRIMARY KEY, cla_name varchar(255), cla_level varchar(255), cla_uplevel_no varchar(255), cla_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶廠商:代號/名稱/英文名稱/系統名稱(搜尋用)/投保單位/負責窗口/開發窗口/薪酬窗口/統一編號/地址-縣市/地址-地區/地址/目前狀況/狀態/順序 create table customer( cus_no int(255) AUTO_INCREMENT PRIMARY KEY, cus_name varchar(255), cus_en_name varchar(255), cus_data_key varchar(255), cus_com_no int(255), cus_user_no varchar(255), cus_sales_user_no varchar(255), cus_pay_user_no varchar(255), cus_ind_no varchar(255), cus_kind varchar(255), cus_id varchar(255), cus_city varchar(255), cus_area varchar(255), cus_address varchar(255), cus_situation varchar(255), cus_state varchar(255), cus_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶產業別資訊:代號/產業別/順序 create table customer_industry( ind_no int(255) AUTO_INCREMENT PRIMARY KEY, ind_name varchar(255), ind_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶聯絡人資訊:代號/客戶代號/連絡人名稱/職稱/電話/email/順序 create table customer_infor( inf_no int(255) AUTO_INCREMENT PRIMARY KEY, inf_cus_no int(255), inf_name varchar(255), inf_job varchar(255), inf_tel varchar(255), inf_email varchar(255), inf_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶職稱:代號/客戶代號/職稱/順序 create table customer_job( job_no int(255) AUTO_INCREMENT PRIMARY KEY, job_cus_no int(255), job_name varchar(255), job_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶付費方式:代號/客戶代號/名稱/招募方式/負擔方式/數值/期數 create table customer_pay( pay_no int(255) AUTO_INCREMENT PRIMARY KEY, pay_cus_no int(255), pay_name varchar(255), pay_kind varchar(255), pay_type varchar(255), pay_value varchar(255), pay_period varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶付費方式-會計參數:代號/付費方式代號/欄位代號/負擔方式/數值 create table customer_pay_param( par_no int(255) AUTO_INCREMENT PRIMARY KEY, par_pay_no int(255), par_col_no int(255), par_type varchar(255), par_value varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 分店資訊:代號/廠商代號/分店名稱/狀態/順序 create table store( sto_no int(255) AUTO_INCREMENT PRIMARY KEY, sto_cus_no int(255), sto_name varchar(255), sto_state varchar(255), sto_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者公佈欄:代號/公告人/公告時間/標題/內容/檔案/檔案名稱/跳出提醒/求職者 create table staff_bulletin( bul_no int(255) AUTO_INCREMENT PRIMARY KEY, bul_user_no varchar(255), bul_date varchar(255), bul_title varchar(255), bul_content longtext, bul_file varchar(255), bul_file_name varchar(255), bul_alert varchar(255), bul_emp_no longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 公司資訊:代號/公司名稱(簡稱)/公司名稱(全名)/公司名稱(英文)/負責人/統一編號/電話/地址/英文地址/勞工保險證號/勞工保險證號檢查碼/健保保險證號/順序 create table company( com_no int(255) AUTO_INCREMENT PRIMARY KEY, com_name varchar(255), com_full_name varchar(255), com_en_name varchar(255), com_leader varchar(255), com_id varchar(255), com_tel varchar(255), com_address varchar(255), com_en_address varchar(255), com_ins_id varchar(255), com_ins_check varchar(255), com_ins_id2 varchar(255), com_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 招募人員:代號/招募專員/駐廠代號/客戶代號/分店代號/專案代號/職稱/面試日期/面試方式/履歷代號/國籍/姓名/性別/手機/家電/生日/身份證字號/可接受地區/履歷來源/招募方式 地址-縣市/地址-地區/地址/戶籍地址-縣市/戶籍地址-地區/戶籍地址/緊急聯絡人/緊急連絡人關係/電話/履歷送出/履歷送出修改日期/錄取/錄取修改日期/ 體檢日/體檢日修改日期/交資料/交資料修改日期/合約簽回/合約簽回修改日期/報到日期/最後在職日期/最後工作日/備註/階段 銀行別/銀行分行/銀行戶名/銀行帳號/郵局分行/手續費/銀行資訊最後修改時間/文件管理狀態/狀態 create table recruit( rec_no int(255) AUTO_INCREMENT PRIMARY KEY, rec_user_no int(255), rec_permanent int(255), rec_cus_no int(255), rec_sto_no int(255), rec_pro_no int(255), rec_job varchar(255), rec_idate varchar(255), rec_kind varchar(255), rec_res_no int(255), rec_country varchar(255), rec_name varchar(255), rec_sex varchar(255), rec_mobile varchar(255), rec_tel varchar(255), rec_birthday varchar(255), rec_id varchar(255), rec_work_area varchar(255), rec_source varchar(255), rec_type varchar(255), rec_city varchar(255), rec_area varchar(255), rec_address varchar(255), rec_residence_city varchar(255), rec_residence_area varchar(255), rec_residence_address varchar(255), rec_contact varchar(255), rec_contact_relation varchar(255), rec_contact_tel varchar(255), rec_resume_send varchar(255), rec_resume_send_date varchar(255), rec_offer varchar(255), rec_offer_date varchar(255), rec_physical_examination varchar(255), rec_physical_examination_date varchar(255), rec_infor varchar(255), rec_infor_date varchar(255), rec_contract_sign varchar(255), rec_contract_sign_date varchar(255), rec_on varchar(255), rec_on_date varchar(255), rec_off_date varchar(255), rec_last_date varchar(255), rec_note varchar(255), rec_step varchar(255), rec_bank varchar(255), rec_branch_bank varchar(255), rec_bank_name varchar(255), rec_bank_id varchar(255), rec_post varchar(255), rec_fee varchar(255), rec_bank_date varcahr(255), rec_papers_state varchar(255), rec_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 員工契約書:代號/廠商代號/契約名稱/契約WORD檔/WORD檔名稱/備註 create table customer_contract( con_no int(255) AUTO_INCREMENT PRIMARY KEY, con_cus_no int(255), con_name varchar(255), con_file varchar(255), con_file_name varchar(255), con_note longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 文件基礎項目:代號/文件類別/文件編號/文件名稱/文件寬/文件高/是否必填/上傳筆數/順序 create table papers_item( item_no int(255) AUTO_INCREMENT PRIMARY KEY, item_kind varchar(255), item_id varchar(255), item_name varchar(255), item_width varchar(255), item_height varchar(255), item_need varchar(255), item_number varchar(255), item_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者文件資訊:代號/求職者代號/上傳時間/驗證時間/驗證人員代號/文件類別(pic/contract/health/resign)/文件編號/文件名稱/體檢檢查日期/體檢收據日期/文件寬/文件高/必填/上傳筆數 自定檔案/檔案/檔案名稱/備註/簽名/簽名2/銀行別/銀行分行/銀行戶名/銀行帳號/郵局分行/地址-縣市/地址-區域/地址/狀態(待上傳/待驗證/已驗證)/ create table recruit_papers( pap_no int(255) AUTO_INCREMENT PRIMARY KEY, pap_rec_no int(255), pap_date varchar(255), pap_date2 varchar(255), pap_user_no2 int(255), pap_kind varchar(255), pap_id varchar(255), pap_name varchar(255), pap_body_date varchar(255), pap_pay_date varchar(255), pap_width varchar(255), pap_height varchar(255), pap_need varchar(255), pap_number varchar(255), pap_self varchar(255), pap_file varchar(255), pap_file_name varchar(255), pap_note longtext, pap_sign varcahr(255), pap_sign2 varcahr(255), pap_bank varchar(255), pap_branch_bank varchar(255), pap_bank_name varchar(255), pap_bank_id varchar(255), pap_post varchar(255), pap_residence_city varchar(255), pap_residence_area varchar(255), pap_residence_address varchar(255), pap_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者健康聲明:代號/求職者代號/症狀確認/症狀/症狀描述/入境/身分證/旅遊地點/返台日期/說明/接觸病例/接觸對象/接觸描述/是否篩檢/篩檢日期/篩檢醫療院所/篩檢結果/同意事項/簽名 create table recruit_health( hea_no int(255) AUTO_INCREMENT PRIMARY KEY, hea_rec_no int(255), hea_symptom_check varchar(255), hea_symptom varchar(255), hea_symptom_note varchar(255), hea_entry varchar(255), hea_entry_id varchar(255), hea_travel varchar(255), hea_back_date varchar(255), hea_entry_note varchar(255), hea_touch varchar(255), hea_touch_targer varchar(255), hea_touch_note varchar(255), hea_scan varchar(255), hea_scan_date varchar(255), hea_scan_hospital varchar(255), hea_scan_result varchar(255), hea_agree varchar(255), hea_sign varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者面試時間:代號/求職者代號/面試時間/面試方式 create table recruit_interview( int_no int(255) AUTO_INCREMENT PRIMARY KEY, int_rec_no int(255), int_date varchar(255), int_kind varchar(255) SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者離職單:代號/求職者代號/離職原因/在職證明申請/勞健退申請/電子掃描/EMAIL/同意事項/簽名 create table recruit_resign( res_no int(255) AUTO_INCREMENT PRIMARY KEY, res_rec_no int(255), res_cause varchar(255), res_employee_apply varchar(255), res_insurance_apply varchar(255), res_mail_scan varchar(255), res_email varchar(255), res_agree varchar(255), res_sign varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者健寶放棄:代號/求職者代號/退保原因/其他原因/同意事項/簽名 create table recruit_waiver( wai_no int(255) AUTO_INCREMENT PRIMARY KEY, wai_rec_no int(255), wai_reason varchar(255), wai_other_reason varchar(255), wai_agree varchar(255), wai_sign varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 多筆資料資訊:代號/欄位/檔案/檔案名稱 create table multi_file( file_no int(255) AUTO_INCREMENT PRIMARY KEY, file_column varchar(255), file_file varchar(255), file_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者匯票收款同意書:代號/求職者代號/簽收地址/連絡電話/同意事項/簽名 create table recruit_remit( rem_no int(255) AUTO_INCREMENT PRIMARY KEY, rem_rec_no int(255), rem_address varchar(255), rem_tel varchar(255), rem_agree varchar(255), rem_sign varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 非中華民國境內居住之個人所得稅代扣同意書:代號/求職者代號/護照號碼/同意事項/簽名 create table recruit_holding( hold_no int(255) AUTO_INCREMENT PRIMARY KEY, hold_rec_no int(255), hold_passport varchar(255), hold_agree varchar(255), hold_sign varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 周領資訊:代號/求職者代號/申請日期/週期/申請預支金額/匯費(不是第一銀行就帶30)/上傳出勤資訊/備註/核定實發金額(預帶申請預支金額)/薪資月份/預支金額(實發金額+匯費)/狀態 create table recruit_week_pay( pay_no int(255) AUTO_INCREMENT PRIMARY KEY, pay_rec_no int(255), pay_date varchar(255), pay_circle varchar(255), pay_amount varchar(255), pay_fee varchar(255), pay_file varchar(255), pay_file_name varchar(255), pay_remark longtext, pay_agree_amount varchar(255), pay_month varchar(255), pay_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 連絡記錄:代號/客戶代號/Keyin使用者代號/備註 create table contact( con_no int(255) AUTO_INCREMENT PRIMARY KEY, con_cus_no int(255), con_inf_no int(255), con_date int(255), con_kind int(255), con_user_no int(255), con_note longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 合約:代號/廠商代號/合約起/合約迄/上傳檔案/上傳檔案名稱/自動續約/付款天數/備註 create table contract( con_no int(255) AUTO_INCREMENT PRIMARY KEY, con_cus_no int(255), con_start varchar(255), con_end varchar(255), con_file varchar(255), con_file_name varchar(255), con_auto varchar(255), con_pay_day varchar(255), con_note longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 專案:代號/廠商代號/招募方式/專案名稱/專案內容/實際薪資/修改級距/職務類別/文件/合約書/加保方式/需當日健保加保/駐廠專員/體檢週期/保證期天數/相關檔案/II/PP/CI/OFFER/OB/狀態/順序 create table project( pro_no int(255) AUTO_INCREMENT PRIMARY KEY, pro_cus_no int(255), pro_kind varchar(255), pro_name varchar(255), pro_content longtext, pro_pay int(255), pro_lev_modify varchar(255), pro_interview_modify varchar(255), pro_cla_no varchar(255), pro_papers varchar(255), pro_contract varchar(255), pro_ins_kind varchar(255), pro_health varchar(255), pro_user_no varchar(255), pro_body_cycle varchar(255), pro_day varchar(255), pro_file varchar(255), pro_file_name varchar(255), pro_ii varchar(255), pro_pp varchar(255), pro_ci varchar(255), pro_offer varchar(255), pro_ci varchar(255), pro_state varchar(255), pro_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 專案:代號/專案代號/開始時段/結束時段 create table project_slot( slot_no int(255) AUTO_INCREMENT PRIMARY KEY, slot_pro_no int(255), slot_start varchar(255), slot_end varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 投保級距:代號/加保級距 - 行政 create table ins_level( lev_no int(255) AUTO_INCREMENT PRIMARY KEY, lev_value int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 投保類別:代號/名稱/打折比率/備註/順序 - 行政 create table ins_class( cla_no int(255) AUTO_INCREMENT PRIMARY KEY, cla_name varchar(255), cla_percent int(255), cla_note longtext, cla_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 公司人才庫:代號/顧問/客戶/名稱/電話/EMAIL/來源/履歷代碼/職務類別/居住區域/上傳檔案/上傳檔案名稱/上傳檔案2/上傳檔案名稱2/上傳檔案3/上傳檔案名稱3/ create table referral( ref_no int(255) AUTO_INCREMENT PRIMARY KEY, ref_user_no varchar(50), ref_cus_no varchar(255), ref_name varchar(50), ref_phone varchar(50), ref_mail varchar(255), ref_source varchar(50), ref_code varchar(50), ref_job varchar(50), ref_live varchar(255), ref_file varchar(255), ref_file_name varchar(255), ref_file2 varchar(255), ref_file_name2 varchar(255), ref_file3 varchar(255), ref_file_name3 varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 公司人才庫 追蹤紀錄: create table referral_note( note_no int(255) AUTO_INCREMENT PRIMARY KEY, note_ref_no varchar(50), note_content longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 履歷資訊:代號/類型/主顧問/次顧問/履歷類型/應徵職務/應徵地點/應徵身分/姓名/英文名字/身分證字號/出生年月日/年齡/市話/手機/ 身高/體重/email/性別/語言/交通工具/兵役/婚姻/經歷簡述/就讀大學/大學科系 緊急聯絡人/關係/連絡電話/想應徵公司或類型 大頭照/照片1/照片2/簽名/客戶代號/專案代號/追蹤數量/釋出剩餘天數/最後修改時間/狀態 組裝/目檢/測試/插件/自動起子/桌上機台操作/流線/久站工作/烘焙 品檢/焊錫/包裝/鑷子夾/顯微鏡/SMT機台/無塵室/搬重/烹飪 是否曾在警政司法單位有違法之犯罪紀錄、訴訟事件?/說明 信用狀況，是否有以下狀況(強制執行、法扣)?/說明 是否領有殘障手冊?/說明 是否患有重大、特殊、遺傳性、慢性疾病?/說明 近五年是否曾固定服用藥物?/說明 現在是否懷孕？（男性免填）?/說明 是否有吸菸之習慣?/說明 是否有刺青?/說明 是否有嚼檳榔之習慣?/說明 是否具有新住民身份/外籍學生?/說明 是否可以配合加班?/說明 主要負責顧問/替補顧問們(可複數逗號隔開) create table resume( res_no int(255) AUTO_INCREMENT PRIMARY KEY, res_method varchar(50), res_user_no varchar(50), res_user_no2 varchar(50), res_type varchar(50), res_job varchar(50), res_location varchar(50), res_identity varchar(50), res_name varchar(50), res_name_en varchar(50), res_id varchar(50), res_birthday varchar(50), res_age varchar(50), res_phone varchar(50), res_mobile varchar(50), res_height varchar(50), res_weight varchar(50), res_email varchar(50), res_gender varchar(50), res_relation varchar(50), res_language varchar(50), res_trans varchar(50), res_mandatory varchar(50), res_marry varchar(50), res_desc longtext, res_university varchar(50), res_dept varchar(50), res_emergent_name varchar(50), res_emergent_relation varchar(50), res_emergent_mobile varchar(50), res_want varchar(255), res_headshot varchar(255), res_pic1 varchar(255), res_pic2 varchar(255), res_sign varchar(255), res_cus_no varchar(50), res_pro_no varchar(50), res_remark_num int(50), res_release_day varchar(50), res_mdate varchar(50), res_state varchar(50), res_assemble varchar(255), res_eye_check varchar(255), res_test varchar(255), res_plugin varchar(255), res_screwdriver varchar(255), res_table_device varchar(255), res_streamline varchar(255), res_stand varchar(255), res_bake varchar(255), res_q_check varchar(255), res_solder varchar(255), res_package varchar(255), res_tweezers varchar(255), res_microscope varchar(255), res_smt varchar(255), res_dustfree_room varchar(255), res_carry_weight varchar(255), res_cook varchar(255), res_illegal varchar(255), res_illegal_note varchar(255), res_trust varchar(255), res_trust_note varchar(255), res_handicapped varchar(255), res_handicapped_note varchar(255), res_sick varchar(255), res_sick_note varchar(255), res_medicine varchar(255), res_medicine_note varchar(255), res_pregnant varchar(255), res_pregnant_note varchar(255), res_smoke varchar(255), res_smoke_note varchar(255), res_tatoo varchar(255), res_tatoo_note varchar(255), res_areca varchar(255), res_areca_note varchar(255), res_foreign varchar(255), res_foreign_note varchar(255), res_overtime varchar(255), res_overtime_note varchar(255), res_consultant_no int(255), res_sub_consultant_no varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 證照:代號/履歷代號/證照名稱/取得日期 create table resume_license( lic_no int(255) AUTO_INCREMENT PRIMARY KEY, lic_res_no int(255), lic_type varchar(255), lic_name varchar(255), lic_date varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 蝦皮關係:代號/履歷代號/姓名/關係/部門 create table resume_relation( rel_no int(255) AUTO_INCREMENT PRIMARY KEY, rel_res_no int(255), rel_type varchar(255), rel_name varchar(255), rel_relation varchar(255), rel_department varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 家庭:代號/履歷代號/姓名/關係/職業 create table resume_family( fam_no int(255) AUTO_INCREMENT PRIMARY KEY, fam_res_no int(255), fam_type varchar(255), fam_name varchar(255), fam_relation varchar(255), fam_occupation varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 緊急資訊:代號/履歷代號/姓名/關係/連絡電話 create table resume_emergency( eme_no int(255) AUTO_INCREMENT PRIMARY KEY, eme_res_no int(255), eme_type varchar(255), eme_name varchar(255), eme_relation varchar(255), eme_phone varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 歷程:代號/履歷代號/使用者代號/備註 create table resume_remark( rem_no int(255) AUTO_INCREMENT PRIMARY KEY, rem_res_no int(255), rem_user_no int(255), rem_note longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 學歷:代號/履歷代號/履歷類型/學程/學校名稱/科系/入學日期/畢業日期/日校夜校/狀態(畢/肄業) create table resume_education( edu_no int(255) AUTO_INCREMENT PRIMARY KEY, edu_res_no int(255), edu_type varchar(255), edu_class varchar(255), edu_school varchar(255), edu_department varchar(255), edu_start varchar(255), edu_end varchar(255), edu_interval varchar(255), edu_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 經歷:代號/履歷代號/履歷類型/服務單位/職稱/管理責任/管理人數/工作內容/到職日/離職日/是否離職/離職原因/ create table resume_experience( exp_no int(255) AUTO_INCREMENT PRIMARY KEY, exp_res_no int(255), exp_type varchar(255), exp_unit varchar(255), exp_job varchar(255), exp_manage varchar(255), exp_manage_num varchar(255), exp_work longtext, exp_start varchar(255), exp_end varchar(255), exp_state varchar(255), exp_cause longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 列表欄位資訊:代號/類別/原始欄位/列表欄位/名稱/列表名稱/寬度/是否排序/CSS/說明/順序 create table list_column( col_no int(255) AUTO_INCREMENT PRIMARY KEY, col_kind varchar(255), col_column varchar(255), col_list_column varchar(255), col_name varchar(255), col_list_name varchar(255), col_width varchar(255), col_order varchar(255), col_css varchar(255), col_desc varchar(255), col_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 欄位排序資訊:代號/類別/使用者代號/欄位代號/狀態/順序 create table column_order( ord_no int(255) AUTO_INCREMENT PRIMARY KEY, ord_kind varchar(255), ord_user_no int(255), ord_col_no int(255), ord_state varchar(255), ord_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 履歷短網址:代號/編號/Token create table short_url( sho_no int(255) AUTO_INCREMENT PRIMARY KEY, sho_id varchar(255) BINARY, sho_token longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 總公司系統選單:代號/系統/名稱/連結/標題/背景圖片/相關連結/連結方式/類別名稱/階層/上一層代號/順序 create table webmenu( menu_no int(255) AUTO_INCREMENT PRIMARY KEY, menu_system varchar(255), menu_name varchar(255), menu_link varchar(255), menu_title varchar(255), menu_pic varchar(255), menu_related longtext, menu_target varchar(255), menu_class varchar(255), menu_level varchar(255), menu_uplevel_no varchar(255), menu_order_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 在離職證明:代號/求職者代號/申請顧問/簽核狀態/簽核人員/簽核時間/備註 create table certificate( cer_no int(255) AUTO_INCREMENT PRIMARY KEY, cer_rec_no int(255), cer_user_no int(255), cer_state varchar(255), cer_check varchar(255), cer_date varchar(255), cer_note varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 加退保資訊:代號/求職者代號/投保方式/加退保群組代號/加保規則/專案代號/實際薪資/勞保級距/勞退級距/健保級距/職保級距/提繳率/報到日期OR最後工作日期/加退保日期/加退保作業日期/是否異常/來源/備註/ create table insurance( ins_no int(255) AUTO_INCREMENT PRIMARY KEY, ins_rec_no int(255), ins_kind varchar(255), ins_group int(255), ins_rule varchar(255), ins_pro2_no int(255), ins_pay int(255), ins_labor varchar(255), ins_labor2 varchar(255), ins_health varchar(255), ins_job varchar(255), ins_percent varchar(255), ins_wdate varchar(255), ins_date varchar(255), ins_mdate varchar(255), ins_normal varchar(255), ins_source varchar(255), ins_note longtext, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 眷屬:代號/求職者代號/身分證/姓名/性別/身份別/出生日期/加保日期/加保作業日期/退保日期/退保作業日期/稱謂/加保原因/是否為學生/學生證/健保卡/相關檔案1/相關檔案2/相關檔案3 create table family( fam_no int(255) AUTO_INCREMENT PRIMARY KEY, fam_rec_no int(255), fam_id varchar(255), fam_name varchar(255), fam_sex varchar(255), fam_cla_no int(255), fam_birthday varchar(255), fam_add_date varchar(255), fam_add_mdate varchar(255), fam_out_date varchar(255), fam_out_mdate varchar(255), fam_related varchar(255), fam_cause varchar(255), fam_student varchar(255), fam_student_pic varchar(255), fam_health_pic varchar(255), fam_related_pic1 varchar(255), fam_related_pic2 varchar(255), fam_related_pic3 varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 目前有效認可醫療機構:代號/醫院代號/縣市/醫院名稱 create table hospital( hos_no int(255) AUTO_INCREMENT PRIMARY KEY, hos_id int(255), hos_city varchar(255), hos_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 面試時間:代號/求職者代號/面試日期/面試方式/是否完成 create table interview( int_no int(255) AUTO_INCREMENT PRIMARY KEY, int_rec_no int(255), int_date varchar(255), int_kind varchar(255), int_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者專案生效設定:代號/求職者代號/專案代號/類別方式(加保or薪調)/生效日期/結束日期/系統判定結束日期/實際薪資/勞保級距/勞退級距/健保級距/職保級距/是否加健保/提繳率/離職原因/狀態 create table recruit_project( pro2_no int(255) AUTO_INCREMENT PRIMARY KEY, pro2_rec_no int(255), pro2_pro_no int(255), pro2_kind varchar(255), pro2_start varchar(255), pro2_end varchar(255), pro2_end2 varchar(255), pro2_pay int(255), pro2_labor int(255); pro2_labor2 int(255); pro2_health int(255); pro2_job int(255); pro2_health_state varchar(255), pro2_percent varchar(255), pro2_resign varchar(255), pro2_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 專案加保個人提繳率:代號/求職者代號/求職者專案代號/生效日期/提繳率/備註/來源 create table recruit_percent( per_no int(255) AUTO_INCREMENT PRIMARY KEY, per_rec_no int(255), per_pro2_no int(255), per_date varchar(255), per_value varchar(255), per_note longtext, per_source varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 統包時薪欄位資訊:代號/統包代號/求職者代號/專案代號/薪資類別/時數/1.34/1.67/2.67/1/薪水/加班費 create table wage( wage_no int(255) AUTO_INCREMENT PRIMARY KEY, wage_wag_no varchar(255), wage_rec_no varchar(255), wage_pro_no varchar(255), wage_salary_kind varchar(255), wage_hour varchar(255), wage_134 varchar(255), wage_167 varchar(255), wage_267 varchar(255), wage_1 varchar(255), wage_money varchar(255), wage_overtime_money varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 統包上傳其他資訊欄位資訊:代號/統包代號/求職者代號/月份/階段/檔案名稱/檔案/上傳人員 create table wage_supplement( sup_no int(255) AUTO_INCREMENT PRIMARY KEY, sup_wag_no varchar(255), sup_rec_no varchar(255), sup_pro_no varchar(255), sup_col_no varchar(255), sup_amount varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 統包時薪欄位資訊:代號/統包實心代號/求職者代號/假別/日期/專案/工時/報薪/時薪 create table wage_source( sou_no int(255) AUTO_INCREMENT PRIMARY KEY, sou_wage_no varchar(255), sou_wag_no varchar(255), sou_rec_no varchar(255), sou_holiday varchar(255), sou_date varchar(255), sou_pro_no varchar(255), sou_work_hour varchar(255), sou_salary varchar(255), sou_hour_money varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 打卡資訊設定:代號/打卡模式/ create table punch_infor( inf_no int(255) AUTO_INCREMENT PRIMARY KEY, inf_model varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 客戶打卡資訊:代號/客戶代碼/公司代碼/名稱/地址/經度/緯度/GPS有效距離(公尺)/帳號/密碼/Qrcode有效時間 create table punch_site( site_no int(255) AUTO_INCREMENT PRIMARY KEY, site_cus_no int(255), site_com_no int(255), site_name varchar(255), site_city varchar(255), site_area varchar(255), site_address varchar(255), site_lng varchar(255), site_lat varchar(255), site_distance varchar(255), site_id varchar(255), site_password varchar(255), site_qrcode_timer varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 打卡資訊設定:代號/履歷代號/客戶代號/打卡點代號/求職者代號/專案代號/上班日期/上班時間/下班時間/狀態(已完成/未完成) create table punch_data( data_no int(255) AUTO_INCREMENT PRIMARY KEY, data_res_no varchar(255), data_cus_no varchar(255), data_site_no varchar(255), data_rec_no varchar(255), data_pro_no varchar(255), data_on_date varchar(255), data_on_time varchar(255), data_off_time varchar(255), data_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 排班行事曆:代號/客戶代號/地點代號/排班名稱 create table work( work_no int(255) AUTO_INCREMENT PRIMARY KEY, work_cus_no int(255), work_sto_no int(255), work_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 排班班別內容:代號/行事曆代號/時段代號/時段開始時間/時段結束時間/日期/需求數 create table work_shift( shi_no int(255) AUTO_INCREMENT PRIMARY KEY, shi_work_no int(255), shi_slot_no int(255), shi_slot_start varchar(255), shi_slot_end varchar(255), shi_date varchar(255), shi_qty int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 加班資訊:代號/打卡代號/求職者代號/加班小時數/通過加班小時數/加班原因/可審核人員/審核人員/審核時間/審核內容/狀態 create table work_overtime( over_no int(255) AUTO_INCREMENT PRIMARY KEY, over_data_no int(255), over_rec_no int(255), over_hour int(255), over_min int(255), over_ahour int(255), over_amin int(255), over_cause longtext, over_can_user_no int(255), over_check_user_no int(255), over_check_date varchar(255), over_note longtext, over_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 忘記打卡資訊:代號/打卡代號/求職者代號/類別/真實上下班時間/可審核人員/審核人員/審核時間/審核內容/狀態 create table work_forget( for_no int(255) AUTO_INCREMENT PRIMARY KEY, for_data_no int(255), for_rec_no int(255), for_kind varchar(255), for_date varchar(255), for_can_user_no varchar(255), for_check_user_no int(255), for_check_date varchar(255), for_note longtext, for_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 請假類別:代號/假別名稱 create table leave_class( cla_no int(255) AUTO_INCREMENT PRIMARY KEY, cla_name varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 請假類別:代號/客戶代號/專案代號/求職者代號/假別代號/時數 create table leave_info( info_no int(255) AUTO_INCREMENT PRIMARY KEY, info_cus_no int(255), info_pro_no int(255), info_rec_no int(255), info_cla_no int(255), info_hour float, SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 請假:代號/求職者代號/客戶代號/專案代號/假別代號/請假開始日期/開始時間/請假結束日期/結束時間/請假小時數/請假事由/相關檔案/可審核人員/審核人員/審核時間/審核內容/狀態 create table recruit_leave( lea_no int(255) AUTO_INCREMENT PRIMARY KEY, lea_rec_no int(255), lea_cus_no int(255), lea_pro_no int(255), lea_cla_no int(255), lea_sdate varchar(255), lea_stime varchar(255), lea_edate varchar(255), lea_etime varchar(255), lea_hour double, lea_cause longtext, lea_file_name varchar(255), lea_file varchar(255), lea_can_user_no int(255), lea_check_user_no int(255), lea_check_date varchar(255), lea_note longtext, lea_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 請假:代號/打卡代號/求職者代號/請假小時數/通過請假小時數/請假原因/可審核人員/審核人員/審核時間/審核內容/狀態 create table work_leave( lea_no int(255) AUTO_INCREMENT PRIMARY KEY, lea_data_no int(255), lea_rec_no int(255), lea_hour int(255), lea_min int(255), lea_ahour int(255), lea_amin int(255), lea_cause longtext, lea_can_user_no int(255), lea_check_user_no int(255), lea_check_date varchar(255), lea_note longtext, lea_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 審核:代號/班表代號/日期/簽名/審核日期/備註/審核狀態 create table work_review( rev_no int(255) AUTO_INCREMENT PRIMARY KEY, rev_work_no int(255), rev_date varchar(255), rev_sign varchar(255), rev_check_date varchar(255), rev_note longtext, rev_state varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 求職者專案打卡資訊:代號/求職者代號/求職者專案代號/開始日期/結束日期/客戶/地點/時段 create table recruit_punch( pun_no int(255) AUTO_INCREMENT PRIMARY KEY, pun_rec_no int(255), pun_pro2_no int(255), pun_start varchar(255), pun_end varchar(255), pun_cus_no int(255), pun_sto_no int(255), pun_slot_no int(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; LineRichmenu:代號/預設menu/Id/Name/Json/Pic/LineId create table line_richmenu( menu_no int(255) AUTO_INCREMENT PRIMARY KEY, menu_default varchar(255), menu_id varchar(255), menu_name varchar(255), menu_json varchar(255), menu_photo varchar(255), menu_lineid varchar(255), SystemCreateDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, SystemModifyDate timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, State enum('FALSE','TRUE') NOT NULL DEFAULT 'TRUE' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE resume ( res_no INT(255) AUTO_INCREMENT PRIMARY KEY, -- 自動遞增的履歷編號 res_user_no VARCHAR(50) COMMENT '用戶編號', res_name VARCHAR(50) COMMENT '姓名', res_birthday VARCHAR(50) COMMENT '生日', res_gender VARCHAR(50) COMMENT '性別', res_id VARCHAR(50) COMMENT '身份證字號', res_blood VARCHAR(50) COMMENT '血型', res_height VARCHAR(50) COMMENT '身高 (單位: CM)', res_weight VARCHAR(50) COMMENT '體重 (單位: KG)', res_shift VARCHAR(255) COMMENT '應徵班別', res_headshot VARCHAR(255) COMMENT '個人頭像', res_city VARCHAR(50) COMMENT '通訊城市', res_area VARCHAR(50) COMMENT '通訊區域', res_short_address VARCHAR(100) COMMENT '通訊地址簡短描述', res_address TEXT COMMENT '完整通訊地址', res_marry VARCHAR(50) COMMENT '婚姻狀況', res_child INT COMMENT '子女人數', res_identity VARCHAR(255) COMMENT '求職者身份別', res_abo_type VARCHAR(50) COMMENT '族別 (原住民類別)', res_dis_type VARCHAR(50) COMMENT '身心障礙類別', res_dis_level VARCHAR(50) COMMENT '身心障礙等級', res_help_level VARCHAR(50) COMMENT '生活扶助戶類別', res_lost_start VARCHAR(50) COMMENT '領取失業給付起始日期', res_lost_end VARCHAR(50) COMMENT '領取失業給付結束日期', res_phone VARCHAR(50) COMMENT '家裡電話', res_mobile VARCHAR(50) COMMENT '行動電話', res_email VARCHAR(50) COMMENT '電子郵件地址', res_emergent_name VARCHAR(50) COMMENT '緊急聯絡人姓名', res_emergent_relation VARCHAR(50) COMMENT '緊急聯絡人關係', res_emergent_mobile VARCHAR(50) COMMENT '緊急聯絡人電話/行動電話', res_trans VARCHAR(50) COMMENT '交通方式', res_trans_note VARCHAR(100) COMMENT '交通方式說明', res_trans_time VARCHAR(50) COMMENT '車程抵達公司所需時間', res_car_license VARCHAR(50) COMMENT '駕照類型', res_car_type VARCHAR(50) COMMENT '車輛類型', res_salary_type VARCHAR(50) COMMENT '希望待遇類型 (時薪/月薪)', res_salary VARCHAR(50) COMMENT '希望薪資', res_accept_area VARCHAR(255) COMMENT '可接受的上班地點', res_brief VARCHAR(255) COMMENT '簡歷摘要', res_brief_unit VARCHAR(255) COMMENT '簡歷介紹單位', res_on_board VARCHAR(50) COMMENT '可到職日', res_military_type VARCHAR(50) COMMENT '兵役狀況', res_military_reason TEXT COMMENT '免役原因', res_military_date VARCHAR(50) COMMENT '退役日期', res_work_skill VARCHAR(255) COMMENT '工作技能', res_coo_work VARCHAR(255) COMMENT '工作配合度調查', res_health_status VARCHAR(255) COMMENT '健康狀況檢視表', res_ep_chk VARCHAR(10) COMMENT '癲癇定期回診', res_can_name VARCHAR(255) COMMENT '癌症病名', res_can_chk VARCHAR(10) COMMENT '癌症定期回診', res_dia_chk VARCHAR(10) COMMENT '糖尿病定期回診', res_arth_name VARCHAR(255) COMMENT '關節炎病名', res_mi_name VARCHAR(255) COMMENT '精神疾病病名', res_sa_chk VARCHAR(10) COMMENT '皮膚過敏檢查', res_sa_note VARCHAR(255) COMMENT '皮膚過敏說明', res_dis_note VARCHAR(255) COMMENT '其他需要固定吃藥之疾病 病名', res_smk_amt VARCHAR(10) COMMENT '抽菸數量', res_an_type VARCHAR(10) COMMENT '貧血類型', res_bn_amt VARCHAR(10) COMMENT '檳榔數量', res_ast_chk VARCHAR(10) COMMENT '氣喘定期回診', res_tat_note VARCHAR(100) COMMENT '刺青部位', res_sws_chk VARCHAR(20) COMMENT '手汗檢查', res_my_l_deg VARCHAR(20) COMMENT '左眼近視度數', res_my_r_deg VARCHAR(20) COMMENT '右眼近視度數', res_prb_chk VARCHAR(10) COMMENT '老花檢查', res_friend_chk VARCHAR(10) COMMENT '有無親戚/朋友在公司', res_friend_name VARCHAR(100) COMMENT '親戚/朋友姓名', res_friend_relation VARCHAR(100) COMMENT '親戚/朋友關係', res_again_check VARCHAR(10) COMMENT '是否曾任職過本公司', res_again_note VARCHAR(100) COMMENT '曾任職過公司說明', res_fired_chk VARCHAR(10) COMMENT '是否曾被開除', res_fired_note VARCHAR(100) COMMENT '開除原因', res_layoff_chk VARCHAR(10) COMMENT '是否曾被資遣', res_layoff_note VARCHAR(100) COMMENT '資遣原因', res_illegal_chk VARCHAR(10) COMMENT '是否曾有違法紀錄', res_illegal_note VARCHAR(100) COMMENT '違法紀錄說明', res_hurt_chk VARCHAR(10) COMMENT '是否曾遭受意外傷害', res_hurt_note VARCHAR(100) COMMENT '傷害說明', res_cure_chk VARCHAR(10) COMMENT '是否痊癒', res_plan LONGTEXT COMMENT '進修計劃或生涯規劃', res_agree_auth VARCHAR(10) COMMENT '同意授權審查資料', res_agree_provide VARCHAR(10) COMMENT '同意提供人事基本資料', res_sign VARCHAR(10) COMMENT '簽名確認', SystemCreateDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系統創建日期', SystemModifyDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系統修改日期', State ENUM('FALSE', 'TRUE') NOT NULL DEFAULT 'TRUE' COMMENT '履歷狀態 (TRUE: 啟用, FALSE: 停用)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE resume_education ( edu_no INT(255) AUTO_INCREMENT PRIMARY KEY, -- 自動遞增的教育記錄編號 edu_res_no INT(255) COMMENT '關聯到履歷編號', edu_class VARCHAR(100) COMMENT '學位 (例如: 學士, 碩士, 博士)', edu_school VARCHAR(255) COMMENT '校名', edu_department VARCHAR(255) COMMENT '科系', edu_category VARCHAR(100) COMMENT '類別 (日間部/夜間部/其他)', edu_category_note VARCHAR(255) COMMENT '類別 說明', edu_start VARCHAR(100) COMMENT '入學年月', edu_end VARCHAR(100) COMMENT '畢業年月', edu_state VARCHAR(100) COMMENT '畢業與否 (畢業/肄業/在學)', SystemCreateDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系統創建日期', SystemModifyDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系統修改日期', State ENUM('FALSE', 'TRUE') NOT NULL DEFAULT 'TRUE' COMMENT '資料狀態 (TRUE: 啟用, FALSE: 停用)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE resume_experience ( exp_no INT(255) AUTO_INCREMENT PRIMARY KEY, -- 自動遞增的工作經驗編號 exp_res_no INT(255) COMMENT '關聯到履歷編號', exp_type VARCHAR(100) COMMENT '履歷類型', exp_unit VARCHAR(255) COMMENT '公司名稱', exp_job VARCHAR(255) COMMENT '職稱', exp_start VARCHAR(100) COMMENT '服務起期間', exp_end VARCHAR(100) COMMENT '服務迄期間', exp_work VARCHAR(255) COMMENT '工作內容 (簡單說明)', exp_salary VARCHAR(50) COMMENT '薪資', exp_cause VARCHAR(255) COMMENT '離職原因', SystemCreateDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系統創建日期', SystemModifyDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '系統修改日期', State ENUM('FALSE', 'TRUE') NOT NULL DEFAULT 'TRUE' COMMENT '資料狀態 (TRUE: 啟用, FALSE: 停用)' ) ENGINE=InnoDB DEFAULT CHARSET=utf8;