class User(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
admin = db.Column(db.Boolean, default=False)
active = db.Column(db.Boolean, default=True)
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def get_reset_token(self, expires_sec=1800):
s = Serializer(app.config['SECRET_KEY'], expires_sec)
return s.dumps({'user_id': self.id}).decode('utf-8')
@staticmethod
def verify_reset_token(token):
s = Serializer(app.config['SECRET_KEY'])
try:
user_id = s.loads(token)['user_id']
except:
return None
return User.query.get(user_id)
def __repr__(self):
return f"User('{self.id}', '{self.username}', '{self.email}', '{self.company_id}')"
class icd10(db.Model):
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.String(20), nullable=False)
name = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"ic_d10('{self.code}', '{self.name}')"
class EMR(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"EMR('{self.username}')"
class Driver(db.Model):
license_number = db.Column(db.String(20), primary_key=True)
driver_name = db.Column(db.String(50), nullable=False)
birthdate = db.Column(db.Date, nullable=False)
vehicle_id = db.Column(db.Integer,
db.ForeignKey('vehicle.vin'),
nullable=False)
def __repr__(self):
return f"Driver('{self.license_number}', '{self.driver_name}'')"
class PrimeSettings(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
fax = db.Column(db.String(15), nullable=False)
provider = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"Credentials('{self.username}')"
class Vehicle(db.Model):
vin = db.Column(db.String(20), primary_key=True)
make_model_year = db.Column(db.Integer, nullable=False)
status = db.Column(db.String(1), nullable=False)
insurance_id = db.Column(db.Integer,
db.ForeignKey('insurance.id'),
nullable=False)
drivers = db.relationship('Driver', backref='vhc', lazy=True)
def __repr__(self):
return f"Vehicle('{self.vin}', '{self.status}'')"
class Company(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False)
file_counter = db.Column(db.Integer, default=0)
def __repr__(self):
return f"Company('{self.id}', '{self.name}', '{self.file_counter})'"
class Home(db.Model):
id = db.Column(db.Integer, primary_key=True)
purchase_date = db.Column(db.Date, nullable=False)
purchase_value = db.Column(db.Numeric(scale=2), nullable=False)
home_area = db.Column(db.Numeric(scale=2), nullable=False)
home_type = db.Column(db.String(1), nullable=False)
fire = db.Column(db.Integer, nullable=False)
security = db.Column(db.Integer, nullable=False)
swimming_pool = db.Column(db.String(1))
basement = db.Column(db.Integer, nullable=False)
insurance_id = db.Column(db.Integer,
db.ForeignKey('insurance.id'),
nullable=False)
def __repr__(self):
return f"Home('{self.purchase_date}', '${self.purchase_value}', '{self.home_area}Sq.ft')"
class Insurance(db.Model):
id = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String(1), nullable=False)
start_date = db.Column(db.Date, nullable=False)
end_date = db.Column(db.Date, nullable=False)
premium = db.Column(db.Numeric(scale=2), nullable=False)
status = db.Column(db.String(1), nullable=False)
customer_id = db.Column(db.Integer,
db.ForeignKey('customer.id'),
nullable=False)
vehicles = db.relationship('Vehicle', backref='insurance', lazy=True)
homes = db.relationship('Home', backref='insurance', lazy=True)
invoices = db.relationship('Invoice', backref='insurance', lazy=True)
def __repr__(self):
return f"Insurance('{self.type}')"
class Payment(db.Model):
id = db.Column(db.Integer, primary_key=True)
payment_date = db.Column(db.Date, nullable=False)
method = db.Column(db.String(1), nullable=False)
invoice_id = db.Column(db.Integer,
db.ForeignKey('invoice.id'),
nullable=False)
def __repr__(self):
return f"Payment('{self.id}', '{self.payment_date}', '{self.method}')"
class PHPPendingRequest(db.Model):
id = db.Column(db.Integer, primary_key=True)
member_ID = db.Column(db.String(20), nullable=False)
firstName = db.Column(db.String(30))
lastName = db.Column(db.String(30))
dob = db.Column(db.DateTime)
refNumber = db.Column(db.String(30))
submittedDate = db.Column(db.DateTime, nullable=False)
status = db.Column(db.String(100), nullable=False)
message = db.Column(db.String(300))
case = db.Column(db.String(50))
emr = db.Column(db.String(100))
emr_entry = db.Column(db.String(100))
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"PendingRequest('{self.refNumber}', '{self.submittedDate}')"
class Invoice(db.Model):
id = db.Column(db.Integer, primary_key=True)
invoice_date = db.Column(db.Date, nullable=False)
payment_due_date = db.Column(db.Date, nullable=False)
invoice_amount = db.Column(db.Numeric(scale=2), nullable=False)
status = db.Column(db.String(1), nullable=False)
insurance_id = db.Column(db.Integer,
db.ForeignKey('insurance.id'),
nullable=False)
payment = db.relationship('Payment', backref='invoice', lazy=True)
def __repr__(self):
return f"Invoice('{self.id}', '{self.invoice_date}', '{self.invoice_amount}')"
class PHPEligibility(db.Model):
member_ID = db.Column(db.String(20), primary_key=True)
firstName = db.Column(db.String(30))
lastName = db.Column(db.String(30))
eligibility = db.Column(db.String(100))
thruDate = db.Column(db.DateTime)
status = db.Column(db.String(100))
other_ins = db.Column(db.String(200))
message = db.Column(db.String(200))
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"Eligibility('{self.member_ID}', '{self.status}')"
class MediCalSettings(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(20), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
contactName = db.Column(db.String(60), nullable=False)
contactPhone = db.Column(db.String(60), nullable=False)
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
npi = db.Column(db.String(20), nullable=False)
speciality = db.Column(db.String(100), nullable=False)
def __repr__(self):
return f"Credentials('{self.username}')"
class Customer(db.Model, UserMixin):
id = db.Column(db.Integer, primary_key=True)
full_name = db.Column(db.String(50), nullable=False)
address = db.Column(db.String(120), nullable=False)
gender = db.Column(db.String(1), nullable=False)
marital_status = db.Column(db.String(1), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
password = db.Column(db.String(60), nullable=False)
insurances = db.relationship('Insurance', backref='buyer', lazy=True)
def __repr__(self):
return f"Customer('{self.full_name}', '{self.email}'')"
class MediCalEligibility(db.Model):
member_ID = db.Column(db.String(20), primary_key=True)
firstName = db.Column(db.String(30))
lastName = db.Column(db.String(30))
eligibility = db.Column(db.String(100))
dateChecked = db.Column(db.DateTime)
dob = db.Column(db.DateTime)
plan = db.Column(db.String(200))
message = db.Column(db.String(200))
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"Eligibility('{self.member_ID}', '{self.plan}')"
class PHPTemplate(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(40), nullable=False)
frequency = db.Column(db.String(20))
emr = db.Column(db.Boolean, default=False)
icd1 = db.Column(db.String(10))
icd2 = db.Column(db.String(10))
icd3 = db.Column(db.String(10))
icd4 = db.Column(db.String(10))
icd5 = db.Column(db.String(10))
icd6 = db.Column(db.String(10))
icd7 = db.Column(db.String(10))
CPT1 = db.Column(db.String(20))
CPTUnit1 = db.Column(db.Integer)
CPT2 = db.Column(db.String(20))
CPTUnit2 = db.Column(db.Integer)
CPT3 = db.Column(db.String(20))
CPTUnit3 = db.Column(db.Integer)
CPT4 = db.Column(db.String(20))
CPTUnit4 = db.Column(db.Integer)
CPT5 = db.Column(db.String(20))
CPTUnit5 = db.Column(db.Integer)
CPT6 = db.Column(db.String(20))
CPTUnit6 = db.Column(db.Integer)
CPT7 = db.Column(db.String(20))
CPTUnit7 = db.Column(db.Integer)
message = db.Column(db.String(300))
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"Template('{self.name}', '{self.message}')"
class PHPRequest(db.Model):
id = db.Column(db.Integer, primary_key=True)
member_ID = db.Column(db.String(20), nullable=False)
caseName = db.Column(db.String(30))
frequency = db.Column(db.String(20))
icd1 = db.Column(db.String(20))
icd2 = db.Column(db.String(20))
icd3 = db.Column(db.String(20))
icd4 = db.Column(db.String(20))
icd5 = db.Column(db.String(20))
icd6 = db.Column(db.String(20))
icd7 = db.Column(db.String(20))
CPT1 = db.Column(db.String(20))
CPTUnit1 = db.Column(db.Integer)
CPT2 = db.Column(db.String(20))
CPTUnit2 = db.Column(db.Integer)
CPT3 = db.Column(db.String(20))
CPTUnit3 = db.Column(db.Integer)
CPT4 = db.Column(db.String(20))
CPTUnit4 = db.Column(db.Integer)
CPT5 = db.Column(db.String(20))
CPTUnit5 = db.Column(db.Integer)
CPT6 = db.Column(db.String(20))
CPTUnit6 = db.Column(db.Integer)
CPT7 = db.Column(db.String(20))
CPTUnit7 = db.Column(db.Integer)
urgent = db.Column(db.Boolean, default=False)
emr = db.Column(db.Boolean, default=False)
startDate = db.Column(db.DateTime, nullable=False)
endDate = db.Column(db.DateTime, nullable=False)
message = db.Column(db.String(300))
files = db.Column(db.String(100))
status = db.Column(db.String(100), nullable=False)
submissionMessage = db.Column(db.String(300))
company_id = db.Column(db.Integer,
db.ForeignKey('company.id'),
nullable=False)
def __repr__(self):
return f"Request('{self.member_ID}', '{self.status}')"
