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)