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')]),
),
]
