修改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;

管理者帳號:代號/職稱/主管/名稱/暱稱/帳號/手機/大頭照/全身照/Googleid/系統選單/備註/狀態/順序
人才庫刪除/切換人員/
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_mobile varchar(255),
       user_pic varchar(255),
       user_pic2 varchar(255),
       user_google_id varchar(255),
       user_menu_no varchar(255),
       user_note longtext,
       user_state varchar(255),
       user_order_no int(255),
			
       HumanDel varchar(255),
       
       RecruitModify varchar(255),
       RecruitDel varchar(255),
       RecruitCheck varchar(255),
       
       UserChange 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),
       
       HumanDel varchar(255),
       RecruitModify varchar(255),
       RecruitDel varchar(255),
       RecruitPapersCheck varchar(255),
       UserChange 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(
       cus_no int(255) AUTO_INCREMENT PRIMARY KEY,
       cus_kind varchar(255),
       cus_name varchar(255),
       cus_com_no int(255),
       cus_user_no varchar(255),
       cus_user_no2 varchar(255),
       cus_id varchar(255),
       cus_score varchar(255),
       cus_city varchar(255),
       cus_area varchar(255),
       cus_address 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 store(
       sto_no int(255) AUTO_INCREMENT PRIMARY KEY,
       sto_cus_no int(255),
       sto_name varchar(255),
       sto_user_no int(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;

列表欄位資訊:代號/類別/原始欄位/列表欄位/名稱/列表名稱/寬度/是否排序/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 message(
       mes_no int(255) AUTO_INCREMENT PRIMARY KEY,
							mes_user_no int(255),
       mes_content longtext,
       mes_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 holiday(
       hol_no int(255) AUTO_INCREMENT PRIMARY KEY,
       hol_date date,
       hol_name varchar(255),
       hol_state varchar(255),
       hol_national varchar(255),
       hol_desc 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 project(
       pro_no int(255) AUTO_INCREMENT PRIMARY KEY,
       pro_cus_no int(255),
       pro_com_no varchar(255),
       pro_name varchar(255),
       pro_content longtext,
       pro_pay int(255),
       pro_lev_modify varchar(255),
       pro_papers varchar(255),
       pro_contract varchar(255),
       pro_ins_kind varchar(255),
       pro_health 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 work_date(
       work_no int(255) AUTO_INCREMENT PRIMARY KEY,
			 work_cus_no int(255),
       work_date varchar(255),
       work_note longtext,
       work_limit int(255),
       work_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 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;

學校:代號/學校名稱/學校類型(高中、大學)/當日加健保/順序
create table school(
       sch_no int(255) AUTO_INCREMENT PRIMARY KEY,
       sch_name varchar(255),
       sch_kind varchar(255),
       sch_health varchar(255),
       sch_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 department(
       dep_no int(255) AUTO_INCREMENT PRIMARY KEY,
       dep_sch_no int(255),
       dep_name varchar(255),
       dep_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 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 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_group_id 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 varchar(255),
       rec_cus_no int(255),
       rec_sto_no int(255),
	     rec_pro_no int(255), 
       res_hum_no int(255),
		   rec_name varchar(255),
       rec_name2 varchar(255),
       rec_country varchar(255),
		   rec_sex varchar(255),
       rec_birthday varchar(255),
		   rec_id varchar(255),
       
       rec_sho_no int(255),
       rec_dep_no int(255),
       rec_job_week varchar(255),
       rec_city varchar(255),
       rec_area varchar(255),
       rec_address varchar(255),
       rec_mobile varchar(255),
       rec_reside varchar(255),
       rec_work_start varchar(255),
       rec_work_end varchar(255),
       rec_trans varchar(255),
	     rec_note longtext,
       rec_language varchar(255),
       rec_papers_state 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_on_date varchar(255),
       rec_off_date 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;


人才庫資訊:代號/人才庫模式/語言/專員代號/國籍/中文姓名/英文姓名/性別/生日/居留號碼/學校/科系/地址-縣市/地址-地區/地址/電話號碼/備註/狀態
create table human(
       hum_no int(255) AUTO_INCREMENT PRIMARY KEY,
       hum_type varchar(255),
       hum_language vachar(255),
       hum_user_no int(255),
       hum_country varchar(255),
		   hum_name varchar(255),
       hum_name2 varchar(255),
		   hum_sex varchar(255),
       hum_birthday varchar(255),
		   hum_id varchar(255),
       hum_sho_no int(255),
       hum_dep_no int(255),
       hum_city varchar(255),
       hum_area varchar(255),
       hum_address varchar(255),
       hum_mobile varchar(255),
	     hum_note longtext,
       hum_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 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_cha_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,
			 ins_status varchar(255),
       ins_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;

眷屬:代號/求職者代號/身分證/姓名/性別/身份別/出生日期/加保日期/加保作業日期/退保日期/退保作業日期/稱謂/加保原因/是否為學生/學生證/健保卡/相關檔案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;
員工契約書:代號/廠商代號/語言版本/契約名稱(中文)/契約名稱(印尼文)/契約名稱(越文)/契約名稱(英文)/契約WORD檔/WORD檔名稱/備註
create table customer_contract(
       con_no int(255) AUTO_INCREMENT PRIMARY KEY,
       con_cus_no int(255),
       con_language varchar(255),
       con_name_tw varchar(255),
       con_name_id varchar(255),
       con_name_vn varchar(255),
       con_name_en 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_language varchar(255),
       item_id varchar(255),
       item_name_tw varchar(255),
       item_name_id varchar(255),
       item_name_vn varchar(255),
       item_name_en 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/file/contract/health/resign)/文件編號/
文件名稱(中文)/文件名稱(印尼文)/文件名稱(越文)/文件名稱(英文)/
文件寬/文件高/必填/自定檔案/檔案/檔案名稱/備註/簽名/筆數/狀態(待上傳/待驗證/已驗證)/
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_tw varchar(255),
       pap_name_id varchar(255),
       pap_name_vn varchar(255),
       pap_name_en varchar(255),
       
       pap_width varchar(255),
       pap_height varchar(255),
       pap_need varchar(255),
       pap_self varchar(255),
       pap_file varchar(255),
       pap_file_name varchar(255),
       pap_note longtext,
       pap_sign varchar(255),
       pap_number 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;

面試交戰守則:代號/求職者代號/Q1~11/說明1~2/同意/簽名檔
create table recruit_interview(
       int_no int(255) AUTO_INCREMENT PRIMARY KEY,
       int_rec_no int(255),
       int_q1   varchar(255),
       int_q2   varchar(255),
       int_q3   varchar(255),
       int_q4   varchar(255),
       int_q5   varchar(255),
       int_q6   varchar(255),
       int_q7   varchar(255),
       int_q8   varchar(255),
       int_q9   varchar(255),
       int_q10  varchar(255),
       int_q10_note varchar(255),
       int_q11  varchar(255),
       int_q11_note varchar(255),
       int_agree varchar(255),
       int_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_resign(
       res_no int(255) AUTO_INCREMENT PRIMARY KEY,
       res_rec_no int(255),
       res_reason longtext,
       res_stuff  longtext,
       res_note   longtext,
       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 resume(
       res_no int(255) AUTO_INCREMENT PRIMARY KEY,
       res_method varchar(255),
       res_name varchar(255),
       res_id varchar(255),
       res_mobile varchar(255),
       res_email varchar(255),
       res_password varchar(255),
       res_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_type(
       type_no int(255) AUTO_INCREMENT PRIMARY KEY,
       type_res_no int(255),
       type_name varchar(255),
       type_lang 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_work varchar(255),
       pro2_end varchar(255),
       pro2_last_work 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_status varchar(255),
       pro2_ostatus 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_change(
       cha_no int(255) AUTO_INCREMENT PRIMARY KEY,
       cha_rec_no int(255),
       cha_pro2_no int(255),
       cha_user_no int(255),
       cha_date varchar(255),
       cha_status varchar(255),
       cha_idate 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;

計薪項目:代號/項目名稱/順序
create table salary_item(
       item_no int(255) AUTO_INCREMENT PRIMARY KEY,
       item_name 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 cowork(
       cow_no int(255) AUTO_INCREMENT PRIMARY KEY,
       cow_customer   	varchar(255),
       cow_company 		varchar(255),
       cow_name		 	varchar(255),
       cow_on_date		varchar(255),
       cow_off_date		varchar(255),
       cow_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;

排班表計薪項目:代號/班表代碼/求職者代碼/計薪項目代碼/值
create table work_item(
       wite_no int(255) AUTO_INCREMENT PRIMARY KEY,
       wite_work_no int(255),
       wite_rec_no int(255),
       wite_item_no int(255),
	   wite_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 bulletin(
       bul_no int(255) AUTO_INCREMENT PRIMARY KEY,
       bul_public_date varchar(255),
       bul_run_date varchar(255),
       bul_title 	varchar(255),
	   bul_content  longtext,
       bul_user 	text,
       
       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 stamp(
       sta_no int(255) AUTO_INCREMENT PRIMARY KEY,
       sta_date 		varchar(255),
	   sta_user_no   	 varchar(255),
	   sta_user2_no   	 varchar(255),
	   sta_date2  	 varchar(255),
	   sta_user3_no   	 varchar(255),
	   sta_date3  	 varchar(255),
       sta_unit		    varchar(255),
       sta_class     	varchar(255),
       sta_seal	 		varchar(255),
	   sta_customer   	varchar(255),
       sta_period	 	longtext,
	   sta_contract_file varchar(255),
	   sta_quote_file	 varchar(255),
	   sta_salary_file	 varchar(255),
	   sta_init_file	 varchar(255),
	   sta_renew_file	 varchar(255),
	   sta_revised_file	 varchar(255),
	   sta_other_file	 varchar(255),
	   sta_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;

新建廠商資料表: 代號|填表日期|駐場人員|管理部審核人員|管理部審核日期|會計部覆核人員|會計部覆核日期|隸屬單位|開發人員|客戶名稱|服務內容|統一編號|郵遞區號+發票寄送地址|請款匯款日(廠商匯款日期)|員工發薪日|薪資結算區間|每周排班標準|上班時間|人事聯絡窗口(請記得寫職稱)+電話+E-mail|請款聯絡窗口(請記得寫職稱)+電話+E-mail|注意事項1.場內是否有小組長|2.遲到早退扣標準|3.餐費補助|可請款金額|4.餐費扣款|5.體檢費補助|可請款金額|6.體檢費扣款|7.未歸還項目需扣款-門禁卡價格|工作鞋價格|置物櫃價格|背心價格|半/全套無塵服or靜電服價格|其他|發票開立日|分成單位及利潤(我司;貴司)-材霈|分成單位及利潤(我司;貴司)-艾肯|分成單位及利潤(我司;貴司)-首誠|分成單位及利潤(我司;貴司)-仲誠|分成單位及利潤(我司;貴司)-其他|報價|投保級距|扣員工自付額金額-勞保|扣員工自付額金額-健保|扣員工自付額金額-團保|狀態
create table prepcust(
       pre_no int(255) AUTO_INCREMENT PRIMARY KEY,
	   pre_date		   VARCHAR(255),
	   pre_user_no   		VARCHAR(255),
	   pre_user_no2	VARCHAR(255),
	   pre_date2	VARCHAR(255),
	   pre_user_no3	VARCHAR(255),
	   pre_date3	VARCHAR(255),
       pre_unit        VARCHAR(255),
	   pre_dev_user_no VARCHAR(255),
	   pre_customer    VARCHAR(255),
	   pre_service	   VARCHAR(255),
	   pre_id  	   	   VARCHAR(255),
	   pre_zipcode	   VARCHAR(255),
	   pre_invoice_address 	VARCHAR(255),
	   pre_payment_date   	VARCHAR(255),
	   pre_salary_date   	VARCHAR(255),
	   pre_salary_period   	VARCHAR(255),
	   pre_weekly_shift   	VARCHAR(255),
	   pre_work_hours 		VARCHAR(255),
	   pre_hr_contact		longtext,
	   pre_fi_contract		longtext,
	   prg_has_team_leader  VARCHAR(255),
	   pre_late_penalty  	VARCHAR(255),
	   pre_meal_subsidy	 	VARCHAR(255),
	   pre_meal_subsidy_amount 	VARCHAR(255),
	   pre_meal_deduct 	VARCHAR(255),
	   pre_health_check_subsidy VARCHAR(255),
	   pre_health_check_subsidy_amount VARCHAR(255),
	   pre_health_check_deduct 	VARCHAR(255), 
	   pre_missing_keycard_cost  VARCHAR(255),
	   pre_missing_shoes_cost 	 VARCHAR(255),
	   pre_missing_locker_cost 	 VARCHAR(255),
	   pre_missing_vest_cost	 VARCHAR(255),
	   pre_missing_suit_cost	VARCHAR(255),
	   pre_missing_other 	VARCHAR(255),
	   pre_invoice_date		VARCHAR(255),
	   pre_share_profit_tsaipei		VARCHAR(255),
	   pre_share_profit_ican		VARCHAR(255),
	   pre_share_profit_shoucheng	VARCHAR(255),
	   pre_share_profit_chongcheng	VARCHAR(255),
	   pre_share_profit_other		VARCHAR(255),
	   pre_quote					VARCHAR(255),
	   pre_insurance_level			VARCHAR(255),
	   pre_labor_insurance_deduct	VARCHAR(255),
	   pre_health_insurance_deduct	VARCHAR(255),
	   pre_group_insurance_deduct	VARCHAR(255),
	   pre_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;
--------------------------------------------------------------------------------------------------------------------------