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

from sqlalchemy import Column, Integer, String, JSON, create_engine,DateTime,BigInteger
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from database import Base
from datetime import datetime

class TpPatternList(Base):
    __tablename__ = 'tp_pattern_list'

    id = Column(String(255),  primary_key=True)
    pattern_name = Column(String(255), nullable=True, comment='图案名称')
    content = Column(JSON, nullable=True, comment='图案json')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='数据更新时间')
    create_dept = Column(BigInteger, default=None, comment='创建部门')
    create_by = Column(BigInteger, default=None, comment='创建者')
    class Config:
        orm_mode = True

class TpPatternWSList(Base):
    __tablename__ = 'tp_pattern_ws_list'

    id = Column(String(255), primary_key=True)
    pattern_id = Column(String(255), nullable=True, comment='图案id')
    content = Column(JSON, nullable=True, comment='图案json')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='数据更新时间')
    create_dept = Column(BigInteger, default=None, comment='创建部门')
    create_by = Column(BigInteger, default=None, comment='创建者')
    update_by = Column(BigInteger, default=None, comment='更新者')
    class Config:
        orm_mode = True

class TpPatternWSUserList(Base):
    __tablename__ = 'tp_pattern_ws_user_list'

    id = Column(String(255), primary_key=True)
    pattern_id = Column(String(255), nullable=True, comment='图案id')
    pattern_name = Column(String(255), nullable=True, comment='图案名称')
    user_id = Column(String(255), nullable=True, comment='用户id')
    del_flag = Column(String(1), default='0', comment='删除标志（0代表存在 2代表删除）')
    create_time = Column(DateTime, default=datetime.now, comment='数据创建时间')
    update_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='数据更新时间')
    create_dept = Column(BigInteger, default=None, comment='创建部门')
    create_by = Column(BigInteger, default=None, comment='创建者')
    update_by = Column(BigInteger, default=None, comment='更新者')
    class Config:
        orm_mode = True