"""LabelParticipantProductParticipation Snowflake model."""

from sqlalchemy.orm import Mapped, mapped_column

from collaborator import config
from collaborator.connectors import snowflake


class LabelParticipantProductParticipation(snowflake.BaseModel):
    """LabelParticipantProductParticipation model."""

    __tablename__ = "LABEL_PARTICIPANT_PARTICIPATED_IN_ORCHARD_PRODUCT"

    if config.ENVIRONMENT != config.TEST_ENVIRONMENT:
        __table_args__ = {"schema": config.SNOWFLAKE_SCHEMAS["facts"]}

    label_participant_id: Mapped[int] = mapped_column(primary_key=True)
    product_id: Mapped[int] = mapped_column(primary_key=True)