| | |
| | | import { BaseEntity } from '@cool-midway/core'; |
| | | import { Column, Double } from 'typeorm'; |
| | | /** |
| | | * 任务执行记录表 |
| | | */ |
| | | * 任务执行记录 |
| | | */ |
| | | @EntityModel('t_task_exec_record') |
| | | export class Execrecord extends BaseEntity { |
| | | @Column({ comment:'设备物理ID', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"物理序列号"}', type:'varchar', default:'null', length:50}) |
| | | device_id: string; |
| | | |
| | | @Column({ comment:'设备执行任务时刻的相关参数,json格式。', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'设备执行任务时刻的相关参数,json格式。', type:'varchar', default:'null', length:200}) |
| | | device_params: string; |
| | | |
| | | @Column({ comment:'结束时间,任务执行完成时间', type:'datetime'}) |
| | | @Column({ comment:'{name:"统计截止时间"}', type:'datetime'}) |
| | | end_time: Date; |
| | | |
| | | @Column({ comment:'执行结果', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"执行结果"}', type:'varchar', default:'null', length:50}) |
| | | exec_result: string; |
| | | |
| | | @Column({ comment:'执行耗时', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"执行耗时"}', type:'varchar', default:'null', length:0}) |
| | | exec_time: string; |
| | | |
| | | @Column({ comment:'1-周期任务 0-即时性任务', type:'int', default:null, width:0}) |
| | | @Column({ comment:'{name:"是否周期任务",dict:{"1":"周期任务","0":"即时性任务"}}', type:'int', default:null, width:0}) |
| | | is_periodic: number; |
| | | |
| | | @Column({ comment:'设备的逻辑ID', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"设备逻辑ID"}', type:'varchar', default:'null', length:50}) |
| | | logic_id: string; |
| | | |
| | | @Column({ comment:'服务端数据接收时间', type:'datetime'}) |
| | | @Column({ comment:'{name:"服务端数据接收时间"}', type:'datetime'}) |
| | | receive_time: Date; |
| | | |
| | | @Column({ comment:'备注', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"备注"}', type:'varchar', default:'null', length:50}) |
| | | remark: string; |
| | | |
| | | @Column({ comment:'数据回传时间', type:'datetime'}) |
| | | @Column({ comment:'{name:"数据回传时间"}', type:'datetime'}) |
| | | send_time: Date; |
| | | |
| | | @Column({ comment:'开始时间,设备收到指令时间', type:'datetime'}) |
| | | @Column({ comment:'{name:"统计起始时间"}', type:'datetime'}) |
| | | start_time: Date; |
| | | |
| | | @Column({ comment:'无意义,框架需要', type:'int', default:1, width:0}) |
| | | @Column({ comment:'{name:"状态",dict:{"1":"启用", "0":"停用"}}', type:'int', default:1, width:0}) |
| | | status: number; |
| | | |
| | | @Column({ comment:'任务指令', type:'varchar', default:'', length:50}) |
| | | @Column({ comment:'{name:"任务指令}', type:'varchar', default:'null', length:50}) |
| | | task_command: string; |
| | | |
| | | @Column({ comment:'任务ID,对应t_task_periodic_setting的主键,或者t_task_immediately主键', type:'int', default:null, width:0}) |
| | | @Column({ comment:'{name:"任务ID",tips:"周期任务表或者即时任务表主键"}', type:'int', default:null, width:0}) |
| | | task_id: number; |
| | | |
| | | @Column({ comment:'监测记录ID,对应t_task_monitor的主键', type:'int', default:null, width:0}) |
| | | @Column({ comment:'{name:"监测记录id"}', type:'int', default:null, width:0}) |
| | | task_monitor_id: number; |
| | | |
| | | } |