| 123456789101112131415161718192021222324252627 |
- from __future__ import annotations
- from sqlmodel import Field, SQLModel
- class InboundOutbound(SQLModel, table=True):
- """出入库单表 - 对应 inbound_outbound"""
- __tablename__ = "inbound_outbound"
- id: int | None = Field(default=None, primary_key=True)
- date: str = Field(max_length=255, index=True) # 日期
- partner_company: str = Field(max_length=255) # 往来单位
- business_type: str = Field(max_length=255) # 业务类型（入库/出库）
- product: str = Field(max_length=255) # 产品
- quantity: float = Field() # 本次量（t）
- plan_no: str | None = Field(default=None, max_length=255, index=True) # 计划号
- batch_no: str | None = Field(default=None, max_length=255) # 批次号
- vehicle_no: str = Field(max_length=255, index=True) # 车牌号
- status: str | None = Field(default=None, max_length=50, index=True) # 状态
- remarks: str | None = Field(default=None) # 备注
- purchase_plan_id: int | None = Field(default=None, index=True) # 关联的计划ID
- is_deleted: int = Field(default=0, index=True) # 是否删除(0=否,1=是)
- created_at: str = Field(max_length=255) # 创建时间
- # 保留别名以兼容
- Inventory = InboundOutbound
|
