薪資廠商資訊:代號/招募客戶代號/名稱/備註/狀態/順序 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_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/lineid/linkedin/系統選單/推播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_lineid varchar(255), user_linkedin 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_position ( pos_no INT AUTO_INCREMENT PRIMARY KEY, -- 職務代號 pos_cus_no INT, -- 客戶代號（對應客戶表） pos_title VARCHAR(100), -- 職稱 pos_location VARCHAR(100), -- 工作地點 pos_num INT, -- 需求人數 pos_project_period VARCHAR(50), -- 專案期間（例如：6個月、長期等） pos_type VARCHAR(50), -- 類型（例如：正職、約聘） pos_org_type longtext, -- 組織編制 pos_condition longtext, -- 招募條件 pos_work_time longtext, -- 上班時間（可自由格式，如 9:00-18:00） pos_content longtext, -- 工作內容 pos_interview longtext, -- 面試流程 pos_salary longtext, -- 薪資（文字說明，或改用數字欄位視需求） pos_benefits longtext, -- 福利 pos_remark 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 customer_invoice( inv_no int(255) AUTO_INCREMENT PRIMARY KEY, inv_cus_no int(255), inv_date varchar(255), inv_num varchar(255), inv_context 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 customer_interval( int_no int(255) AUTO_INCREMENT PRIMARY KEY, int_cus_no int(255), int_rule varchar(255), int_name varchar(255), int_bank varchar(255), int_pay_rule varchar(255), int_pay_note varchar(255), int_currency varchar(255), int_record varchar(255), int_plan varchar(255), int_cost 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_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; 文件簽核資訊:代號/文件代號/簽核人/簽核時間/簽核狀態/說明/ create table papers_sign( sign_no int(255) AUTO_INCREMENT PRIMARY KEY, sign_pap_no int(255), sign_user_no varchar(255), sign_date varchar(255), sign_state varchar(255), sign_remark 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; 求職者文件資訊:代號/求職者代號/上傳時間/驗證時間/驗證人員代號/文件類別(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 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_year varchar(255), hold_month varchar(255), hold_item varchar(255), hold_amount 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 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/通訊地址/戶籍地址/期望薪資/最快可報到日/可否加班/可否海外派/職缺管道/ create table resume( res_no int(255) AUTO_INCREMENT PRIMARY KEY, res_user_id varchar(255), res_type varchar(255), res_pic varchar(255), res_dept varchar(255), res_position varchar(255), res_name varchar(255), res_birthday varchar(20), res_blood varchar(10), res_en_name varchar(100), res_id varchar(100), res_gender varchar(10), res_marry varchar(10), res_hight varchar(10), res_weight varchar(10), res_mobile_phone varchar(100), res_tel_phone varchar(100), res_email varchar(255), res_city varchar(255), res_area varchar(255), res_short_address varchar(255), res_address varchar(255), res_home_city varchar(255), res_home_area varchar(255), res_home_short_address varchar(255), res_home_address varchar(255), res_exp_salary varchar(255), res_soon_date varchar(255), res_overtime_state varchar(10), res_oversea_state varchar(10), res_vacancy_state varchar(10), res_en_listen varchar(10), res_en_speak varchar(10), res_en_read varchar(10), res_en_write varchar(10), res_en_proof varchar(100), res_en_score varchar(100), res_minnan_listen varchar(10), res_minnan_speak varchar(10), res_minnan_read varchar(10), res_minnan_write varchar(10), res_minnan_proof varchar(100), res_minnan_score varchar(100), res_other_lang varchar(10), res_other_listen varchar(10), res_other_speak varchar(10), res_other_read varchar(10), res_other_write varchar(10), res_other_proof varchar(100), res_other_score varchar(100), res_skill1 varchar(255), res_skill2 varchar(255), res_skill3 varchar(255), res_cert_name1 varchar(255), res_cert_date1 varchar(255), res_cert_number1 varchar(255), res_cert_name2 varchar(255), res_cert_date2 varchar(255), res_cert_number2 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_note( note_no int(255) AUTO_INCREMENT PRIMARY KEY, note_res_no int(255), 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; create table resume_param( par_no int(255) AUTO_INCREMENT PRIMARY KEY, par_type varchar(255), par_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 occupation( occ_no int(255) AUTO_INCREMENT PRIMARY KEY, occ_name varchar(255), occ_level varchar(255), occ_uplevel_no varchar(255), occ_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 resume_experience( exp_no int(255) AUTO_INCREMENT PRIMARY KEY, exp_res_no int(255), exp_type varchar(255), exp_start_date varchar(255), exp_end_date varchar(255), exp_name varchar(255), exp_position varchar(255), exp_job varchar(255), exp_salary 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; 學歷:代號/履歷代號/履歷類型/學校名/科系/入學日期/畢業日期/狀態(畢/肄業) create table resume_education( edu_no int(255) AUTO_INCREMENT PRIMARY KEY, edu_res_no int(255), edu_type varchar(255), edu_name varchar(255), edu_major varchar(255), edu_start varchar(255), edu_end 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_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_age varchar(255), eme_job 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_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_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; 列表欄位資訊:代號/類別/原始欄位/列表欄位/名稱/列表名稱/寬度/是否排序/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;