class tblS7PreventionProgram3Description_ChangeHistory(BaseRMPModel): preventionprogram3descchangehistoryid = CopyFromIntegerField( primary_key=True, source_column='PreventionProgram3DescChangeHistoryID', ) facilitychangehistoryid = CopyFromIntegerField( source_column='FacilityChangeHistoryID', ) cdxcorrectioncode = CopyFromCharField( max_length=1, source_column='CDXCorrectionCode', ) preventionprogram3id = CopyFromForeignKey( 'tblS7PreventionProgram3', on_delete=models.PROTECT, source_column='PreventionProgram3ID', ) description = CopyFromTextField( source_column='Description', blank=True, ) olddescription = CopyFromTextField( source_column='OldDescription', blank=True, ) seqnum = CopyFromIntegerField(source_column='SeqNum', )
class ExecutiveSummaryLength(BaseRMPModel): rmp_id = CopyFromIntegerField( primary_key=True, ) byte_count = CopyFromIntegerField() suspect_count = CopyFromIntegerField() line_count = CopyFromIntegerField() edited_yn = CopyFromCharField(max_length=1) source_file = 'rmp_exec_sum_len'
class AccChem(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='accchem_id', verbose_name='Accident Chemical Record ID', help_text='A unique ID for each accident chemical record.', ) accident = CopyFromForeignKey( 'Accident', on_delete=models.PROTECT, help_text='The unique ID for each accident record', ) chemical = CopyFromForeignKey( 'ChemCd', on_delete=models.PROTECT, help_text='The identifying ID for a particular chemical released in an ' 'accident.', ) quantity_lbs = CopyFromIntegerField( null=True, verbose_name='Amount Released (lbs)', help_text='The amount of the substance released in the accident, in ' 'pounds, to two significant digits.', ) percent_weight = CopyFromDecimalField( decimal_places=2, null=True, max_digits=5, verbose_name='Percent Weight (Within Mixture)', help_text='The percent weight of a chemical within a mixture released ' 'in an accident.', ) num_acc_flam = CopyFromIntegerField( null=True, verbose_name='Number of Flammable Components', help_text='The number of listed flammable component chemicals for this' ' chemical record.', ) cas = CopyFromCharField( max_length=9, verbose_name='CAS number', help_text='The identifying CAS number for a chemical.', ) CHEMICAL_TYPE_CHOICES = ( ('T', 'toxic'), ('F', 'flammable'), ) chemical_type = CopyFromCharField( max_length=1, choices=CHEMICAL_TYPE_CHOICES, help_text='"The type of chemical.', ) source_file = 'rmp_acc_chem'
class tblS7PreventionProgram3Description_ChangeHistory(BaseRMPModel): PreventionProgram3DescChangeHistoryID = CopyFromIntegerField( primary_key=True, ) FacilityChangeHistoryID = CopyFromIntegerField() CDXCorrectionCode = CopyFromCharField(max_length=1, ) PreventionProgram3ID = CopyFromForeignKey( 'tblS7PreventionProgram3', db_column='PreventionProgram3ID', on_delete=models.PROTECT, ) Description = CopyFromTextField(blank=True, ) OldDescription = CopyFromTextField(blank=True, ) SeqNum = CopyFromIntegerField()
class ProcNaics(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='procnaics_id', ) process = CopyFromForeignKey( 'Process', on_delete=models.CASCADE ) naics = CopyFromIntegerField() num_prevent_2 = CopyFromIntegerField() num_prevent_3 = CopyFromIntegerField() source_file = 'rmp_proc_naics'
class EmergencyResponse(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='rmp_id', ) community_erp_yn = CopyFromBooleanField() facility_erp_yn = CopyFromBooleanField() erp_specific_yn = CopyFromBooleanField() erp_inform_yn = CopyFromBooleanField() erp_inform_hth_yn = CopyFromBooleanField() # erp_review_date = CopyFromDateTimeField(blank=True) # erp_training_date = CopyFromDateTimeField(blank=True) erp_review_date = CopyFromCharField(max_length=10, blank=True) erp_training_date = CopyFromCharField(max_length=10, blank=True) coord_agency= CopyFromCharField(max_length=250, blank=True) coord_phone = CopyFromCharField(max_length=10, blank=True) subto_osha191038 = CopyFromBooleanField() subto_osha191020 = CopyFromBooleanField() subto_cwa112 = CopyFromBooleanField() subto_rcra264= CopyFromBooleanField() subto_opa90 = CopyFromBooleanField() subto_state_epcra = CopyFromBooleanField() subto_other = CopyFromCharField(max_length=200, blank=True) source_file = 'rmp_response'
class ExecutiveSummary(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='rmp_id', ) summary_text = CopyFromTextField( source_column='execsum', blank=True, ) @classmethod def get_transform_queryset(self): qs = raw_models.tblExecutiveSummaries.objects.filter( ESSeqNum=Subquery( raw_models.tblExecutiveSummaries.objects.filter( FacilityID=OuterRef('FacilityID'), ).values('FacilityID_id').annotate( max_seqnum=Max('ESSeqNum') ).values('max_seqnum')[:1] ) ).annotate( rmp_id=F('FacilityID'), execsum=F('SummaryText') ) return qs
class AccFlam(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='FlamMixChemID', verbose_name='Flammable Chemical ID', help_text='A unique ID for each flammable chemical record.', ) accchem = CopyFromForeignKey( 'AccChem', on_delete=models.PROTECT, source_column='AccidentChemicalID', verbose_name='Accident Chemical Record ID', help_text='A unique ID for each accident chemical record.') chemical = CopyFromForeignKey( 'ChemCd', on_delete=models.PROTECT, source_column='ChemicalID', verbose_name='Chemical ID', help_text= 'The identifying ID for a particular flammable chemical released in an accident.', ) @classmethod def get_transform_queryset(self): m = raw_models.tblS6FlammableMixtureChemicals """ Baseline table for accidents """ return m.objects.get_default_transform_queryset()
class tblS1FlammableMixtureChemicals(BaseRMPModel): FlamMixChemID = CopyFromIntegerField( primary_key=True, verbose_name='Flam Mix Chem ID', help_text='Unique identifier for the Section 1 Flammable Mixture ' 'Chemicals record destination table. Generated by ' 'RMP*Submit and 3rd-party programs.', ) ProcessChemicalID = CopyFromForeignKey( 'tbls1ProcessChemicals', db_column='ProcessChemicalID', on_delete=models.PROTECT, verbose_name='Process Chemical ID', help_text='Unique number used to identify each chemical within a ' 'single RMP. Generated by RMP*Submit and 3rd-party ' 'programs.', ) ChemicalID = CopyFromForeignKey( 'tlkpChemicals', db_column='ChemicalID', on_delete=models.PROTECT, verbose_name='Chemical ID', help_text='Chemical Abstract Service (CAS) registry number for the ' 'flammable chemical.', ) class Meta: verbose_name = 'Registration Information' verbose_name_plural = 'Registration Information'
class tblS1Process_NAICS(BaseRMPModel): Process_NAICS_ID = CopyFromIntegerField( primary_key=True, verbose_name='Process NAICS ID', help_text='Unique number used to identify each NAICS code within a ' 'covered process in an RMP. Generated by RMP*Submit and ' '3rd-party programs.', ) ProcessID = CopyFromForeignKey( 'tblS1Processes', db_column='ProcessID', on_delete=models.PROTECT, verbose_name='Process ID', help_text='Unique number used to identify each covered process in an ' 'RMP reported in Section 1. Generated by RMP*Submit and 3rd-' 'party programs.', ) NAICSCode = CopyFromForeignKey( 'tlkpNAICS', db_column='NAICSCode', on_delete=models.PROTECT, verbose_name='1.17.b NAICS Code', help_text='The 5- or 6-digit NAICS Code.', ) class Meta: verbose_name = 'Process: NAICS Code' verbose_name_plural = 'Process: NAICS Code'
class tblRMPError(BaseRMPModel): FacilityID = CopyFromForeignKey( 'tblFacility', on_delete=models.PROTECT, source_column='FacilityID', verbose_name='Facility ID', help_text='Unique identifier for all RMPs submitted by a specific ' 'facility (assigned by Reporting Center for first-time ' 'submission). * After this number is assigned to the first ' 'submission for a facility, subsequent submissions for the ' 'same facility must include this identifier.', ) SequenceNumber = CopyFromIntegerField( source_column='SequenceNumber', verbose_name='Sequence Number', help_text='Unique sequence number.', ) ErrorText = CopyFromTextField( source_column='ErrorText', verbose_name='Error Text', help_text='Error message text.', ) class Meta: verbose_name = 'RMP ValidationError' verbose_name_plural = 'RMP ValidationErrors'
class tblS6AccidentChemicals(BaseRMPModel): accidentchemicalid = CopyFromIntegerField( source_column='AccidentChemicalID', primary_key=True, ) accidenthistoryid = CopyFromForeignKey( 'tblS6AccidentHistory', source_column='AccidentHistoryID', on_delete=models.PROTECT, ) chemicalid = CopyFromForeignKey( 'tlkpChemicals', source_column='ChemicalID', on_delete=models.PROTECT, ) quantityreleased = CopyFromFloatField( source_column='QuantityReleased', null=True, ) percentweight = CopyFromFloatField( source_column='PercentWeight', null=True, ) class Meta: verbose_name = 'Accident History: Chemicals' verbose_name_plural = 'Accident History: Chemicals'
class CountyCd(BaseRMPModel): state_code = CopyFromForeignKey( 'StateCd', on_delete=PROTECT, help_text='The U.S. Postal Service abbreviation for the state in which' ' the facility is located.', db_column='State_Code', ) county_code = CopyFromCharField( max_length=2, help_text='Federal Information Processing Standard (FIPS) code for the' ' county in which the facility is located.', ) county_name = CopyFromCharField( max_length=30, help_text='The name of the county.', ) state_county_code = CopyFromIntegerField( primary_key=True, help_text='Concatenation of state_code and county_code(?)', ) @classmethod def get_transform_queryset(self): m = raw_models.tlkpCountyFIPSCodes return m.objects.get_default_transform_queryset()
class tblExecutiveSummaries(BaseRMPModel): ESSeqNum = CopyFromIntegerField( verbose_name='Executive Summary Sequence Number', help_text='Unique sequence number for the executive summary.', ) FacilityID = CopyFromForeignKey( 'tblS1Facilities', db_column='FacilityID', on_delete=models.PROTECT, verbose_name='Facility ID', help_text='Unique identifier for all RMPs submitted by a specific ' 'facility (assigned by Reporting Center for first-time ' 'submission). * After this number is assigned to the first ' 'submission for a facility, subsequent submissions for the ' 'same facility must include this identifier.', ) SummaryText = CopyFromTextField( verbose_name='Executive Summary', blank=True, help_text='The Executive Summary includes a brief description of the ' "facility's risk management program.", ) source_file = 'tblExecutiveSummaries' class Meta: db_table = 'tblExecutiveSummaries'
class FlammablesWorstCase(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='flammable_id', ) procchem = CopyFromForeignKey( 'ProcChem', on_delete=models.CASCADE ) analytical_basis = CopyFromCharField(max_length=255, blank=True) # quantity_lbs = CopyFromDecimalField(max_digits=6, decimal_places=2, blank=True) # endpoint_distance = CopyFromDecimalField(max_digits=5, decimal_places=1) quantity_lbs = CopyFromCharField(max_length=20, blank=True) endpoint_distance = CopyFromCharField(max_length=20, blank=True) population = CopyFromCharField(max_length=9, blank=True) pr_schools = CopyFromBooleanField() pr_residences = CopyFromBooleanField() pr_hospitals = CopyFromBooleanField() pr_prisons = CopyFromBooleanField() pr_public_rec = CopyFromBooleanField() pr_comm_ind = CopyFromBooleanField() pr_othertype = CopyFromCharField(max_length=200, blank=True) er_natlstateparks = CopyFromBooleanField() er_wildlife_sanct = CopyFromBooleanField() er_fedwilderness = CopyFromBooleanField() er_othertype = CopyFromCharField(max_length=200, blank=True) pm_blastwalls = CopyFromBooleanField() pm_othertype = CopyFromCharField(max_length=200, blank=True) ptrgraphic = CopyFromCharField(max_length=12, blank=True) cbi_flag = CopyFromBooleanField() source_file = 'rmp_worst_flam'
class tblS7PreventionProgramChemicals(BaseRMPModel): PrimaryKey = CopyFromIntegerField( primary_key=True, verbose_name='Primary Key', help_text='Unique identifier for the Prevention Program 3 chemicals ' 'record destination table. Generated by RMP*Submit and 3rd-' 'party programs.', ) PreventionProgram3ID = CopyFromForeignKey( 'Tbls7PreventionProgram3', db_column='PreventionProgram3ID', verbose_name='Prevention Program 3 ID', on_delete=models.PROTECT, help_text='A unique number used to identify each prevention program ' 'within a NAICS code within a process. Generated by ' 'RMP*Submit and 3rd-party programs.', ) ProcessChemicalID = CopyFromForeignKey( 'tbls1ProcessChemicals', db_column='ProcessChemicalID', on_delete=models.PROTECT, verbose_name='Process Chemical ID', help_text='A number used to identify each chemical within a single RMP' 'from Section 1 Chemicals in Covered Process. Generated by ' 'RMP*Submit and 3rd-party programs.' ) source_file = 'tblS7_Prevention_Program_Chemicals' class Meta: verbose_name = 'Prevention Program: Program Level 3 Chemical' verbose_name_plural = 'Prevention Program: Program Level 3 Chemical'
class tblS7PreventionProgramChemicalsChangeHistory(BaseRMPModel): pp3chemchangehistoryid = CopyFromIntegerField( primary_key=True, source_column='PP3ChemChangeHistoryID', verbose_name='PP3 Chemical Change History ID', ) facilitychangehistoryid = CopyFromIntegerField( source_column='FacilityChangeHistoryID', verbose_name='Facility Change History ID', ) cdxcorrectioncode = CopyFromCharField( max_length=1, source_column='CDXCorrectionCode', verbose_name='CDX Correction Code', ) pp3chemid = CopyFromForeignKey( 'tblS7PreventionProgramChemicals', on_delete=models.PROTECT, source_column='PP3ChemID', verbose_name='Prevention Program Chemical ID', ) preventionprogram3id = CopyFromForeignKey( 'tblS7PreventionProgram3', on_delete=models.PROTECT, source_column='PreventionProgram3ID', verbose_name='Prevention Program3 ID', ) processchemicalid = CopyFromForeignKey( 'tblS1ProcessChemicals', on_delete=models.PROTECT, source_column='ProcessChemicalID', verbose_name='Process Chemical ID', ) process_naics_id = CopyFromForeignKey( 'tblS1ProcessNAICS', on_delete=models.PROTECT, source_column='Process_NAICS_ID', verbose_name='', ) naicscode = CopyFromForeignKey( 'tlkpNAICS', on_delete=models.PROTECT, source_column='NAICSCode', verbose_name='NAICS Code', ) source_file = 'tblS7_Prevention_Program_Chemicals_ChangeHistory'
class tblS7PreventionProgramChemicalsChangeHistory(BaseRMPModel): PP3ChemChangeHistoryID = CopyFromIntegerField( primary_key=True, verbose_name='PP3 Chemical Change History ID', ) FacilityChangeHistoryID = CopyFromIntegerField( verbose_name='Facility Change History ID', ) CDXCorrectionCode = CopyFromCharField( max_length=1, verbose_name='CDX Correction Code', ) PP3ChemID = CopyFromForeignKey( 'tblS7PreventionProgramChemicals', db_column='PP3ChemID', on_delete=models.PROTECT, verbose_name='Prevention Program Chemical ID', ) PreventionProgram3ID = CopyFromForeignKey( 'tblS7PreventionProgram3', db_column='PreventionProgram3ID', on_delete=models.PROTECT, verbose_name='Prevention Program3 ID', ) ProcessChemicalID = CopyFromForeignKey( 'tblS1ProcessChemicals', db_column='ProcessChemicalID', on_delete=models.PROTECT, verbose_name='Process Chemical ID', ) process_naics_id = CopyFromForeignKey( 'tblS1Process_NAICS', db_column='process_naics_id', on_delete=models.PROTECT, verbose_name='', ) NAICSCode = CopyFromForeignKey( 'tlkpNAICS', db_column='NAICSCode', on_delete=models.PROTECT, verbose_name='NAICS Code', ) source_file = 'tblS7_Prevention_Program_Chemicals_ChangeHistory'
class Tbls6AccidentChemicals(BaseRMPModel): accidentchemicalid = CopyFromIntegerField( source_column='AccidentChemicalID', primary_key=True, verbose_name='Accident Chemical Record ID', help_text='A unique ID for each accident chemical record.', ) # accidenthistoryid = CopyFromForeignKey( # 'Tbls6Accidenthistory', # on_delete=models.PROTECT, accidenthistoryid = CopyFromIntegerField( source_column='AccidentHistoryID', help_text='The unique ID for each accident record', ) # TODO: ForeignKeyField candidate chemicalid = CopyFromForeignKey( 'ChemCd', on_delete=models.PROTECT, source_column='ChemicalID', help_text='The identifying ID for a particular chemical released in an ' 'accident.', ) quantityreleased = CopyFromDecimalField( source_column='QuantityReleased', decimal_places=1, max_digits=8, null=True, verbose_name='Amount Released (lbs)', help_text='The amount of the substance released in the accident, in ' 'pounds, to two significant digits.', ) percentweight = CopyFromDecimalField( source_column='PercentWeight', decimal_places=2, null=True, max_digits=5, verbose_name='Percent Weight (Within Mixture)', help_text='The percent weight of a chemical within a mixture released ' 'in an accident.', ) source_file = 'tblS6AccidentChemicals'
class ExecutiveSummary(BaseRMPModel): #rmp_execsum id = CopyFromIntegerField( primary_key=True, source_column='rmp_id', ) summary_text = CopyFromTextField( source_column='execsum', blank=True, ) source_file = 'rmp_execsum'
class StateCounts(BaseRMPModel): state = CopyFromOneToOneField( 'StateCd', primary_key=True, on_delete=models.PROTECT, db_column='state', help_text='Federal Information Processing Standard (FIPS) code for the' ' county in which the facility is located.') total_facilities = CopyFromIntegerField() total_accidents = CopyFromIntegerField() total_deaths = CopyFromIntegerField() total_injuries = CopyFromIntegerField() total_evacuated = CopyFromIntegerField() total_property_damage = CopyFromIntegerField() @classmethod def get_transform_queryset(self): qs = Facility.objects.filter(registered=True).values('state').annotate( code=F('state'), total_facilities=Count('id'), total_accidents=Sum('num_accident_actual'), total_deaths=Sum('num_deaths'), total_injuries=Sum('num_injuries'), total_evacuated=Sum('num_evacuated'), total_property_damage=Sum('property_damage'), ).order_by('state') return qs
class ToxicsWorstCase(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='toxic_id', ) procchem = CopyFromForeignKey( 'ProcChem', on_delete=models.CASCADE ) percent_weight = CopyFromDecimalField( max_digits=4, decimal_places=1, null=True, ) # percent_weight = CopyFromCharField(max_length=7) physical_state = CopyFromCharField(max_length=1, blank=True) analytical_basis = CopyFromCharField(max_length=255, blank=True) scenario = CopyFromCharField(max_length=1, blank=True) # quantity_lbs = CopyFromDecimalField(max_digits=6, decimal_places=2, blank=True) quantity_lbs = CopyFromCharField(max_length=4, blank=True) # release_duration = CopyFromDecimalField(max_digits=7, decimal_places=2, blank=True) release_duration = CopyFromCharField(max_length=7, blank=True) # release_rate = CopyFromDecimalField(max_digits=4, decimal_places=1, blank=True) release_rate = CopyFromCharField(max_length=7, blank=True) wind_speed = CopyFromDecimalField(max_digits=4, decimal_places=1, blank=True) stability_class = CopyFromCharField(max_length=1, blank=True) topography = CopyFromCharField(max_length=1, blank=True) # endpoint_distance = CopyFromDecimalField(max_digits=5, decimal_places=1) endpoint_distance = CopyFromCharField(max_length=4, blank=True) population = CopyFromCharField(max_length=9, blank=True) pr_schools = CopyFromBooleanField() pr_residences = CopyFromBooleanField() pr_hospitals = CopyFromBooleanField() pr_prisons = CopyFromBooleanField() pr_public_rec= CopyFromBooleanField() pr_comm_ind = CopyFromBooleanField() pr_othertype = CopyFromCharField(max_length=200, blank=True) er_natlstateparks = CopyFromBooleanField() er_wildlifesanct = CopyFromBooleanField() er_fedwilderness = CopyFromBooleanField() er_othertype = CopyFromCharField(max_length=200, blank=True) pm_dikes = CopyFromBooleanField() pm_enclosures = CopyFromBooleanField() pm_berms = CopyFromBooleanField() pm_drains = CopyFromBooleanField() pm_sumps = CopyFromBooleanField() pm_othertype = CopyFromCharField(max_length=200, blank=True) ptrgraphic = CopyFromCharField(max_length=12, blank=True) cbi_flag = CopyFromBooleanField() source_file = 'rmp_worst_tox'
class tblS6FlammableMixtureChemicals(BaseRMPModel): FlamMixChemID = CopyFromIntegerField(primary_key=True, ) AccidentChemicalID = CopyFromForeignKey( 'tblS6AccidentChemicals', db_column='AccidentChemicalID', on_delete=models.PROTECT, ) ChemicalID = CopyFromForeignKey('tlkpChemicals', db_column='ChemicalID', on_delete=models.PROTECT) class Meta: verbose_name = 'Accident History: Flammable Mixture Chemicals' verbose_name_plural = 'Accident History: Flammable Mixture Chemicals'
class tlkpLatLongMethods(BaseRMPModel): Primary_Key = CopyFromIntegerField( primary_key=True, ) Method_Code = CopyFromCharField( max_length=2, unique=True, ) Method_Desc = CopyFromCharField( max_length=83 ) class Meta: verbose_name='Lookup: Lat/Long Method'
class ProcFlam(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='flammixchem_id', ) procchem = CopyFromForeignKey( ProcChem, on_delete=models.CASCADE ) chemical = CopyFromForeignKey( 'ChemCd', on_delete=models.CASCADE ) source_file = 'rmp_proc_flam'
class Prevent3Chem(BaseRMPModel): id = CopyFromIntegerField( primary_key=True, source_column='primary_key', ) prevent_3 = CopyFromForeignKey( 'PreventionProgram3', on_delete=models.CASCADE, source_column='prevent_3_id', ) procchem = CopyFromForeignKey( 'ProcChem', on_delete=models.CASCADE ) source_file = 'rmp_prevent_3_chem'
class tblS8_Prevention_Program_Chemicals(BaseRMPModel): primarykey = CopyFromIntegerField( source_column='PrimaryKey', primary_key=True, ) preventionprogram2id = CopyFromForeignKey( 'tblS8PreventionProgram2', source_column='PreventionProgram2ID', on_delete=models.PROTECT) processchemicalid = CopyFromForeignKey('tblS1ProcessChemicals', source_column='ProcessChemicalID', on_delete=models.PROTECT) class Meta: verbose_name = 'Prevention Program: Program Level 2 Chemicals' verbose_name_plural = 'Prevention Program: Program Level 2 Chemicals'
class tlkpLatLongMethods(BaseRMPModel): primary_key = CopyFromIntegerField( primary_key=True, source_column='Primary_Key', ) method_code = CopyFromCharField( source_column='Method_Code', max_length=2, unique=True, ) method_desc = CopyFromCharField(source_column='Method_Desc', max_length=83) source_file = 'tlkpLatLongMethods' class Meta: verbose_name = 'Lookup: Lat/Long Method'
class tblS4FlammablesWorstCase(BaseRMPModel): FlammableID = CopyFromIntegerField(primary_key=True, ) ProcessChemicalID = CopyFromForeignKey( 'tblS1ProcessChemicals', db_column='ProcessChemicalID', on_delete=models.PROTECT, ) AnalyticalBasis = CopyFromCharField( max_length=255, blank=True, ) QuantityReleased = CopyFromFloatField(null=True, ) Distance2Endpoint = CopyFromFloatField(null=True, ) ResidentialPopulation = CopyFromCharField( max_length=9, blank=True, ) PR_Schools = CopyFromBooleanField() PR_Residences = CopyFromBooleanField() PR_Hospitals = CopyFromBooleanField() PR_Prisons = CopyFromBooleanField() PR_PublicRecreation = CopyFromBooleanField() PR_Comm_Ind = CopyFromBooleanField() PR_OtherType = CopyFromCharField( max_length=200, blank=True, ) ER_NatlStateParks = CopyFromBooleanField() ER_WildlifeSactuary = CopyFromBooleanField() ER_FedWilderness = CopyFromBooleanField() ER_OtherType = CopyFromCharField( max_length=200, blank=True, ) PM_BlastWalls = CopyFromBooleanField() PM_OtherType = CopyFromCharField( max_length=200, blank=True, ) ptrGraphic = CopyFromCharField( max_length=12, blank=True, ) CBI_Flag = CopyFromBooleanField() class Meta: verbose_name = 'Flammables: Worst Case Scenario'
class tblS6FlammableMixtureChemicals(BaseRMPModel): flammixchemid = CopyFromIntegerField( source_column='FlamMixChemID', primary_key=True, ) accidentchemicalid = CopyFromForeignKey( 'Tbls6Accidentchemicals', source_column='AccidentChemicalID', on_delete=models.PROTECT, ) chemicalid = CopyFromForeignKey('tlkpChemicals', source_column='ChemicalID', on_delete=models.PROTECT) class Meta: verbose_name = 'Accident History: Flammable Mixture Chemicals' verbose_name_plural = 'Accident History: Flammable Mixture Chemicals'