薪資廠商資訊:代號/招募客戶代號/名稱/備註/狀態/順序 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; 求職者業績歸屬:代號/求職者代號/顧問/比例 create table recruit_performance( per_no int(255) AUTO_INCREMENT PRIMARY KEY, per_rec_no int(255), per_user_no varchar(255), per_rate 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_fund( fund_no int(255) AUTO_INCREMENT PRIMARY KEY, fund_rec_no int(255), fund_issue_date varchar(255), fund_reply_date varchar(255), fund_doc_no varchar(255), fund_city varchar(255), fund_total varchar(255), fund_amount varchar(255), fund_file varchar(255), fund_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_fund_info( info_no int(255) AUTO_INCREMENT PRIMARY KEY, info_fund_no int(255), info_pay varchar(255), info_pay_name varchar(255), info_pay_address varchar(255), info_bank varchar(255), info_branch_bank varchar(255), info_bank_name varchar(255), info_bank_id 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_fund_salary( sal_no int(255) AUTO_INCREMENT PRIMARY KEY, sal_month varchar(255), sal_salary int(255), sal_meal int(255), sal_general int(255), sal_overtime int(255), sal_subsidy int(255), sal_research int(255), sal_work_bonus int(255), sal_per_bonus int(255), sal_year_bonus int(255), sal_app_bonus int(255), sal_other_bonus int(255), sal_labor int(255), sal_health int(255), sal_second_health int(255), sal_emp_fund int(255), sal_ret_fund int(255), sal_income_fund int(255), sal_labor_fund int(255), sal_leave_fund int(255), sal_group_fund int(255), sal_equ_fund int(255), sal_advance_fund 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_fund_rel ( rel_no INT AUTO_INCREMENT PRIMARY KEY, rel_info_no INT , -- 對應 recruit_fund_info.info_no rel_sal_no INT, -- 對應 recruit_fund_salary.sal_no rel_month varchar(255), rel_result varchar(255), rel_amount int, 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; 連絡記錄:代號/客戶代號/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; 求職者轉換預支類別log:代號/求職者代號/內容 create table advance_log( log_no int(255) AUTO_INCREMENT PRIMARY KEY, log_rec_no int(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; 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;