| | |
| | | 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 '任务完成时间'; |
| | | * wms任务 |
| | | */ |
| | | @TableName(schema = "db_wms",value = "tb_task") |
| | | @Data |