| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576 |
- 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',
- dict_id bigint NOT NULL DEFAULT '-1' COMMENT '商品类型id',
- goods_id bigint NOT NULL DEFAULT '-1' COMMENT '商品id',
- goods_name varchar(20) NOT NULL default '' COMMENT '商品名称',
- loading_type int NOT NULL DEFAULT '0' COMMENT '装载类型（0装载，1补货）',
- status int NOT NULL DEFAULT '0' COMMENT '状态（1-待接单，5-已接单、10-已装载）',
- driver_id bigint NOT NULL DEFAULT '-1' COMMENT '装载员id',
- driver_name varchar(40) DEFAULT '' COMMENT '装载员姓名',
- driver_phone varchar(20) DEFAULT '' COMMENT '装载员联系电话',
- forklift_accept_time datetime DEFAULT NULL COMMENT '装载接单时间',
- finish_time datetime DEFAULT NULL COMMENT '装载完成时间',
- waybill_accept_time datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '运单接单时间',
- entrust_amount decimal(10,6) DEFAULT NULL COMMENT '任务量',
- truck_type varchar(5) NOT NULL DEFAULT '' COMMENT '车辆类型',
- carAxis varchar(5) NOT NULL DEFAULT '' 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 '铲车司机运单';
- create table kwt_gatekeeper_waybill_order
- (
- id bigint NOT NULL AUTO_INCREMENT 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',
- good_id bigint NOT NULL DEFAULT '-1' COMMENT '商品id',
- goods_name varchar(20) NOT NULL default '' COMMENT '商品名称',
- status int NOT NULL DEFAULT '0' COMMENT '状态（1-待进场，5-已进场、10-待离场、15-空载待离场、20-已放行未离场、25-已离场、30-空载离场）',
- into_time datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '进场时间',
- leave_time datetime DEFAULT NULL COMMENT '离场时间',
- waybill_accept_time datetime NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT '运单接单时间',
- entrust_amount decimal(10,6) DEFAULT NULL COMMENT '任务量',
- truck_type varchar(5) NOT NULL default '' COMMENT '车辆类型',
- carAxis varchar(5) NOT NULL default '' COMMENT '车辆轴数',
- legal_load decimal(10,2) DEFAULT NULL 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 '门卫车辆运单';
- CREATE TABLE tms_truck_axle_num (
- id int unsigned NOT NULL AUTO_INCREMENT,
- group_id int DEFAULT NULL,
- name varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车辆轴数',
- num varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
- standard_load decimal(10,2) DEFAULT NULL COMMENT '默认准载量',
- legal_load decimal(10,2) DEFAULT NULL COMMENT '货车法定载重',
- tractor_legal_load decimal(10,2) DEFAULT NULL COMMENT '牵引车法定载重',
- uuid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人id',
- uuid_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建人姓名',
- status tinyint unsigned NOT NULL DEFAULT '1' COMMENT '1正常 2禁用',
- create_time datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '数据添加时间',
- update_time datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '数据修改时间',
- delete_time datetime DEFAULT NULL COMMENT '数据删除时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='车辆轴数表';
|
