class Doctor(db.Model):
__tablename__ = 'doctor'
id = db.Column(db.Integer, primary_key=True)
doctor_name = db.Column(db.String(150), unique=False)
doctor_email = db.Column(db.String(50), unique=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Doctor('{self.doctor_name}', '{self.doctor_email}')"
class Readings(db.Model):
__tablename__ = 'readings'
id = db.Column(db.Integer, primary_key=True)
date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow())
#date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
systolic = db.Column(db.Integer())
diastolic = db.Column(db.Integer())
notes = db.Column(db.String(250))
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Readings('{self.date_posted}', '{self.systolic}', '{self.diastolic}', '{self.notes}')"
class Doctor(Base):
__tablename__ = 'doctor'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(150), unique=False)
email = db.Column(db.String(50), unique=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)