from db import db


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

    __tablename__ = "RawPRSBudgets"

    form_id = db.Column(db.Integer, nullable=False)
    phase_id = db.Column(db.Integer, nullable=False)
    phase_short_desc_tx = db.Column(db.String, nullable=True)
    inactive_in = db.Column(db.String, nullable=True)
    group_id = db.Column(db.Integer, nullable=False, primary_key=True)
    category_id = db.Column(db.Integer, nullable=False, primary_key=True)
    proposed_am = db.Column(db.DECIMAL, nullable=True)
    created_user = db.Column(db.String, nullable=True)
    updated_user = db.Column(db.String, nullable=True)
    created_at = db.Column(db.String, nullable=True)
    updated_at = db.Column(db.String, nullable=True)

    sub_project_cd = db.Column(
        db.String, db.ForeignKey("RawPRSProjects.sub_project_cd", ondelete="CASCADE"), nullable=False, primary_key=True
    )

    prs_project = db.relationship("RawPRSProjects")