2025_10_30_cxf_create.sql 893 B

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