class Patient(db.Model):
__table_args__ = {'sqlite_autoincrement': True}
id = db.Column(db.Integer, primary_key=True)
ssid = db.Column(db.String(250), unique=True, nullable=False)
name = db.Column(db.String(80), nullable=False)
age = db.Column(db.Integer, nullable=False)
date_of_admission = db.Column(db.Date, nullable=False)
type_of_bed = db.Column(db.String(80), nullable=False)
address = db.Column(db.String(250), nullable=False)
city = db.Column(db.String(250), nullable=False)
state = db.Column(db.String(250), nullable=False)
status = db.Column(db.String(100), nullable=False)
class DiagnosticIssued(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
test_id = db.Column(db.Integer, nullable=False)
p_id = db.Column(db.Integer, nullable=False)
class User(db.Model):
user_id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
password = db.Column(db.String(), unique=True, nullable=False)
timestamp = db.Column(db.DateTime, default=datetime.now())
class Diagnostic_test(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
test_name = db.Column(db.String(80), nullable=False)
test_cost = db.Column(db.Integer, nullable=False)
class MedicinesIssued(db.Model):
__table_args__ = {'sqlite_autoincrement': True}
id = db.Column(db.Integer, primary_key=True)
med_id = db.Column(db.Integer, nullable=False)
p_id = db.Column(db.Integer, nullable=False)
quantity = db.Column(db.Integer, nullable=False)
class Medicines(db.Model):
__table_args__ = {'sqlite_autoincrement': True}
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
quantity_available = db.Column(db.Integer, nullable=False)
rate = db.Column(db.Integer, nullable=False)