device_pic.py 790 B

1234567891011121314151617181920
  1. # -*- coding: utf-8 -*-
  2. """
  3. demeter database
  4. name:device_pic.py
  5. author:rabin
  6. """
  7. from .__load__ import *
  8. class Device_pic(Model):
  9. __table__ = 'device_pic'
  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. gateway_id = Fields(type='uuid', comment='网关id')
  14. device_id = Fields(type='uuid', comment='设备id')
  15. pic = Fields(type='text', comment='图像记录')
  16. spic = Fields(type='text', comment='原图地址')
  17. sdate = Fields(type='int', comment='原图创建时间')
  18. state = Fields(type='boolean', default='True', comment='数据存在状态')
  19. cdate = Fields(type='int', default='time', comment='创建时间')