setting_device_type.py 842 B

123456789101112131415161718192021
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. """
  4. demeter database
  5. name:device_type.py
  6. author:rabin
  7. """
  8. from .__load__ import *
  9. class Setting_device_type(Model):
  10. __table__ = 'setting_device_type'
  11. __comment__ = '设备类型'
  12. id = Fields(type='int', primaryKey=True, autoIncrement=True, comment='设备类型ID')
  13. name = Fields(type='varchar(50)', comment='设备类型名')
  14. key = Fields(type='varchar(50)', comment='设备标识', unique=True)
  15. unit = Fields(type='varchar(20)', comment='设备单位')
  16. exp = Fields(type='varchar(300)', comment='表达式')
  17. data_type = Fields(type='int', comment='数据类型')
  18. data_option = Fields(type='text', comment='数据类型选项')
  19. state = Fields(type='boolean', default='True', comment='数据存在状态')
  20. cdate = Fields(type='int', default='time', comment='创建时间')