from db import db


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

    __tablename__ = "RawPRSPurchaseOrders"

    po_num = db.Column(db.Integer, nullable=False, primary_key=True)
    item_no = db.Column(db.Integer, nullable=False, primary_key=True)
    mps_form_id = db.Column(db.Integer, nullable=True)
    mps_budget_phase_id = db.Column(db.Integer, nullable=True)
    budget_group = db.Column(db.Integer, nullable=True)
    budget_category = db.Column(db.Integer, nullable=True)
    po_created_on = db.Column(db.Date, nullable=True)
    po_modified_on = db.Column(db.Date, nullable=True)
    po_status = db.Column(db.String, nullable=True)
    po_total = db.Column(db.DECIMAL, nullable=True)
    po_total_paid = db.Column(db.DECIMAL, nullable=True)

    vendor_name = db.Column(db.String, nullable=True)
    is_req_under_blanket = db.Column(db.String, nullable=True)
    blanket = db.Column(db.String, nullable=True)
    blanket_name = db.Column(db.String, nullable=True)
    blanket_po_id = db.Column(db.Integer, nullable=True)
    blanket_item_no = db.Column(db.Integer, nullable=True)
    total_blanket_remain = db.Column(db.String, nullable=True)
    item_desc = db.Column(db.String, nullable=True)
    item_full_desc = db.Column(db.String, nullable=True)
    is_unknown_vendor = db.Column(db.String, nullable=True)
    is_under_uncommited_blanket = db.Column(db.String, nullable=False)

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

    prs_project = db.relationship("RawPRSProjects")