"""Project territory model."""

from db import db


class CampaignTerritory(db.Model):
    """Project territory model."""

    __tablename__ = "CampaignTerritory"

    campaign_id = db.Column(
        db.BigInteger, db.ForeignKey("Campaign.id", ondelete="CASCADE"), nullable=False, primary_key=True
    )

    territory_id = db.Column(db.Integer, db.ForeignKey("Territory.id"), nullable=False, primary_key=True)

    campaign = db.relationship("Campaign", back_populates="territories")

    territory = db.relationship("Territory")

    budget_spend = db.Column(db.Numeric(12, 2), nullable=False)