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} >'