from sqlalchemy import Column, Float, ForeignKey, String, UniqueConstraint

from app import db


class LabComponentNutrientValue(db.Model):
    """Полная матрица показателей zootech «База сырья» (EAV, server-only)."""

    __tablename__ = "lab_component_nutrient_value"
    __table_args__ = (
        UniqueConstraint("component_id", "nutrient_key", name="uq_lab_comp_nutrient"),
    )

    id = Column(String(36), primary_key=True)
    component_id = Column(String(36), ForeignKey("component.id"), nullable=False, index=True)
    nutrient_key = Column(String(80), nullable=False, index=True)
    value = Column(Float, nullable=True)