hd-crane-gs/backend/app/api/v1/module_business/crane/model.py

# -*- coding: utf-8 -*-
from typing import TYPE_CHECKING
from sqlalchemy import DECIMAL, String, DateTime, Text, Integer
from sqlalchemy.orm import relationship,Mapped, mapped_column
from decimal import Decimal  # Python内置Decimal
from app.core.base_model import ModelMixin, UserMixin

if TYPE_CHECKING:
    from app.api.v1.module_business.vardict.model import BizVarDictModel


class BizCraneModel(ModelMixin, UserMixin):
    """
    行车信息表
    """
    __tablename__: str = 'biz_crane'
    __table_args__: dict[str, str] = {'comment': '行车信息'}
    __loader_options__: list[str] = ["created_by", "updated_by"]

    crane_name: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='行车名称')
    crane_no: Mapped[str | None] = mapped_column(String(200), nullable=True, comment='行车编号')
    crane_model: Mapped[str | None] = mapped_column(String(50), nullable=True, comment='行车型号')
    work_span: Mapped[Decimal | None] = mapped_column(DECIMAL, nullable=True, comment='工作跨度')
    work_height: Mapped[Decimal | None] = mapped_column(DECIMAL, nullable=True, comment='工作高度')
    ip_address: Mapped[str | None] = mapped_column(String(50), nullable=True, comment='ip地址')
    order: Mapped[int | None] = mapped_column(Integer, nullable=True, comment='排序')