廖磊 / control_calwaybill · Files

init.sql 680 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 
CREATE TABLE `bsth_control_r_hoursjsy` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `company_id` varchar(20) DEFAULT NULL,
  `sub_company_id` varchar(20) DEFAULT NULL,
  `line_code` varchar(100) DEFAULT NULL,
  `line_name` varchar(100) DEFAULT NULL,
  `jsy` varchar(100) DEFAULT NULL,
  `jsy_name` varchar(100) DEFAULT NULL,
  `nbbm` varchar(100) DEFAULT NULL,
  `lp_name` varchar(20) DEFAULT NULL,
  `rq` varchar(100) DEFAULT NULL,
  `hours_jh` float(10,0) DEFAULT NULL,
  `hours_sj` float(10,0) DEFAULT NULL,
  `fb_status` int(11) DEFAULT NULL,
  `source` int(11) DEFAULT NULL,
  `remarks` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;