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'