419 lines
14 KiB
Python
419 lines
14 KiB
Python
# Generated by Django 5.2.7 on 2025-10-06 21:15
|
|
|
|
import django.db.models.deletion
|
|
from django.conf import settings
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
("billing", "0001_initial"),
|
|
("core", "0001_initial"),
|
|
("emr", "0001_initial"),
|
|
("inpatients", "0001_initial"),
|
|
("patients", "0001_initial"),
|
|
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
|
|
]
|
|
|
|
operations = [
|
|
migrations.AddField(
|
|
model_name="billingconfiguration",
|
|
name="tenant",
|
|
field=models.OneToOneField(
|
|
help_text="Organization tenant",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="billing_configuration",
|
|
to="core.tenant",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="billlineitem",
|
|
name="rendering_provider",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Rendering provider",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="rendered_line_items",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="billlineitem",
|
|
name="supervising_provider",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Supervising provider",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="supervised_line_items",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="claimstatusupdate",
|
|
name="updated_by",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Staff member who made the update",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="claim_status_updates",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="insuranceclaim",
|
|
name="created_by",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="User who created the claim",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="created_insurance_claims",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="insuranceclaim",
|
|
name="insurance_info",
|
|
field=models.ForeignKey(
|
|
help_text="Insurance information",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="insurance_claims",
|
|
to="patients.insuranceinfo",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="insuranceclaim",
|
|
name="original_claim",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Original claim if this is a resubmission",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="resubmissions",
|
|
to="billing.insuranceclaim",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="claimstatusupdate",
|
|
name="insurance_claim",
|
|
field=models.ForeignKey(
|
|
help_text="Related insurance claim",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="status_updates",
|
|
to="billing.insuranceclaim",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="admission",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Related admission",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="medical_bills",
|
|
to="inpatients.admission",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="attending_provider",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Attending provider",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="attending_bills",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="billing_provider",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Billing provider",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="billing_provider_bills",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="created_by",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="User who created the bill",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="created_medical_bills",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="encounter",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Related encounter",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="medical_bills",
|
|
to="emr.encounter",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="patient",
|
|
field=models.ForeignKey(
|
|
help_text="Patient",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="medical_bills",
|
|
to="patients.patientprofile",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="primary_insurance",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Primary insurance",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="primary_bills",
|
|
to="patients.insuranceinfo",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="secondary_insurance",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Secondary insurance",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="secondary_bills",
|
|
to="patients.insuranceinfo",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="medicalbill",
|
|
name="tenant",
|
|
field=models.ForeignKey(
|
|
help_text="Organization tenant",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="medical_bills",
|
|
to="core.tenant",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="insuranceclaim",
|
|
name="medical_bill",
|
|
field=models.ForeignKey(
|
|
help_text="Related medical bill",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="insurance_claims",
|
|
to="billing.medicalbill",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="billlineitem",
|
|
name="medical_bill",
|
|
field=models.ForeignKey(
|
|
help_text="Medical bill",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="line_items",
|
|
to="billing.medicalbill",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="payment",
|
|
name="insurance_claim",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Related insurance claim",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="payments",
|
|
to="billing.insuranceclaim",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="payment",
|
|
name="medical_bill",
|
|
field=models.ForeignKey(
|
|
help_text="Related medical bill",
|
|
on_delete=django.db.models.deletion.CASCADE,
|
|
related_name="payments",
|
|
to="billing.medicalbill",
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="payment",
|
|
name="processed_by",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Staff member who processed payment",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="processed_payments",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddField(
|
|
model_name="payment",
|
|
name="received_by",
|
|
field=models.ForeignKey(
|
|
blank=True,
|
|
help_text="Staff member who received payment",
|
|
null=True,
|
|
on_delete=django.db.models.deletion.SET_NULL,
|
|
related_name="received_payments",
|
|
to=settings.AUTH_USER_MODEL,
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="claimstatusupdate",
|
|
index=models.Index(
|
|
fields=["insurance_claim"], name="billing_cla_insuran_7c9e49_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="claimstatusupdate",
|
|
index=models.Index(
|
|
fields=["status_date"], name="billing_cla_status__49d81f_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="claimstatusupdate",
|
|
index=models.Index(
|
|
fields=["new_status"], name="billing_cla_new_sta_9c28d3_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="medicalbill",
|
|
index=models.Index(
|
|
fields=["tenant", "status"], name="billing_med_tenant__fe8d14_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="medicalbill",
|
|
index=models.Index(
|
|
fields=["patient", "bill_date"], name="billing_med_patient_8f1a85_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="medicalbill",
|
|
index=models.Index(
|
|
fields=["bill_number"], name="billing_med_bill_nu_f01dfa_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="medicalbill",
|
|
index=models.Index(
|
|
fields=["status", "due_date"], name="billing_med_status_cde77f_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="medicalbill",
|
|
index=models.Index(
|
|
fields=["collection_status"], name="billing_med_collect_6d0faf_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="insuranceclaim",
|
|
index=models.Index(
|
|
fields=["medical_bill"], name="billing_ins_medical_1fec52_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="insuranceclaim",
|
|
index=models.Index(
|
|
fields=["insurance_info"], name="billing_ins_insuran_e54611_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="insuranceclaim",
|
|
index=models.Index(
|
|
fields=["claim_number"], name="billing_ins_claim_n_becaa3_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="insuranceclaim",
|
|
index=models.Index(
|
|
fields=["status", "submission_date"],
|
|
name="billing_ins_status_921ea7_idx",
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="insuranceclaim",
|
|
index=models.Index(
|
|
fields=["response_date"], name="billing_ins_respons_fc4f3d_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="billlineitem",
|
|
index=models.Index(
|
|
fields=["medical_bill", "line_number"],
|
|
name="billing_bil_medical_37a377_idx",
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="billlineitem",
|
|
index=models.Index(
|
|
fields=["service_code"], name="billing_bil_service_b88f5b_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="billlineitem",
|
|
index=models.Index(
|
|
fields=["service_date"], name="billing_bil_service_658c36_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="billlineitem",
|
|
index=models.Index(
|
|
fields=["rendering_provider"], name="billing_bil_renderi_2740ad_idx"
|
|
),
|
|
),
|
|
migrations.AlterUniqueTogether(
|
|
name="billlineitem",
|
|
unique_together={("medical_bill", "line_number")},
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="payment",
|
|
index=models.Index(
|
|
fields=["medical_bill"], name="billing_pay_medical_e4e348_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="payment",
|
|
index=models.Index(
|
|
fields=["payment_number"], name="billing_pay_payment_0825d6_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="payment",
|
|
index=models.Index(
|
|
fields=["payment_date"], name="billing_pay_payment_bed741_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="payment",
|
|
index=models.Index(
|
|
fields=["payment_method"], name="billing_pay_payment_715e62_idx"
|
|
),
|
|
),
|
|
migrations.AddIndex(
|
|
model_name="payment",
|
|
index=models.Index(fields=["status"], name="billing_pay_status_b7739e_idx"),
|
|
),
|
|
]
|