class StateTranslation(models.Model): statefull = models.CharField(max_length=-1, blank=True, null=True) abbreviation = models.CharField(max_length=3, blank=True, null=True) class Meta: managed = False db_table = 'state_translation'
class DjangoMigrations(models.Model): app = models.CharField(max_length=255) name = models.CharField(max_length=255) applied = models.DateTimeField() class Meta: managed = False db_table = 'django_migrations'
class DjangoContentType(models.Model): app_label = models.CharField(max_length=100) model = models.CharField(max_length=100) class Meta: managed = False db_table = 'django_content_type' unique_together = (('app_label', 'model'),)
class AuthPermission(models.Model): name = models.CharField(max_length=255) content_type = models.ForeignKey('DjangoContentType') codename = models.CharField(max_length=100) class Meta: managed = False db_table = 'auth_permission' unique_together = (('content_type_id', 'codename'),)
class AuthUser(models.Model): password = models.CharField(max_length=128) last_login = models.DateTimeField(blank=True, null=True) is_superuser = models.BooleanField() username = models.CharField(unique=True, max_length=30) first_name = models.CharField(max_length=30) last_name = models.CharField(max_length=30) email = models.CharField(max_length=254) is_staff = models.BooleanField() is_active = models.BooleanField() date_joined = models.DateTimeField() class Meta: managed = False db_table = 'auth_user'
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 WorkingTransactions(models.Model): tran_id = models.IntegerField(blank=True, primary_key=True, null=False) 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) def __str__(self): return representation(self) class Meta: managed = False 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) IMPORTANT_FIELDS = ['tran_id', 'tran_date', 'filer_id', 'filer', 'filed_date', 'amount', 'direction', 'purpose_codes'] def __str__(self): return representation(self) class Meta: app_label = 'pacs' verbose_name = 'working transaction' verbose_name_plural = 'working transactions' managed = False db_table = 'cc_working_transactions'
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 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 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 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 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 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 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 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 WorkingCommittees(models.Model): committee_id = models.IntegerField(blank=True, null=True) committee_name = models.CharField(max_length=-1, blank=True, null=True) committee_type = models.CharField(max_length=-1, blank=True, null=True) committee_subtype = models.CharField(max_length=-1, blank=True, null=True) party_affiliation = models.TextField(blank=True, null=True) phone = models.CharField(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.CharField(max_length=-1, blank=True, null=True) candidate_work_phone_home_phone_fax = models.TextField(blank=True, null=True) candidate_address = models.CharField(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.CharField(max_length=-1, blank=True, null=True) web_address = models.TextField(blank=True, null=True) measure = models.CharField(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 = 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 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'
class RawCommitteeTransactionsErrors(models.Model): tran_id = models.IntegerField(blank=True, null=True) original_id = models.IntegerField(blank=True, null=True) tran_date = models.DateField(blank=True, null=True) tran_status = models.CharField(max_length=-1, blank=True, null=True) filer = models.CharField(max_length=-1, blank=True, null=True) contributor_payee = models.CharField(max_length=-1, blank=True, null=True) sub_type = models.CharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_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) attest_by_name = models.CharField(max_length=-1, blank=True, null=True) attest_date = models.DateField(blank=True, null=True) review_by_name = models.CharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.CharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.CharField(max_length=-1, blank=True, null=True) purp_desc = models.CharField(max_length=-1, blank=True, null=True) intrst_rate = models.CharField(max_length=-1, blank=True, null=True) check_nbr = models.CharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.CharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.CharField(max_length=-1, blank=True, null=True) book_type = models.CharField(max_length=-1, blank=True, null=True) title_txt = models.CharField(max_length=-1, blank=True, null=True) occptn_txt = models.CharField(max_length=-1, blank=True, null=True) emp_name = models.CharField(max_length=-1, blank=True, null=True) emp_city = models.CharField(max_length=-1, blank=True, null=True) emp_state = models.CharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.CharField(max_length=-1, blank=True, null=True) addr_line2 = models.CharField(max_length=-1, blank=True, null=True) city = models.CharField(max_length=-1, blank=True, null=True) state = models.CharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.CharField(max_length=-1, blank=True, null=True) purpose_codes = models.CharField(max_length=-1, blank=True, null=True) exp_date = models.CharField(max_length=-1, blank=True, null=True) class Meta: managed = False db_table = 'raw_committee_transactions_errors'
class AuthGroup(models.Model): name = models.CharField(unique=True, max_length=80) class Meta: managed = False db_table = 'auth_group'
class RawCommittees(models.Model): committee_id = models.IntegerField(primary_key=True) committee_name = models.CharField(max_length=-1, blank=True, null=True) committee_type = models.CharField(max_length=-1, blank=True, null=True) committee_subtype = models.CharField(max_length=-1, blank=True, null=True) candidate_office = models.CharField(max_length=-1, blank=True, null=True) candidate_office_group = models.CharField(max_length=-1, blank=True, null=True) filing_date = models.DateField(blank=True, null=True) organization_filing_date = models.DateField(db_column='organization_filing Date', blank=True, null=True) # Field name made lowercase. Field renamed to remove unsuitable characters. treasurer_first_name = models.CharField(max_length=-1, blank=True, null=True) treasurer_last_name = models.CharField(max_length=-1, blank=True, null=True) treasurer_mailing_address = models.CharField(max_length=-1, blank=True, null=True) treasurer_work_phone = models.CharField(max_length=-1, blank=True, null=True) treasurer_fax = models.CharField(max_length=-1, blank=True, null=True) candidate_first_name = models.CharField(max_length=-1, blank=True, null=True) candidate_last_name = models.CharField(max_length=-1, blank=True, null=True) candidate_work_phone = models.CharField(max_length=-1, blank=True, null=True) candidate_residence_phone = models.CharField(max_length=-1, blank=True, null=True) candidate_fax = models.CharField(max_length=-1, blank=True, null=True) candidate_email = models.CharField(max_length=-1, blank=True, null=True) active_election = models.CharField(max_length=-1, blank=True, null=True) measure = models.CharField(max_length=-1, blank=True, null=True) maling_address = models.CharField(max_length=-1, blank=True, null=True) class Meta: managed = False db_table = 'raw_committees'
class SchemaMigrations(models.Model): version = models.CharField(unique=True, max_length=-1) class Meta: managed = False db_table = 'schema_migrations'
class SubTypeFromContributorPayee(models.Model): contributor_payee = models.CharField(max_length=-1, blank=True, null=True) class Meta: managed = False db_table = 'sub_type_from_contributor_payee'