79 lines
2.7 KiB
Python
79 lines
2.7 KiB
Python
"""库存系统 ORM 模型（只读，从现有数据库逆向生成）"""
|
||
from sqlalchemy import Column, Integer, String, Numeric, Boolean, ForeignKey
|
||
from sqlalchemy.orm import relationship
|
||
from app.database import Base
|
||
|
||
|
||
class SysUser(Base):
|
||
"""系统用户表（只读，从旧库映射）"""
|
||
__tablename__ = "sys_user"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
username = Column(String(100), unique=True, nullable=False, index=True)
|
||
password = Column(String(255), nullable=False)
|
||
real_name = Column(String(100))
|
||
department = Column(String(100))
|
||
is_active = Column(Integer, default=1)
|
||
|
||
|
||
class MaterialBase(Base):
|
||
"""物料基础表（只读）"""
|
||
__tablename__ = "material_base"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
name = Column(String(255), nullable=False)
|
||
spec_model = Column(String(255))
|
||
unit = Column(String(50))
|
||
|
||
|
||
class BomTable(Base):
|
||
"""BOM物料清单表（只读）"""
|
||
__tablename__ = "bom_table"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
parent_id = Column(Integer, ForeignKey("material_base.id"), nullable=False)
|
||
child_id = Column(Integer, ForeignKey("material_base.id"), nullable=False)
|
||
dosage = Column(Numeric(10, 4), nullable=False)
|
||
bom_no = Column(String(100), nullable=True)
|
||
version = Column(String(50), nullable=True)
|
||
is_enabled = Column(Boolean, default=True)
|
||
|
||
parent = relationship("MaterialBase", foreign_keys=[parent_id])
|
||
child = relationship("MaterialBase", foreign_keys=[child_id])
|
||
|
||
|
||
class StockProduct(Base):
|
||
"""库存产品表（只读）"""
|
||
__tablename__ = "stock_product"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
base_id = Column(Integer, ForeignKey("material_base.id"), nullable=False)
|
||
stock_quantity = Column(Numeric(10, 2), default=0)
|
||
work_order_id = Column(Integer, nullable=True)
|
||
|
||
material = relationship("MaterialBase", foreign_keys=[base_id])
|
||
|
||
|
||
class TransOutbound(Base):
|
||
"""出库记录表（只读）"""
|
||
__tablename__ = "trans_outbound"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
outbound_no = Column(String(100), unique=True, nullable=False)
|
||
stock_id = Column(Integer, ForeignKey("stock_product.id"), nullable=False)
|
||
quantity = Column(Numeric(10, 2), nullable=False)
|
||
consumer_name = Column(String(255))
|
||
|
||
stock = relationship("StockProduct", foreign_keys=[stock_id])
|
||
|
||
|
||
class StockBuy(Base):
|
||
"""原材料库存表（只读）"""
|
||
__tablename__ = "stock_buy"
|
||
|
||
id = Column(Integer, primary_key=True, index=True)
|
||
base_id = Column(Integer, ForeignKey("material_base.id"), nullable=False)
|
||
stock_quantity = Column(Numeric(10, 2), default=0)
|
||
|
||
material = relationship("MaterialBase", foreign_keys=[base_id])
|