create table kwt_forklift_waybill_order ( id bigint NOT NULL AUTO_INCREMENT COMMENT '主键', f_order_no varchar(30) NOT NULL DEFAULT '-1' COMMENT '编号', ent_id bigint NOT NULL DEFAULT '-1' COMMENT '企业id', w_order_id bigint NOT NULL DEFAULT '-1' COMMENT '物流运单id', l_order_id bigint NOT NULL DEFAULT '-1' COMMENT '物流订单id', loading_type int NOT NULL DEFAULT '0' COMMENT '装载类型(0装载,1补货)', status int NOT NULL DEFAULT '0' COMMENT '是否为当前车辆(1已结单、5已完成)', driver_id bigint NOT NULL DEFAULT '-1' COMMENT '装载员id', driver_name varchar(40) DEFAULT NULL default '' COMMENT '接单的装载员', driver_phone varchar(20) DEFAULT NULL default '' COMMENT '装载员联系电话', finish_time datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '装载完成时间', create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP COMMENT '更新时间', create_user bigint NOT NULL DEFAULT '-1' COMMENT '创建人', update_user bigint NOT NULL DEFAULT '-1' COMMENT '更新人', PRIMARY KEY (`id`) USING BTREE ) comment '铲车司机运单';