| 1234567891011121314151617 |
- create table kwf_truck_route
- (
- id bigint not null comment '主键'
- primary key,
- fleet_id bigint not null default 0 comment '车队id',
- driver_id bigint not null default 0 comment '司机id',
- ent_id bigint not null default 0 comment '企业id',
- start_point varchar(400) not null default '' comment '起始点',
- unloading_Point varchar(400) not null default '' comment '卸货地点',
- shortest_time varchar(10) not null comment '最短时间',
- create_time datetime not null default current_timestamp comment '创建时间',
- update_time datetime not null default current_timestamp on update current_timestamp comment '更新时间',
- del_flag tinyint not null default 0 comment '是否删除(0未删除,1删除)'
- )
- comment '车辆惯用线路信息表';
|