python-fastapi-mm-zhcs-yj-api/models/yzy_base.py

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
from sqlalchemy import String, Column, Integer, Date, DateTime
from database import Base
from datetime import datetime

class YzyOrgUnitEntity(Base):
    """
    组织机构信息表
    """
    __tablename__ = "yzy_org_unit"

    unitid = Column(String, primary_key=True)
    unitname = Column(String)
    createtime = Column(Date)
    updatetime = Column(Date)
    unitpath = Column(String)
    parentunitid = Column(String)
    order = Column(Integer)
    weworkpartyid = Column(String)
    orgtype = Column(String)
    priority = Column(Integer)

    class Config:
        orm_mode = True



class YzyOrgUserEntity(Base):
    """
    用户信息表
    """
    __tablename__ = "yzy_org_user"

    uid = Column(Integer, primary_key=True, autoincrement=True)
    userid = Column(String, primary_key=True)
    username = Column(String)
    displayname = Column(String)
    account = Column(String)
    gender = Column(Integer)
    telephonenumber = Column(String)
    certificatetypeid = Column(Integer)
    certificatenumber = Column(String)
    #weworkpartyid = Column(String)
    createtime = Column(Date)
    updatetime = Column(Date)
    unitid = Column(String)
    #unitleader = Column(Integer)
    position = Column(String)
    priority = Column(Integer)
    unitpath = Column(Integer)


    class Config:
        orm_mode = True


class YzyMsgQueue(Base):
    """
    粤政易消息队列
    """
    __tablename__ = "yzy_msg_queue"

    id = Column(Integer, primary_key=True, autoincrement=True)
    yzy_userid = Column(String, default='', server_default='', comment='粤政易用户ID')
    mobile = Column(String, default='', server_default='', comment='手机号码')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    sent_time = Column(String, comment='发送时间')
    sent_status = Column(Integer, default=0, server_default='0', comment='发送状态 0 待发 1发送中 2 发送成功 9 发送失败')
    content = Column(String, default='', server_default='', comment='消息体')
    recorded_by = Column(Integer, default=0, server_default='0', comment='记录用户ID')
    detail_url = Column(String, default='', server_default='', comment='跳转URL')
    title = Column(String, default='', server_default='', comment='标题')
    foreign_key = Column(String, default='', server_default='', comment='文件外键 --技术字段')
    from_scenario = Column(String, default='', server_default='', comment='对应标识 --技术字段')
    errcode = Column(Integer, default=0, server_default='0', comment='错误代码')
    errmsg = Column(String, default='', server_default='', comment='错误提示')