class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0203_daily_feeding_indicator'),
]
operations = [
migrations.CreateModel(
name='AggregateDailyCcsRecordTHRForms',
fields=[
('doc_id', models.TextField()),
('state_id', models.TextField()),
('supervisor_id', models.TextField(null=True)),
('month', models.DateField(help_text='Will always be YYYY-MM-01')),
('case_id', models.CharField(max_length=40, primary_key=True, serialize=False)),
('latest_time_end_processed', models.DateTimeField(help_text='The latest form.meta.timeEnd that has been processed for this case')),
('photo_thr_packets_distributed', models.TextField(help_text='Photo taken during thr distribution', null=True)),
],
options={
'db_table': 'icds_dashboard_daily_ccs_record_thr_forms',
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggregatedailyccsrecordthrforms',
unique_together=set([('month', 'supervisor_id', 'case_id', 'latest_time_end_processed')]),
),
migrations.CreateModel(
name='AggregateDailyChildHealthTHRForms',
fields=[
('doc_id', models.TextField()),
('state_id', models.TextField()),
('supervisor_id', models.TextField(null=True)),
('month', models.DateField(help_text='Will always be YYYY-MM-01')),
('case_id', models.CharField(max_length=40, primary_key=True, serialize=False)),
('latest_time_end_processed', models.DateTimeField(help_text='The latest form.meta.timeEnd that has been processed for this case')),
('photo_thr_packets_distributed', models.TextField(help_text='Photo taken during thr distribution', null=True)),
],
options={
'db_table': 'icds_dashboard_daily_child_health_thr_forms',
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggregatedailychildhealththrforms',
unique_together=set([('month', 'supervisor_id', 'case_id', 'latest_time_end_processed')]),
),
]
operations.extend(get_composite_primary_key_migrations(['aggregatedailyccsrecordthrforms']))
operations.extend(get_composite_primary_key_migrations(['aggregatedailychildhealththrforms']))
operations += [
migrations.RunSQL(f"SELECT create_distributed_table('{AGG_DAILY_CCS_RECORD_THR_TABLE}', 'supervisor_id')"),
migrations.RunSQL(f"SELECT create_distributed_table('{AGG_DAILY_CHILD_HEALTH_THR_TABLE}', 'supervisor_id')"),
]
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0155_added_new_fields_css_record_monthly_and_delivery_forms'),
]
operations = [
migrations.CreateModel(
name='AggregateAdolescentGirlsRegistrationForms',
fields=[
('person_case_id', models.TextField(primary_key=True, serialize=False)),
('state_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('awc_id', models.TextField(null=True)),
('out_of_school', models.NullBooleanField()),
('re_out_of_school', models.NullBooleanField()),
('admitted_in_school', models.NullBooleanField()),
('month', models.DateField(null=True)),
],
options={
'db_table': 'icds_dashboard_adolescent_girls_registration',
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggregateadolescentgirlsregistrationforms',
unique_together=set([('supervisor_id', 'person_case_id', 'month')]),
),
migrations.RunSQL("ALTER table agg_awc ADD COLUMN cases_person_adolescent_girls_11_14_out_of_school INTEGER"),
migrations.RunSQL("ALTER table agg_awc ADD COLUMN cases_person_adolescent_girls_11_14_all_v2 INTEGER"),
]
operations.extend(get_composite_primary_key_migrations(['aggregateadolescentgirlsregistrationforms']))
operations.append(migrations.RunPython(_distribute_citus_tables, migrations.RunPython.noop))
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0164_auto_20200123_0702'),
]
operations = [
migrations.CreateModel(
name='AggregateMigrationForms',
fields=[
('state_id', models.CharField(max_length=40)),
('supervisor_id', models.TextField(null=True)),
('month', models.DateField(help_text='Will always be YYYY-MM-01')),
('person_case_id', models.CharField(max_length=40, primary_key=True, serialize=False)),
('is_migrated', models.PositiveSmallIntegerField(
blank=True, help_text='Status of the Migration', null=True)),
('migration_date', models.DateTimeField(help_text='Migration Date', null=True)),
],
options={
'db_table': 'icds_dashboard_migration_forms',
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggregatemigrationforms',
unique_together=set([('month', 'supervisor_id', 'person_case_id')]),
),
]
operations.extend(get_composite_primary_key_migrations(['aggregatemigrationforms']))
operations.append(migrations.RunPython(_distribute_citus_tables, migrations.RunPython.noop))
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0169_merge_20200217_1447'),
]
operations = [
migrations.CreateModel(
name='AggServiceDeliveryReport',
fields=[
('state_id', models.TextField(null=True)),
('district_id', models.TextField(null=True)),
('block_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('awc_id', models.TextField(primary_key=True,
serialize=False)),
('lunch_eligible', models.IntegerField(null=True)),
('lunch_0_days', models.IntegerField(null=True)),
('lunch_1_7_days', models.IntegerField(null=True)),
('lunch_8_14_days', models.IntegerField(null=True)),
('lunch_15_20_days', models.IntegerField(null=True)),
('lunch_21_days', models.IntegerField(null=True)),
('pse_eligible', models.IntegerField(null=True)),
('pse_0_days', models.IntegerField(null=True)),
('pse_1_7_days', models.IntegerField(null=True)),
('pse_8_14_days', models.IntegerField(null=True)),
('pse_15_20_days', models.IntegerField(null=True)),
('pse_21_days', models.IntegerField(null=True)),
('thr_eligible', models.IntegerField(null=True)),
('thr_0_days', models.IntegerField(null=True)),
('thr_1_7_days', models.IntegerField(null=True)),
('thr_8_14_days', models.IntegerField(null=True)),
('thr_15_20_days', models.IntegerField(null=True)),
('thr_21_days', models.IntegerField(null=True)),
('state_is_test', models.SmallIntegerField(null=True)),
('district_is_test', models.SmallIntegerField(null=True)),
('block_is_test', models.SmallIntegerField(null=True)),
('supervisor_is_test', models.SmallIntegerField(null=True)),
('awc_is_test', models.SmallIntegerField(null=True)),
('month', models.DateField(null=True)),
('aggregation_level', models.SmallIntegerField(null=True)),
],
options={
'db_table': 'agg_service_delivery_report',
},
bases=(models.Model,
custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggservicedeliveryreport',
unique_together=set([
('month', 'aggregation_level', 'state_id', 'district_id',
'block_id', 'supervisor_id', 'awc_id')
]),
),
]
operations.extend(
get_composite_primary_key_migrations(['aggservicedeliveryreport']))
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0117_awc_location_local'),
]
operations = get_composite_primary_key_migrations([
'ccsrecordmonthly',
'childhealthmonthly',
])
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0215_birth_death_cols'),
]
operations = [
migrations.CreateModel(
name='AggregateSamMamPanchayatForm',
fields=[
('state_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('month', models.DateField(help_text='Will always be YYYY-MM-01')),
('awc_id', models.TextField(primary_key=True, serialize=False)),
('poshan_panchayat_date_1', models.DateField(blank=True, null=True)),
('poshan_panchayat_date_2', models.DateField(blank=True, null=True)),
('poshan_panchayat_date_3', models.DateField(blank=True, null=True)),
('poshan_panchayat_date_4', models.DateField(blank=True, null=True)),
],
options={
'db_table': 'icds_dashboard_sam_mam_panchayat_forms',
'unique_together': {('month', 'state_id', 'supervisor_id', 'awc_id')},
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.RemoveField(
model_name='aggregatesammamform',
name='poshan_panchayat_date_1',
),
migrations.RemoveField(
model_name='aggregatesammamform',
name='poshan_panchayat_date_2',
),
migrations.RemoveField(
model_name='aggregatesammamform',
name='poshan_panchayat_date_3',
),
migrations.RemoveField(
model_name='aggregatesammamform',
name='poshan_panchayat_date_4',
)
]
operations.extend(get_composite_primary_key_migrations(['aggregatesammampanchayatform']))
operations.append(migrations.RunSQL(f"SELECT create_distributed_table('icds_dashboard_sam_mam_panchayat_forms', 'supervisor_id')"))
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0106_left_join_service_delivery'),
]
operations = get_composite_primary_key_migrations([
'aggregatebirthpreparednesforms',
'aggregateccsrecorddeliveryforms',
'aggregateccsrecordpostnatalcareforms',
'aggregateccsrecordthrforms',
'aggregateccsrecordcomplementaryfeedingforms',
'aggregatechildhealthdailyfeedingforms',
'aggregatechildhealthpostnatalcareforms',
'aggregatechildhealththrforms',
'aggregatecomplementaryfeedingforms',
'aggregategrowthmonitoringforms',
'aggregateawcinfrastructureforms',
'dailyattendance',
])
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0213_add_new_columns_ccs_chm'),
]
operations = [
migrations.CreateModel(
name='AggregatePersonCase',
fields=[
('supervisor_id', models.TextField(null=True)),
('month',
models.DateField(help_text='Will always be YYYY-MM-01')),
('awc_id', models.TextField(primary_key=True,
serialize=False)),
('cases_person', models.IntegerField(null=True)),
('cases_person_all', models.IntegerField(null=True)),
('cases_person_adolescent_girls_11_14',
models.IntegerField(null=True)),
('cases_person_adolescent_girls_11_14_all',
models.IntegerField(null=True)),
('cases_person_adolescent_girls_11_14_all_v2',
models.IntegerField(null=True)),
('cases_person_adolescent_girls_15_18',
models.IntegerField(null=True)),
('cases_person_adolescent_girls_15_18_all',
models.IntegerField(null=True)),
('cases_person_referred', models.IntegerField(null=True)),
('num_premature_referral_awcs',
models.IntegerField(null=True)),
('total_premature_referrals', models.IntegerField(null=True)),
('total_premature_reached_facility',
models.IntegerField(null=True)),
('num_sepsis_referral_awcs', models.IntegerField(null=True)),
('total_sepsis_referrals', models.IntegerField(null=True)),
('total_sepsis_reached_facility',
models.IntegerField(null=True)),
('num_diarrhoea_referral_awcs',
models.IntegerField(null=True)),
('total_diarrhoea_referrals', models.IntegerField(null=True)),
('total_diarrhoea_reached_facility',
models.IntegerField(null=True)),
('num_pneumonia_referral_awcs',
models.IntegerField(null=True)),
('total_pneumonia_referrals', models.IntegerField(null=True)),
('total_pneumonia_reached_facility',
models.IntegerField(null=True)),
('num_fever_referral_awcs', models.IntegerField(null=True)),
('total_fever_referrals', models.IntegerField(null=True)),
('total_fever_reached_facility',
models.IntegerField(null=True)),
('num_severely_underweight_referral_awcs',
models.IntegerField(null=True)),
('total_severely_underweight_referrals',
models.IntegerField(null=True)),
('total_severely_underweight_reached_facility',
models.IntegerField(null=True)),
('num_other_child_referral_awcs',
models.IntegerField(null=True)),
('total_other_child_referrals',
models.IntegerField(null=True)),
('total_other_child_reached_facility',
models.IntegerField(null=True)),
('num_bleeding_referral_awcs', models.IntegerField(null=True)),
('total_bleeding_referrals', models.IntegerField(null=True)),
('total_bleeding_reached_facility',
models.IntegerField(null=True)),
('num_convulsions_referral_awcs',
models.IntegerField(null=True)),
('total_convulsions_referrals',
models.IntegerField(null=True)),
('total_convulsions_reached_facility',
models.IntegerField(null=True)),
('num_prolonged_labor_referral_awcs',
models.IntegerField(null=True)),
('total_prolonged_labor_referrals',
models.IntegerField(null=True)),
('total_prolonged_labor_reached_facility',
models.IntegerField(null=True)),
('num_abortion_complications_referral_awcs',
models.IntegerField(null=True)),
('total_abortion_complications_referrals',
models.IntegerField(null=True)),
('total_abortion_complications_reached_facility',
models.IntegerField(null=True)),
('num_fever_discharge_referral_awcs',
models.IntegerField(null=True)),
('total_fever_discharge_referrals',
models.IntegerField(null=True)),
('total_fever_discharge_reached_facility',
models.IntegerField(null=True)),
('num_other_referral_awcs', models.IntegerField(null=True)),
('total_other_referrals', models.IntegerField(null=True)),
('total_other_reached_facility',
models.IntegerField(null=True)),
],
options={'db_table': 'icds_dashboard_person_cases'},
bases=(models.Model,
custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggregatepersoncase',
unique_together=set([('month', 'supervisor_id', 'awc_id')]),
),
]
operations.extend(
get_composite_primary_key_migrations(['aggregatepersoncase']))
operations += [
migrations.RunSQL(
f"ALTER TABLE {AGG_PERSON_CASE_TABLE} RENAME TO {AGG_PERSON_CASE_TABLE}_old"
),
migrations.RunSQL(
f"CREATE TABLE {AGG_PERSON_CASE_TABLE} (LIKE {AGG_PERSON_CASE_TABLE}_old INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES) PARTITION BY LIST (month)"
),
migrations.RunSQL(
f"SELECT create_distributed_table('{AGG_PERSON_CASE_TABLE}', 'supervisor_id')"
),
migrations.RunSQL(f"DROP TABLE {AGG_PERSON_CASE_TABLE}_old"),
]
operations += [
migrations.AddField(
model_name='aggmprawc',
name='num_abortion_complications_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_bleeding_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_convulsions_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_diarrhoea_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_fever_discharge_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_fever_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_other_child_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_other_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_pneumonia_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_premature_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_prolonged_labor_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_sepsis_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='num_severely_underweight_referral_awcs',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_abortion_complications_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_abortion_complications_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_bleeding_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_bleeding_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_convulsions_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_convulsions_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_diarrhoea_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_diarrhoea_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_fever_discharge_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_fever_discharge_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_fever_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_fever_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_other_child_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_other_child_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_other_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_other_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_pneumonia_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_pneumonia_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_premature_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_premature_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_prolonged_labor_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_prolonged_labor_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_sepsis_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_sepsis_referrals',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_severely_underweight_reached_facility',
field=models.IntegerField(null=True),
),
migrations.AddField(
model_name='aggmprawc',
name='total_severely_underweight_referrals',
field=models.IntegerField(null=True),
)
]
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0204_daily_thr_photos'),
]
operations = [
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN last_referral_date date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN referral_reached_date date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN last_referral_discharge_date date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN referral_health_problem text "
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN sam_mam_visit_date_1 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN sam_mam_visit_date_2 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN sam_mam_visit_date_3 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN sam_mam_visit_date_4 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN poshan_panchayat_date_1 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN poshan_panchayat_date_2 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN poshan_panchayat_date_3 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN poshan_panchayat_date_4 date"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN last_recorded_weight decimal"
),
migrations.RunSQL(
"ALTER TABLE child_health_monthly ADD COLUMN last_recorded_height decimal"
),
migrations.CreateModel(
name='AggregateSamMamForm',
fields=[
('state_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('month',
models.DateField(help_text='Will always be YYYY-MM-01')),
('child_health_case_id',
models.TextField(primary_key=True, serialize=False)),
('sam_mam_visit_date_1', models.DateField(blank=True,
null=True)),
('sam_mam_visit_date_2', models.DateField(blank=True,
null=True)),
('sam_mam_visit_date_3', models.DateField(blank=True,
null=True)),
('sam_mam_visit_date_4', models.DateField(blank=True,
null=True)),
('poshan_panchayat_date_1',
models.DateField(blank=True, null=True)),
('poshan_panchayat_date_2',
models.DateField(blank=True, null=True)),
('poshan_panchayat_date_3',
models.DateField(blank=True, null=True)),
('poshan_panchayat_date_4',
models.DateField(blank=True, null=True)),
],
options={
'db_table': 'icds_dashboard_sam_mam_forms',
'unique_together': {('month', 'state_id', 'supervisor_id',
'child_health_case_id')},
},
),
]
operations.extend(
get_composite_primary_key_migrations(['aggregatesammamform']))
operations.append(
migrations.RunSQL(
f"SELECT create_distributed_table('icds_dashboard_sam_mam_forms', 'supervisor_id')"
))
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0179_drop_bihar_model'),
]
operations = [
migrations.CreateModel(
name='BiharAPIDemographics',
fields=[
('state_id', models.TextField(null=True)),
('district_id', models.TextField(null=True)),
('block_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('awc_id', models.TextField(null=True)),
('month', models.DateField()),
('household_id', models.TextField(null=True)),
('household_name', models.TextField(null=True)),
('hh_reg_date', models.TextField(null=True)),
('hh_num', models.IntegerField(null=True)),
('hh_gps_location', models.TextField(null=True)),
('hh_caste', models.TextField(null=True)),
('hh_bpl_apl', models.TextField(null=True)),
('hh_minority', models.SmallIntegerField(null=True)),
('hh_religion', models.TextField(null=True)),
('hh_member_number', models.IntegerField(null=True)),
('person_id', models.TextField(primary_key=True, serialize=False)),
('person_name', models.TextField(null=True)),
('has_adhaar', models.SmallIntegerField(null=True)),
('bank_account_number', models.TextField(null=True)),
('ifsc_code', models.TextField(null=True)),
('age_at_reg', models.SmallIntegerField(null=True)),
('dob', models.DateField(null=True)),
('gender', models.TextField(null=True)),
('blood_group', models.TextField(null=True)),
('disabled', models.SmallIntegerField(null=True)),
('disability_type', models.TextField(null=True)),
('referral_status', models.TextField(null=True)),
('migration_status', models.SmallIntegerField(null=True)),
('resident', models.SmallIntegerField(null=True)),
('registered_status', models.SmallIntegerField(null=True)),
('married', models.SmallIntegerField(null=True)),
('husband_name', models.TextField(null=True)),
('husband_id', models.TextField(null=True)),
('last_preg_tt', models.SmallIntegerField(null=True)),
('is_pregnant', models.SmallIntegerField(null=True)),
('rch_id', models.TextField(null=True)),
('mcts_id', models.TextField(null=True)),
('phone_number', models.TextField(null=True)),
('date_death', models.DateField(null=True)),
('site_death', models.TextField(null=True)),
('closed_on', models.DateField(null=True)),
('reason_closure', models.TextField(null=True)),
],
options={
'db_table': 'bihar_api_demographics',
},
bases=(models.Model, custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='biharapidemographics',
unique_together=set([('supervisor_id', 'month', 'person_id')]),
),
]
operations.extend(get_composite_primary_key_migrations(['biharapidemographics']))
operations += [
migrations.RunSQL(f"ALTER TABLE {BIHAR_API_DEMOGRAPHICS_TABLE} RENAME TO {BIHAR_API_DEMOGRAPHICS_TABLE}_old"),
migrations.RunSQL(f"CREATE TABLE {BIHAR_API_DEMOGRAPHICS_TABLE} (LIKE {BIHAR_API_DEMOGRAPHICS_TABLE}_old INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES) PARTITION BY LIST (month)"),
migrations.RunSQL(f"SELECT create_distributed_table('{BIHAR_API_DEMOGRAPHICS_TABLE}', 'supervisor_id')"),
migrations.RunSQL(f"DROP TABLE {BIHAR_API_DEMOGRAPHICS_TABLE}_old"),
]
operations += [
migrations.RunSQL("ALTER TABLE ccs_record_monthly ADD COLUMN tt_booster date"),
migrations.RunSQL("ALTER TABLE ccs_record_monthly ADD COLUMN last_preg_year integer")
]
class Migration(migrations.Migration):
dependencies = [
('icds_reports', '0205_sam_mam_fields'),
]
operations = [
migrations.CreateModel(
name='AggMPRAwc',
fields=[
('state_id', models.TextField(null=True)),
('district_id', models.TextField(null=True)),
('block_id', models.TextField(null=True)),
('supervisor_id', models.TextField(null=True)),
('awc_id', models.TextField(primary_key=True,
serialize=False)),
('state_is_test', models.SmallIntegerField(null=True)),
('district_is_test', models.SmallIntegerField(null=True)),
('block_is_test', models.SmallIntegerField(null=True)),
('supervisor_is_test', models.SmallIntegerField(null=True)),
('awc_is_test', models.SmallIntegerField(null=True)),
('month', models.DateField(null=True)),
('aggregation_level', models.SmallIntegerField(null=True)),
('visitor_icds_sup', models.IntegerField(null=True)),
('visitor_anm', models.IntegerField(null=True)),
('visitor_health_sup', models.IntegerField(null=True)),
('visitor_cdpo', models.IntegerField(null=True)),
('visitor_med_officer', models.IntegerField(null=True)),
('visitor_dpo', models.IntegerField(null=True)),
('visitor_officer_state', models.IntegerField(null=True)),
('visitor_officer_central', models.IntegerField(null=True)),
('vhnd_done_when_planned', models.IntegerField(null=True)),
('vhnd_with_aww_present', models.IntegerField(null=True)),
('vhnd_with_icds_sup', models.IntegerField(null=True)),
('vhnd_with_asha_present', models.IntegerField(null=True)),
('vhnd_with_anm_mpw', models.IntegerField(null=True)),
('vhnd_with_health_edu_org', models.IntegerField(null=True)),
('vhnd_with_display_tools', models.IntegerField(null=True)),
('vhnd_with_thr_distr', models.IntegerField(null=True)),
('vhnd_with_child_immu', models.IntegerField(null=True)),
('vhnd_with_vit_a_given', models.IntegerField(null=True)),
('vhnd_with_anc_today', models.IntegerField(null=True)),
('vhnd_with_local_leader', models.IntegerField(null=True)),
('vhnd_with_due_list_prep_immunization',
models.IntegerField(null=True)),
('vhnd_with_due_list_prep_vita_a',
models.IntegerField(null=True)),
('vhnd_with_due_list_prep_antenatal_checkup',
models.IntegerField(null=True)),
],
options={'db_table': 'agg_mpr_awc'},
bases=(models.Model,
custom.icds_reports.models.aggregate.AggregateMixin),
),
migrations.AlterUniqueTogether(
name='aggmprawc',
unique_together=set([
('month', 'aggregation_level', 'state_id', 'district_id',
'block_id', 'supervisor_id', 'awc_id')
]),
),
]
operations.extend(get_composite_primary_key_migrations(['aggmprawc']))
