farm_user.py 906 B

123456789101112131415161718192021
  1. #!/usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. """
  4. demeter database
  5. name:farm_user.py
  6. author:rabin
  7. """
  8. from __load__ import *
  9. class Farm_user(Model):
  10. __table__ = 'farm_user'
  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. username = Fields(type='varchar(50)', comment='园区管理员姓名')
  15. mobile = Fields(type='bigint', comment='园区管理员手机号', unique=True)
  16. password = Fields(type='varchar(38)', comment='安全密码', md5=True)
  17. openid = Fields(type='varchar(50)', comment='wx openid')
  18. session_key = Fields(type='varchar(50)', comment='session_key')
  19. state = Fields(type='boolean', default='True', comment='数据存在状态')
  20. cdate = Fields(type='int', default='time', comment='创建时间')