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 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 CcGrassRootsInState(models.Model):
filer_id = models.IntegerField(blank=True, primary_key=True)
filer = models.LongCharField(max_length=-1, blank=True, null=True)
num_transactions = models.BigIntegerField(blank=True, null=True)
in_state = models.FloatField(blank=True, null=True)
grass_roots = models.FloatField(blank=True, null=True)
total_contributions = models.FloatField(blank=True, null=True)
total_money = models.FloatField(blank=True, null=True)
total_money_out = models.FloatField(blank=True, null=True)
percent_grass_roots = models.FloatField(blank=True, null=True)
percent_in_state = models.FloatField(blank=True, null=True)
IMPORTANT_FIELDS = [
'filer_id', 'filer', 'total_money', 'percent_grass_roots',
'percent_in_state'
]
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'grass roots in-state total'
verbose_name_plural = 'grass roots in-state totals'
managed = False
db_table = 'cc_grass_roots_in_state'
class SubTypeFromContributorPayee(models.Model):
contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'sub_type_from_contributor_payee'
class StateTranslation(models.Model):
statefull = models.LongCharField(max_length=-1, blank=True, null=True)
abbreviation = models.CharField(max_length=3, blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'state_translation'
class OregonByContributions(models.Model):
contribution_type = models.LongCharField(max_length=-1, blank=True, null=True)
total = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'oregon_by_contributions'
class DirectionCodes(models.Model):
sub_type = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'direction_codes'
class OregonCommitteeAgg(models.Model):
contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True)
contributor_payee_committee_id = models.IntegerField(blank=True, null=True)
sum = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'oregon_committee_agg'
class SchemaMigrations(models.Model):
version = models.LongCharField(primary_key=True, unique=True, max_length=-1, default=0)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'schema_migrations'
class StateTranslation(models.Model):
statefull = models.LongCharField(max_length=-1, blank=True, null=True)
abbreviation = models.CharField(max_length=3, blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
managed = False
db_table = 'state_translation'
class SubTypeFromContributorPayee(models.Model):
contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'sub_type_from_contributor_payee'
class OregonByContributions(models.Model):
contribution_type = models.LongCharField(max_length=-1, 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_contributions'
class DirectionCodes(models.Model):
sub_type = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'direction_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 OregonCommitteeAgg(models.Model):
contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True)
contributor_payee_committee_id = models.IntegerField(blank=True, null=True)
sum = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
app_label = 'pacs'
managed = False
db_table = 'oregon_committee_agg'
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)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'working_candidate_committees'
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 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 DirectionCodes(models.Model):
sub_type = models.LongCharField(max_length=-1,
blank=True,
primary_key=True)
direction = models.CharField(max_length=7, blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'direction'
verbose_name_plural = 'directions'
managed = False
db_table = 'direction_codes'
class OregonByContributions(models.Model):
contribution_type = models.LongCharField(max_length=-1,
blank=True,
primary_key=True)
total = models.FloatField(blank=True, null=True)
def __str__(self):
return representation(self)
class Meta:
verbose_name = 'contribution type'
verbose_name_plural = 'contribution types'
managed = False
db_table = 'oregon_by_contributions'
class WorkingCandidateCommittees(models.Model):
committee_id = models.IntegerField(blank=True, null=True)
candidate_name = models.TextField(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)
def __str__(self):
return representation(self)
class Meta:
managed = False
db_table = 'working_candidate_committees'
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 CcGrassRootsInState(models.Model):
filer_id = models.IntegerField(blank=True, null=True)
filer = models.LongCharField(max_length=-1, blank=True, null=True)
num_transactions = models.BigIntegerField(blank=True, null=True)
in_state = models.FloatField(blank=True, null=True)
grass_roots = models.FloatField(blank=True, null=True)
total_contributions = models.FloatField(blank=True, null=True)
total_money = models.FloatField(blank=True, null=True)
total_money_out = models.FloatField(blank=True, null=True)
percent_grass_roots = models.FloatField(blank=True, null=True)
percent_in_state = models.FloatField(blank=True, null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'cc_grass_roots_in_state'
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 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 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 WorkingTransactions(models.Model):
# id = models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)
tran_id = models.IntegerField(primary_key=True,
verbose_name='transaction ID',
blank=False,
null=False,
default=0,
help_text="1.0 fraction unique")
tran_date = models.DateField(blank=True, null=True)
filer = models.LongCharField(max_length=-1, blank=True, null=True)
contributor_payee = models.LongCharField(max_length=-1,
blank=True,
null=True)
sub_type = models.LongCharField(max_length=-1, blank=True, null=True)
amount = models.FloatField(blank=True, null=True)
contributor_payee_committee_id = models.IntegerField(blank=True, null=True)
filer_id = models.ForeignKey(
CampaignDetail,
db_column='filer_id',
blank=True,
null=True,
help_text="filer_id 17222 is not present in table working_committees")
purp_desc = models.LongCharField(max_length=-1, blank=True, null=True)
book_type = models.LongCharField(max_length=-1, blank=True, null=True)
addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True)
filed_date = models.DateField(blank=True, null=True)
addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True)
city = models.LongCharField(max_length=-1, blank=True, null=True)
state = models.LongCharField(max_length=-1, blank=True, null=True)
zip = models.IntegerField(blank=True, null=True)
purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
contributor_payee_class = models.LongCharField(max_length=-1,
blank=True,
null=True)
class Meta:
managed = True
db_table = 'working_transactions'
class WorkingTransactions(models.Model):
tran_id = models.IntegerField(blank=True, null=True)
tran_date = models.DateField(blank=True, null=True)
filer = models.LongCharField(max_length=-1, blank=True, null=True)
contributor_payee = models.LongCharField(max_length=-1,
blank=True,
null=True)
sub_type = models.LongCharField(max_length=-1, blank=True, null=True)
amount = models.FloatField(blank=True, null=True)
contributor_payee_committee_id = models.IntegerField(blank=True, null=True)
filer_id = models.IntegerField(blank=True, null=True)
purp_desc = models.LongCharField(max_length=-1, blank=True, null=True)
book_type = models.LongCharField(max_length=-1, blank=True, null=True)
addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True)
filed_date = models.DateField(blank=True, null=True)
addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True)
city = models.LongCharField(max_length=-1, blank=True, null=True)
state = models.LongCharField(max_length=-1, blank=True, null=True)
zip = models.IntegerField(blank=True, null=True)
purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
contributor_payee_class = models.LongCharField(max_length=-1,
blank=True,
null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'working_transactions'
class CcWorkingTransactions(models.Model):
id = models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)
tran_id = models.IntegerField(
blank=True,
null=True,
help_text="Should be unique ID but isnt, e.g. 1171373 is duplicated.")
tran_date = models.DateField(blank=True, null=True)
filer = models.LongCharField(max_length=-1, blank=True, null=True)
contributor_payee = models.LongCharField(max_length=-1,
blank=True,
null=True)
sub_type = models.LongCharField(max_length=-1, blank=True, null=True)
amount = models.FloatField(blank=True, null=True)
contributor_payee_committee_id = models.IntegerField(blank=True, null=True)
filer_id = models.IntegerField(blank=True, null=True)
purp_desc = models.LongCharField(max_length=-1, blank=True, null=True)
book_type = models.LongCharField(max_length=-1, blank=True, null=True)
addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True)
filed_date = models.DateField(blank=True, null=True)
addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True)
city = models.LongCharField(max_length=-1, blank=True, null=True)
state = models.LongCharField(max_length=-1, blank=True, null=True)
zip = models.IntegerField(blank=True, null=True)
purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True)
direction = models.CharField(max_length=7, blank=True, null=True)
contributor_payee_class = models.LongCharField(max_length=-1,
blank=True,
null=True)
class Meta:
managed = True
app_label = 'pacs'
db_table = 'cc_working_transactions'
