# Generated by Django 5.0.14 on 2026-07-27 17:36 import uuid from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name="CarotidUltrasoundFinding", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "laterality", models.TextField( choices=[ ("left", "Left"), ("right", "Right"), ("bilateral", "Bilateral"), ] ), ), ("anatomic_segment", models.TextField(blank=True, null=True)), ("plaque_location", models.TextField(blank=True, null=True)), ("plaque_length_mm", models.FloatField(blank=True, null=True)), ("plaque_thickness_mm", models.FloatField(blank=True, null=True)), ( "residual_lumen_diameter_mm", models.FloatField(blank=True, null=True), ), ("psv_cm_s", models.FloatField(blank=True, null=True)), ("edv_cm_s", models.FloatField(blank=True, null=True)), ("stenosis_classification", models.TextField(blank=True, null=True)), ("plaque_morphology", models.TextField(blank=True, null=True)), ("flow_direction", models.TextField(blank=True, null=True)), ("measurement_method", models.TextField(blank=True, null=True)), ("status", models.TextField(default="drafted")), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="ClinicalObservation", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "observation_type", models.TextField( choices=[ ("lab", "Lab"), ("vital_sign", "Vital Sign"), ("symptom", "Symptom"), ("imaging_finding", "Imaging Finding"), ("prom_score", "PROM Score"), ("other", "Other"), ] ), ), ("measure_name", models.TextField()), ("value_text", models.TextField(blank=True, null=True)), ("value_numeric", models.FloatField(blank=True, null=True)), ("unit", models.TextField(blank=True, null=True)), ("ucum_unit", models.TextField(blank=True, null=True)), ("collection_date", models.DateField()), ( "data_source", models.TextField( choices=[ ("labcorp", "Labcorp"), ("quest", "Quest"), ("patient_upload", "Patient Upload"), ("device", "Device"), ("physician_entered", "Physician Entered"), ("curation", "Curation"), ] ), ), ("collection_method", models.TextField(blank=True, null=True)), ("is_synthetic", models.BooleanField(default=True)), ( "status", models.TextField( choices=[ ("imported", "Imported"), ("cleaning_pending", "Cleaning Pending"), ("curated_draft", "Curated Draft"), ("needs_clarification", "Needs Clarification"), ("qc_passed", "QC Passed"), ("clinician_review_required", "Clinician Review Required"), ("physician_review_required", "Physician Review Required"), ("approved", "Approved"), ("locked_for_reporting", "Locked for Reporting"), ("submitted_to_cms", "Submitted to CMS"), ("rejected", "Rejected"), ("superseded", "Superseded"), ], default="imported", ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], options={ "ordering": ["-collection_date"], }, ), migrations.CreateModel( name="ClinicalObservationSource", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "source_type", models.TextField( choices=[ ("lab_result", "Lab Result"), ("prom_score", "PROM Score"), ("imaging_finding", "Imaging Finding"), ("execution_log", "Execution Log"), ("status_log", "Status Log"), ("daily_checkin", "Daily Checkin"), ] ), ), ("source_record_id", models.UUIDField()), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="FHIRConceptMapping", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("source_system", models.TextField()), ("source_code", models.TextField()), ("fhir_system", models.TextField()), ("fhir_code", models.TextField()), ("display", models.TextField(blank=True, null=True)), ("mapping_status", models.TextField(default="pending_review")), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name="ImagingStudy", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "imaging_type", models.TextField( choices=[ ("carotid_ultrasound", "Carotid Ultrasound"), ("fatty_liver_ultrasound", "Fatty Liver Ultrasound"), ("kidney_ultrasound", "Kidney Ultrasound"), ("thyroid_ultrasound", "Thyroid Ultrasound"), ("other", "Other"), ] ), ), ("facility", models.TextField(blank=True, null=True)), ("study_date", models.DateField(blank=True, null=True)), ("report_date", models.DateField(blank=True, null=True)), ("radiologist", models.TextField(blank=True, null=True)), ("physician_interpretation", models.TextField(blank=True, null=True)), ("is_synthetic", models.BooleanField(default=True)), ( "status", models.TextField( choices=[ ("imported", "Imported"), ("curated_draft", "Curated Draft"), ("approved", "Approved"), ("rejected", "Rejected"), ], default="imported", ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="ImagingStudyComparison", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("finding_type", models.TextField()), ("calculated_change", models.TextField(blank=True, null=True)), ("trajectory", models.TextField(blank=True, null=True)), ("physician_interpretation", models.TextField(blank=True, null=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="LabResult", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("lab_order_date", models.DateField(blank=True, null=True)), ("specimen_collection_date", models.DateField(blank=True, null=True)), ("result_date", models.DateField(blank=True, null=True)), ("ordering_physician", models.TextField(blank=True, null=True)), ("lab_facility", models.TextField(blank=True, null=True)), ( "source_type", models.TextField( choices=[ ("pdf_upload", "PDF Upload"), ("structured_feed", "Structured Feed"), ("patient_upload", "Patient Upload"), ] ), ), ("is_synthetic", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="LabResultItem", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("test_name", models.TextField()), ("value", models.FloatField(blank=True, null=True)), ("unit", models.TextField(blank=True, null=True)), ("ucum_unit", models.TextField(blank=True, null=True)), ("reference_range_low", models.FloatField(blank=True, null=True)), ("reference_range_high", models.FloatField(blank=True, null=True)), ("flags", models.TextField(blank=True, null=True)), ("status", models.TextField(default="imported")), ], ), migrations.CreateModel( name="LiverUltrasoundFinding", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("steatosis_grade", models.TextField(blank=True, null=True)), ("liver_echogenicity", models.TextField(blank=True, null=True)), ("liver_size_cm", models.FloatField(blank=True, null=True)), ("other_findings", models.TextField(blank=True, null=True)), ("status", models.TextField(default="drafted")), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="LoincCode", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("loinc_number", models.TextField(unique=True)), ("component", models.TextField()), ("property", models.TextField(blank=True, null=True)), ("time_aspect", models.TextField(blank=True, null=True)), ("system", models.TextField(blank=True, null=True)), ("method", models.TextField(blank=True, null=True)), ("class_name", models.TextField(blank=True, null=True)), ("common_name", models.TextField(blank=True, null=True)), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="OAPMeasureDefinition", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("measure_name", models.TextField()), ( "clinical_track", models.TextField( choices=[("CKM", "CKM"), ("eCKM", "eCKM"), ("MSK", "MSK")] ), ), ("unit", models.TextField(blank=True, null=True)), ("reporting_types", models.TextField(blank=True, null=True)), ("ucum_unit", models.TextField(blank=True, null=True)), ("fhir_code_mapping", models.TextField(blank=True, null=True)), ("description", models.TextField(blank=True, null=True)), ("is_active", models.BooleanField(default=True)), ], ), migrations.CreateModel( name="OAPMeasureObservation", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("reporting_type", models.TextField()), ("collection_date", models.DateField()), ("submission_date", models.DateField(blank=True, null=True)), ("validity_window_status", models.TextField()), ("data_source", models.TextField()), ("collection_method", models.TextField(blank=True, null=True)), ("physician_review_status", models.TextField()), ("cms_submission_payload", models.JSONField(blank=True, null=True)), ("cms_submission_response", models.JSONField(blank=True, null=True)), ("status", models.TextField(default="draft")), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name="OAPReportingWindow", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("reporting_type", models.TextField()), ("window_start", models.DateField()), ("window_end", models.DateField()), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="PromInstrument", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("instrument_name", models.TextField()), ("version", models.TextField()), ("scoring_logic", models.JSONField()), ("response_options", models.JSONField(blank=True, null=True)), ( "applicable_track", models.TextField( choices=[("CKM", "CKM"), ("eCKM", "eCKM"), ("MSK", "MSK")] ), ), ("is_active", models.BooleanField(default=True)), ], ), migrations.CreateModel( name="PromResponse", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("body_site", models.TextField(blank=True, null=True)), ("raw_item_responses", models.JSONField()), ("completion_date", models.DateTimeField()), ("device_metadata", models.JSONField(blank=True, null=True)), ("is_synthetic", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="PromScore", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("score", models.FloatField()), ("score_interpretation", models.TextField(blank=True, null=True)), ("reporting_status", models.TextField(default="not_applicable")), ("status", models.TextField(default="computed")), ], ), migrations.CreateModel( name="StructuralEvidence", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("evidence_type", models.TextField()), ("evidence_summary", models.TextField()), ("trajectory", models.TextField(blank=True, null=True)), ("is_synthetic", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], ), migrations.CreateModel( name="StructuralEvidenceSource", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("source_type", models.TextField()), ("source_record_id", models.UUIDField()), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="UCUMUnit", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("ucum_code", models.TextField(unique=True)), ("description", models.TextField()), ("is_active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ], ), ]