device_gateway.py 908 B

123456789101112131415161718192021
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. """
  4. demeter database
  5. name:device_gateway.py
  6. author:rabin
  7. """
  8. from __load__ import *
  9. class Device_gateway(Base):
  10. __table__ = 'device_gateway'
  11. __comment__ = '设备网关管理'
  12. id = Fields(type='uuid', primaryKey=True, comment='网关ID', uuid='farm_id')
  13. farm_id = Fields(type='int', default='setting.farm', comment='园区ID', match='not')
  14. name = Fields(type='varchar(50)', comment='网关名')
  15. hardware_id = Fields(type='bigint', comment='硬件id')
  16. power_num = Fields(type='smallint', comment='电源数值')
  17. power_status = Fields(type='boolean', default='False', comment='电源连接状态')
  18. status = Fields(type='boolean', default='False', comment='网关连接状态')
  19. state = Fields(type='boolean', default='True', comment='数据存在状态')
  20. cdate = Fields(type='int', default='time', comment='创建时间')