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'