class Allergy_History(db.Model):
id = db.Column(db.Integer, primary_key=True)
allergy = db.Column(db.String(100), nullable=True)
date_diagnosed = db.Column(db.DateTime, nullable=True)
PastMedHist_id = db.Column(db.Integer,
db.ForeignKey('past__medical__history.id'),
nullable=False)
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 Previous_Admissions(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime, nullable=True, default=datetime.utcnow)
place = db.Column(db.String(100), nullable=True)
comments = db.Column(db.String(100), nullable=True)
PastMedHist_id = db.Column(db.Integer,
db.ForeignKey('past__medical__history.id'),
nullable=False)
class Personal_Profile(db.Model):
id = db.Column(db.Integer, primary_key=True)
full_name = db.Column(db.String(60), nullable=True)
nric = db.Column(db.String(9), unique=True, nullable=True)
age = db.Column(db.Integer, nullable=True)
sex = db.Column(db.String(20), nullable=True)
address = db.Column(db.String(100), nullable=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
def __repr__(self):
return f"Personal_Profile('{self.age}', '{self.sex}', '{self.address}', '{self.full_name}', '{self.nric}')"
class Blood_Transfusion_History(db.Model):
id = db.Column(db.Integer, primary_key=True)
blood_type = db.Column(db.String(100), nullable=True)
date = db.Column(db.DateTime, nullable=True, default=datetime.utcnow)
place = db.Column(db.String(100), nullable=True)
comments = db.Column(db.String(100), nullable=True)
PastMedHist_id = db.Column(db.Integer,
db.ForeignKey('past__medical__history.id'),
nullable=False)
class Past_Medical_History(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
previous_admissions = db.relationship('Previous_Admissions',
backref="PastMedHist",
lazy=True)
previous_surgeries = db.relationship('Previous_Surgeries',
backref="PastMedHist",
lazy=True)
blood_transfusion_history = db.relationship('Blood_Transfusion_History',
backref="PastMedHist",
lazy=True)
allergy_history = db.relationship('Allergy_History',
backref="PastMedHist",
lazy=True)