class Application(db.Model):
id = db.Column(db.Integer(), primary_key=True)
app_timestamp = db.Column(db.TIMESTAMP())
symptoms = db.Column(db.Text())
status = db.Column(db.Enum(StatusEnum), nullable=False)
reject_reason = db.Column(db.Text())
date = db.Column(db.Date(), nullable=False)
#foreign key
time_slot_id = db.Column(db.Integer(), \
db.ForeignKey('time_slot.id'), nullable=False)
doctor_id = db.Column(db.String(100), \
db.ForeignKey('doctor.id'), nullable=False)
approver_id = db.Column(db.String(100), \
db.ForeignKey('nurse.id'), nullable=False)
patient_id = db.Column(db.String(100), \
db.ForeignKey('patient.id'), nullable=False)
#one-to-one relationship
medical_record = db.relationship('Medical_record',
backref='application',
uselist=False,
lazy=True)
def __repr__(self):
return f'Application < id: {self.id}, app_timestamp: {self.app_timestamp}, \
class Prescription(db.Model):
id = db.Column(db.Integer(), primary_key=True)
medicine = db.Column(db.Text())
dose = db.Column(db.Text())
comments = db.Column(db.Text())
#foreign key
mc_id = db.Column(db.Integer(), \
db.ForeignKey('medical_record.id'), nullable=False)
def __repr__(self):
return f'Prescription < id: {self.id}, mc_id: {self.mc_id} >'
class Hospital(db.Model):
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(100), nullable=False)
phone = db.Column(db.String(20))
address = db.Column(db.Text(), nullable=False)
description = db.Column(db.Text())
#one-to-many relationship
departments = db.relationship('Department', backref='hospital', lazy=True)
def __repr__(self):
return f'Hospital < id: {self.id}, name: {self.name}, \
class Lab_report_type(db.Model):
type = db.Column(db.String(50), primary_key=True)
description = db.Column(db.Text())
#one-to-many relationship, one report type might contains sereval reports.
lab_reports = db.relationship('Lab_report',
backref='lab_report_type',
lazy=True)
def __repr__(self):
return f'Lab_report_type < type: {self.type}, number of lab reports: {len(self.lab_reports)} >'
class Department(db.Model):
id = db.Column(db.Integer(), primary_key=True)
title = db.Column(db.String(100), nullable=False)
phone = db.Column(db.String(20))
description = db.Column(db.Text())
#foreign key
hospital_id = db.Column(db.Integer(), \
db.ForeignKey('hospital.id'), nullable=False, onupdate="CASCADE")
#one-to-many relationship
doctors = db.relationship('Doctor', backref='department', lazy=True)
nurses = db.relationship('Nurse', backref='department', lazy=True)
def __repr__(self):
return f'Department < id: {self.id}, name: {self.title}, \
class Lab_report(db.Model):
id = db.Column(db.Integer(), primary_key=True)
file = db.Column(db.LargeBinary())
comments = db.Column(db.Text())
#foreign key
lr_type = db.Column(db.String(50), \
db.ForeignKey('lab_report_type.type'), nullable=False)
mc_id = db.Column(db.Integer(), \
db.ForeignKey('medical_record.id'), nullable=False)
uploader_id = db.Column(db.String(100), \
db.ForeignKey('nurse.id'), nullable=False)
patient_id = db.Column(db.String(100), \
db.ForeignKey('patient.id'), nullable=False)
def __repr__(self):
return f'Lab_report < id: {self.id}, (report_)type: {len(self.type)},\
class Patient(db.Model):
id = db.Column(db.String(100),
db.ForeignKey('user.id'),
primary_key=True,
onupdate="CASCADE")
#foreign key
# user_id = db.Column(db.String(100), db.ForeignKey('user.user_id'), nullable=False, unique=True, onupdate="CASCADE")
age = db.Column(db.SmallInteger())
gender = db.Column(db.Enum(GenderEnum))
blood_type = db.Column(db.String(10))
allergies = db.Column(db.Text())
#one-to-many relationship
applications = db.relationship('Application', backref='patient', lazy=True)
medical_records = db.relationship('Medical_record',
backref='patient',
lazy=True)
lab_reports = db.relationship('Lab_report', backref='patient', lazy=True)
def __repr__(self):
return f'Patient < id: {self.id} >'