device_set_condition.py 984 B

12345678910111213141516171819202122
  1. # -*- coding: utf-8 -*-
  2. """
  3. demeter database
  4. name:device_set_condition.py
  5. author:rabin
  6. """
  7. from .__load__ import *
  8. class Device_set_condition(Model):
  9. __table__ = 'device_set_condition'
  10. __comment__ = '设备条件设置表'
  11. id = Fields(type='uuid', primaryKey=True, comment='设置ID', uuid='farm_id')
  12. farm_id = Fields(type='int', default='setting.farm', comment='园区ID', match='not')
  13. devices = Fields(type='text', comment='设备id')
  14. device_id = Fields(type='uuid', comment='设备条件里的设备id')
  15. oper = Fields(type='smallint', comment='操作')
  16. condition = Fields(type='smallint', comment='条件')
  17. value = Fields(type='varchar(100)', comment='条件的值')
  18. notice = Fields(type='boolean', default='False', comment='是否报警')
  19. status = Fields(type='boolean', default='True', comment='是否取消')
  20. state = Fields(type='boolean', default='True', comment='数据存在状态')
  21. cdate = Fields(type='int', default='time', comment='创建时间')