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 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 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 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 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 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 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 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 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 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 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 MediCalRequest(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)) referringMD = db.Column(db.String(20)) frequency = db.Column(db.String(20)) dob = db.Column(db.DateTime) 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) prescriptionDate = db.Column(db.DateTime) onsetDate = db.Column(db.DateTime) message = db.Column(db.String(300)) medicalJustification = 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)) gender = db.Column(db.String(10)) company_id = db.Column(db.Integer, db.ForeignKey('company.id'), nullable=False) active = db.Column(db.Boolean, default=True) def __repr__(self): return f"Request('{self.member_ID}', '{self.status}')"
class PrimePendingRequest(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)) refNumber = db.Column(db.String(30), nullable=False) submittedDate = db.Column(db.DateTime, nullable=False) status = db.Column(db.String(100)) message = db.Column(db.String(300)) case = 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 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}')"