from sqlalchemy.orm import Mapped, mapped_column

from dmp.adapters.db import ReportingModel


class EmailAnalyticsByCampaignFanDbt(ReportingModel, kw_only=True):
    __tablename__ = "email_analytics_by_campaign_fan_dbt"

    campaign_id: Mapped[str] = mapped_column(primary_key=True)
    fan_id: Mapped[str] = mapped_column(primary_key=True)
    delivered: Mapped[bool]
    opened: Mapped[bool]
    clicked: Mapped[bool]