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)