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'
