NexLab_System / app /models /inventory.py
alisaleem97's picture
Upload folder using huggingface_hub
6ea020b verified
Raw History Blame Contribute Delete
2.03 kB
# app/models/inventory.py
# Supply, Inventory, and CalControl models.
from typing import Optional
from datetime import datetime
from sqlmodel import SQLModel, Field, Relationship
class Supply(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
name: str = Field(index=True)
note: Optional[str] = None
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
class Inventory(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
material_type: str = Field(index=True)
test_id: Optional[int] = Field(default=None, foreign_key="testdefinition.id")
supply_id: Optional[int] = Field(default=None, foreign_key="supply.id")
test: Optional["TestDefinition"] = Relationship()
supply: Optional["Supply"] = Relationship()
quantity: float = Field(default=0.0)
unit: str = Field(default="Test")
expiration_date: datetime
note: Optional[str] = None
is_active: bool = Field(default=True)
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
edited_by: Optional[int] = Field(default=None, foreign_key="user.id")
edited_at: Optional[datetime] = None
class CalControl(SQLModel, table=True):
id: Optional[int] = Field(default=None, primary_key=True)
test_id: int = Field(foreign_key="testdefinition.id", index=True)
device_id: int = Field(foreign_key="device.id", index=True)
process_type: str = Field(index=True)
quantity: float
note: Optional[str] = None
created_by: Optional[int] = Field(default=None, foreign_key="user.id")
created_at: datetime = Field(default_factory=datetime.now)
test: "TestDefinition" = Relationship()
device: "Device" = Relationship()