from db import db


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

    __tablename__ = "RawCCPPurchaseOrders"
    po_id = db.Column(db.String, nullable=False, primary_key=True)
    po_line = db.Column(db.String, nullable=False)
    commodity_lvl_2 = db.Column(db.String, nullable=True)
    expense_type = db.Column(db.String, nullable=True)
    creation_date = db.Column(db.Date, nullable=False)
    last_modified_date = db.Column(db.Date, nullable=True)
    status = db.Column(db.String, nullable=False)
    line_item_total_amount = db.Column(db.DECIMAL, nullable=False)
    line_item_total_amount_currency = db.Column(db.String, nullable=False)
    paid_line_item_amount = db.Column(db.DECIMAL, nullable=True)
    paid_line_item_amount_currency = db.Column(db.String, nullable=True)
    project_budget_code = db.Column(db.String, nullable=True)
    supplier = db.Column(db.String, nullable=True)
    short_description = db.Column(db.String, nullable=False)
    region = db.Column(db.String, nullable=False)