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

from sqlalchemy import Column, Integer, String

from domain.models.base_model import FullModelBase


class SysDeptModel(FullModelBase):
    """
    部门表
    """

    __tablename__ = "sys_dept"

    parent_id = Column(Integer, default=0, comment="父部门id")
    ancestors = Column(String(50), nullable=True, default="", comment="祖级列表")
    dept_name = Column(String(30), nullable=True, default="", comment="部门名称")
    order_num = Column(Integer, default=0, comment="显示顺序")
    leader = Column(String(20), nullable=True, default=None, comment="负责人")
    phone = Column(String(11), nullable=True, default=None, comment="联系电话")
    email = Column(String(50), nullable=True, default=None, comment="邮箱")
    status = Column(
        Integer, nullable=False, default=0, comment="部门状态（0正常 1停用）"
    )