class Documentation(models.Model):
title = models.TextField(blank=True, null=True)
endpoint_name = models.TextField(blank=True, null=True)
txt = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'documentation'
class WorkingCommittees(models.Model):
committee_id = models.IntegerField(blank=True, null=True)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1,
blank=True,
null=True)
party_affiliation = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
candidate_email_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
candidate_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
candidate_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
treasurer_name = models.TextField(blank=True, null=True)
treasurer_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
treasurer_mailing_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
web_address = models.TextField(blank=True, null=True)
measure = models.LongCharField(max_length=-1, blank=True, null=True)
simple_election = models.TextField(blank=True, null=True)
db_update_status = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'working_committees'
class Documentation(models.Model):
title = models.TextField(blank=True, null=True)
endpoint_name = models.TextField(blank=True, null=True)
txt = models.TextField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'documentation'
class WorkingCandidateCommittees(models.Model):
candidate_name = models.TextField(blank=True, null=True)
committee_id = models.IntegerField(blank=True, null=True)
committee_name = models.CharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
phone = models.TextField(blank=True, null=True)
party_affiliation = models.TextField(blank=True, null=True)
web_address = models.TextField(blank=True, null=True)
class Meta:
managed = False
db_table = 'working_candidate_committees'
class DjangoAdminLog(models.Model):
action_time = models.DateTimeField()
object_id = models.TextField(blank=True, null=True)
object_repr = models.CharField(max_length=200)
action_flag = models.SmallIntegerField()
change_message = models.TextField()
content_type = models.ForeignKey('DjangoContentType', blank=True, null=True)
user = models.ForeignKey(AuthUser)
class Meta:
managed = False
db_table = 'django_admin_log'
class AcGrassRootsInState(models.Model):
filer_id = models.FloatField(blank=True, null=True)
filer = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
total_money = models.FloatField(blank=True, null=True)
percent_grassroots = models.FloatField(blank=True, null=True)
percent_instate = models.FloatField(blank=True, null=True)
total_money_out = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'ac_grass_roots_in_state'
class WorkingCandidateCommittees(models.Model):
# id = models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)
candidate_name = models.TextField(blank=True, null=True)
committee_id = models.IntegerField(primary_key=True, default=0)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
phone = models.TextField(blank=True, null=True)
party_affiliation = models.TextField(blank=True, null=True)
web_address = models.TextField(blank=True, null=True)
class Meta:
managed = True
db_table = 'working_candidate_committees'
class AcGrassRootsInState(models.Model):
filer_id = models.FloatField(blank=True, primary_key=True)
filer = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
total_money = models.FloatField(blank=True, null=True)
percent_grassroots = models.FloatField(blank=True, null=True)
percent_instate = models.FloatField(blank=True, null=True)
total_money_out = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
managed = False
db_table = 'ac_grass_roots_in_state'
class SearchLog(models.Model):
search_term = models.TextField(blank=True, null=True)
date = models.DateTimeField(blank=True, null=True)
class Meta:
managed = False
db_table = 'search_log'
class OregonByPurposeCodes(models.Model):
purpose_code = models.TextField(blank=True, null=True)
total = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'oregon_by_purpose_codes'
class AcGrassRootsInState(models.Model):
"""filer_id is not unique so it cannot be made PK"""
filer_id = models.FloatField(blank=True, null=True)
filer = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
total_money = models.FloatField(blank=True, null=True)
percent_grassroots = models.FloatField(blank=True, null=True)
percent_instate = models.FloatField(blank=True, null=True)
total_money_out = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'ac_grass_roots_in_state'
class DjangoSession(models.Model):
session_key = models.CharField(primary_key=True, max_length=40)
session_data = models.TextField()
expire_date = models.DateTimeField()
class Meta:
managed = False
db_table = 'django_session'
class ImportDates(models.Model):
file_id = models.DecimalField(max_digits=256, decimal_places=256, blank=True, null=True)
scrape_date = models.DateField(blank=True, null=True)
file_name = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'import_dates'
class SearchLog(models.Model):
search_term = models.TextField(blank=True, null=True)
date = models.DateTimeField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
managed = False
db_table = 'search_log'
class WorkingCandidateCommittees(models.Model):
candidate_name = models.TextField(blank=True, null=True)
committee_id = models.IntegerField(blank=True, null=True)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
phone = models.TextField(blank=True, null=True)
party_affiliation = models.TextField(blank=True, null=True)
web_address = models.TextField(blank=True, null=True)
IMPORTANT_FIELDS = ['committee_id', 'committee_name', 'candidate_name', 'party_affiliation']
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'candidate committee'
app_label = 'pacs'
managed = True
db_table = 'working_candidate_committees'
class OregonByPurposeCodes(models.Model):
purpose_code = models.TextField(blank=True, null=True)
total = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'oregon_by_purpose_codes'
class CandidateByState(models.Model):
candidate_name = models.TextField(blank=True, null=True)
filer_id = models.IntegerField(blank=True, null=True)
state = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
value = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'candidate_by_state'
class CampaignDetail(models.Model):
filer_id = models.IntegerField(
primary_key=True,
default=0,
help_text="2384 unique integers identifying each committee.")
candidate_name = models.TextField(
blank=True,
null=True,
help_text="Not unique_together (candidate_name, committee_name, race)."
)
committee_name = models.LongCharField(
max_length=-1,
blank=True,
null=True,
help_text='Nonunique identifying name.')
race = models.TextField(blank=True, null=True)
website = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
total = models.FloatField(blank=True, null=True)
total_spent = models.FloatField(blank=True, null=True)
grassroots = models.FloatField(blank=True, null=True)
instate = models.FloatField(blank=True, null=True)
election = models.TextField(blank=True, null=True)
party = models.TextField(blank=True, null=True)
num_transactions = models.BigIntegerField(blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1,
blank=True,
null=True)
db_update_status = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'campaign_detail'
class CampaignDetail(models.Model):
filer_id = models.IntegerField(primary_key=True, default=0)
candidate_name = models.TextField(blank=True, null=True)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
race = models.TextField(blank=True, null=True)
website = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
total = models.FloatField(blank=True, null=True)
total_spent = models.FloatField(blank=True, null=True)
grassroots = models.FloatField(blank=True, null=True)
instate = models.FloatField(blank=True, null=True)
election = models.TextField(blank=True, null=True)
party = models.TextField(blank=True, null=True)
num_transactions = models.BigIntegerField(blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1, blank=True, null=True)
db_update_status = models.TextField(blank=True, null=True)
IMPORTANT_FIELDS = ['filer_id', 'committee_name', 'committee_type', 'committee_subtype',
'candidate_name', 'website', 'party', 'race']
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = True
db_table = 'campaign_detail'
class OregonByPurposeCodes(models.Model):
purpose_code = models.TextField(blank=True, primary_key=True)
total = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'purpose'
verbose_name_plural = 'purposes'
managed = False
db_table = 'oregon_by_purpose_codes'
class ImportDates(models.Model):
file_hash = models.DecimalField(primary_key=True, db_column='id', default=0,
max_digits=1000, decimal_places=1000, blank=True, null=False)
scrape_date = models.DateField(blank=True, null=True)
file_name = models.TextField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = True
db_table = 'import_dates'
class CandidateByState(models.Model):
candidate_name = models.TextField(blank=True, null=True)
filer_id = models.IntegerField(blank=True, null=True)
state = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
value = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'candidate_by_state'
class WorkingCommittees(models.Model):
# ALTER TABLE working_committees ADD COLUMN id SERIAL PRIMARY KEY;
# Must initially have all these properities identical to the properties in the initial migration
# id = models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)
committee_id = models.IntegerField(primary_key=True,
blank=True,
null=False,
default=0,
help_text='1.0 unique!')
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1,
blank=True,
null=True)
party_affiliation = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
candidate_email_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
candidate_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
candidate_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
treasurer_name = models.TextField(blank=True, null=True)
treasurer_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
treasurer_mailing_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
web_address = models.TextField(blank=True, null=True)
measure = models.LongCharField(max_length=-1, blank=True, null=True)
simple_election = models.TextField(blank=True, null=True)
db_update_status = models.TextField(blank=True, null=True)
class Meta:
managed = True
db_table = 'working_committees'
class ImportDates(models.Model):
id = models.DecimalField(max_digits=65535,
decimal_places=65535,
blank=True,
primary_key=True)
scrape_date = models.DateField(blank=True, null=True)
file_name = models.TextField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'file import date'
verbose_name_plural = 'file import dates'
managed = False
db_table = 'import_dates'
class WorkingCommittees(models.Model):
committee_id = models.IntegerField(blank=True,
primary_key=True,
null=False)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1,
blank=True,
null=True)
party_affiliation = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
election_office = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
candidate_email_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
candidate_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
candidate_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
treasurer_name = models.TextField(blank=True, null=True)
treasurer_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
treasurer_mailing_address = models.LongCharField(max_length=-1,
blank=True,
null=True)
web_address = models.TextField(blank=True, null=True)
measure = models.LongCharField(max_length=-1, blank=True, null=True)
simple_election = models.TextField(blank=True, null=True)
db_update_status = models.TextField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
managed = False
db_table = 'working_committees'
class HackOregonDbStatus(models.Model):
ac_grass_roots_in_state = models.FloatField(blank=True, null=True)
campaign_detail = models.FloatField(blank=True, null=True)
candidate_by_state = models.FloatField(blank=True, null=True)
candidate_sum_by_date = models.FloatField(blank=True, null=True)
cc_grass_roots_in_state = models.FloatField(blank=True, null=True)
cc_working_transactions = models.FloatField(blank=True, null=True)
direction_codes = models.FloatField(blank=True, null=True)
raw_candidate_filings = models.FloatField(blank=True, null=True)
raw_committees = models.FloatField(blank=True, null=True)
raw_committees_scraped = models.FloatField(blank=True, null=True)
raw_committee_transactions = models.FloatField(blank=True, null=True)
raw_committee_transactions_ammended_transactions = models.FloatField(
blank=True, null=True)
state_translation = models.FloatField(blank=True, null=True)
working_candidate_committees = models.FloatField(blank=True, null=True)
working_candidate_filings = models.FloatField(blank=True, null=True)
working_committees = models.FloatField(blank=True, null=True)
working_transactions = models.FloatField(blank=True, null=True)
date = models.DateField(blank=True, null=True)
event_at_log_time = models.TextField(blank=True, null=True)
hack_oregon_db_status = models.FloatField(blank=True, null=True)
all_oregon_sum = models.FloatField(blank=True, null=True)
state_sum_by_date = models.FloatField(blank=True, null=True)
documentation = models.FloatField(blank=True, null=True)
oregon_by_contributions = models.FloatField(blank=True, null=True)
oregon_by_purpose_codes = models.FloatField(blank=True, null=True)
sub_type_from_contributor_payee = models.FloatField(blank=True, null=True)
oregon_committee_agg = models.FloatField(blank=True, null=True)
import_dates = models.FloatField(blank=True, null=True)
raw_committee_transactions_errors = models.FloatField(blank=True,
null=True)
access_log = models.FloatField(blank=True, null=True)
search_log = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'database status'
verbose_name_plural = 'database status'
managed = False
db_table = 'hack_oregon_db_status'
class CampaignDetail(models.Model):
filer_id = models.IntegerField(primary_key=True, default=0)
candidate_name = models.TextField(blank=True, null=True)
committee_name = models.LongCharField(max_length=-1, blank=True, null=True)
race = models.TextField(blank=True, null=True)
website = models.TextField(blank=True, null=True)
phone = models.LongCharField(max_length=-1, blank=True, null=True)
total = models.FloatField(blank=True, null=True)
total_spent = models.FloatField(blank=True, null=True)
grassroots = models.FloatField(blank=True, null=True)
instate = models.FloatField(blank=True, null=True)
election = models.TextField(blank=True, null=True)
party = models.TextField(blank=True, null=True)
num_transactions = models.BigIntegerField(blank=True, null=True)
committee_type = models.LongCharField(max_length=-1, blank=True, null=True)
committee_subtype = models.LongCharField(max_length=-1,
blank=True,
null=True)
db_update_status = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'campaign_detail'
class WorkingCandidateFilings(models.Model):
id = models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)
election_txt = models.TextField(blank=True, null=True)
election_year = models.IntegerField(blank=True, null=True)
office_group = models.TextField(blank=True, null=True)
id_nbr = models.IntegerField(blank=True,
null=True,
help_text="0.32 unique")
office = models.TextField(blank=True, null=True)
candidate_office = models.TextField(blank=True, null=True)
candidate_file_rsn = models.IntegerField(blank=True, null=True)
file_mthd_ind = models.TextField(blank=True, null=True)
filetype_descr = models.TextField(blank=True, null=True)
party_descr = models.TextField(blank=True, null=True)
major_party_ind = models.TextField(blank=True, null=True)
cand_ballot_name_txt = models.TextField(blank=True, null=True)
occptn_txt = models.TextField(blank=True, null=True)
education_bckgrnd_txt = models.TextField(blank=True, null=True)
occptn_bkgrnd_txt = models.TextField(blank=True, null=True)
school_grade_diploma_degree_certificate_course_of_study = models.TextField(
blank=True, null=True)
prev_govt_bkgrnd_txt = models.TextField(blank=True, null=True)
judge_incbnt_ind = models.TextField(blank=True, null=True)
qlf_ind = models.TextField(blank=True, null=True)
filed_date = models.DateField(blank=True, null=True)
file_fee_rfnd_date = models.DateField(blank=True, null=True)
witdrw_date = models.DateField(blank=True, null=True)
withdrw_resn_txt = models.NullBooleanField()
pttn_file_date = models.DateField(blank=True, null=True)
pttn_sgnr_rqd_nbr = models.IntegerField(blank=True, null=True)
pttn_signr_filed_nbr = models.IntegerField(blank=True, null=True)
pttn_cmplt_date = models.DateField(blank=True, null=True)
ballot_order_nbr = models.IntegerField(blank=True, null=True)
prfx_name_cd = models.TextField(blank=True, null=True)
first_name = models.TextField(blank=True, null=True)
mdle_name = models.TextField(blank=True, null=True)
last_name = models.TextField(blank=True, null=True)
sufx_name = models.TextField(blank=True, null=True)
title_txt = models.TextField(blank=True, null=True)
mailing_addr_line_1 = models.TextField(blank=True, null=True)
mailing_addr_line_2 = models.TextField(blank=True, null=True)
mailing_city_name = models.TextField(blank=True, null=True)
mailing_st_cd = models.TextField(blank=True, null=True)
mailing_zip_code = models.IntegerField(blank=True, null=True)
mailing_zip_plus_four = models.IntegerField(blank=True, null=True)
residence_addr_line_1 = models.TextField(blank=True, null=True)
residence_addr_line_2 = models.TextField(blank=True, null=True)
residence_city_name = models.TextField(blank=True, null=True)
residence_st_cd = models.TextField(blank=True, null=True)
residence_zip_code = models.IntegerField(blank=True, null=True)
residence_zip_plus_four = models.IntegerField(blank=True, null=True)
home_phone = models.TextField(blank=True, null=True)
cell_phone = models.TextField(blank=True, null=True)
fax_phone = models.TextField(blank=True, null=True)
email = models.TextField(blank=True, null=True)
work_phone = models.TextField(blank=True, null=True)
web_address = models.TextField(blank=True, null=True)
class Meta:
managed = True
db_table = 'working_candidate_filings'
class RawCommitteesScraped(models.Model):
name = models.TextField(blank=True, null=True)
committee_id = models.IntegerField(blank=True,
null=False,
default=0,
primary_key=True)
acronym = models.TextField(blank=True, null=True)
pac_type = models.TextField(blank=True, null=True)
filing_effective_from = models.TextField(blank=True, null=True)
filing_type = models.TextField(blank=True, null=True)
address = models.TextField(blank=True, null=True)
campaign_phone = models.TextField(blank=True, null=True)
treasurer_name = models.TextField(blank=True, null=True)
treasurer_mailing_address = models.TextField(blank=True, null=True)
treasurer_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
treasurer_email_address = models.TextField(blank=True, null=True)
candidate_name = models.TextField(blank=True, null=True)
candidate_election_office = models.TextField(blank=True, null=True)
candidate_party_affiliation = models.TextField(blank=True, null=True)
candidate_candidate_address = models.TextField(blank=True, null=True)
candidate_work_phone_home_phone_fax = models.TextField(blank=True,
null=True)
candidate_mailing_address = models.TextField(blank=True, null=True)
candidate_email_address = models.TextField(blank=True, null=True)
candidate_occupation = models.TextField(blank=True, null=True)
candidate_employer = models.TextField(blank=True, null=True)
measure_election = models.TextField(blank=True, null=True)
measure_support = models.TextField(blank=True, null=True)
measure_details = models.TextField(blank=True, null=True)
committee_type = models.TextField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'raw_committees_scraped'
class WorkingCandidateFilings(models.Model):
candidate_file_rsn = models.IntegerField(primary_key=True, blank=True, null=False, default=0)
election_txt = models.TextField(blank=True, null=True)
election_year = models.IntegerField(blank=True, null=True)
office_group = models.TextField(blank=True, null=True)
id_nbr = models.IntegerField(blank=True, null=True)
office = models.TextField(blank=True, null=True)
candidate_office = models.TextField(blank=True, null=True)
file_mthd_ind = models.TextField(blank=True, null=True)
filetype_descr = models.TextField(blank=True, null=True)
party_descr = models.TextField(blank=True, null=True)
major_party_ind = models.TextField(blank=True, null=True)
cand_ballot_name_txt = models.TextField(blank=True, null=True)
occptn_txt = models.TextField(blank=True, null=True)
education_bckgrnd_txt = models.TextField(blank=True, null=True)
occptn_bkgrnd_txt = models.TextField(blank=True, null=True)
school_grade_diploma_degree_certificate_course_of_study = models.TextField(blank=True, null=True)
prev_govt_bkgrnd_txt = models.TextField(blank=True, null=True)
judge_incbnt_ind = models.TextField(blank=True, null=True)
qlf_ind = models.TextField(blank=True, null=True)
filed_date = models.DateField(blank=True, null=True)
file_fee_rfnd_date = models.DateField(blank=True, null=True)
witdrw_date = models.DateField(blank=True, null=True)
withdrw_resn_txt = models.NullBooleanField()
pttn_file_date = models.DateField(blank=True, null=True)
pttn_sgnr_rqd_nbr = models.IntegerField(blank=True, null=True)
pttn_signr_filed_nbr = models.IntegerField(blank=True, null=True)
pttn_cmplt_date = models.DateField(blank=True, null=True)
ballot_order_nbr = models.IntegerField(blank=True, null=True)
prfx_name_cd = models.TextField(blank=True, null=True)
first_name = models.TextField(blank=True, null=True)
mdle_name = models.TextField(blank=True, null=True)
last_name = models.TextField(blank=True, null=True)
sufx_name = models.TextField(blank=True, null=True)
title_txt = models.TextField(blank=True, null=True)
mailing_addr_line_1 = models.TextField(blank=True, null=True)
mailing_addr_line_2 = models.TextField(blank=True, null=True)
mailing_city_name = models.TextField(blank=True, null=True)
mailing_st_cd = models.TextField(blank=True, null=True)
mailing_zip_code = models.IntegerField(blank=True, null=True)
mailing_zip_plus_four = models.IntegerField(blank=True, null=True)
residence_addr_line_1 = models.TextField(blank=True, null=True)
residence_addr_line_2 = models.TextField(blank=True, null=True)
residence_city_name = models.TextField(blank=True, null=True)
residence_st_cd = models.TextField(blank=True, null=True)
residence_zip_code = models.IntegerField(blank=True, null=True)
residence_zip_plus_four = models.IntegerField(blank=True, null=True)
home_phone = models.TextField(blank=True, null=True)
cell_phone = models.TextField(blank=True, null=True)
fax_phone = models.TextField(blank=True, null=True)
email = models.TextField(blank=True, null=True)
work_phone = models.TextField(blank=True, null=True)
web_address = models.TextField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'working_candidate_filings'