ismail
fd19216b0d
All checks were successful
Build and Push Docker Image / build (push) Successful in 1m5s
205 lines
14 KiB
Python
205 lines
14 KiB
Python
# Generated by Django 6.0.1 on 2026-05-11 20:32
|
|
|
|
import django.db.models.deletion
|
|
import uuid
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
('organizations', '0001_initial'),
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='EventMapping',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('external_event_code', models.CharField(help_text='Event code from external system', max_length=100)),
|
|
('internal_event_code', models.CharField(help_text='Internal event code used in journey stages', max_length=100)),
|
|
('field_mappings', models.JSONField(blank=True, default=dict, help_text='Maps external field names to internal field names')),
|
|
('is_active', models.BooleanField(default=True)),
|
|
],
|
|
options={
|
|
'ordering': ['integration_config', 'external_event_code'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='HISEventType',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('event_type', models.CharField(help_text="HIS event type name (e.g., 'Lab Bill', 'Triage')", max_length=200, unique=True)),
|
|
('patient_types', models.JSONField(blank=True, default=list, help_text="Patient types that have this event: ['OP', 'IP', 'ED']")),
|
|
('event_count', models.IntegerField(default=0, help_text='Total number of times this event type has been seen')),
|
|
('last_seen_at', models.DateTimeField(auto_now=True)),
|
|
],
|
|
options={
|
|
'verbose_name': 'HIS Event Type',
|
|
'verbose_name_plural': 'HIS Event Types',
|
|
'ordering': ['event_type'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='HISTestPatient',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('admission_id', models.CharField(db_index=True, max_length=100)),
|
|
('patient_id', models.CharField(db_index=True, max_length=100)),
|
|
('patient_type', models.CharField(db_index=True, max_length=10)),
|
|
('reg_code', models.CharField(blank=True, db_index=True, max_length=100)),
|
|
('ssn', models.CharField(blank=True, db_index=True, max_length=50)),
|
|
('mobile_no', models.CharField(blank=True, db_index=True, max_length=20)),
|
|
('admit_date', models.DateTimeField(db_index=True)),
|
|
('discharge_date', models.DateTimeField(blank=True, null=True)),
|
|
('patient_data', models.JSONField(default=dict)),
|
|
('hospital_id', models.CharField(blank=True, max_length=20)),
|
|
('hospital_name', models.CharField(blank=True, max_length=200)),
|
|
('patient_name', models.CharField(blank=True, max_length=300)),
|
|
],
|
|
options={
|
|
'ordering': ['admit_date'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='HISTestVisit',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('admission_id', models.CharField(db_index=True, max_length=100)),
|
|
('patient_id', models.CharField(db_index=True, max_length=100)),
|
|
('visit_category', models.CharField(db_index=True, max_length=10)),
|
|
('event_type', models.CharField(blank=True, max_length=200)),
|
|
('bill_date', models.DateTimeField(blank=True, db_index=True, null=True)),
|
|
('reg_code', models.CharField(blank=True, max_length=100)),
|
|
('ssn', models.CharField(blank=True, db_index=True, max_length=50)),
|
|
('mobile_no', models.CharField(blank=True, db_index=True, max_length=20)),
|
|
('visit_data', models.JSONField(default=dict)),
|
|
],
|
|
options={
|
|
'ordering': ['bill_date'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='HISVisitEvent',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('event_type', models.CharField(blank=True, help_text="Type from HIS (e.g., 'Registration')", max_length=200)),
|
|
('bill_date', models.CharField(blank=True, help_text='Raw BillDate from HIS (DD-Mon-YYYY HH:MM)', max_length=50)),
|
|
('parsed_date', models.DateTimeField(blank=True, db_index=True, help_text='Parsed bill_date', null=True)),
|
|
('patient_type', models.CharField(blank=True, help_text='PatientType for this event', max_length=10)),
|
|
('visit_category', models.CharField(blank=True, help_text='Visit category: ED, IP, OP', max_length=10)),
|
|
('admission_id', models.CharField(blank=True, db_index=True, max_length=100)),
|
|
('patient_id', models.CharField(blank=True, db_index=True, help_text='PatientID from HIS', max_length=100)),
|
|
('reg_code', models.CharField(blank=True, db_index=True, max_length=100)),
|
|
('ssn', models.CharField(blank=True, db_index=True, max_length=50)),
|
|
('mobile_no', models.CharField(blank=True, max_length=50)),
|
|
],
|
|
options={
|
|
'ordering': ['parsed_date'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='InboundEvent',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('source_system', models.CharField(choices=[('his', 'Hospital Information System'), ('lab', 'Laboratory System'), ('radiology', 'Radiology System'), ('pharmacy', 'Pharmacy System'), ('moh', 'Ministry of Health'), ('chi', 'Council of Health Insurance'), ('pxconnect', 'PX Connect'), ('other', 'Other')], db_index=True, help_text='System that sent this event', max_length=50)),
|
|
('event_code', models.CharField(db_index=True, help_text='Event type code (e.g., OPD_VISIT_COMPLETED, LAB_ORDER_COMPLETED)', max_length=100)),
|
|
('encounter_id', models.CharField(db_index=True, help_text='Encounter ID from HIS system', max_length=100)),
|
|
('patient_identifier', models.CharField(blank=True, db_index=True, help_text='Patient MRN or other identifier', max_length=100)),
|
|
('payload_json', models.JSONField(help_text='Full event payload from source system')),
|
|
('status', models.CharField(choices=[('pending', 'Pending'), ('processing', 'Processing'), ('processed', 'Processed'), ('failed', 'Failed'), ('ignored', 'Ignored')], db_index=True, default='pending', max_length=20)),
|
|
('received_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('processed_at', models.DateTimeField(blank=True, null=True)),
|
|
('error', models.TextField(blank=True, help_text='Error message if processing failed')),
|
|
('processing_attempts', models.IntegerField(default=0, help_text='Number of processing attempts')),
|
|
('physician_license', models.CharField(blank=True, help_text='Physician license number from event', max_length=100)),
|
|
('department_code', models.CharField(blank=True, help_text='Department code from event', max_length=50)),
|
|
('metadata', models.JSONField(blank=True, default=dict, help_text='Additional processing metadata')),
|
|
],
|
|
options={
|
|
'ordering': ['-received_at'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='IntegrationConfig',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('name', models.CharField(max_length=200, unique=True)),
|
|
('source_system', models.CharField(choices=[('his', 'Hospital Information System'), ('lab', 'Laboratory System'), ('radiology', 'Radiology System'), ('pharmacy', 'Pharmacy System'), ('moh', 'Ministry of Health'), ('chi', 'Council of Health Insurance'), ('pxconnect', 'PX Connect'), ('other', 'Other')], max_length=50, unique=True)),
|
|
('api_url', models.URLField(blank=True, help_text='API endpoint URL')),
|
|
('api_key', models.CharField(blank=True, help_text='API key (encrypted)', max_length=500)),
|
|
('is_active', models.BooleanField(default=True)),
|
|
('config_json', models.JSONField(blank=True, default=dict, help_text='Additional configuration (event mappings, field mappings, etc.)')),
|
|
('description', models.TextField(blank=True)),
|
|
('last_sync_at', models.DateTimeField(blank=True, null=True)),
|
|
],
|
|
options={
|
|
'ordering': ['name'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='SurveyTemplateMapping',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('patient_type', models.CharField(choices=[('IP', 'Inpatient'), ('OP', 'Outpatient'), ('ED', 'Emergency'), ('DAYCASE', 'Day Case'), ('APPOINTMENT', 'Appointment')], db_index=True, help_text='Patient type from HIS system', max_length=20)),
|
|
('is_active', models.BooleanField(db_index=True, default=True, help_text='Whether this mapping is active')),
|
|
('send_delay_hours', models.IntegerField(default=1, help_text='Hours after discharge to send survey')),
|
|
],
|
|
options={
|
|
'ordering': ['hospital', 'patient_type'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='HISPatientVisit',
|
|
fields=[
|
|
('created_at', models.DateTimeField(auto_now_add=True, db_index=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)),
|
|
('admission_id', models.CharField(db_index=True, max_length=100)),
|
|
('reg_code', models.CharField(blank=True, db_index=True, max_length=100)),
|
|
('patient_id_his', models.CharField(blank=True, db_index=True, help_text='PatientID from HIS', max_length=100)),
|
|
('patient_type', models.CharField(help_text='ED, IP, OP from HIS', max_length=10)),
|
|
('admit_date', models.DateTimeField(blank=True, null=True)),
|
|
('discharge_date', models.DateTimeField(blank=True, help_text='From HIS DischargeDate (null for OP)', null=True)),
|
|
('effective_discharge_date', models.DateTimeField(blank=True, help_text='For OP: last visit timestamp when deemed complete', null=True)),
|
|
('visit_data', models.JSONField(blank=True, default=dict, help_text='Full patient demographic dict from HIS')),
|
|
('visit_timeline', models.JSONField(blank=True, default=list, help_text='Extracted visit events for this patient')),
|
|
('primary_doctor', models.CharField(blank=True, help_text='From HIS PrimaryDoctor (raw text fallback)', max_length=300)),
|
|
('consultant_id', models.CharField(blank=True, help_text='From HIS ConsultantID (raw text fallback)', max_length=50)),
|
|
('company_name', models.CharField(blank=True, help_text='From HIS CompanyName (insurance sponsor)', max_length=300)),
|
|
('grade_name', models.CharField(blank=True, help_text='From HIS GradeName (insurance grade)', max_length=100)),
|
|
('insurance_company_name', models.CharField(blank=True, help_text='From HIS InsuranceCompanyName', max_length=300)),
|
|
('bill_type', models.CharField(blank=True, help_text='From HIS BillType (CS/CR)', max_length=20)),
|
|
('is_vip', models.BooleanField(db_index=True, default=False, help_text='From HIS IsVIP')),
|
|
('nationality', models.CharField(blank=True, help_text='From HIS PatientNationality', max_length=100)),
|
|
('is_visit_complete', models.BooleanField(db_index=True, default=False)),
|
|
('last_his_fetch_at', models.DateTimeField(blank=True, help_text='Last time this visit was seen in a HIS fetch', null=True)),
|
|
('consultant_fk', models.ForeignKey(blank=True, help_text='Resolved Staff record from ConsultantID', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='his_visits_as_consultant', to='organizations.staff')),
|
|
('hospital', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='his_visits', to='organizations.hospital')),
|
|
('patient', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='his_visits', to='organizations.patient')),
|
|
('primary_doctor_fk', models.ForeignKey(blank=True, help_text='Resolved Staff record from PrimaryDoctor ID prefix', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='his_visits_as_doctor', to='organizations.staff')),
|
|
],
|
|
options={
|
|
'ordering': ['-created_at'],
|
|
},
|
|
),
|
|
]
|