class DoctorAppoinment(db.Model):
id = db.Column(db.Integer, primary_key=True)
owner = db.Column(db.String)
name = db.Column(db.VARCHAR(200), nullable=False)
doctor = db.Column(db.VARCHAR(200), nullable=False)
reason = db.Column(db.VARCHAR(200), nullable=False)
contactno = db.Column(db.VARCHAR(200), nullable=False)
date = db.Column(db.VARCHAR(200), nullable=False)
status = db.Column(db.String(200), nullable=False)
hosid = db.Column(db.String(200), nullable=False)
class Contact(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(200), nullable=False)
email = db.Column(db.String(120), nullable=False)
phone = db.Column(db.String(100))
subject = db.Column(db.String(120), nullable=False)
message = db.Column(db.String(120), nullable=False)
usertype = db.Column(db.String(120), nullable=False)
class Doctor(db.Model):
id = db.Column(db.Integer, primary_key=True)
owner = db.Column(db.String(100))
name = db.Column(db.String(100))
email = db.Column(db.String(100))
phone = db.Column(db.String(100))
specilisation = db.Column(db.String(100))
class Quesions(db.Model):
id = db.Column(db.Integer, primary_key=True)
owner = db.Column(db.String(200),nullable=False)
name = db.Column(db.String(200), nullable=False)
reply = db.Column(db.String(200), nullable=False)
question = db.Column(db.String(200), nullable=False)
doctor = db.Column(db.String(200), nullable=False)
class AddDisease(db.Model):
id = db.Column(db.Integer, primary_key=True)
owner = db.Column(db.String)
disease = db.Column(db.VARCHAR(200), nullable=False)
symptom = db.Column(db.VARCHAR(200), nullable=False)
category = db.Column(db.VARCHAR(200), nullable=False)
remedy = db.Column(db.VARCHAR(200), nullable=False)
class User(db.Model, UserMixin):
id=db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80))
email = db.Column(db.String(120), nullable=False)
address = db.Column(db.String(100))
phone = db.Column(db.String(100))
password = db.Column(db.String(80), nullable=False)
status = db.Column(db.String(300))
image= db.Column(db.String(20), nullable=False, default='default.jpg')
usertype = db.Column(db.String(80), nullable=False)
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
class Gallery(db.Model):
id=db.Column(db.Integer, primary_key=True)
desc = db.Column(db.String(80))
image= db.Column(db.String(20), nullable=False, default='default.jpg')
class TreatDisease(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.VARCHAR(200), nullable=False)
location = db.Column(db.VARCHAR(200), nullable=False)
disease = db.Column(db.VARCHAR(200), nullable=False)
contactno = db.Column(db.VARCHAR(200), nullable=False)