class Testimonial(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), unique=True, nullable=False) desc = db.Column(db.String(30), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='recom.jpg') testimony = db.Column(db.String(1000), nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Achievement(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String, nullable=False) description = db.Column(db.String, nullable=False) year = db.Column(db.Integer, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Achievement('{self.name}', '{self.category}', '{self.winner}')"
class Job(db.Model): id = db.Column(db.Integer, primary_key=True) role = db.Column(db.String(30), unique=False, nullable=False) company = db.Column(db.String(30), unique=False, nullable=False) start = db.Column(db.DateTime, unique=False, nullable=True) end = db.Column(db.DateTime, unique=False, nullable=True) place = db.Column(db.String(30), unique=False, nullable=True) jd = db.Column(db.String(100), unique=False, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Project(db.Model): id = db.Column(db.Integer, primary_key=True) p_name = db.Column(db.String(50), unique=True, nullable=False) p_description = db.Column(db.String(200), unique=True, nullable=True) Organization = db.Column(db.String(200), unique=False, nullable=True) p_url = db.Column(db.String(200), unique=True, nullable=True) cred_id = db.Column(db.String(200), unique=True, nullable=True) certi_url = db.Column(db.String(200), unique=True, nullable=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class Project(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String, nullable=False) year = db.Column(db.Integer, nullable=False) url = db.Column(db.String) description = db.Column(db.String, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Project('{self.name}', '{self.year}', '{self.creator}')"
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Job(db.Model): id = db.Column(db.Integer, primary_key=True) company_name = db.Column(db.String, nullable=False) start_date = db.Column(db.DateTime, nullable=False) end_date = db.Column(db.DateTime) role = db.Column(db.String, nullable=False) description = db.Column(db.String, nullable=False) volunteer = db.Column(db.Boolean) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Job('{self.company_name}', '{self.role}', '{self.employee}')"
class Skills(db.Model): id = db.Column(db.Integer, primary_key=True) sk_name = db.Column(db.String(20), unique=True, nullable=False) sk_value = db.Column(db.Integer, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)