| 12345678910111213141516 |
- from sqlalchemy import BigInteger, Integer, SmallInteger, String
- from sqlalchemy.orm import Mapped, mapped_column
- from app.models.base import BaseModel, SoftDeleteMixin
- class ExpenseItem(BaseModel, SoftDeleteMixin):
- __tablename__ = "bx_expense_item"
- parent_id: Mapped[int] = mapped_column(BigInteger, nullable=False, default=0, server_default="0")
- item_name: Mapped[str] = mapped_column(String(128), nullable=False)
- item_code: Mapped[str | None] = mapped_column(String(64))
- level: Mapped[int] = mapped_column(SmallInteger, nullable=False, default=1, server_default="1")
- sort_order: Mapped[int] = mapped_column(Integer, nullable=False, default=0, server_default="0")
- status: Mapped[int] = mapped_column(SmallInteger, nullable=False, default=1, server_default="1")
- remark: Mapped[str | None] = mapped_column(String(512))
|
