from db import db


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

    __tablename__ = "RawPRSProjects"

    sub_project_cd = db.Column(db.String, nullable=False, primary_key=True)
    sub_project_description = db.Column(db.String, nullable=False)
    recording_project_no = db.Column(db.Integer, nullable=False)
    recording_project_artist_tx = db.Column(db.String, nullable=True)
    recording_project_title_tx = db.Column(db.String, nullable=True)
    rep_owner_key = db.Column(db.String, nullable=True)
    recording_project_artist_num = db.Column(db.Integer, nullable=True)
    admin_group_cd = db.Column(db.String, nullable=True)
    admin_group_name_tx = db.Column(db.String, nullable=True)
    company_code = db.Column(db.String, nullable=True)

    __table_args__ = (db.UniqueConstraint("sub_project_cd", name="uq_RawPRSProjects_sub_project_cd"),)

    purchase_orders = db.relationship("RawPRSPurchaseOrders")
    budgets = db.relationship("RawPRSBudgets")