from db import db


class AdAccount(db.Model):
    """Ad account related to Fivetran connector"""

    __tablename__ = "AdAccount"

    id = db.Column(db.BigInteger, primary_key=True)
    ad_account_id = db.Column(db.String, nullable=False)
    connector_id = db.Column(db.Integer, db.ForeignKey("Connector.id", ondelete="CASCADE"), nullable=False)

    connector = db.relationship("Connector", back_populates="ad_accounts")