class Diagnostics(db.Model):
id = db.Column(db.Integer, primary_key=True)
test_name = db.Column(db.String(100), nullable=False)
charge = db.Column(db.Float)
def __repr__(self):
return f"Diagnostics('{self.id}', '{self.test_name}', '{self.charge}')"
class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(10), unique=True, nullable=False)
password = db.Column(db.String(10), nullable=False)
def __repr__(self):
return f"User('{self.username}', '{self.image_file}')"
class Medicines(db.Model):
id = db.Column(db.Integer, primary_key=True)
m_name = db.Column(db.String(100), nullable=False)
quantity = db.Column(db.Float)
charge = db.Column(db.Float)
def __repr__(self):
return f"Medicines('{self.id}', '{self.m_name}', '{self.charge}')"
class PatientMedicine(db.Model):
id = db.Column(db.Integer, primary_key=True)
patient_id = db.Column(db.Integer, db.ForeignKey('patient.id'))
m_id = db.Column(db.Integer, db.ForeignKey('diagnostics.id'))
ws_pat_name = db.Column(db.String(100), nullable=False)
m_name = db.Column(db.String(100), nullable=False)
quantity = db.Column(db.Float)
charge = db.Column(db.Float)
def __repr__(self):
return f"PatientDiagnostics('{self.patient_id}'), '{self.test_id}')"
class Patient(db.Model):
id = db.Column(db.Integer, primary_key=True)
ws_pat_name = db.Column(db.String(100), nullable=False)
ws_adrs = db.Column(db.String(100), nullable=False)
ws_age = db.Column(db.String(10), nullable=False)
ws_doj = db.Column(db.String(100), nullable=False)
ws_rtype = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"{self.id},{self.ws_pat_name}, {self.ws_adrs}, {self.ws_age},{self.ws_doj},{self.ws_rtype}"
class temp(db.Model):
id = db.Column(db.Integer, primary_key=True)