class Workhistory(db.Model):
__tablename__ = 'Workhistory'
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(40))
startdate = db.Column(db.String(40))
enddate = db.Column(db.String(40))
text = db.Column(db.String(100))
class Contactform(db.Model):
__tablename__ = 'conactform'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
email = db.Column(db.String(120))
date = db.Column(db.Date)
message = db.Column(db.Text)
class Hireme(db.Model):
__tablename__ = 'Hireme'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
email = db.Column(db.String(120))
service = db.Column(db.String(120))
message = db.Column(db.Text)
class Skills(db.Model):
__tablename__ = 'Skills'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
percatage = db.Column(db.String(120))
skill_catagory = db.Column(db.Integer, db.ForeignKey('SkillCatagory.id'))
class PortfolioCatagory(db.Model):
__tablename__ = "PortfolioCatagory"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
portfolio_catagory = db.relationship('Portfolio',
backref='PortfolioCatagory',
lazy=True)
class BlogPost(db.Model):
__tablename__ = "BlogPost"
id = db.Column(db.Integer, primary_key=True)
url = db.Column(db.String(50))
title = db.Column(db.String(50))
subtitle = db.Column(db.String(50))
img = db.Column(db.String(120))
date = db.Column(db.Date)
tag = db.Column(db.String(120))
content = db.Column(db.Text)
catagory_post = db.Column(db.Integer, db.ForeignKey('Catagory.id'))
post_comment = db.relationship('Comments', backref='BlogPost', lazy=True)
class Portfolio(db.Model):
__tablename__ = "Portfolio"
id = db.Column(db.Integer, primary_key=True)
url = db.Column(db.String(50))
title = db.Column(db.String(50))
subtitle = db.Column(db.String(50))
img = db.Column(db.String(120))
content = db.Column(db.Text)
catagory_portfolio = db.Column(db.Integer,
db.ForeignKey('PortfolioCatagory.id'))
class Comments(db.Model):
__tablename__ = "Comments"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
email = db.Column(db.String(50))
comment = db.Column(db.String(100))
date = db.Column(db.Date)
blog_id = db.Column(db.Integer, db.ForeignKey('BlogPost.id'))
class Catagory(db.Model):
__tablename__ = "Catagory"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
post_catagory = db.relationship('BlogPost', backref='catagory', lazy=True)
class MyService(db.Model):
__tablename__ = 'MyService'
id = db.Column(db.Integer, primary_key=True)
servicetitle = db.Column(db.String(50))
serviceimage = db.Column(db.String(120))
servicesubtitle = db.Column(db.String(50))
class Slides(db.Model):
__tablename__ = 'slider'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
job = db.Column(db.String(20))
text = db.Column(db.String(50))
class Aboutme(db.Model):
__tablename__ = 'Aboutme'
id = db.Column(db.Integer, primary_key=True)
content = db.Column(db.String(120))
class SkillsCat(db.Model):
__tablename__ = 'SkillCatagory'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(120))
skill_catagory = db.relationship('Skills', backref='skillscat', lazy=True)
class Profileim(db.Model):
__tablename__ = 'Profileimg'
id = db.Column(db.Integer, primary_key=True)
img = db.Column(db.String(120))
class Profile(db.Model):
__tablename__ = 'Profile'
id = db.Column(db.Integer, primary_key=True)
infoheader = db.Column(db.String(120))
informatio = db.Column(db.String(120))
class Contact(db.Model):
__tablename__ = 'Contact'
id = db.Column(db.Integer, primary_key=True)
header = db.Column(db.String(20))
info = db.Column(db.String(50))