class Job(db.Model):
__tablename__ = 'job'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(256), nullable=False)
status = db.Column(db.String(256), nullable=False)
skill_id = db.Column(db.Integer, db.ForeignKey('skill.id'), nullable=False)
job_candidate = db.relationship('JobCandidate', backref='job', lazy=True)
def __repr__(self):
return 'id {}'.format(self.id)
class CandidateWordTitle(db.Model):
_tablename_ = 'candidate_word_title'
id = db.Column(db.Integer, primary_key=True)
candidate_id = db.Column(db.Integer,
db.ForeignKey('candidate.id'),
nullable=False)
word = db.Column(db.String(256), nullable=False)
class JobCandidateOpinion(db.Model):
__tablename__ = 'job_candidate_opinion'
id = db.Column(db.Integer, primary_key=True)
job_candidate = db.Column(db.Integer, db.ForeignKey('job_candidate.id'))
opinion = db.Column(db.String(256), nullable=False)
created_on = db.Column(db.DateTime,
nullable=False,
default=datetime.datetime.utcnow)
def __repr__(self):
return 'id {}'.format(self.id)
class Skill(db.Model):
__tablename__ = 'skill'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(256), unique=True, nullable=False)
job = db.relationship('Job', backref='skill', lazy=True)
candidate_skill = db.relationship('CandidateSkill',
backref='Skill',
lazy=True)
def __repr__(self):
return self.name
class Candidate(db.Model):
__tablename__ = 'candidate'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(256), nullable=False)
candidate_skill = db.relationship('CandidateSkill',
backref='Candidate',
lazy=True)
job_candidate = db.relationship('JobCandidate',
backref='Candidate',
lazy=True)
def __repr__(self):
return 'id {}'.format(self.id)
class JobWordTitle(db.Model):
_tablename_ = 'job_word_title'
id = db.Column(db.Integer, primary_key=True)
job_id = db.Column(db.Integer, db.ForeignKey('job.id'), nullable=False)
word = db.Column(db.String(256), nullable=False)