class EmailTemplate(Base, TimestampMixin):
    __tablename__ = "html_templates"
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey("users.id", ondelete="CASCADE"), nullable=False, index=True)
    name = Column(String(250), nullable=False)
    subject_hint = Column(String(500), default="")
    body_html = Column(Text, nullable=False)
    body_text = Column(Text, default="")
    source = Column(String(20), default="paste")  # paste|upload
    is_active = Column(Boolean, default=True, nullable=False)
    sequence_order = Column(Integer, default=0)


class Campaign(Base, TimestampMixin):
=== Recipient
class Recipient(Base, TimestampMixin):
    __tablename__ = "recipients"
    id = Column(Integer, primary_key=True)
    list_id = Column(Integer, ForeignKey("recipient_lists.id", ondelete="CASCADE"), nullable=False, index=True)
    email = Column(String(320), nullable=False, index=True)
    first_name = Column(String(150), default="")
    last_name = Column(String(150), default="")
    company_name = Column(String(250), default="")
    company_phone = Column(String(60), default="")
    customer_email = Column(String(320), default="")
    custom_fields = Column(JSON, default=dict)
    # validation / status
    status = Column(String(30), default="valid")  # valid|invalid|duplicate|suppressed|bounced
    validation_error = Column(Text, default="")
    is_valid = Column(Boolean, default=True, nullable=False)
    # unsubscribe token (unique secret per recipient)
    unsub_token = Column(String(64), unique=True, nullable=False)

    list = relationship("RecipientList", back_populates="recipients")

    __table_args__ = (Index("ix_recipient_list_email", "list_id", "email"),)


class SuppressionEntry(Base, TimestampMixin):