SchemaSpy Analysis of pvsadmin.public - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  addr2zip.state_id	state.state_id
  auth_group.id	auth_user.id
  auth_group_permissions.id	auth_user.id
  auth_permission.id	auth_user.id
  auth_user_groups.id	auth_user.id
  auth_user_user_permissions.id	auth_user.id
  biotext.biotype_id	biotype.biotype_id
  biotext.officelevel_id	officelevel.officelevel_id
  biotext_candidate.officelevel_id	officelevel.officelevel_id
  biotype.experiencetype_id	experiencetype.experiencetype_id
  committee_archive.committeetype_id	committeetype.committeetype_id
  committee_archive.state_id	state.state_id
  committee_candidate_archive.committeeposition_id	committeeposition.committeeposition_id
  committee_positions.state_id	state.state_id
  conglevel_office.conglevel_id	conglevel.conglevel_id
  conglevel_office.office_id	office.office_id
  congress.release_id	release.release_id
  congstatus.release_id	release.release_id
  django_admin_log.id	auth_user.id
  django_content_type.id	auth_user.id
  django_migrations.id	auth_user.id
  election.officetype_id	officetype.officetype_id
  election_electionstage.electionstage_id	electionstage.electionstage_id
  electionoffice.state_id	state.state_id
  featured.release_id	release.release_id
  measure.measuretype_id	measuretype.measuretype_id
  measure.state_id	state.state_id
  npatform_criteria.electionstage_id	electionstage.electionstage_id
  npatform_criteria.officetype_id	officetype.officetype_id
  npatform_criteria.state_id	state.state_id
  npatmatrix_p.npatmatrix_id	npatmatrix.npatmatrix_id
  npatmatrix_p.npatrow_id	npatrowshorttext.npatrow_id
  npatrow_p.npatrow_id	npatrow.npatrow_id
  npatrowtext_p.npatrowtext_id	npatrowtext.npatrowtext_id
  npatrowtype.npatoptiongroup_id	npatoptiongroup.npatoptiongroup_id
  office_state.office_id	office.office_id
  office_state.state_id	state.state_id
  officials_roster.state_id	state.state_id
  speechlock.speech_id	speechlocking.speech_id
  user_role.role_id	role.role_id

  40 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  category_released	168
  category_released_new	187
  committee_positions	32,566
  legislativedistricts_gis	7,230
  merge_candidate	339
  mv_rating_party_average	133
  npatanswer_backup	8,758
  npatanswer_citation_congstatus	311
  npatanswer_citation_rating	619
  npatanswer_citation_speech_candidate	378
  npatanswer_pct_old	0
  npatrowtext_p	106
  officials_roster	0
  primarytype_state	65
  speechlock	252
  zip2district_old	0
  zip2redistrict_old	0

  17 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  biotextlocking.biotext_id
  category_tag.category_id
  category_tag.tag_id
  congaction.code
  congstatus_tag.congstatus_id
  congstatus_tag.tag_id
  county.local_id
  degree.name
  education_category.category_id
  education_category.education_id
  education_tag.education_id
  education_tag.tag_id
  electionstage.rank
  endorsertype.name
  experience_tag.experience_id
  experience_tag.tag_id
  factcheck_speech.factcheck_id
  factcheck_speech.speech_id
  factcheck_speech_candidate.factcheck_id
  factcheck_speech_candidate.speech_candidate_id
  factcheck_tag.factcheck_id
  factcheck_tag.tag_id
  local_districtname.districtname_id
  local_districtname.local_id
  local_leadership.leadership_id
  local_leadership.local_id
  measure_tag.measure_id
  measure_tag.tag_id
  npatgroup.code
  npatproblem_npatcandidate.npatcandidate_id
  npatproblem_npatcandidate.npatproblem_id
  npatrowtext_tag.npatrowtext_id
  npatrowtext_tag.tag_id
  rating_tag.rating_id
  rating_tag.tag_id
  sig_tag.sig_id
  sig_tag.tag_id
  speech_tag.speech_id
  speech_tag.tag_id
  website.website
  zipcode_local.local_id
  zipcode_local.zip5

  42 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  congcategory	congcategory_id
  congdocgroup	congdocgroup_id
  npatoptiongroup	npatoptiongroup_id
  pvs_encoding	translate

  4 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  committee
  committee_archive
  election_address
  electionoffice
  office_address
  resource
  sig
  v_candidate_timeline

  8 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected