New file |
| | |
| | | package com.whyc.pojo.db_wms; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.IdType; |
| | | import com.baomidou.mybatisplus.annotation.TableId; |
| | | import com.baomidou.mybatisplus.annotation.TableName; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import lombok.ToString; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * CREATE TABLE db_wms.tb_task( |
| | | * id integer NOT NULL DEFAULT nextval('db_wms.task_id_seq'::regclass), |
| | | * task_no character varying(20) NOT NULL COLLATE pg_catalog."default", |
| | | * des inet, |
| | | * pallets character varying(50) NOT NULL COLLATE pg_catalog."default", |
| | | * activate_parameter character varying(50) COLLATE pg_catalog."default", |
| | | * task_type integer NOT NULL, |
| | | * start_location_code character varying(20) NOT NULL COLLATE pg_catalog."default", |
| | | * end_location_code character varying(20) NOT NULL COLLATE pg_catalog."default", |
| | | * status integer NOT NULL, |
| | | * status_time timestamp without time zone NOT NULL, |
| | | * execute_time timestamp without time zone, |
| | | * execute_end_time timestamp without time zone, |
| | | * create_time timestamp without time zone NOT NULL, |
| | | * end_time timestamp without time zone, |
| | | * PRIMARY KEY (id) |
| | | * ) |
| | | * |
| | | * ; |
| | | * |
| | | * ALTER TABLE db_wms.tb_task |
| | | * OWNER TO sysdba; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.task_no IS '任务编号'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.des IS '任务类型 1 =一楼出库、2=测电压、3=活化、4=二楼出库'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.pallets IS '电池编号,用逗号隔开'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.activate_parameter IS '活化参数,用逗号隔开'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.task_type IS '任务类型:1=普通搬运、2=活化任务、3=缓存测压任务、4=入库测压任务、5=检测搬运任务'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.start_location_code IS '起点编号'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.end_location_code IS '终点编号'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.status IS '状态:1=开始取货、2=取货完成、4=放货完成; 11=开始取活化电池、12=取到活化电池、13=活化电池放置到活化仓内、14=开始取活化结束的电池、15=取到活化结束的电池、16=活化返库完成; 21=开始取测压电池、22=取到测压电池、23=测压电池放置到活化仓内、24=开始取测压结束的电池、25=取到测压结束的电池、26=测压返库完成'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.status_time IS '获取状态时对应的时间'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.execute_time IS '活化或者测压动作的开始时间'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.execute_end_time IS '活化或者测压动作的开始时间'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.create_time IS '任务开始时间'; |
| | | * |
| | | * COMMENT ON COLUMN db_wms.tb_task.end_time IS '任务完成时间'; |
| | | */ |
| | | @TableName(schema = "db_wms",value = "tb_task") |
| | | @Data |
| | | @ToString |
| | | public class Task { |
| | | |
| | | @TableId(type = IdType.AUTO) |
| | | private Integer id; |
| | | @ApiModelProperty(value = "任务编号") |
| | | private String taskNo; |
| | | @ApiModelProperty(value = "任务类型 1 =一楼出库、2=测电压、3=活化、4=二楼出库") |
| | | private Integer des; |
| | | @ApiModelProperty(value = "电池编号,用逗号隔开") |
| | | private String pallets; |
| | | @ApiModelProperty(value = "激活参数,用逗号隔开") |
| | | private String activateParameter; |
| | | @ApiModelProperty(value = "任务类型:1=普通搬运、2=活化任务、3=缓存测压任务、4=入库测压任务、5=检测搬运任务") |
| | | private Integer taskType; |
| | | @ApiModelProperty(value = "起点编号") |
| | | private String startLocationCode; |
| | | @ApiModelProperty(value = "终点编号") |
| | | private String endLocationCode; |
| | | @ApiModelProperty(value = "状态:1=开始取货、2=取货完成、4=放货完成; 11=开始取活化电池、12=取到活化电池、13=活化电池放置到活化仓内、14=开始取活化结束的电池、15=取到活化结束的电池、16=活化返库完成; 21=开始取测压电池、22=取到测压电池、23=测压电池放置到活化仓内、24=开始取测压结束的电池、25=取到测压结束的电池、26=测压返库完成") |
| | | private Integer status; |
| | | @ApiModelProperty(value = "状态时间") |
| | | private Date statusTime; |
| | | @ApiModelProperty(value = "活化或者测压动作的开始时间") |
| | | private Date executeTime; |
| | | @ApiModelProperty(value = "活化或者测压动作的结束时间") |
| | | private Date executeEndTime; |
| | | @ApiModelProperty(value = "创建时间") |
| | | private Date createTime; |
| | | @ApiModelProperty(value = "完成时间") |
| | | private Date endTime; |
| | | |
| | | } |