from atlas_um.pgdb import pgdb
from atlas_um.pgdb.queries.job_cateegory import JobCategoryQuery


class JobCategory(pgdb.Model):
    __tablename__ = "job_category"
    query_class = JobCategoryQuery

    id = pgdb.Column(pgdb.Integer, primary_key=True)
    name = pgdb.Column(pgdb.String(), nullable=False, unique=True)
    slug = pgdb.Column(pgdb.String(), nullable=False, unique=True)
    is_deleted = pgdb.Column(pgdb.Boolean(), nullable=False, default=False)

    # Relations
    dna_accounts = pgdb.relationship(
        "DNAAccount", back_populates="job_category"
    )

    def __str__(self):
        return self.name