from db import db


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

    __tablename__ = "PRSProjectBudget"
    id = db.Column(db.BigInteger, primary_key=True)
    project_id = db.Column(db.BigInteger, db.ForeignKey("Project.id", ondelete="CASCADE"), nullable=False)
    group_id = db.Column(db.BigInteger, db.ForeignKey("PRSBudgetGroup.id", ondelete="CASCADE"), nullable=False)
    category_id = db.Column(db.BigInteger, db.ForeignKey("PRSBudgetCategory.id", ondelete="CASCADE"), nullable=False)
    external_key = db.Column(db.String, nullable=True, unique=True)

    is_deleted = db.Column(db.Boolean, nullable=False, server_default="FALSE")
    value = db.Column(db.Numeric(12, 2), nullable=False)
    currency = db.Column(db.String, nullable=False, server_default="USD")

    project = db.relationship("Project", foreign_keys=[project_id])
    prs_budget_group = db.relationship("PRSBudgetGroup", foreign_keys=[group_id])
    prs_budget_category = db.relationship("PRSBudgetCategory", foreign_keys=[category_id])