19 lines
655 B
Python
19 lines
655 B
Python
from sqlalchemy import Column, DateTime, ForeignKey, String
|
|
|
|
from app import db
|
|
from app.models.base import SoftDeleteMixin, TimestampMixin
|
|
|
|
from ._mixins import LabAuditMixin
|
|
|
|
|
|
class LabRecipeRation(db.Model, TimestampMixin, SoftDeleteMixin, LabAuditMixin):
|
|
__tablename__ = "lab_recipe_ration"
|
|
|
|
recipe_id = Column(String(36), ForeignKey("recipe.id"), primary_key=True)
|
|
animal_profile_id = Column(
|
|
String(36), ForeignKey("lab_animal_profile.id"), nullable=True, index=True
|
|
)
|
|
calc_engine = Column(String(20), nullable=True)
|
|
seed_source = Column(String(32), nullable=True)
|
|
calculated_at = Column(DateTime, nullable=True)
|