VberAdminPy/VapAdmin/BACKEND/domain/models/admin/sys_dict.py

from sqlalchemy import Column, Integer, String, UniqueConstraint

from domain.models.base_model import UpdateModelBase, OrderModelBase


class SysDictTypeModel(UpdateModelBase):
    """
    字典类型表
    """

    __tablename__ = "sys_dict_type"

    dict_name = Column(String(100), nullable=True, default="", comment="字典名称")
    dict_type = Column(String(100), nullable=True, default="", comment="字典类型")
    status = Column(
        String(1), nullable=True, default="0", comment="状态（0正常 1停用）"
    )
    remark = Column(String(500), nullable=True, default=None, comment="备注")

    __table_args__ = (UniqueConstraint("dict_type", name="uq_sys_dict_type_dict_type"),)


class SysDictDataModel(UpdateModelBase, OrderModelBase):
    """
    字典数据表
    """

    __tablename__ = "sys_dict_data"

    dict_code = Column(
        Integer, primary_key=True, autoincrement=True, comment="字典编码"
    )
    dict_label = Column(String(100), nullable=True, default="", comment="字典标签")
    dict_value = Column(String(100), nullable=True, default="", comment="字典键值")
    dict_type = Column(String(100), nullable=True, default="", comment="字典类型")
    css_class = Column(
        String(100), nullable=True, default=None, comment="样式属性（其他样式扩展）"
    )
    list_class = Column(
        String(100), nullable=True, default=None, comment="表格回显样式"
    )
    is_default = Column(
        Integer, nullable=False, default=0, comment="是否默认（1是 0否）"
    )
    status = Column(Integer, nullable=False, default=0, comment="状态（0正常 1停用）")
    order_num = Column(Integer, nullable=True, default=0, comment="字典排序")
    remark = Column(String(500), nullable=True, default=None, comment="备注")