class Faculty(db.Model):
__bind_key__ = 'fac'
__tablename__ = 'Faculty'
sno = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200))
designation = db.Column(db.String(200))
qualification = db.Column(db.String(200))
email = db.Column(db.String(400))
number = db.Column(db.String(100))
image = db.Column(db.String(200))
class Thread(db.Model):
__tablename__ = 'Thread'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
body = db.Column(db.String(3000))
author = db.Column(db.String(100))
title = db.Column(db.String(300))
karma = db.Column(db.Integer, default=0)
upvoted = db.Column(db.String(100))
downvoted = db.Column(db.String(100))
time_created = db.Column(db.String(100))
class Login(db.Model):
__tablename__ = 'Login'
username = db.Column(db.String(100), primary_key=True)
password = db.Column(db.String(100))