"""MarketingAccount model."""
from src.db import db


class MarketingAccount(db.Model):
    """MarketingAccount model."""

    __tablename__ = "MarketingAccount"

    id = db.Column(db.Integer, primary_key=True)
    label_id = db.Column(db.Integer, db.ForeignKey("Label.id"), nullable=False)
    external_id = db.Column(db.String, nullable=False, index=True)
    provider_id = db.Column(db.Integer, nullable=False)
    name = db.Column(db.String)
    source = db.Column(db.String)
    currency = db.Column(db.String)
    label = db.relationship("Label")

    __table_args__ = (db.UniqueConstraint("external_id", name="uq_MarketingAccount_external_id"),)

    def __str__(self):
        return self.name