class Migration(migrations.Migration): dependencies = [ ('base', '0129_translation_active'), ] operations = [ migrations.AddIndex( model_name='translation', index=partial_index.PartialIndex( fields=['entity', 'locale', 'plural_form', 'active'], name='base_transl_entity__fbea1e_partial', unique=True, where=partial_index.PQ(active=True)), ), migrations.AddIndex( model_name='translation', index=partial_index.PartialIndex( fields=['entity', 'locale', 'active'], name='base_transl_entity__ed9592_partial', unique=True, where=partial_index.PQ(('active', True), ('plural_form__isnull', True))), ), ]
class Migration(migrations.Migration): dependencies = [ ("base", "0129_translation_active"), ] operations = [ migrations.AddIndex( model_name="translation", index=partial_index.PartialIndex( fields=["entity", "locale", "plural_form", "active"], name="base_transl_entity__fbea1e_partial", unique=True, where=partial_index.PQ(active=True), ), ), migrations.AddIndex( model_name="translation", index=partial_index.PartialIndex( fields=["entity", "locale", "active"], name="base_transl_entity__ed9592_partial", unique=True, where=partial_index.PQ(("active", True), ("plural_form__isnull", True)), ), ), ]
class Migration(migrations.Migration): dependencies = [ ('company', '0009_auto_20190207_1919'), ] operations = [ migrations.RemoveIndex( model_name='usercompany', name='company_use_user_id_099c95_partial', ), migrations.AlterField( model_name='company', name='status', field=models.PositiveIntegerField(choices=[(1, b'UNVERIFIED'), (2, b'ACTIVE'), (3, b'INACTIVE')], default=1, help_text='company status'), ), migrations.AddIndex( model_name='usercompany', index=partial_index.PartialIndex( fields=['user', 'company'], name='company_use_user_id_a07d1a_partial', unique=True, where=partial_index.PQ(status=3)), ), ]
class Migration(migrations.Migration): dependencies = [ ('recipient', '0005_auto_20180723_1753'), ] operations = [ migrations.CreateModel( name='RecipientLookup', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipient_hash', models.UUIDField(null=True, unique=True)), ('legal_business_name', models.TextField(db_index=True, null=True)), ('duns', models.TextField(null=True)), ], options={ 'db_table': 'recipient_lookup', }, ), migrations.AddIndex( model_name='recipientlookup', index=partial_index.PartialIndex( fields=['duns'], name='recipient_l_duns_bb057a_partial', unique=True, where=partial_index.PQ(duns__isnull=False)), ), ]
class Migration(migrations.Migration): atomic = False dependencies = [ ('blobs', '0009_delete_blobexpiration'), ] operations = [ migrations.RunSQL( migrations.RunSQL.noop, migrations.RunSQL.noop, state_operations=[ migrations.RemoveIndex( model_name='blobmeta', name='blobs_blobm_expires_64b92d_partial', ), migrations.AddIndex( model_name='blobmeta', index=partial_index.PartialIndex( fields=['expires_on'], name='blobs_blobm_expires_ed7e3d_partial', unique=False, where=partial_index.PQ(expires_on__isnull=False)), ) ]), migrations.RunSQL( sql=CREATE_INDEX_SQL, reverse_sql=DROP_INDEX_SQL, state_operations=[ migrations.AddIndex( model_name='blobmeta', index=partial_index.PartialIndex( fields=['type_code', 'created_on'], name='blobs_blobm_type_co_23e226_partial', unique=False, where=partial_index.PQ(domain='icds-cas')), ), ]), ]
class Migration(migrations.Migration): dependencies = [ ('users', '0039_auto_20210616_1634'), ] operations = [ migrations.AddIndex( model_name='userskill', index=partial_index.PartialIndex( fields=['skill', 'user'], name='users_users_skill_i_6ebc32_partial', unique=True, where=partial_index.PQ(deleted=False)), ), ]
class Migration(migrations.Migration): dependencies = [ ('facility', '0117_patientsample_icmr_category'), ] operations = [ migrations.CreateModel( name='FacilityInventoryMinQuantity', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('external_id', models.UUIDField(db_index=True, default=uuid.uuid4, unique=True)), ('created_date', models.DateTimeField(auto_now_add=True, null=True)), ('modified_date', models.DateTimeField(auto_now=True, null=True)), ('deleted', models.BooleanField(default=False)), ('min_quantity', models.FloatField(default=0)), ('facility', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='facility.Facility')), ('item', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='facility.FacilityInventoryItem')), ], bases=(models.Model, care.facility.models.mixins.permissions. facility.FacilityRelatedPermissionMixin), ), migrations.AddIndex( model_name='facilityinventoryminquantity', index=partial_index.PartialIndex( fields=['facility', 'item'], name='facility_fa_facilit_a9eb9a_partial', unique=True, where=partial_index.PQ(deleted=False)), ), ]
class Migration(migrations.Migration): dependencies = [ ('recipient', '0010_duns_dba_name'), ] operations = [ migrations.RemoveIndex( model_name='recipientlookup', name='recipient_l_parent__e14231_partial', ), migrations.AddIndex( model_name='recipientlookup', index=partial_index.PartialIndex( fields=['parent_duns'], name='recipient_l_parent__efd6d5_partial', unique=False, where=partial_index.PQ(parent_duns__isnull=False)), ), ]
class Migration(migrations.Migration): dependencies = [ ("facility", "0028_auto_20200326_1705"), ] operations = [ migrations.AlterUniqueTogether( name="facilitycapacity", unique_together=set(), ), migrations.AddIndex( model_name="facilitycapacity", index=partial_index.PartialIndex( fields=["facility", "room_type"], name="facility_fa_facilit_ec2b0e_partial", unique=True, where=partial_index.PQ(deleted=False), ), ), ]
class Migration(migrations.Migration): dependencies = [ ("facility", "0027_auto_20200326_1015"), ] operations = [ migrations.AlterUniqueTogether( name="hospitaldoctors", unique_together=set(), ), migrations.AddIndex( model_name="hospitaldoctors", index=partial_index.PartialIndex( fields=["facility", "area"], name="facility_ho_facilit_ec08f4_partial", unique=True, where=partial_index.PQ(deleted=False), ), ), ]
class Migration(migrations.Migration): dependencies = [ ('facility', '0053_delete_duplicate_diseases'), ] operations = [ migrations.AddField( model_name='disease', name='deleted', field=models.BooleanField(default=False), ), migrations.AddIndex( model_name='disease', index=partial_index.PartialIndex( fields=['patient', 'disease'], name='facility_di_patient_640ef7_partial', unique=True, where=partial_index.PQ(deleted=False)), ), ]
class Migration(migrations.Migration): dependencies = [ ('company', '0010_auto_20190208_0930'), ] operations = [ migrations.RemoveIndex( model_name='usercompany', name='company_use_user_id_a07d1a_partial', ), migrations.AddIndex( model_name='usercompany', index=partial_index.PartialIndex(fields=['user', 'company'], name='company_use_user_id_9b3056_partial', unique=True, where=partial_index.PQ(status=2)), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('facility', '0114_auto_20200610_1720'), ] operations = [ migrations.CreateModel( name='FacilityInventoryItem', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=1000)), ('description', models.TextField(blank=True)), ('min_quantity', models.FloatField()), ], ), migrations.CreateModel( name='FacilityInventoryItemTag', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ], ), migrations.CreateModel( name='FacilityInventoryUnit', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ], ), migrations.CreateModel( name='FacilityInventoryUnitConverter', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('multiplier', models.FloatField()), ('from_unit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='from_unit', to='facility.FacilityInventoryUnit')), ('to_unit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='to_unit', to='facility.FacilityInventoryUnit')), ], ), migrations.CreateModel( name='FacilityInventorySummary', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('external_id', models.UUIDField(db_index=True, default=uuid.uuid4, unique=True)), ('created_date', models.DateTimeField(auto_now_add=True, null=True)), ('modified_date', models.DateTimeField(auto_now=True, null=True)), ('deleted', models.BooleanField(default=False)), ('quantity', models.FloatField(default=0)), ('is_low', models.BooleanField(default=False)), ('facility', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='facility.Facility')), ('item', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='facility.FacilityInventoryItem')), ], bases=(models.Model, care.facility.models.mixins.permissions. facility.FacilityRelatedPermissionMixin), ), migrations.CreateModel( name='FacilityInventoryLog', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('external_id', models.UUIDField(db_index=True, default=uuid.uuid4, unique=True)), ('created_date', models.DateTimeField(auto_now_add=True, null=True)), ('modified_date', models.DateTimeField(auto_now=True, null=True)), ('deleted', models.BooleanField(default=False)), ('quantity', models.FloatField(default=0)), ('is_incoming', models.BooleanField()), ('created_by', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ('facility', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='facility.Facility')), ('item', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='facility.FacilityInventoryItem')), ('unit', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to='facility.FacilityInventoryUnit')), ], options={ 'abstract': False, }, bases=(models.Model, care.facility.models.mixins.permissions. facility.FacilityRelatedPermissionMixin), ), migrations.AddField( model_name='facilityinventoryitem', name='allowed_units', field=models.ManyToManyField(related_name='allowed_units', to='facility.FacilityInventoryUnit'), ), migrations.AddField( model_name='facilityinventoryitem', name='default_unit', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='default_unit', to='facility.FacilityInventoryUnit'), ), migrations.AddField( model_name='facilityinventoryitem', name='tags', field=models.ManyToManyField( to='facility.FacilityInventoryItemTag'), ), migrations.AddIndex( model_name='facilityinventorysummary', index=partial_index.PartialIndex( fields=['facility', 'item'], name='facility_fa_facilit_ff33b8_partial', unique=True, where=partial_index.PQ(deleted=False)), ), ]
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ TrigramExtension(), migrations.CreateModel( name='DUNS', fields=[ ('awardee_or_recipient_uniqu', models.TextField(primary_key=True, serialize=False)), ('legal_business_name', models.TextField(blank=True, null=True)), ('dba_name', models.TextField(blank=True, null=True)), ('ultimate_parent_unique_ide', models.TextField(blank=True, null=True)), ('ultimate_parent_legal_enti', models.TextField(blank=True, null=True)), ('address_line_1', models.TextField(blank=True, null=True)), ('address_line_2', models.TextField(blank=True, null=True)), ('city', models.TextField(blank=True, null=True)), ('state', models.TextField(blank=True, null=True)), ('zip', models.TextField(blank=True, null=True)), ('zip4', models.TextField(blank=True, null=True)), ('country_code', models.TextField(blank=True, null=True)), ('congressional_district', models.TextField(blank=True, null=True)), ('business_types_codes', django.contrib.postgres.fields.ArrayField( base_field=models.TextField(), default=list, null=True, size=None)), ('entity_structure', models.TextField(blank=True, null=True)), ('broker_duns_id', models.TextField()), ('update_date', models.DateField()), ], options={ 'db_table': 'duns', }, ), migrations.CreateModel( name='HistoricParentDUNS', fields=[ ('awardee_or_recipient_uniqu', models.TextField()), ('legal_business_name', models.TextField(blank=True, null=True)), ('ultimate_parent_unique_ide', models.TextField(blank=True, null=True)), ('ultimate_parent_legal_enti', models.TextField(blank=True, null=True)), ('broker_historic_duns_id', models.IntegerField(primary_key=True, serialize=False)), ('year', models.IntegerField(blank=True, null=True)), ], options={ 'db_table': 'historic_parent_duns', }, ), migrations.CreateModel( name='RecipientLookup', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipient_hash', models.UUIDField(null=True, unique=True)), ('legal_business_name', models.TextField(db_index=True, null=True)), ('duns', models.TextField(null=True, unique=True)), ('parent_duns', models.TextField(null=True)), ('parent_legal_business_name', models.TextField(null=True)), ('address_line_1', models.TextField(null=True)), ('address_line_2', models.TextField(null=True)), ('city', models.TextField(null=True)), ('state', models.TextField(null=True)), ('zip5', models.TextField(null=True)), ('zip4', models.TextField(null=True)), ('country_code', models.TextField(null=True)), ('congressional_district', models.TextField(null=True)), ('business_types_codes', django.contrib.postgres.fields.ArrayField( base_field=models.TextField(), default=list, null=True, size=None)), ], options={ 'db_table': 'recipient_lookup', }, ), migrations.CreateModel( name='RecipientProfile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipient_level', models.CharField(max_length=1)), ('recipient_hash', models.UUIDField(db_index=True, null=True)), ('recipient_unique_id', models.TextField(db_index=True, null=True)), ('recipient_name', models.TextField(db_index=True, null=True)), ('recipient_affiliations', django.contrib.postgres.fields.ArrayField( base_field=models.TextField(), default=list, size=None)), ('award_types', django.contrib.postgres.fields.ArrayField( base_field=models.TextField(), default=list, size=None)), ('last_12_months', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_contracts', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_grants', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_direct_payments', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_loans', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_other', models.DecimalField(decimal_places=2, default=0.0, max_digits=23)), ('last_12_months_count', models.IntegerField(default=0)), ], options={ 'db_table': 'recipient_profile', 'managed': True, }, ), migrations.CreateModel( name='StateData', fields=[ ('id', models.TextField(primary_key=True, serialize=False)), ('fips', models.TextField(db_index=True)), ('code', models.TextField()), ('name', models.TextField()), ('type', models.TextField()), ('year', models.IntegerField(db_index=True)), ('population', models.BigIntegerField(blank=True, null=True)), ('pop_source', models.TextField(blank=True, null=True)), ('median_household_income', models.DecimalField(blank=True, decimal_places=2, max_digits=23, null=True)), ('mhi_source', models.TextField(blank=True, null=True)), ], options={ 'db_table': 'state_data', }, ), migrations.CreateModel( name='SummaryAwardRecipient', fields=[ ('award_id', models.BigIntegerField(primary_key=True, serialize=False)), ('action_date', models.DateField(blank=True, db_index=True)), ('recipient_hash', models.UUIDField(db_index=True, null=True)), ('parent_recipient_unique_id', models.TextField(db_index=True, null=True)), ], options={ 'db_table': 'summary_award_recipient', 'managed': True, }, ), migrations.AddIndex( model_name='recipientprofile', index=django.contrib.postgres.indexes.GinIndex( fields=['award_types'], name='recipient_p_award_t_211373_gin'), ), migrations.AddIndex( model_name='recipientprofile', index=models.Index(fields=['recipient_unique_id'], name='recipient_p_recipie_7039a5_idx'), ), migrations.AlterUniqueTogether( name='recipientprofile', unique_together=set([('recipient_hash', 'recipient_level')]), ), migrations.AddIndex( model_name='recipientlookup', index=partial_index.PartialIndex( fields=['duns'], name='recipient_l_duns_bb057a_partial', unique=True, where=partial_index.PQ(duns__isnull=False)), ), migrations.AddIndex( model_name='recipientlookup', index=partial_index.PartialIndex( fields=['parent_duns'], name='recipient_l_parent__efd6d5_partial', unique=False, where=partial_index.PQ(parent_duns__isnull=False)), ), migrations.RunSQL(sql=[ 'alter table only recipient_profile alter column last_12_months set default 0.00', "alter table only recipient_profile alter column recipient_affiliations set default '{}'::text[]", 'create index idx_recipient_profile_name on recipient_profile using gin (recipient_name gin_trgm_ops)', ], ), ]
class Migration(migrations.Migration): dependencies = [ ('recipient', '0007_auto_20180802_1757'), ] operations = [ migrations.AddField( model_name='recipientlookup', name='address_line_1', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='address_line_2', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='business_types_codes', field=django.contrib.postgres.fields.ArrayField( base_field=models.TextField(), default=list, null=True, size=None), ), migrations.AddField( model_name='recipientlookup', name='city', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='congressional_district', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='country_code', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='parent_duns', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='parent_legal_business_name', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='state', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='zip4', field=models.TextField(null=True), ), migrations.AddField( model_name='recipientlookup', name='zip5', field=models.TextField(null=True), ), migrations.AddIndex( model_name='recipientlookup', index=partial_index.PartialIndex( fields=['parent_duns'], name='recipient_l_parent__e14231_partial', unique=False, where=partial_index.PQ(parent_duns__isnull=False)), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ("accounts", "0002_auto_20200522_1408"), ] operations = [ migrations.CreateModel( name="Ambulance", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "vehicle_number", models.CharField( db_index=True, max_length=20, unique=True, validators=[ django.core.validators.RegexValidator( code="invalid_vehicle_number", message= "Please Enter the vehicle number in all uppercase without spaces, eg: KL13AB1234", regex= "^[A-Z]{2}[0-9]{1,2}[A-Z]{0,2}[0-9]{1,4}$", ) ], ), ), ("owner_name", models.CharField(max_length=255)), ( "owner_phone_number", models.CharField( max_length=14, validators=[ django.core.validators.RegexValidator( code="invalid_mobile", message= "Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>", regex= "^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$", ) ], ), ), ("owner_is_smart_phone", models.BooleanField(default=True)), ("has_oxygen", models.BooleanField()), ("has_ventilator", models.BooleanField()), ("has_suction_machine", models.BooleanField()), ("has_defibrillator", models.BooleanField()), ( "insurance_valid_till_year", models.IntegerField(choices=[(2020, 2020), (2021, 2021), (2022, 2022)]), ), ( "ambulance_type", models.IntegerField(choices=[(1, "Basic"), (2, "Cardiac"), (3, "Hearse")], default=1), ), ( "price_per_km", models.DecimalField(decimal_places=2, max_digits=7, null=True), ), ("has_free_service", models.BooleanField(default=False)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ( "primary_district", models.ForeignKey( null=True, on_delete=django.db.models.deletion.PROTECT, related_name="primary_ambulances", to="accounts.District", ), ), ( "secondary_district", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="secondary_ambulances", to="accounts.District", ), ), ( "third_district", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name="third_ambulances", to="accounts.District", ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Building", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("name", models.CharField(max_length=1000)), ( "num_rooms", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "num_floors", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "num_buildings", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Facility", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("name", models.CharField(max_length=1000)), ("is_active", models.BooleanField(default=True)), ("verified", models.BooleanField(default=False)), ( "facility_type", models.IntegerField(choices=[ (1, "Educational Inst"), (2, "Private Hospital"), (3, "Other"), (4, "Hostel"), (5, "Hotel"), (6, "Lodge"), (7, "TeleMedicine"), (8, "Govt Hospital"), (9, "Labs"), (800, "Primary Health Centres"), (801, "24x7 Public Health Centres"), (802, "Family Health Centres"), (803, "Community Health Centres"), (820, "Urban Primary Health Center"), (830, "Taluk Hospitals"), (831, "Taluk Headquarters Hospitals"), (840, "Women and Child Health Centres"), (850, "General hospitals"), (860, "District Hospitals"), (870, "Govt Medical College Hospitals"), (950, "Corona Testing Labs"), (1000, "Corona Care Centre"), ]), ), ( "location", location_field.models.spatial.LocationField(blank=True, null=True, srid=4326), ), ("address", models.TextField()), ("oxygen_capacity", models.IntegerField(default=0)), ( "phone_number", models.CharField( blank=True, max_length=14, validators=[ django.core.validators.RegexValidator( code="invalid_mobile", message= "Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>", regex= "^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$", ) ], ), ), ("corona_testing", models.BooleanField(default=False)), ( "created_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ( "district", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="accounts.District", ), ), ( "local_body", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="accounts.LocalBody", ), ), ( "state", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="accounts.State", ), ), ], options={ "verbose_name_plural": "Facilities", }, ), migrations.CreateModel( name="Inventory", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "quantitiy", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ], options={ "verbose_name_plural": "Inventories", }, ), migrations.CreateModel( name="InventoryItem", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("name", models.CharField(max_length=1000)), ("description", models.TextField()), ( "minimum_stock", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ("unit", models.CharField(max_length=20)), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Room", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("num", models.CharField(max_length=1000)), ( "floor", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "beds_capacity", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "occupied_beds", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "room_type", models.IntegerField(choices=[ (0, "Total"), (1, "General Bed"), (2, "Hostel"), (3, "Single Room with Attached Bathroom"), (10, "ICU"), (20, "Ventilator"), ]), ), ( "building", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Building", ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="StaffRoomAllocation", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "room", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Room"), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="InventoryLog", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "prev_count", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "new_count", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "inventory", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Inventory", ), ), ( "updated_by", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.AddField( model_name="inventory", name="item", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.InventoryItem"), ), migrations.CreateModel( name="HospitalDoctors", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "area", models.IntegerField(choices=[ (1, "General Medicine"), (2, "Pulmonology"), (3, "Critical Care"), (4, "Paediatrics"), (5, "Other Speciality"), ]), ), ("count", models.IntegerField()), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ], ), migrations.CreateModel( name="HistoricalFacilityCapacity", fields=[ ( "id", models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name="ID"), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(blank=True, editable=False)), ("updated_at", models.DateTimeField(blank=True, editable=False)), ( "room_type", models.IntegerField(choices=[ (0, "Total"), (1, "General Bed"), (2, "Hostel"), (3, "Single Room with Attached Bathroom"), (10, "ICU"), (20, "Ventilator"), ]), ), ( "total_capacity", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "current_capacity", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ("history_id", models.AutoField(primary_key=True, serialize=False)), ("history_date", models.DateTimeField()), ("history_change_reason", models.CharField(max_length=100, null=True)), ( "history_type", models.CharField( choices=[("+", "Created"), ("~", "Changed"), ("-", "Deleted")], max_length=1, ), ), ( "facility", models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name="+", to="facility.Facility", ), ), ( "history_user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ], options={ "verbose_name": "historical facility capacity", "ordering": ("-history_date", "-history_id"), "get_latest_by": "history_date", }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name="FacilityVolunteer", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ( "volunteer", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="FacilityUser", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "created_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="created_users", to=settings.AUTH_USER_MODEL, ), ), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="FacilityStaff", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ( "staff", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="FacilityLocalGovtBody", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "district", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="accounts.District", ), ), ( "facility", models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="facility.Facility", ), ), ( "local_body", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to="accounts.LocalBody", ), ), ], ), migrations.CreateModel( name="FacilityCapacity", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "room_type", models.IntegerField(choices=[ (0, "Total"), (1, "General Bed"), (2, "Hostel"), (3, "Single Room with Attached Bathroom"), (10, "ICU"), (20, "Ventilator"), ]), ), ( "total_capacity", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "current_capacity", models.IntegerField( default=0, validators=[ django.core.validators.MinValueValidator(0) ], ), ), ( "facility", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility", ), ), ], ), migrations.AddField( model_name="facility", name="users", field=models.ManyToManyField( related_name="facilities", through="facility.FacilityUser", to=settings.AUTH_USER_MODEL, ), ), migrations.AddField( model_name="building", name="facility", field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Facility"), ), migrations.CreateModel( name="AmbulanceDriver", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("active", models.BooleanField(default=True)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ("name", models.CharField(max_length=255)), ( "phone_number", models.CharField( max_length=14, validators=[ django.core.validators.RegexValidator( code="invalid_mobile", message= "Please Enter 10/11 digit mobile number or landline as 0<std code><phone number>", regex= "^((\\+91|91|0)[\\- ]{0,1})?[456789]\\d{9}$", ) ], ), ), ("is_smart_phone", models.BooleanField()), ( "ambulance", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to="facility.Ambulance", ), ), ], options={ "abstract": False, }, ), migrations.AddIndex( model_name="hospitaldoctors", index=partial_index.PartialIndex( fields=["facility", "area"], name="facility_ho_facilit_efac7e_partial", unique=True, where=partial_index.PQ(active=True), ), ), migrations.AddConstraint( model_name="facilitylocalgovtbody", constraint=models.CheckConstraint( check=models.Q( ("local_body__isnull", False), ("district__isnull", False), _connector="OR", ), name="cons_facilitylocalgovtbody_only_one_null", ), ), migrations.AddIndex( model_name="facilitycapacity", index=partial_index.PartialIndex( fields=["facility", "room_type"], name="facility_fa_facilit_9f0bcc_partial", unique=True, where=partial_index.PQ(active=True), ), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Company', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', models.DateTimeField(auto_now_add=True)), ('modified', models.DateTimeField(auto_now=True)), ('company_id', models.UUIDField(default=uuid.uuid4, editable=False, unique=True, verbose_name='company id')), ('name', django.contrib.postgres.fields.citext.CICharField( max_length=100, unique=True)), ('address', django.contrib.postgres.fields.citext.CITextField()), ('is_verified', models.BooleanField(default=False)), ('is_active', models.BooleanField(default=True)), ('logo', models.ImageField(upload_to='company/logo/')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='Link', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', models.DateTimeField(auto_now_add=True)), ('modified', models.DateTimeField(auto_now=True)), ('name', models.PositiveIntegerField( choices=[(0, 'TWITTER'), (2, 'GOOGLE'), (1, 'FACEBOOK')])), ('url', models.URLField()), ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='links', to='company.Company')), ], ), migrations.CreateModel( name='UserCompany', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', models.DateTimeField(auto_now_add=True)), ('modified', models.DateTimeField(auto_now=True)), ('designation', models.PositiveIntegerField(choices=[(0, 'HR'), ( 1, 'CEO'), (2, 'CTO'), (3, 'SDE-1'), (4, 'SDE-2')])), ('join_on', models.DateTimeField()), ('inactive_on', models.DateTimeField(null=True)), ('status', models.PositiveIntegerField( choices=[(1, 'ACTIVE'), (0, 'INVITED'), (2, 'INACTIVE')])), ('is_admin', models.BooleanField(default=False)), ('company', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='users', to='company.Company')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='companies', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddIndex( model_name='usercompany', index=partial_index.PartialIndex( fields=['user', 'company'], name='company_use_user_id_ad6b21_partial', unique=True, where=partial_index.PQ(status__in=(0, 1))), ), migrations.AlterUniqueTogether( name='link', unique_together=set([('company', 'name')]), ), ]