# Generated by Django 2.1.2 on 2018-11-11 03:24

from django.db import migrations, models
import django.db.models.deletion
import rmp.fields


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='AccChem',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(help_text='A unique ID for each accident chemical record.', primary_key=True, serialize=False, verbose_name='Accident Chemical Record ID')),
                ('quantity_lbs', rmp.fields.CopyFromIntegerField(help_text='The amount of the substance released in the accident, in pounds, to two significant digits.', null=True, verbose_name='Amount Released (lbs)')),
                ('percent_weight', rmp.fields.CopyFromDecimalField(decimal_places=2, help_text='The percent weight of a chemical within a mixture released in an accident.', max_digits=5, null=True, verbose_name='Percent Weight (Within Mixture)')),
                ('num_acc_flam', rmp.fields.CopyFromIntegerField(help_text='The number of listed flammable component chemicals for this chemical record.', null=True, verbose_name='Number of Flammable Components')),
                ('cas', rmp.fields.CopyFromCharField(help_text='The identifying CAS number for a chemical.', max_length=9, verbose_name='CAS number')),
                ('chemical_type', rmp.fields.CopyFromCharField(choices=[('T', 'toxic'), ('F', 'flammable')], help_text='"The type of chemical.', max_length=1)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='AccFlam',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(help_text='A unique ID for each flammable chemical record.', primary_key=True, serialize=False, verbose_name='Flammable Chemical ID')),
                ('accchem', rmp.fields.CopyFromForeignKey(help_text='A unique ID for each accident chemical record.', on_delete=django.db.models.deletion.PROTECT, to='rmp.AccChem', verbose_name='Accident Chemical Record ID')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Accident',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('accident_date', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('accident_time', rmp.fields.CopyFromCharField(max_length=4)),
                ('naics_code', rmp.fields.CopyFromCharField(max_length=6)),
                ('release_duration', rmp.fields.CopyFromCharField(max_length=5)),
                ('re_gas', rmp.fields.CopyFromBooleanField()),
                ('re_spill', rmp.fields.CopyFromBooleanField()),
                ('re_fire', rmp.fields.CopyFromBooleanField()),
                ('re_explosion', rmp.fields.CopyFromBooleanField()),
                ('re_reactive_incident', rmp.fields.CopyFromBooleanField()),
                ('rs_storage_vessel', rmp.fields.CopyFromBooleanField()),
                ('rs_piping', rmp.fields.CopyFromBooleanField()),
                ('rs_process_vessel', rmp.fields.CopyFromBooleanField()),
                ('rs_transfer_hose', rmp.fields.CopyFromBooleanField()),
                ('rs_valve', rmp.fields.CopyFromBooleanField()),
                ('rs_pump', rmp.fields.CopyFromBooleanField()),
                ('rs_joint', rmp.fields.CopyFromBooleanField()),
                ('other_release_source', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('wind_speed', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=6, null=True)),
                ('wind_speed_unit', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('wind_direction', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('temperature', rmp.fields.CopyFromIntegerField(null=True)),
                ('stability_class', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('precipitation', rmp.fields.CopyFromBooleanField()),
                ('unknown_weather', rmp.fields.CopyFromBooleanField()),
                ('deaths_workers', rmp.fields.CopyFromIntegerField()),
                ('deaths_responders', rmp.fields.CopyFromIntegerField()),
                ('deaths_public', rmp.fields.CopyFromIntegerField()),
                ('injuries_workers', rmp.fields.CopyFromIntegerField()),
                ('injuries_responders', rmp.fields.CopyFromIntegerField()),
                ('injuries_public', rmp.fields.CopyFromIntegerField()),
                ('onsite_damage', rmp.fields.CopyFromIntegerField()),
                ('offsite_deaths', rmp.fields.CopyFromBooleanField()),
                ('hospitalization', rmp.fields.CopyFromIntegerField()),
                ('offsite_medical', rmp.fields.CopyFromIntegerField()),
                ('offsite_evacuated', rmp.fields.CopyFromIntegerField()),
                ('offsite_shelter', rmp.fields.CopyFromIntegerField()),
                ('offsite_damage', rmp.fields.CopyFromIntegerField()),
                ('ed_kills', rmp.fields.CopyFromBooleanField()),
                ('ed_defoliation', rmp.fields.CopyFromBooleanField()),
                ('ed_water_contamination', rmp.fields.CopyFromBooleanField()),
                ('ed_soil_contamination', rmp.fields.CopyFromBooleanField()),
                ('ed_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('initiating_event', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('cf_equipment_failure', rmp.fields.CopyFromBooleanField()),
                ('cf_human_error', rmp.fields.CopyFromBooleanField()),
                ('cf_improper_procedure', rmp.fields.CopyFromBooleanField()),
                ('cf_overpressure', rmp.fields.CopyFromBooleanField()),
                ('cf_upset_condition', rmp.fields.CopyFromBooleanField()),
                ('cf_bypass_condition', rmp.fields.CopyFromBooleanField()),
                ('cf_maintenance', rmp.fields.CopyFromBooleanField()),
                ('cf_process_design_failure', rmp.fields.CopyFromBooleanField()),
                ('cf_unsuitable_equipment', rmp.fields.CopyFromBooleanField()),
                ('cf_unusual_weather', rmp.fields.CopyFromBooleanField()),
                ('cf_management_error', rmp.fields.CopyFromBooleanField()),
                ('cf_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('offsite_responders_notify', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('ci_improved_equipment', rmp.fields.CopyFromBooleanField()),
                ('ci_revised_maintenance', rmp.fields.CopyFromBooleanField()),
                ('ci_revised_training', rmp.fields.CopyFromBooleanField()),
                ('ci_revised_op_procedures', rmp.fields.CopyFromBooleanField()),
                ('ci_new_process_controls', rmp.fields.CopyFromBooleanField()),
                ('ci_new_mitigation_systems', rmp.fields.CopyFromBooleanField()),
                ('ci_response_plan', rmp.fields.CopyFromBooleanField()),
                ('ci_changed_process', rmp.fields.CopyFromBooleanField()),
                ('ci_reduced_inventory', rmp.fields.CopyFromBooleanField()),
                ('ci_none', rmp.fields.CopyFromBooleanField()),
                ('ci_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('num_acc_chem', rmp.fields.CopyFromIntegerField()),
                ('flam_total', rmp.fields.CopyFromIntegerField()),
                ('toxic_total', rmp.fields.CopyFromIntegerField()),
                ('quantity_total', rmp.fields.CopyFromIntegerField()),
                ('num_deaths', rmp.fields.CopyFromIntegerField()),
                ('num_injuries', rmp.fields.CopyFromIntegerField()),
                ('num_evacuated', rmp.fields.CopyFromIntegerField()),
                ('property_damage', rmp.fields.CopyFromIntegerField()),
                ('env_damage', rmp.fields.CopyFromIntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ChemCd',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(help_text="RMP's unique identifier of a chemical substance.", primary_key=True, serialize=False)),
                ('chemical_name', rmp.fields.CopyFromCharField(help_text='Chemical substance name.', max_length=92)),
                ('cas2', rmp.fields.CopyFromCharField(blank=True, help_text='Chemical Abstracts Service (CAS) registry number (is 2 meaningful?)', max_length=10)),
                ('threshold', rmp.fields.CopyFromDecimalField(decimal_places=1, help_text='Threshold above which the chemical is regulated???', max_digits=8, null=True)),
                ('chemical_type', rmp.fields.CopyFromCharField(blank=True, choices=[('T', 'toxic'), ('F', 'flammable')], help_text='"The type of chemical (T=toxic, F=Flammable).', max_length=1)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField(help_text='Indicates whether this record contained Confidential Business Information (CBI) which has been erased by EPA from the public version of the data.')),
                ('chemical_owner', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='City',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('city', models.CharField(blank=True, max_length=30)),
                ('state', models.CharField(blank=True, max_length=2)),
                ('num_fac', models.IntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DeregCd',
            fields=[
                ('dereg', models.IntegerField(help_text='Unique identifier of the de-regulation reason.', primary_key=True, serialize=False)),
                ('dereg_tr', models.CharField(help_text='Full description of the de-regulation reason.', max_length=62)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DochanCd',
            fields=[
                ('dochan', models.CharField(max_length=1, primary_key=True, serialize=False)),
                ('dochan_tr', models.CharField(max_length=1)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='DoctypCd',
            fields=[
                ('doctyp', models.CharField(help_text='Unique identifier of the document type.', max_length=1, primary_key=True, serialize=False)),
                ('doctyp_tr', models.CharField(help_text='Full description of the document type.', max_length=30)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EmergencyResponse',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('community_erp_yn', rmp.fields.CopyFromBooleanField()),
                ('facility_erp_yn', rmp.fields.CopyFromBooleanField()),
                ('erp_specific_yn', rmp.fields.CopyFromBooleanField()),
                ('erp_inform_yn', rmp.fields.CopyFromBooleanField()),
                ('erp_inform_hth_yn', rmp.fields.CopyFromBooleanField()),
                ('erp_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('erp_training_date', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('coord_agency', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('coord_phone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('subto_osha191038', rmp.fields.CopyFromBooleanField()),
                ('subto_osha191020', rmp.fields.CopyFromBooleanField()),
                ('subto_cwa112', rmp.fields.CopyFromBooleanField()),
                ('subto_rcra264', rmp.fields.CopyFromBooleanField()),
                ('subto_opa90', rmp.fields.CopyFromBooleanField()),
                ('subto_state_epcra', rmp.fields.CopyFromBooleanField()),
                ('subto_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='EventsCd',
            fields=[
                ('events', models.CharField(help_text='Unique identifier of the event type.', max_length=1, primary_key=True, serialize=False)),
                ('events_tr', models.CharField(help_text='Full description of the event type.', max_length=40)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ExecutiveSummary',
            fields=[
                ('rmp_id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('summary_text', rmp.fields.CopyFromTextField(blank=True)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ExecutiveSummaryLength',
            fields=[
                ('rmp_id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('byte_count', rmp.fields.CopyFromIntegerField()),
                ('suspect_count', rmp.fields.CopyFromIntegerField()),
                ('line_count', rmp.fields.CopyFromIntegerField()),
                ('edited_yn', rmp.fields.CopyFromCharField(max_length=1)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Facility',
            fields=[
                ('id', rmp.fields.CopyFromBigIntegerField(primary_key=True, serialize=False)),
                ('facility_name', rmp.fields.CopyFromCharField(max_length=50)),
                ('rmp_id', rmp.fields.CopyFromIntegerField()),
                ('street_1', rmp.fields.CopyFromCharField(max_length=35)),
                ('street_2', rmp.fields.CopyFromCharField(max_length=35)),
                ('city', rmp.fields.CopyFromCharField(max_length=19)),
                ('state', rmp.fields.CopyFromCharField(max_length=2)),
                ('zip_code', rmp.fields.CopyFromCharField(max_length=5)),
                ('zip_ext', rmp.fields.CopyFromCharField(max_length=4)),
                ('county_fips', rmp.fields.CopyFromIntegerField()),
                ('num_registrations', rmp.fields.CopyFromIntegerField()),
                ('latitude', rmp.fields.CopyFromDecimalField(decimal_places=3, max_digits=6)),
                ('longitude', rmp.fields.CopyFromDecimalField(decimal_places=3, max_digits=6)),
                ('num_registration', rmp.fields.CopyFromIntegerField()),
                ('sub_type', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('sub_date', rmp.fields.CopyFromDateTimeField()),
                ('exec_type', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('execsum_rmp_id', rmp.fields.CopyFromIntegerField()),
                ('exec_sub_type', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('exec_sub_date', rmp.fields.CopyFromDateTimeField()),
                ('deregistration_date', rmp.fields.CopyFromCharField(max_length=10)),
                ('dereg_effect_date', rmp.fields.CopyFromCharField(max_length=10)),
                ('parent', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('parent_2', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('operator_name', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('operator_city', rmp.fields.CopyFromCharField(blank=True, max_length=20)),
                ('operator_state', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('operator_zip', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('province', rmp.fields.CopyFromCharField(blank=True, max_length=20)),
                ('county', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('country', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('sub_reason', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('dereg_reason', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('dereg_other', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('toxic_tot', rmp.fields.CopyFromIntegerField()),
                ('flam_tot', rmp.fields.CopyFromBigIntegerField()),
                ('quantity_tot', rmp.fields.CopyFromBigIntegerField()),
                ('num_proc_23', rmp.fields.CopyFromBigIntegerField()),
                ('toxic_tot_23', rmp.fields.CopyFromIntegerField()),
                ('flam_tot_23', rmp.fields.CopyFromBigIntegerField()),
                ('quantity_tot_23', rmp.fields.CopyFromBigIntegerField()),
                ('all_naics', rmp.fields.CopyFromCharField(blank=True, max_length=20)),
                ('sortid_1', rmp.fields.CopyFromCharField(max_length=5)),
                ('sortid_2', rmp.fields.CopyFromCharField(max_length=5)),
                ('sortid_3', rmp.fields.CopyFromCharField(max_length=5)),
                ('deregistration_yn', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('num_fte', rmp.fields.CopyFromIntegerField(null=True)),
                ('num_accident', rmp.fields.CopyFromIntegerField()),
                ('acc_flam_tot', rmp.fields.CopyFromIntegerField()),
                ('acc_toxic_tot', rmp.fields.CopyFromIntegerField()),
                ('acc_quantity_tot', rmp.fields.CopyFromIntegerField()),
                ('num_deaths', rmp.fields.CopyFromIntegerField()),
                ('num_injuries', rmp.fields.CopyFromIntegerField()),
                ('num_evacuated', rmp.fields.CopyFromIntegerField()),
                ('property_damage', rmp.fields.CopyFromIntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='FlammablesAltRelease',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('analytical_basis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromCharField(max_length=200)),
                ('quantity_released', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5, null=True)),
                ('endpoint_used', rmp.fields.CopyFromCharField(blank=True, max_length=30)),
                ('lfl_value', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5, null=True)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5, null=True)),
                ('population', rmp.fields.CopyFromCharField(blank=True, max_length=9, verbose_name='Residential population')),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_public_recreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natl_state_parks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlife_sactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fed_wilderness', rmp.fields.CopyFromBooleanField()),
                ('er_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_firewalls', rmp.fields.CopyFromBooleanField()),
                ('pm_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('am_sprinklers', rmp.fields.CopyFromBooleanField()),
                ('am_deluge_systems', rmp.fields.CopyFromBooleanField()),
                ('am_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('am_excess_flowvalve', rmp.fields.CopyFromBooleanField()),
                ('am_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='FlammablesWorstCase',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('analytical_basis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('quantity_lbs', rmp.fields.CopyFromCharField(blank=True, max_length=20)),
                ('endpoint_distance', rmp.fields.CopyFromCharField(blank=True, max_length=20)),
                ('population', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_public_rec', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlife_sanct', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='LldescCd',
            fields=[
                ('lldesc', models.CharField(max_length=2, primary_key=True, serialize=False)),
                ('lldesc_tr', models.CharField(max_length=36)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='LlmethCd',
            fields=[
                ('primary_key', models.IntegerField(primary_key=True, serialize=False)),
                ('llmeth', models.CharField(max_length=2)),
                ('llmeth_tr', models.CharField(max_length=83)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='PhysCd',
            fields=[
                ('phys', models.CharField(help_text='Unique identifier of the physical state.', max_length=1, primary_key=True, serialize=False)),
                ('phys_tr', models.CharField(help_text='Full description of the physical state.', max_length=30)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Prevent2Chem',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Prevent3Chem',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='PreventionProgram2',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('safety_info_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('fr_nfpa58', rmp.fields.CopyFromBooleanField()),
                ('fr_osha', rmp.fields.CopyFromBooleanField()),
                ('fr_astm', rmp.fields.CopyFromBooleanField()),
                ('fr_ansi', rmp.fields.CopyFromBooleanField()),
                ('fr_asme', rmp.fields.CopyFromBooleanField()),
                ('fr_none', rmp.fields.CopyFromBooleanField()),
                ('fr_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('fr_comments', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('haz_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('change_comp_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('mh_toxicrelease', rmp.fields.CopyFromBooleanField()),
                ('mh_fire', rmp.fields.CopyFromBooleanField()),
                ('mh_explosion', rmp.fields.CopyFromBooleanField()),
                ('mh_runawayreact', rmp.fields.CopyFromBooleanField()),
                ('mh_polymerization', rmp.fields.CopyFromBooleanField()),
                ('mh_overpressure', rmp.fields.CopyFromBooleanField()),
                ('mh_corrosion', rmp.fields.CopyFromBooleanField()),
                ('mh_overfilling', rmp.fields.CopyFromBooleanField()),
                ('mh_contamination', rmp.fields.CopyFromBooleanField()),
                ('mh_equipfailure', rmp.fields.CopyFromBooleanField()),
                ('mh_cooling_loss', rmp.fields.CopyFromBooleanField()),
                ('mh_earthquake', rmp.fields.CopyFromBooleanField()),
                ('mh_floods', rmp.fields.CopyFromBooleanField()),
                ('mh_tornado', rmp.fields.CopyFromBooleanField()),
                ('mh_hurricanes', rmp.fields.CopyFromBooleanField()),
                ('mh_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pc_vents', rmp.fields.CopyFromBooleanField()),
                ('pc_reliefvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_checkvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('pc_flares', rmp.fields.CopyFromBooleanField()),
                ('pc_manualshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_autoshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_interlocks', rmp.fields.CopyFromBooleanField()),
                ('pc_alarms', rmp.fields.CopyFromBooleanField()),
                ('pc_keyedbypass', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencyair', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencypower', rmp.fields.CopyFromBooleanField()),
                ('pc_backuppump', rmp.fields.CopyFromBooleanField()),
                ('pc_groundingequip', rmp.fields.CopyFromBooleanField()),
                ('pc_inhibitoradd', rmp.fields.CopyFromBooleanField()),
                ('pc_rupturedisks', rmp.fields.CopyFromBooleanField()),
                ('pc_excessflowdev', rmp.fields.CopyFromBooleanField()),
                ('pc_quenchsystem', rmp.fields.CopyFromBooleanField()),
                ('pc_purgesystem', rmp.fields.CopyFromBooleanField()),
                ('pc_none', rmp.fields.CopyFromBooleanField()),
                ('pc_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ms_sprinklersys', rmp.fields.CopyFromBooleanField()),
                ('ms_dikes', rmp.fields.CopyFromBooleanField()),
                ('ms_firewalls', rmp.fields.CopyFromBooleanField()),
                ('ms_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('ms_delugesystem', rmp.fields.CopyFromBooleanField()),
                ('ms_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('ms_enclosure', rmp.fields.CopyFromBooleanField()),
                ('ms_neutralization', rmp.fields.CopyFromBooleanField()),
                ('ms_none', rmp.fields.CopyFromBooleanField()),
                ('ms_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('md_processarea', rmp.fields.CopyFromBooleanField()),
                ('md_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('md_none', rmp.fields.CopyFromBooleanField()),
                ('md_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ch_reduceinv', rmp.fields.CopyFromBooleanField()),
                ('ch_increaseinv', rmp.fields.CopyFromBooleanField()),
                ('ch_changeparam', rmp.fields.CopyFromBooleanField()),
                ('ch_proccontrol', rmp.fields.CopyFromBooleanField()),
                ('ch_procdetect', rmp.fields.CopyFromBooleanField()),
                ('ch_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('ch_mitigationsys', rmp.fields.CopyFromBooleanField()),
                ('ch_nonerequired', rmp.fields.CopyFromBooleanField()),
                ('ch_none', rmp.fields.CopyFromBooleanField()),
                ('ch_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('proc_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('train_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('tr_classroom', rmp.fields.CopyFromBooleanField()),
                ('tr_onthejob', rmp.fields.CopyFromBooleanField()),
                ('tr_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ct_writtentest', rmp.fields.CopyFromBooleanField()),
                ('ct_oraltest', rmp.fields.CopyFromBooleanField()),
                ('ct_demonstration', rmp.fields.CopyFromBooleanField()),
                ('ct_observation', rmp.fields.CopyFromBooleanField()),
                ('ct_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('maint_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('maint_inspect_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('equip_tested', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('comp_audit_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('audit_comp_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('inc_invest_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('inc_change_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('most_recent_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('num_prevent_2_chem', rmp.fields.CopyFromIntegerField()),
                ('num_prev2text', rmp.fields.CopyFromIntegerField()),
                ('num_prev2_text', rmp.fields.CopyFromIntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='PreventionProgram3',
            fields=[
                ('prevent_id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('safety_info_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('last_pha_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('pha_whatif', rmp.fields.CopyFromBooleanField()),
                ('pha_checklist', rmp.fields.CopyFromBooleanField()),
                ('pha_whatifcheck', rmp.fields.CopyFromBooleanField()),
                ('pha_hazop', rmp.fields.CopyFromBooleanField()),
                ('pha_fmea', rmp.fields.CopyFromBooleanField()),
                ('pha_fta', rmp.fields.CopyFromBooleanField()),
                ('pha_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('change_comp_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('mh_toxicrelease', rmp.fields.CopyFromBooleanField()),
                ('mh_fire', rmp.fields.CopyFromBooleanField()),
                ('mh_explosion', rmp.fields.CopyFromBooleanField()),
                ('mh_runawayreact', rmp.fields.CopyFromBooleanField()),
                ('mh_polymerization', rmp.fields.CopyFromBooleanField()),
                ('mh_overpressure', rmp.fields.CopyFromBooleanField()),
                ('mh_corrosion', rmp.fields.CopyFromBooleanField()),
                ('mh_overfilling', rmp.fields.CopyFromBooleanField()),
                ('mh_contamination', rmp.fields.CopyFromBooleanField()),
                ('mh_equipfailure', rmp.fields.CopyFromBooleanField()),
                ('mh_cooling_loss', rmp.fields.CopyFromBooleanField()),
                ('mh_earthquake', rmp.fields.CopyFromBooleanField()),
                ('mh_floods', rmp.fields.CopyFromBooleanField()),
                ('mh_tornado', rmp.fields.CopyFromBooleanField()),
                ('mh_hurricanes', rmp.fields.CopyFromBooleanField()),
                ('mh_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pc_vents', rmp.fields.CopyFromBooleanField()),
                ('pc_reliefvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_checkvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('pc_flares', rmp.fields.CopyFromBooleanField()),
                ('pc_manualshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_autoshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_interlocks', rmp.fields.CopyFromBooleanField()),
                ('pc_alarms', rmp.fields.CopyFromBooleanField()),
                ('pc_keyedbypass', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencyair', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencypower', rmp.fields.CopyFromBooleanField()),
                ('pc_backuppump', rmp.fields.CopyFromBooleanField()),
                ('pc_groundingequip', rmp.fields.CopyFromBooleanField()),
                ('pc_inhibitoradd', rmp.fields.CopyFromBooleanField()),
                ('pc_rupturedisks', rmp.fields.CopyFromBooleanField()),
                ('pc_excessflowdev', rmp.fields.CopyFromBooleanField()),
                ('pc_quenchsystem', rmp.fields.CopyFromBooleanField()),
                ('pc_purgesystem', rmp.fields.CopyFromBooleanField()),
                ('pc_none', rmp.fields.CopyFromBooleanField()),
                ('pc_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ms_sprinklersys', rmp.fields.CopyFromBooleanField()),
                ('ms_dikes', rmp.fields.CopyFromBooleanField()),
                ('ms_firewalls', rmp.fields.CopyFromBooleanField()),
                ('ms_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('ms_delugesystem', rmp.fields.CopyFromBooleanField()),
                ('ms_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('ms_enclosure', rmp.fields.CopyFromBooleanField()),
                ('ms_neutralization', rmp.fields.CopyFromBooleanField()),
                ('ms_none', rmp.fields.CopyFromBooleanField()),
                ('ms_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('md_processarea', rmp.fields.CopyFromBooleanField()),
                ('md_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('md_none', rmp.fields.CopyFromBooleanField()),
                ('md_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ch_reduceinv', rmp.fields.CopyFromBooleanField()),
                ('ch_increaseinv', rmp.fields.CopyFromBooleanField()),
                ('ch_changeparam', rmp.fields.CopyFromBooleanField()),
                ('ch_proccontrol', rmp.fields.CopyFromBooleanField()),
                ('ch_procdetect', rmp.fields.CopyFromBooleanField()),
                ('ch_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('ch_mitigationsys', rmp.fields.CopyFromBooleanField()),
                ('ch_nonerequired', rmp.fields.CopyFromBooleanField()),
                ('ch_none', rmp.fields.CopyFromBooleanField()),
                ('ch_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('proc_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('train_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('tr_classroom', rmp.fields.CopyFromBooleanField()),
                ('tr_onthejob', rmp.fields.CopyFromBooleanField()),
                ('tr_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ct_writtentest', rmp.fields.CopyFromBooleanField()),
                ('ct_oraltest', rmp.fields.CopyFromBooleanField()),
                ('ct_demonstration', rmp.fields.CopyFromBooleanField()),
                ('ct_observation', rmp.fields.CopyFromBooleanField()),
                ('ct_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('maint_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('maint_inspect_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('equip_tested', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('change_manage_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('change_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('prestart_rev_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('comp_audit_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('audit_comp_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('inc_invest_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('inc_change_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('part_review_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('hotwork_rev_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('con_safety_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('con_eval_date', rmp.fields.CopyFromCharField(blank=True, max_length=8)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('num_prevent_3_chem', rmp.fields.CopyFromIntegerField()),
                ('num_prev3text', rmp.fields.CopyFromIntegerField()),
                ('num_prev3_text', rmp.fields.CopyFromIntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProcChem',
            fields=[
                ('procchem_id', rmp.fields.CopyFromBigIntegerField(primary_key=True, serialize=False)),
                ('quantity_lbs', rmp.fields.CopyFromBigIntegerField()),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('num_alt_flam', rmp.fields.CopyFromBigIntegerField()),
                ('num_alt_tox', rmp.fields.CopyFromBigIntegerField()),
                ('num_prevent_2_chem', rmp.fields.CopyFromBigIntegerField()),
                ('num_prevent_3_chem', rmp.fields.CopyFromBigIntegerField()),
                ('num_proc_flam', rmp.fields.CopyFromBigIntegerField()),
                ('num_worst_flam', rmp.fields.CopyFromBigIntegerField()),
                ('num_worst_tox', rmp.fields.CopyFromBigIntegerField()),
                ('cas', rmp.fields.CopyFromBigIntegerField()),
                ('chemical_type', rmp.fields.CopyFromCharField(max_length=1)),
                ('chemical', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ChemCd')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Process',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('process_desc', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('rmp_id', rmp.fields.CopyFromIntegerField()),
                ('program_level', rmp.fields.CopyFromIntegerField()),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('num_proc_chem', rmp.fields.CopyFromIntegerField()),
                ('num_proc_naics', rmp.fields.CopyFromIntegerField()),
                ('num_chem_real', rmp.fields.CopyFromIntegerField()),
                ('num_chem_fake', rmp.fields.CopyFromIntegerField()),
                ('num_worst_tox', rmp.fields.CopyFromIntegerField()),
                ('num_worst_flam', rmp.fields.CopyFromIntegerField()),
                ('num_alt_tox', rmp.fields.CopyFromIntegerField()),
                ('num_alt_flam', rmp.fields.CopyFromIntegerField()),
                ('num_prev_2', rmp.fields.CopyFromIntegerField()),
                ('num_prev_3', rmp.fields.CopyFromIntegerField()),
                ('toxic_tot', rmp.fields.CopyFromBigIntegerField()),
                ('flam_tot', rmp.fields.CopyFromBigIntegerField()),
                ('quantity_tot', rmp.fields.CopyFromBigIntegerField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProcFlam',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('chemical', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ChemCd')),
                ('procchem', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ProcNaics',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('naics', rmp.fields.CopyFromIntegerField()),
                ('num_prevent_2', rmp.fields.CopyFromIntegerField()),
                ('num_prevent_3', rmp.fields.CopyFromIntegerField()),
                ('process', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.Process')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Registration',
            fields=[
                ('rmp_id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('facility_name', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('street_1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('street_2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('city', rmp.fields.CopyFromCharField(blank=True, max_length=19)),
                ('state', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('zip', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('zip_ext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('county_fips', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('lepc', rmp.fields.CopyFromCharField(blank=True, max_length=30)),
                ('latitude_dec', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('longitude_dec', rmp.fields.CopyFromCharField(blank=True, max_length=11)),
                ('valid_latlong', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('latlong_meth', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('latlong_desc', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('facility_url', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('facility_phone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('facility_duns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('facility_email', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('parent', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('parent_2', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('parent_duns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('parent2_duns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('operator_name', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('operator_phone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('op_street_1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('op_street_2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('operator_city', rmp.fields.CopyFromCharField(blank=True, max_length=19)),
                ('operator_state', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('operator_zip', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('operator_zip_ext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('rmp_contact', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('rmp_contact_title', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('em_contact_name', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('em_contact_title', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('em_contact_phone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('phone_24hour', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('phone_24hour_ext', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('num_fte', rmp.fields.CopyFromIntegerField(null=True)),
                ('other_facility_id', rmp.fields.CopyFromCharField(blank=True, max_length=15)),
                ('osha_psm_yn', rmp.fields.CopyFromBooleanField()),
                ('epcra_302_yn', rmp.fields.CopyFromBooleanField()),
                ('caa_title_v_yn', rmp.fields.CopyFromBooleanField()),
                ('caa_permit_id', rmp.fields.CopyFromCharField(blank=True, max_length=15)),
                ('safety_inspect_dt', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('safety_inspect_by', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('osha_ranking', rmp.fields.CopyFromBooleanField()),
                ('predictive_file_yn', rmp.fields.CopyFromBooleanField()),
                ('submission_type', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('rmp_desc', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('no_accidents_yn', rmp.fields.CopyFromBooleanField()),
                ('foreign_province', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('foreign_zip', rmp.fields.CopyFromCharField(blank=True, max_length=14)),
                ('foreign_country', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('num_fte_cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('complete_check_dt', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('error_report_dt', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('receipt_date', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('graphics_ind', rmp.fields.CopyFromBooleanField()),
                ('attachment_ind', rmp.fields.CopyFromBooleanField()),
                ('cert_rec_flag', rmp.fields.CopyFromBooleanField()),
                ('submit_method', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('cbi_substant_flag', rmp.fields.CopyFromBooleanField()),
                ('elect_waiver_flag', rmp.fields.CopyFromBooleanField()),
                ('postmark_date', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('rmp_complete_flag', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('deregistration_dt', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('dereg_effect_dt', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('anniversary_date', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('unsanitized_vers', rmp.fields.CopyFromBooleanField()),
                ('version_number', rmp.fields.CopyFromCharField(blank=True, max_length=15)),
                ('frs_lat_dec', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5, null=True)),
                ('frs_long_dec', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5, null=True)),
                ('frs_ll_desc', rmp.fields.CopyFromCharField(blank=True, max_length=40)),
                ('frs_ll_method', rmp.fields.CopyFromCharField(blank=True, max_length=60)),
                ('hor_measure', rmp.fields.CopyFromCharField(blank=True, max_length=6)),
                ('hor_ref', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('source_scale', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('em_email', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('prep_name', rmp.fields.CopyFromCharField(blank=True, max_length=70)),
                ('prep_street_1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('prep_street_2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('prep_city', rmp.fields.CopyFromCharField(blank=True, max_length=19)),
                ('prep_state', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('prep_zip', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('prep_zip_ext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('prep_phone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('prep_foreign_state', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('prep_country', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('prep_foreign_zip', rmp.fields.CopyFromCharField(blank=True, max_length=14)),
                ('sub_reason', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('rmp_email', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('dereg_reason', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('dereg_other', rmp.fields.CopyFromCharField(blank=True, max_length=80)),
                ('num_accident', rmp.fields.CopyFromIntegerField()),
                ('num_facility', rmp.fields.CopyFromIntegerField()),
                ('num_process', rmp.fields.CopyFromIntegerField()),
                ('num_response', rmp.fields.CopyFromIntegerField()),
                ('num_chem_real', rmp.fields.CopyFromIntegerField()),
                ('num_worst_tox', rmp.fields.CopyFromIntegerField()),
                ('num_alt_tox', rmp.fields.CopyFromIntegerField()),
                ('num_worst_flam', rmp.fields.CopyFromIntegerField()),
                ('num_alt_flam', rmp.fields.CopyFromIntegerField()),
                ('num_prev_2', rmp.fields.CopyFromIntegerField()),
                ('num_prev_3', rmp.fields.CopyFromIntegerField()),
                ('toxic_tot', rmp.fields.CopyFromBigIntegerField()),
                ('flam_tot', rmp.fields.CopyFromBigIntegerField()),
                ('acc_flam_tot', rmp.fields.CopyFromIntegerField()),
                ('acc_toxic_tot', rmp.fields.CopyFromIntegerField()),
                ('acc_quantity_tot', rmp.fields.CopyFromIntegerField()),
                ('num_deaths', rmp.fields.CopyFromIntegerField()),
                ('num_injuries', rmp.fields.CopyFromIntegerField()),
                ('num_evacuated', rmp.fields.CopyFromIntegerField()),
                ('property_damage', rmp.fields.CopyFromIntegerField()),
                ('county', rmp.fields.CopyFromCharField(blank=True, max_length=60)),
                ('foreign_country_tr', rmp.fields.CopyFromCharField(blank=True, max_length=60)),
                ('num_proc_23', rmp.fields.CopyFromBigIntegerField()),
                ('toxic_tot_23', rmp.fields.CopyFromBigIntegerField()),
                ('flam_tot_23', rmp.fields.CopyFromBigIntegerField()),
                ('quantity_tot_23', rmp.fields.CopyFromBigIntegerField()),
                ('num_execsum_mod', rmp.fields.CopyFromIntegerField()),
                ('execsum_type', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('num_execsum', rmp.fields.CopyFromIntegerField()),
                ('num_exec_sum', rmp.fields.CopyFromIntegerField()),
                ('facility', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.Facility')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='RejectCd',
            fields=[
                ('reject', models.CharField(help_text='Unique identifier of the rejection reason.', max_length=1, primary_key=True, serialize=False)),
                ('reject_tr', models.CharField(help_text='Full description of the rejection reason.', max_length=59)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ScenCd',
            fields=[
                ('scen', models.CharField(help_text='Unique identifier of the scenario.', max_length=1, primary_key=True, serialize=False)),
                ('scen_tr', models.CharField(help_text='Full description of the scenario.', max_length=27)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='SubmitCd',
            fields=[
                ('submit', models.CharField(help_text='Unique identifier of the submission reason.', max_length=3, primary_key=True, serialize=False)),
                ('submit_tr', models.CharField(help_text='Full description of the submission reason.', max_length=101)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Tblexecutivesummaries',
            fields=[
                ('esseqnum', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('summarytext', rmp.fields.CopyFromTextField()),
            ],
            options={
                'db_table': 'tblExecutiveSummaries',
            },
        ),
        migrations.CreateModel(
            name='Tblfacility',
            fields=[
                ('epafacilityid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('facilityname', rmp.fields.CopyFromCharField(max_length=200)),
                ('marplotid', rmp.fields.CopyFromBooleanField(null=True)),
                ('cameoid', rmp.fields.CopyFromBooleanField(null=True)),
                ('rmpid', rmp.fields.CopyFromIntegerField()),
                ('facilitystr1', rmp.fields.CopyFromCharField(max_length=35)),
                ('facilitystr2', rmp.fields.CopyFromCharField(max_length=35)),
                ('facilitycity', rmp.fields.CopyFromCharField(max_length=19)),
                ('facilitystate', rmp.fields.CopyFromCharField(max_length=2)),
                ('facilityzipcode', rmp.fields.CopyFromCharField(max_length=5)),
                ('facility4digitzipext', rmp.fields.CopyFromCharField(max_length=4)),
                ('facilitycountyfips', rmp.fields.CopyFromIntegerField()),
                ('countoffacilityid', rmp.fields.CopyFromIntegerField()),
                ('facilitylatdecdegs', rmp.fields.CopyFromIntegerField()),
                ('facilitylongdecdegs', rmp.fields.CopyFromIntegerField()),
            ],
            options={
                'db_table': 'tblFacility',
            },
        ),
        migrations.CreateModel(
            name='Tbls1Facilities',
            fields=[
                ('facilityid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('facilityname', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('facilitystr1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('facilitystr2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('facilitycity', rmp.fields.CopyFromCharField(blank=True, max_length=19)),
                ('facilitystate', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('facilityzipcode', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('facility4digitzipext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('facilitycountyfips', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('lepc', rmp.fields.CopyFromCharField(blank=True, max_length=30)),
                ('facilitylatdecdegs', rmp.fields.CopyFromDecimalField(decimal_places=6, max_digits=8)),
                ('facilitylongdecdegs', rmp.fields.CopyFromDecimalField(decimal_places=6, max_digits=8)),
                ('validlatlongflag', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('latlongmethod', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('latlongdescription', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('facilityurl', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('facilityphonenumber', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('facilityemailaddress', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('facilityduns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('parentcompanyname', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('company2name', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('companyduns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('company2duns', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('operatorname', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('operatorphone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('operatorstr1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('operatorstr2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('operatorcity', rmp.fields.CopyFromCharField(blank=True, max_length=19)),
                ('operatorstatefips', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('operatorzipcode', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('operatorzipcodeext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('rmpcontact', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('rmptitle', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('emergencycontactname', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('emergencycontacttitle', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('emergencycontactphone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('phone24', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('emergencycontactext_pin', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('fte', rmp.fields.CopyFromIntegerField()),
                ('otherepafacilityid', rmp.fields.CopyFromIntegerField()),
                ('osha_psm', rmp.fields.CopyFromBooleanField()),
                ('epcra_302', rmp.fields.CopyFromBooleanField()),
                ('caa_titlev', rmp.fields.CopyFromBooleanField()),
                ('clearairoppermitid', rmp.fields.CopyFromIntegerField()),
                ('safetyinspectiondate', models.DateTimeField(blank=True)),
                ('safetyinspectionby', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('osharanking', rmp.fields.CopyFromBooleanField()),
                ('predictivefilingflag', rmp.fields.CopyFromBooleanField()),
                ('submissiontype', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('rmpdescription', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('noaccidents', rmp.fields.CopyFromBooleanField()),
                ('foreignstateprov', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('foreignzipcode', rmp.fields.CopyFromCharField(blank=True, max_length=14)),
                ('foreigncountry', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('completioncheckdate', models.DateTimeField(blank=True)),
                ('errorreportdate', models.DateTimeField(blank=True)),
                ('receiptdate', rmp.fields.CopyFromCharField(blank=True, max_length=25)),
                ('graphicsindicator', rmp.fields.CopyFromBooleanField()),
                ('attachmentsindicator', rmp.fields.CopyFromBooleanField()),
                ('certificationreceivedflag', rmp.fields.CopyFromBooleanField()),
                ('submissionmethod', rmp.fields.CopyFromCharField(blank=True, max_length=50)),
                ('cbisubstantiationflag', rmp.fields.CopyFromBooleanField()),
                ('electronicwaiverreceivedflag', rmp.fields.CopyFromBooleanField()),
                ('postmarkdate', models.DateTimeField(blank=True)),
                ('rmpcompleteflag', rmp.fields.CopyFromBooleanField()),
                ('deregistrationdate', models.DateTimeField(blank=True)),
                ('deregistrationeffectivedate', models.DateTimeField(blank=True)),
                ('anniversarydate', models.DateTimeField(blank=True)),
                ('cbiflag', rmp.fields.CopyFromBooleanField()),
                ('cbiunsanitizedversionflag', rmp.fields.CopyFromBooleanField()),
                ('versionnumber', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('frs_lat', rmp.fields.CopyFromDecimalField(decimal_places=5, max_digits=8)),
                ('frs_long', rmp.fields.CopyFromDecimalField(decimal_places=5, max_digits=8)),
                ('frs_description', rmp.fields.CopyFromCharField(blank=True, max_length=40)),
                ('frs_method', rmp.fields.CopyFromCharField(blank=True, max_length=60)),
                ('horizontalaccmeasure', rmp.fields.CopyFromCharField(blank=True, max_length=6)),
                ('horizontalrefdatumcode', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('sourcemapscalenumber', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('emergencycontactemail', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('rmppreparername', rmp.fields.CopyFromCharField(blank=True, max_length=70)),
                ('rmppreparerstreet1', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('rmppreparerstreet2', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('rmppreparercity', rmp.fields.CopyFromCharField(blank=True, max_length=30)),
                ('rmppreparerstate', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('rmppreparerzip', rmp.fields.CopyFromCharField(blank=True, max_length=5)),
                ('rmppreparerzip4ext', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('rmppreparertelephone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('rmppreparerforeignstateorprovince', rmp.fields.CopyFromCharField(blank=True, max_length=35)),
                ('rmppreparerforeigncountry', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('rmppreparerforeignpostalcode', rmp.fields.CopyFromCharField(blank=True, max_length=14)),
                ('rmpsubmissionreasoncode', rmp.fields.CopyFromCharField(blank=True, max_length=3)),
                ('rmpemail', rmp.fields.CopyFromCharField(blank=True, max_length=100)),
                ('deregistrationreasoncode', rmp.fields.CopyFromCharField(blank=True, max_length=2)),
                ('deregistrationreasonothertext', rmp.fields.CopyFromCharField(blank=True, max_length=80)),
                ('epafacilityid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tblfacility')),
            ],
            options={
                'db_table': 'tblS1Facilities',
            },
        ),
        migrations.CreateModel(
            name='Tbls1Flammablemixturechemicals',
            fields=[
                ('flammixchemid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('chemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd')),
            ],
            options={
                'db_table': 'tblS1FlammableMixtureChemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls1Processchemicals',
            fields=[
                ('processchemicalid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('quantity', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=6)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('chemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd')),
            ],
            options={
                'db_table': 'tblS1ProcessChemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls1Processes',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('processid', rmp.fields.CopyFromIntegerField()),
                ('altid', rmp.fields.CopyFromCharField(max_length=25)),
                ('programlevel', rmp.fields.CopyFromCharField(max_length=1)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('facilityid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Facilities')),
            ],
            options={
                'db_table': 'tblS1Processes',
            },
        ),
        migrations.CreateModel(
            name='Tbls1ProcessNaics',
            fields=[
                ('process_naics_id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('naicscode', rmp.fields.CopyFromIntegerField()),
                ('processid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processes')),
            ],
            options={
                'db_table': 'tblS1Process_NAICS',
            },
        ),
        migrations.CreateModel(
            name='Tbls2Toxicsworstcase',
            fields=[
                ('toxicid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('percentweight', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=1, max_digits=4)),
                ('physicalstate', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('analyticalbasis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromBooleanField(blank=True)),
                ('quantityreleased', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=2, max_digits=6)),
                ('releaseduration', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=2, max_digits=6)),
                ('releaserate', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=1, max_digits=4)),
                ('windspeed', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=1, max_digits=4)),
                ('stabilityclass', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('topography', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5)),
                ('residentialpopulation', rmp.fields.CopyFromBooleanField(blank=True)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_publicrecreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlifesactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_berms', rmp.fields.CopyFromBooleanField()),
                ('pm_drains', rmp.fields.CopyFromBooleanField()),
                ('pm_sumps', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromBooleanField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS2ToxicsWorstCase',
            },
        ),
        migrations.CreateModel(
            name='Tbls3Toxicsaltreleases',
            fields=[
                ('toxicid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('percentweight', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=1, max_digits=4)),
                ('physicalstate', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('analyticalbasis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromCharField(max_length=200)),
                ('quantityreleased', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5)),
                ('releaseduration', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5)),
                ('releaserate', rmp.fields.CopyFromBooleanField(blank=True)),
                ('windspeed', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=6)),
                ('stabilityclass', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('topography', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5)),
                ('residentialpopulation', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_publicrecreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlifesactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_berms', rmp.fields.CopyFromBooleanField()),
                ('pm_drains', rmp.fields.CopyFromBooleanField()),
                ('pm_sumps', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('am_sprinklersystems', rmp.fields.CopyFromBooleanField()),
                ('am_delugesystems', rmp.fields.CopyFromBooleanField()),
                ('am_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('am_neutralization', rmp.fields.CopyFromBooleanField()),
                ('am_excessflowvalve', rmp.fields.CopyFromBooleanField()),
                ('am_flares', rmp.fields.CopyFromBooleanField()),
                ('am_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('am_emergencyshutdown', rmp.fields.CopyFromBooleanField()),
                ('am_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS3ToxicsAltReleases',
            },
        ),
        migrations.CreateModel(
            name='Tbls4Flammablesworstcase',
            fields=[
                ('flammableid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('analyticalbasis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('quantityreleased', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=2, max_digits=6)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5)),
                ('residentialpopulation', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_publicrecreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlifesactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromBooleanField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS4FlammablesWorstCase',
            },
        ),
        migrations.CreateModel(
            name='Tbls5Flammablesaltreleases',
            fields=[
                ('flammableid', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('analyticalbasis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromCharField(max_length=200)),
                ('quantityreleased', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5)),
                ('endpointused', rmp.fields.CopyFromCharField(blank=True, max_length=30)),
                ('lfl_value', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5)),
                ('residentialpopulation', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_publicrecreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlifesactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_firewalls', rmp.fields.CopyFromBooleanField()),
                ('pm_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('am_sprinklersystems', rmp.fields.CopyFromBooleanField()),
                ('am_delugesystems', rmp.fields.CopyFromBooleanField()),
                ('am_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('am_excessflowvalve', rmp.fields.CopyFromBooleanField()),
                ('am_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS5FlammablesAltReleases',
            },
        ),
        migrations.CreateModel(
            name='Tbls6Accidentchemicals',
            fields=[
                ('accidentchemicalid', models.IntegerField(primary_key=True, serialize=False)),
                ('quantityreleased', models.IntegerField(null=True)),
                ('percentweight', models.DecimalField(decimal_places=1, max_digits=4, null=True)),
            ],
            options={
                'db_table': 'tblS6AccidentChemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls6Accidenthistory',
            fields=[
                ('accidenthistoryid', models.IntegerField(primary_key=True, serialize=False)),
                ('accidentdate', models.DateTimeField(blank=True, null=True)),
                ('accidenttime', models.CharField(max_length=4)),
                ('naicscode', models.CharField(max_length=6)),
                ('accidentreleaseduration', models.CharField(max_length=5)),
                ('re_gas', models.BooleanField()),
                ('re_spill', models.BooleanField()),
                ('re_fire', models.BooleanField()),
                ('re_explosion', models.BooleanField()),
                ('re_reactiveincident', models.BooleanField()),
                ('rs_storagevessel', models.BooleanField()),
                ('rs_piping', models.BooleanField()),
                ('rs_processvessel', models.BooleanField()),
                ('rs_transferhose', models.BooleanField()),
                ('rs_valve', models.BooleanField()),
                ('rs_pump', models.BooleanField()),
                ('rs_joint', models.BooleanField()),
                ('otherreleasesource', models.CharField(blank=True, max_length=200)),
                ('windspeed', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('windspeedunitcode', models.CharField(blank=True, max_length=1)),
                ('winddirection', models.CharField(blank=True, max_length=3)),
                ('temperature', models.DecimalField(decimal_places=2, max_digits=6)),
                ('stabilityclass', models.CharField(blank=True, max_length=1)),
                ('precipitation', models.BooleanField()),
                ('weatherunknown', models.BooleanField()),
                ('deathsworkers', models.IntegerField()),
                ('deathspublicresponders', models.IntegerField()),
                ('deathspublic', models.IntegerField()),
                ('injuriesworkers', models.IntegerField()),
                ('injuriespublicresponders', models.IntegerField()),
                ('injuriespublic', models.IntegerField()),
                ('onsitepropertydamage', models.IntegerField()),
                ('offsitedeaths', models.BooleanField(blank=True, null=True)),
                ('hospitalization', models.IntegerField()),
                ('medicaltreatment', models.IntegerField()),
                ('evacuated', models.IntegerField()),
                ('shelteredinplace', models.IntegerField()),
                ('offsitepropertydamage', models.IntegerField()),
                ('ed_kills', models.BooleanField()),
                ('ed_minordefoliation', models.BooleanField()),
                ('ed_watercontamination', models.BooleanField()),
                ('ed_soilcontamination', models.BooleanField()),
                ('ed_other', models.CharField(blank=True, max_length=200)),
                ('initiatingevent', models.CharField(blank=True, max_length=1)),
                ('cf_equipmentfailure', models.BooleanField()),
                ('cf_humanerror', models.BooleanField()),
                ('cf_improperprocedure', models.BooleanField()),
                ('cf_overpressurization', models.BooleanField()),
                ('cf_upsetcondition', models.BooleanField()),
                ('cf_bypasscondition', models.BooleanField()),
                ('cf_maintenance', models.BooleanField()),
                ('cf_processdesignfailure', models.BooleanField()),
                ('cf_unsuitableequipment', models.BooleanField()),
                ('cf_unusualweather', models.BooleanField()),
                ('cf_managementerror', models.BooleanField()),
                ('cf_other', models.CharField(blank=True, max_length=200)),
                ('offsiterespondersnotify', models.CharField(blank=True, max_length=25)),
                ('ci_improvedequipment', models.BooleanField()),
                ('ci_revisedmaintenance', models.BooleanField()),
                ('ci_revisedtraining', models.BooleanField()),
                ('ci_revisedopprocedures', models.BooleanField()),
                ('ci_newprocesscontrols', models.BooleanField()),
                ('ci_newmitigationsystems', models.BooleanField()),
                ('ci_revisederplan', models.BooleanField()),
                ('ci_changedprocess', models.BooleanField()),
                ('ci_reducedinventory', models.BooleanField()),
                ('ci_none', models.BooleanField()),
                ('ci_othertype', models.CharField(blank=True, max_length=200)),
                ('cbi_flag', models.BooleanField()),
                ('facilityid', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Facilities')),
            ],
            options={
                'db_table': 'tblS6AccidentHistory',
            },
        ),
        migrations.CreateModel(
            name='Tbls6Flammablemixturechemicals',
            fields=[
                ('flammixchemid', models.IntegerField(primary_key=True, serialize=False)),
                ('accidentchemicalid', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls6Accidentchemicals')),
                ('chemicalid', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd')),
            ],
            options={
                'db_table': 'tblS6FlammableMixtureChemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls7PreventionProgram3',
            fields=[
                ('preventionprogram3id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('safety_info_date', rmp.fields.CopyFromDateTimeField()),
                ('last_pha_date', rmp.fields.CopyFromDateTimeField()),
                ('pha_whatif', rmp.fields.CopyFromBooleanField()),
                ('pha_checklist', rmp.fields.CopyFromBooleanField()),
                ('pha_whatifcheck', rmp.fields.CopyFromBooleanField()),
                ('pha_hazop', rmp.fields.CopyFromBooleanField()),
                ('pha_fmea', rmp.fields.CopyFromBooleanField()),
                ('pha_fta', rmp.fields.CopyFromBooleanField()),
                ('pha_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('change_comp_date', rmp.fields.CopyFromDateTimeField()),
                ('mh_toxicrelease', rmp.fields.CopyFromBooleanField()),
                ('mh_fire', rmp.fields.CopyFromBooleanField()),
                ('mh_explosion', rmp.fields.CopyFromBooleanField()),
                ('mh_runawayreact', rmp.fields.CopyFromBooleanField()),
                ('mh_polymerization', rmp.fields.CopyFromBooleanField()),
                ('mh_overpressure', rmp.fields.CopyFromBooleanField()),
                ('mh_corrosion', rmp.fields.CopyFromBooleanField()),
                ('mh_overfilling', rmp.fields.CopyFromBooleanField()),
                ('mh_contamination', rmp.fields.CopyFromBooleanField()),
                ('mh_equipfailure', rmp.fields.CopyFromBooleanField()),
                ('mh_cooling_loss', rmp.fields.CopyFromBooleanField()),
                ('mh_earthquake', rmp.fields.CopyFromBooleanField()),
                ('mh_floods', rmp.fields.CopyFromBooleanField()),
                ('mh_tornado', rmp.fields.CopyFromBooleanField()),
                ('mh_hurricanes', rmp.fields.CopyFromBooleanField()),
                ('mh_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pc_vents', rmp.fields.CopyFromBooleanField()),
                ('pc_reliefvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_checkvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('pc_flares', rmp.fields.CopyFromBooleanField()),
                ('pc_manualshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_autoshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_interlocks', rmp.fields.CopyFromBooleanField()),
                ('pc_alarms', rmp.fields.CopyFromBooleanField()),
                ('pc_keyedbypass', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencyair', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencypower', rmp.fields.CopyFromBooleanField()),
                ('pc_backuppump', rmp.fields.CopyFromBooleanField()),
                ('pc_groundingequip', rmp.fields.CopyFromBooleanField()),
                ('pc_inhibitoradd', rmp.fields.CopyFromBooleanField()),
                ('pc_rupturedisks', rmp.fields.CopyFromBooleanField()),
                ('pc_excessflowdev', rmp.fields.CopyFromBooleanField()),
                ('pc_quenchsystem', rmp.fields.CopyFromBooleanField()),
                ('pc_purgesystem', rmp.fields.CopyFromBooleanField()),
                ('pc_none', rmp.fields.CopyFromBooleanField()),
                ('pc_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('mx_sprinklersys', rmp.fields.CopyFromBooleanField()),
                ('ms_dikes', rmp.fields.CopyFromBooleanField()),
                ('ms_firewalls', rmp.fields.CopyFromBooleanField()),
                ('ms_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('ms_delugesystem', rmp.fields.CopyFromBooleanField()),
                ('ms_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('ms_enclosure', rmp.fields.CopyFromBooleanField()),
                ('ms_neutralization', rmp.fields.CopyFromBooleanField()),
                ('ms_none', rmp.fields.CopyFromBooleanField()),
                ('ms_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('md_processare', rmp.fields.CopyFromBooleanField()),
                ('md_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('md_none', rmp.fields.CopyFromBooleanField()),
                ('md_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ch_reduceinv', rmp.fields.CopyFromBooleanField()),
                ('ch_increaseinv', rmp.fields.CopyFromBooleanField()),
                ('ch_changeparam', rmp.fields.CopyFromBooleanField()),
                ('ch_proccontrol', rmp.fields.CopyFromBooleanField()),
                ('ch_procdetect', rmp.fields.CopyFromBooleanField()),
                ('ch_perimetermon', rmp.fields.CopyFromBooleanField()),
                ('ch_mitigationsys', rmp.fields.CopyFromBooleanField()),
                ('ch_nonerequired', rmp.fields.CopyFromBooleanField()),
                ('ch_none', rmp.fields.CopyFromBooleanField()),
                ('ch_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('proc_review_date', rmp.fields.CopyFromDateTimeField()),
                ('train_review_date', rmp.fields.CopyFromDateTimeField()),
                ('tr_classroom', rmp.fields.CopyFromBooleanField()),
                ('tr_onthejob', rmp.fields.CopyFromBooleanField()),
                ('tr_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ct_writtentest', rmp.fields.CopyFromBooleanField()),
                ('ct_oraltest', rmp.fields.CopyFromBooleanField()),
                ('ct_demonstration', rmp.fields.CopyFromBooleanField()),
                ('ct_observation', rmp.fields.CopyFromBooleanField()),
                ('ct_other', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('maint_review_date', rmp.fields.CopyFromDateTimeField()),
                ('maint_inspect_date', rmp.fields.CopyFromDateTimeField()),
                ('equip_tested', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('change_manage_date', rmp.fields.CopyFromDateTimeField()),
                ('change_review_date', rmp.fields.CopyFromDateTimeField()),
                ('prestart_rev_date', rmp.fields.CopyFromDateTimeField()),
                ('comp_audit_date', rmp.fields.CopyFromDateTimeField()),
                ('audit_comp_date', rmp.fields.CopyFromDateTimeField()),
                ('inc_invest_date', rmp.fields.CopyFromDateTimeField()),
                ('inc_change_date', rmp.fields.CopyFromDateTimeField()),
                ('part_review_date', rmp.fields.CopyFromDateTimeField()),
                ('hotwork_rev_date', rmp.fields.CopyFromDateTimeField()),
                ('con_safety_date', rmp.fields.CopyFromDateTimeField()),
                ('con_eval_date', rmp.fields.CopyFromDateTimeField()),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('description', rmp.fields.CopyFromTextField()),
                ('procnaics_id', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.Tbls1ProcessNaics')),
            ],
            options={
                'db_table': 'tblS7PreventionProgram3',
            },
        ),
        migrations.CreateModel(
            name='Tbls7PreventionProgramChemicals',
            fields=[
                ('primarykey', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('preventionprogram3id', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls7PreventionProgram3')),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS7_Prevention_Program_Chemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls8PreventionProgram2',
            fields=[
                ('preventionprogram2id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('safetyreviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('fr_nfpa58', rmp.fields.CopyFromBooleanField()),
                ('fr_osha', rmp.fields.CopyFromBooleanField()),
                ('fr_astm', rmp.fields.CopyFromBooleanField()),
                ('fr_ansi', rmp.fields.CopyFromBooleanField()),
                ('fr_asme', rmp.fields.CopyFromBooleanField()),
                ('fr_none', rmp.fields.CopyFromBooleanField()),
                ('fr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('fr_comments', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('hazardreviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('changecompletiondate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('mh_toxicrelease', rmp.fields.CopyFromBooleanField()),
                ('mh_fire', rmp.fields.CopyFromBooleanField()),
                ('mh_explosion', rmp.fields.CopyFromBooleanField()),
                ('mh_runawayreaction', rmp.fields.CopyFromBooleanField()),
                ('mh_polymerization', rmp.fields.CopyFromBooleanField()),
                ('mh_overpressurization', rmp.fields.CopyFromBooleanField()),
                ('mh_corrosion', rmp.fields.CopyFromBooleanField()),
                ('mh_overfilling', rmp.fields.CopyFromBooleanField()),
                ('mh_contamination', rmp.fields.CopyFromBooleanField()),
                ('mh_equipmentfailure', rmp.fields.CopyFromBooleanField()),
                ('mh_coolingloss', rmp.fields.CopyFromBooleanField()),
                ('mh_earthquake', rmp.fields.CopyFromBooleanField()),
                ('mh_floods', rmp.fields.CopyFromBooleanField()),
                ('mh_tornado', rmp.fields.CopyFromBooleanField()),
                ('mh_hurricanes', rmp.fields.CopyFromBooleanField()),
                ('mh_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pc_vents', rmp.fields.CopyFromBooleanField()),
                ('pc_reliefvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_checkvalves', rmp.fields.CopyFromBooleanField()),
                ('pc_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('pc_flares', rmp.fields.CopyFromBooleanField()),
                ('pc_manualshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_automaticshutoffs', rmp.fields.CopyFromBooleanField()),
                ('pc_interlocks', rmp.fields.CopyFromBooleanField()),
                ('pc_alarms', rmp.fields.CopyFromBooleanField()),
                ('pc_keyedbypass', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencyairsupply', rmp.fields.CopyFromBooleanField()),
                ('pc_emergencypower', rmp.fields.CopyFromBooleanField()),
                ('pc_backuppump', rmp.fields.CopyFromBooleanField()),
                ('pc_groundingequipment', rmp.fields.CopyFromBooleanField()),
                ('pc_inhibitoraddition', rmp.fields.CopyFromBooleanField()),
                ('pc_rupturedisks', rmp.fields.CopyFromBooleanField()),
                ('pc_excessflowdevice', rmp.fields.CopyFromBooleanField()),
                ('pc_quenchsystem', rmp.fields.CopyFromBooleanField()),
                ('pc_purgesystem', rmp.fields.CopyFromBooleanField()),
                ('pc_none', rmp.fields.CopyFromBooleanField()),
                ('pc_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ms_sprinklersystem', rmp.fields.CopyFromBooleanField()),
                ('ms_dikes', rmp.fields.CopyFromBooleanField()),
                ('ms_firewalls', rmp.fields.CopyFromBooleanField()),
                ('ms_blastwalls', rmp.fields.CopyFromBooleanField()),
                ('ms_delugesystem', rmp.fields.CopyFromBooleanField()),
                ('ms_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('ms_enclosure', rmp.fields.CopyFromBooleanField()),
                ('ms_neutralization', rmp.fields.CopyFromBooleanField()),
                ('ms_none', rmp.fields.CopyFromBooleanField()),
                ('ms_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('md_processareadetectors', rmp.fields.CopyFromBooleanField()),
                ('md_perimetermonitors', rmp.fields.CopyFromBooleanField()),
                ('md_none', rmp.fields.CopyFromBooleanField()),
                ('md_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ch_chemicalreduction', rmp.fields.CopyFromBooleanField()),
                ('ch_chemicalincrease', rmp.fields.CopyFromBooleanField()),
                ('ch_changeprocessparameters', rmp.fields.CopyFromBooleanField()),
                ('ch_installprocesscontrols', rmp.fields.CopyFromBooleanField()),
                ('ch_installprocessdetection', rmp.fields.CopyFromBooleanField()),
                ('ch_installperimetermonitoring', rmp.fields.CopyFromBooleanField()),
                ('ch_installmitigationsystems', rmp.fields.CopyFromBooleanField()),
                ('ch_nonerequired', rmp.fields.CopyFromBooleanField()),
                ('ch_none', rmp.fields.CopyFromBooleanField()),
                ('ch_otherchanges', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('opproceduresreviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('trainingreviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('tr_classroom', rmp.fields.CopyFromBooleanField()),
                ('tr_onthejob', rmp.fields.CopyFromBooleanField()),
                ('tr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ct_writtentest', rmp.fields.CopyFromBooleanField()),
                ('ct_oraltest', rmp.fields.CopyFromBooleanField()),
                ('ct_demonstration', rmp.fields.CopyFromBooleanField()),
                ('ct_observation', rmp.fields.CopyFromBooleanField()),
                ('ct_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('maintenancereviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('equipmentinspectiondate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('equipmenttested', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('complianceauditdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('auditcompletiondate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('incidentinvestigationdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('investigationchangedate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('mostrecentchangedate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('description', rmp.fields.CopyFromTextField(blank=True)),
                ('process_naics_id', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1ProcessNaics')),
            ],
            options={
                'db_table': 'tblS8PreventionProgram2',
            },
        ),
        migrations.CreateModel(
            name='Tbls8PreventionProgramChemicals',
            fields=[
                ('primarykey', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('preventionprogram2id', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls8PreventionProgram2')),
                ('processchemicalid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals')),
            ],
            options={
                'db_table': 'tblS8_Prevention_Program_Chemicals',
            },
        ),
        migrations.CreateModel(
            name='Tbls9Emergencyresponses',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('er_communityplan', rmp.fields.CopyFromBooleanField()),
                ('er_facilityplan', rmp.fields.CopyFromBooleanField()),
                ('er_responseactions', rmp.fields.CopyFromBooleanField()),
                ('er_publicinfoprocedures', rmp.fields.CopyFromBooleanField()),
                ('er_emergencyhealthcare', rmp.fields.CopyFromBooleanField()),
                ('er_reviewdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('ertrainingdate', rmp.fields.CopyFromDateTimeField(blank=True)),
                ('coordinatingagencyname', rmp.fields.CopyFromCharField(blank=True, max_length=250)),
                ('coordinatingagencyphone', rmp.fields.CopyFromCharField(blank=True, max_length=10)),
                ('fr_osha1910_38', rmp.fields.CopyFromBooleanField()),
                ('fr_osha1910_120', rmp.fields.CopyFromBooleanField()),
                ('fr_spcc', rmp.fields.CopyFromBooleanField()),
                ('fr_rcra', rmp.fields.CopyFromBooleanField()),
                ('fr_opa90', rmp.fields.CopyFromBooleanField()),
                ('fr_epcra', rmp.fields.CopyFromBooleanField()),
                ('fr_otherregulation', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('facilityid', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Facilities')),
            ],
            options={
                'db_table': 'tblS9EmergencyResponses',
            },
        ),
        migrations.CreateModel(
            name='TopoCd',
            fields=[
                ('topo', models.CharField(help_text='Unique identifier of the topography type.', max_length=1, primary_key=True, serialize=False)),
                ('topo_tr', models.CharField(help_text='Full description of the topography type.', max_length=5)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ToxicsAltRelease',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('percent_weight', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=4, null=True)),
                ('physical_state', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('analytical_basis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromCharField(max_length=200)),
                ('quantity_released', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5, null=True)),
                ('release_duration', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=5, null=True)),
                ('release_rate', rmp.fields.CopyFromBooleanField(null=True)),
                ('wind_speed', rmp.fields.CopyFromDecimalField(decimal_places=2, max_digits=6, null=True)),
                ('stability_class', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('topography', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('endpoint_distance', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=5, null=True)),
                ('population', rmp.fields.CopyFromCharField(blank=True, max_length=9, verbose_name='Residential population')),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_public_recreation', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natl_state_parks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlife_sactuary', rmp.fields.CopyFromBooleanField()),
                ('er_fed_wilderness', rmp.fields.CopyFromBooleanField()),
                ('er_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_berms', rmp.fields.CopyFromBooleanField()),
                ('pm_drains', rmp.fields.CopyFromBooleanField()),
                ('pm_sumps', rmp.fields.CopyFromBooleanField()),
                ('pm_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('am_sprinklers', rmp.fields.CopyFromBooleanField()),
                ('am_deluge_systems', rmp.fields.CopyFromBooleanField()),
                ('am_watercurtain', rmp.fields.CopyFromBooleanField()),
                ('am_neutralization', rmp.fields.CopyFromBooleanField()),
                ('am_excess_flowvalve', rmp.fields.CopyFromBooleanField()),
                ('am_flares', rmp.fields.CopyFromBooleanField()),
                ('am_scrubbers', rmp.fields.CopyFromBooleanField()),
                ('am_emergency_shutdown', rmp.fields.CopyFromBooleanField()),
                ('am_other_type', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('procchem', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='ToxicsWorstCase',
            fields=[
                ('id', rmp.fields.CopyFromIntegerField(primary_key=True, serialize=False)),
                ('percent_weight', rmp.fields.CopyFromDecimalField(decimal_places=1, max_digits=4, null=True)),
                ('physical_state', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('analytical_basis', rmp.fields.CopyFromCharField(blank=True, max_length=255)),
                ('scenario', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('quantity_lbs', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('release_duration', rmp.fields.CopyFromCharField(blank=True, max_length=7)),
                ('release_rate', rmp.fields.CopyFromCharField(blank=True, max_length=7)),
                ('wind_speed', rmp.fields.CopyFromDecimalField(blank=True, decimal_places=1, max_digits=4)),
                ('stability_class', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('topography', rmp.fields.CopyFromCharField(blank=True, max_length=1)),
                ('endpoint_distance', rmp.fields.CopyFromCharField(blank=True, max_length=4)),
                ('population', rmp.fields.CopyFromCharField(blank=True, max_length=9)),
                ('pr_schools', rmp.fields.CopyFromBooleanField()),
                ('pr_residences', rmp.fields.CopyFromBooleanField()),
                ('pr_hospitals', rmp.fields.CopyFromBooleanField()),
                ('pr_prisons', rmp.fields.CopyFromBooleanField()),
                ('pr_public_rec', rmp.fields.CopyFromBooleanField()),
                ('pr_comm_ind', rmp.fields.CopyFromBooleanField()),
                ('pr_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('er_natlstateparks', rmp.fields.CopyFromBooleanField()),
                ('er_wildlifesanct', rmp.fields.CopyFromBooleanField()),
                ('er_fedwilderness', rmp.fields.CopyFromBooleanField()),
                ('er_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('pm_dikes', rmp.fields.CopyFromBooleanField()),
                ('pm_enclosures', rmp.fields.CopyFromBooleanField()),
                ('pm_berms', rmp.fields.CopyFromBooleanField()),
                ('pm_drains', rmp.fields.CopyFromBooleanField()),
                ('pm_sumps', rmp.fields.CopyFromBooleanField()),
                ('pm_othertype', rmp.fields.CopyFromCharField(blank=True, max_length=200)),
                ('ptrgraphic', rmp.fields.CopyFromCharField(blank=True, max_length=12)),
                ('cbi_flag', rmp.fields.CopyFromBooleanField()),
                ('procchem', rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem')),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='WindCd',
            fields=[
                ('wind', models.CharField(help_text='Unique identifier of the wind speed measurement unit.', max_length=1, primary_key=True, serialize=False)),
                ('wind_tr', models.CharField(help_text='Full description of the wind speed measurement unit.', max_length=13)),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Prev2Text',
            fields=[
                ('prevent_2', rmp.fields.CopyFromOneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='rmp.PreventionProgram2')),
                ('desctext', rmp.fields.CopyFromTextField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.CreateModel(
            name='Prev3Text',
            fields=[
                ('prevent_3', rmp.fields.CopyFromOneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='rmp.PreventionProgram3')),
                ('desctext', rmp.fields.CopyFromTextField()),
            ],
            options={
                'abstract': False,
            },
        ),
        migrations.AddField(
            model_name='tbls6accidentchemicals',
            name='accidenthistoryid',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls6Accidenthistory'),
        ),
        migrations.AddField(
            model_name='tbls6accidentchemicals',
            name='chemicalid',
            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd'),
        ),
        migrations.AddField(
            model_name='tbls1processchemicals',
            name='processid',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processes'),
        ),
        migrations.AddField(
            model_name='tbls1flammablemixturechemicals',
            name='processchemicalid',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tbls1Processchemicals'),
        ),
        migrations.AddField(
            model_name='tblexecutivesummaries',
            name='facilityid',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Tblfacility'),
        ),
        migrations.AddField(
            model_name='procchem',
            name='process',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.Process'),
        ),
        migrations.AddField(
            model_name='preventionprogram3',
            name='procnaics',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcNaics'),
        ),
        migrations.AddField(
            model_name='preventionprogram2',
            name='procnaics',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcNaics'),
        ),
        migrations.AddField(
            model_name='prevent3chem',
            name='prevent_3',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.PreventionProgram3'),
        ),
        migrations.AddField(
            model_name='prevent3chem',
            name='procchem',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem'),
        ),
        migrations.AddField(
            model_name='prevent2chem',
            name='prevent_2',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.PreventionProgram2'),
        ),
        migrations.AddField(
            model_name='prevent2chem',
            name='procchem',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem'),
        ),
        migrations.AddField(
            model_name='flammablesworstcase',
            name='procchem',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem'),
        ),
        migrations.AddField(
            model_name='flammablesaltrelease',
            name='procchem',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.CASCADE, to='rmp.ProcChem'),
        ),
        migrations.AddField(
            model_name='accident',
            name='rmp',
            field=rmp.fields.CopyFromForeignKey(on_delete=django.db.models.deletion.PROTECT, to='rmp.Registration'),
        ),
        migrations.AddField(
            model_name='accflam',
            name='chemical',
            field=rmp.fields.CopyFromForeignKey(help_text='The identifying ID for a particular flammable chemical released in an accident.', on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd', verbose_name='Chemical ID'),
        ),
        migrations.AddField(
            model_name='accchem',
            name='accident',
            field=rmp.fields.CopyFromForeignKey(help_text='The unique ID for each accident record', on_delete=django.db.models.deletion.PROTECT, to='rmp.Accident'),
        ),
        migrations.AddField(
            model_name='accchem',
            name='chemical',
            field=rmp.fields.CopyFromForeignKey(help_text='The identifying ID for a particular chemical released in an accident.', on_delete=django.db.models.deletion.PROTECT, to='rmp.ChemCd'),
        ),
    ]
