import sqlalchemy as sa
from sqlalchemy.orm import Mapped, mapped_column

from campaigns.connectors.db.orm import Base
from campaigns.utils.uuid import uuid_string


class CampaignAdSetEngagementAudience(Base):
    __tablename__ = "meta_campaign_ad_set_engagement_audience"

    id: Mapped[str] = mapped_column(primary_key=True, default=uuid_string)
    ad_set_id: Mapped[str] = mapped_column(sa.ForeignKey("meta_campaign_ad_set.id"))
    audience_id: Mapped[str] = mapped_column(
        sa.ForeignKey("meta_engagement_audience.id")
    )