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

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 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)