from db import db


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

    __tablename__ = "RawCCPBudgets"
    project_budget_code = db.Column(db.String, nullable=False, primary_key=True)
    description = db.Column(db.String, nullable=False)
    commodity_lvl_2 = db.Column(db.String, nullable=True)
    commodity_lvl_2_description = db.Column(db.String, nullable=True)
    commodity_lvl_3 = db.Column(db.String, nullable=True)
    commodity_lvl_3_description = db.Column(db.String, nullable=True)
    expense_type = db.Column(db.String, nullable=True)
    expense_type_description = db.Column(db.String, nullable=True)
    expense_group = db.Column(db.String, nullable=True)
    expense_group_description = db.Column(db.String, nullable=True)
    total_project_amount = db.Column(db.String, nullable=False)
    currency = db.Column(db.String, nullable=False)
    creation_date = db.Column(db.Date, nullable=False)
    last_modified_date = db.Column(db.Date, nullable=True)
    region = db.Column(db.String, nullable=True)