| 12345678910111213141516171819202122 |
- from sqlalchemy import Column, Integer, Text, BigInteger, String, SmallInteger, Boolean, TIMESTAMP
- from sqlalchemy.ext.declarative import declarative_base
- Base = declarative_base()
- class QywxEmployee(Base):
- __tablename__ = "qywx_employee"
- id = Column(BigInteger, primary_key=True, autoincrement=True, comment="主键id")
- third_party_user_id = Column(String(32), nullable=True, comment="员工在三方平台ID，唯一")
- name = Column(String(50), nullable=False, comment="员工姓名")
- wxid = Column(String(32), nullable=False, comment="员工在企业微信的ID，唯一")
- status = Column(Integer, nullable=False, comment="员工状态（0: 离职, 1: 在职）")
- create_time = Column(BigInteger, nullable=True, default=0, comment="创建时间（时间戳）")
- update_time = Column(BigInteger, nullable=True, default=0, comment="更新时间（时间戳）")
- agent_name = Column(String(50), nullable=True, comment="作为服务助手时的名字")
- agent_gender = Column(SmallInteger, nullable=True, comment="作为服务助手时的性别")
- agent_age = Column(SmallInteger, nullable=True, comment="作为服务助手时的年龄")
- agent_region = Column(String(50), nullable=True, comment="作为服务助手时的地区")
- agent_profile = Column(Text, nullable=True, comment="服务助手的画像，JSON字符串")
- guid = Column(String(50), nullable=True, comment="设备ID")
|
