# Quorum schema ERD

Table and field reference for the Fivetran Quorum connector.

## Table & Field Reference

### custom_field_limited_to_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK |
| custom_field_id | Unknown | PK, FK |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| group_id | Unknown | FK |
| organization_id | Unknown | FK |
| archived | Unknown |  |
| conditional_boolean_value | Unknown |  |
| conditional_list_value | Json |  |
| conditional_parent_custom_field | Unknown |  |
| conditional_string_value | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| default_boolean_value | Unknown |  |
| default_multi_value | Json |  |
| default_string_value | Unknown |  |
| default_value | Unknown |  |
| description | Unknown |  |
| display_null_value | Unknown |  |
| display_on_create_page | Unknown |  |
| display_on_filter | Unknown |  |
| display_on_profile | Unknown |  |
| external_description | Unknown |  |
| external_name | Unknown |  |
| extra | Json |  |
| is_editable | Unknown |  |
| is_hyperlinkable | Unknown |  |
| is_required | Unknown |  |
| name | Unknown |  |
| option | Json |  |
| option_display_type | Unknown |  |
| options_new | Json |  |
| precedence | Unknown |  |
| slug | Unknown |  |
| tag_owner | Unknown |  |
| tag_type | Unknown |  |
| updated | Unknown |  |
| used_to_generate_outbox_email_list | Unknown |  |

### issue_management_search_term

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_management_id | Unknown | PK, FK |
| term | Unknown |  |

### issue_management_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_management_id | Unknown | PK, FK |
| category | Unknown |  |

### issue_management_magic_board

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_management_id | Unknown | PK, FK |
| magic_board | Unknown |  |

### issue_management_team

| Column | Type | Keys |
| --- | --- | --- |
| issue_management_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### issue_management_organization

| Column | Type | Keys |
| --- | --- | --- |
| issue_management_id | Unknown | PK, FK |
| oragnization_id | Unknown | PK, FK |

### issue_management_participant

| Column | Type | Keys |
| --- | --- | --- |
| participant_id | Unknown | PK |
| issue_management_id | Unknown | PK, FK |

### issue_management

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| archived | Unknown |  |
| can_be_tagged_to_interaction | Unknown |  |
| category | Json |  |
| converted | Unknown |  |
| cost | Unknown |  |
| creator_edit_only | Unknown |  |
| creator_username | Unknown |  |
| deadline | Unknown |  |
| defaults | Unknown |  |
| due_date | Unknown |  |
| extra | Json |  |
| grassroots_order | Unknown |  |
| grassroots_page_layout_type | Unknown |  |
| grassroots_vanity_url_slug | Unknown |  |
| icon | Unknown |  |
| image_url | Unknown |  |
| is_carryover | Unknown |  |
| is_grassroots_issue | Unknown |  |
| is_issue | Unknown |  |
| is_limited_to_creator | Unknown |  |
| is_visible_to_partner | Unknown |  |
| issue_expert | Unknown |  |
| long_description | Unknown |  |
| management_statistics | Json |  |
| name | Unknown |  |
| number_of_campaign | Unknown |  |
| number_of_campaign_action | Unknown |  |
| number_of_interaction | Unknown |  |
| parent | Unknown |  |
| priority | Unknown |  |
| project_type | Unknown |  |
| region_tag | Unknown |  |
| related_region | Unknown |  |
| remove_with_stance | Unknown |  |
| resource_uri | Unknown |  |
| short_description | Unknown |  |
| shown_in_table | Unknown |  |
| year | Unknown |  |

### bulk_email_search_param_dehydrate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| name | Unknown |  |

### bulk_email_search_param_most_recent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| param | Unknown |  |

### bulk_email_search_param_minor_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| id | Unknown |  |

### bulk_email_search_param_staffer_chamber

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| id | Unknown |  |

### bulk_email_search_param_added_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| id | Unknown |  |

### bulk_email_search_param

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| for_outbox | Unknown |  |
| hygiene_staffer_type | Unknown |  |
| ph_current | Unknown |  |
| show_in_quicksearch | Unknown |  |
| staffer_tittle_deleted_id | Unknown |  |
| staffer_tittle_query_set_list | Unknown |  |
| staffer_tittle_searchify_count | Unknown |  |

### bulk_email_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bulk_email_data_id | Unknown | PK, FK |
| bulk_email_id | Unknown | PK, FK |
| region | Unknown |  |

### bulk_email_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bulk_email_id | Unknown | PK, FK |
| added_id | Json |  |
| data_type | Unknown |  |
| deleted_id | Json |  |
| name | Unknown |  |
| quorum_dat_type | Unknown |  |
| reference_hash | Unknown |  |
| selection_type | Unknown |  |
| text | Unknown |  |

### bulk_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| ab_test | Unknown |  |
| action | Unknown |  |
| aggregate_click | Unknown |  |
| aggregate_open | Unknown |  |
| aggregate_unsubscribe | Unknown |  |
| ai_suggestion | Json |  |
| archived | Unknown |  |
| attachment | Unknown |  |
| attempted_resend_count | Unknown |  |
| bcc_rcpt | Json |  |
| bounce | Unknown |  |
| campaign | Unknown |  |
| cc_rcpts | Json |  |
| click | Unknown |  |
| click_rate | Unknown |  |
| compose_tool | Unknown |  |
| content_version | Unknown |  |
| created | Unknown |  |
| current_status | Unknown |  |
| custom_event | Unknown |  |
| email_count | Unknown |  |
| excluded_email_count | Unknown |  |
| excluded_person_count | Unknown |  |
| excluded_press_count | Unknown |  |
| excluded_supporter_count | Unknown |  |
| excludes_json_data | Json |  |
| excludes_json_old | Json |  |
| external_id | Unknown |  |
| extra | Json |  |
| failed_recipient | Json |  |
| from_address | Unknown |  |
| from_name | Unknown |  |
| from_user | Unknown |  |
| html_content | Unknown |  |
| initial_open | Unknown |  |
| is_abtest | Unknown |  |
| is_custom_unsubscribe | Unknown |  |
| is_draft | Unknown |  |
| is_moved | Unknown |  |
| is_scheduled | Unknown |  |
| is_updating | Unknown |  |
| json_content | Json |  |
| last_updated | Unknown |  |
| must_send_as_creator | Unknown |  |
| open_rate | Unknown |  |
| opens | Unknown |  |
| percent_opened | Unknown |  |
| person_count | Unknown |  |
| press_count | Unknown |  |
| reply_count | Unknown |  |
| reply_to_address | Unknown |  |
| reply_to_assignments | Unknown |  |
| reply_to_name | Unknown |  |
| reply_to_user | Unknown |  |
| root_bulk_email | Unknown |  |
| saved_by_user | Unknown |  |
| scheduled_send_time | Unknown |  |
| selection_json_data | Json |  |
| selection_json_old | Json |  |
| send_from_assignment | Unknown |  |
| sent_datetime | Unknown |  |
| should_cc_all | Unknown |  |
| should_stagger_send | Unknown |  |
| subject | Unknown |  |
| supporter_bounce | Unknown |  |
| supporter_count | Unknown |  |
| unsubscribe | Unknown |  |
| unsubscribe_enabled | Unknown |  |
| updated | Unknown |  |
| use_personal_email | Unknown |  |
| variant | Json |  |
| variant_of | Unknown |  |
| was_imported | Unknown |  |
| winner | Unknown |  |
| winner_of | Unknown |  |

### message_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bulk_email_id | Unknown | FK |
| archived | Unknown |  |
| event_id | Unknown |  |
| event_name | Unknown |  |
| event_timestamp | Unknown |  |
| event_type | Unknown |  |
| extra | Json |  |
| send_email | Unknown |  |
| event_json_** |  |  |

### bill_amendment_sponsor

| Column | Type | Keys |
| --- | --- | --- |
| bill_amendment_id | Unknown | PK, FK |
| sponsor | Unknown | PK, FK |

### bill_amendment_text

| Column | Type | Keys |
| --- | --- | --- |
| text | Unknown | PK |
| bill_amendment_id | Unknown | PK, FK |

### bill_amendment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill | Unknown | FK |
| action | Json |  |
| alert_cache | Json |  |
| amendment_type | Unknown |  |
| bill_id | Unknown |  |
| congress_number | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| dms_id | Unknown |  |
| extra | Json |  |
| fts_strip_level | Unknown |  |
| house_number | Unknown |  |
| label | Unknown |  |
| last_action_text | Unknown |  |
| number | Unknown |  |
| number_of_cosponsor | Unknown |  |
| offered_date | Unknown |  |
| primary_party | Unknown |  |
| region | Unknown |  |
| resource_uri | Unknown |  |
| rules_number | Unknown |  |
| rules_status | Unknown |  |
| snippet | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| status_date | Unknown |  |
| text | Unknown |  |
| title | Unknown |  |
| updated | Unknown |  |
| word_count | Unknown |  |

### users_current_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| current_region | Unknown |  |

### users_other_persona

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| other_personas | Unknown |  |

### users_permissioned_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| permissioned_region | Unknown |  |

### users_search_data_type_order

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| search_data_type_order | Unknown |  |

### users_sidebar_setting_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| sidebar_settings_list | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_info_organization_id | Unknown | FK |
| date_joined | Unknown |  |
| email | Unknown |  |
| extra | Json |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| user_info_accepted_terms_and_condition | Unknown |  |
| user_info_alert_default_search_filter | Unknown |  |
| user_info_amendment_default_search_filter | Unknown |  |
| user_info_article_default_search_filter | Unknown |  |
| user_info_attachment_default_search_filter | Unknown |  |
| user_info_bill_default_search_filter | Unknown |  |
| user_info_bulk_action_max_size | Unknown |  |
| user_info_campaign_columns_list | Unknown |  |
| user_info_can_access_all_org_region | Unknown |  |
| user_info_can_access_campaign_finance | Unknown |  |
| user_info_can_access_custom_fields_management | Unknown |  |
| user_info_can_access_grassroot | Unknown |  |
| user_info_can_access_issue_management | Unknown |  |
| user_info_can_access_media_monitoring | Unknown |  |
| user_info_can_access_media_relation | Unknown |  |
| user_info_can_access_mobile_developer_tool | Unknown |  |
| user_info_can_access_note | Unknown |  |
| user_info_can_access_outbox | Unknown |  |
| user_info_can_access_pac | Unknown |  |
| user_info_can_change_action_center_setting | Unknown |  |
| user_info_can_only_create_single_user_issue | Unknown |  |
| user_info_can_see_all_campaign | Unknown |  |
| user_info_can_see_all_event | Unknown |  |
| user_info_can_see_all_file | Unknown |  |
| user_info_can_see_all_user | Unknown |  |
| user_info_can_see_any_previous_outbox_email | Unknown |  |
| user_info_can_see_supporters_and_custom_org | Unknown |  |
| user_info_can_see_supporters_based_on_region | Unknown |  |
| user_info_can_send_from_any_outbox | Unknown |  |
| user_info_can_use_mobile_app | Unknown |  |
| user_info_current_preset_name | Unknown |  |
| user_info_current_project | Unknown |  |
| user_info_date_accepted_terms_and_condition | Unknown |  |
| user_info_default_limited_to_team | Json |  |
| user_info_default_search_data_type | Unknown |  |
| user_info_document_default_search_filter | Unknown |  |
| user_info_email_signature | Unknown |  |
| user_info_employee_id | Unknown |  |
| user_info_event_default_search_filter | Unknown |  |
| user_info_extra | Json |  |
| user_info_feature_cache_1_1 | Unknown |  |
| user_info_feature_cache_1_6 | Unknown |  |
| user_info_full_name | Unknown |  |
| user_info_id | Unknown |  |
| user_info_initial | Unknown |  |
| user_info_legislator_default_search_filter | Unknown |  |
| user_info_limit_from_default_project | Unknown |  |
| user_info_note_default_search_filter | Unknown |  |
| user_info_org_admin | Unknown |  |
| user_info_pacc_user_id | Unknown |  |
| user_info_pacc_version | Unknown |  |
| user_info_permanent_mobile_login_token | Json |  |
| user_info_person_default_search_filter | Unknown |  |
| user_info_persona | Unknown |  |
| user_info_phone_number | Unknown |  |
| user_info_preset_region | Unknown |  |
| user_info_press_contact_default_search_filter | Unknown |  |
| user_info_public_organization_default_search_filter | Unknown |  |
| user_info_push_notification_unseen_count | Unknown |  |
| user_info_related_username | Unknown |  |
| user_info_search_is_table_view | Unknown |  |
| user_info_search_should_hide_filter | Unknown |  |
| user_info_should_hide_team_permissionining_in_form | Unknown |  |
| user_info_single_login | Unknown |  |
| user_info_staffer_default_search_filter | Unknown |  |
| user_info_supporter_default_search_filter | Unknown |  |
| user_info_two_factor_status | Unknown |  |
| user_info_user_persona | Unknown |  |
| user_info_user_role | Unknown |  |
| user_info_visited_feature_cache | Json |  |
| user_info_vote_default_search_filter | Unknown |  |
| username | Unknown |  |

### organization_allowed_user_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | FK |
| allowed_user_domain | Unknown |  |

### organization_allowed_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| domain | Unknown |  |

### organization_interaction_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| internal_interaction_type | Unknown |  |

### organization_relationship_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| internal_relationship_type | Unknown |  |

### organization_qp_executive

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_executive | Unknown |  |

### organization_qp_legislative_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_legislative_data | Unknown |  |

### organization_qp_legislative_profile

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_legislative_profile | Unknown |  |

### organization_qp_legislative

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_legislative | Unknown |  |

### organization_qp_official_document

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_official_document | Unknown |  |

### organization_qp_regulation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_regulation | Unknown |  |

### organization_qp_staffer

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_staffer | Unknown |  |

### organization_qp_state

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_state | Unknown |  |

### organization_ip_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| ip_address | Unknown |  |

### organization_qp_grassroot

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_grassroot | Unknown |  |

### organization_qp_international

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_international | Unknown |  |

### organization_qp_local

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_local | Unknown |  |

### organization_qp_media

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_media | Unknown |  |

### organization_qp_media_relation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| qp_media_relaton | Unknown |  |

### organization_cs_manager

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| id | Unknown |  |

### organization_partner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| partner_id | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| active_client | Unknown |  |
| administrator | Unknown |  |
| agreed_to_texting_user | Unknown |  |
| archived | Unknown |  |
| auto_enrich_supporter | Unknown |  |
| can_see_partners_user | Unknown |  |
| can_use_independent_campaign | Unknown |  |
| created | Unknown |  |
| cs_managers_username | Unknown |  |
| custom_alert_ordering | Json |  |
| custom_session_timeout | Unknown |  |
| date_archived | Unknown |  |
| datetime_agreed_to_texting | Unknown |  |
| default_domain | Unknown |  |
| default_forward_recipient | Unknown |  |
| deliver_supporter_message | Unknown |  |
| deliver_supporter_messages | Unknown |  |
| email_limit | Unknown |  |
| email_limit_percentage | Unknown |  |
| i_360_organization | Unknown |  |
| i_360_organization_and_quorum_client | Unknown |  |
| is_approved | Unknown |  |
| limit_to_cs_manager | Unknown |  |
| log_interaction_json | Json |  |
| lower_tier_bound | Unknown |  |
| max_contact | Unknown |  |
| max_csv_size | Unknown |  |
| max_email_alert | Unknown |  |
| max_member | Unknown |  |
| max_project | Unknown |  |
| max_social_account | Unknown |  |
| name | Unknown |  |
| onboarding_type | Unknown |  |
| outbox_domain_dict | Json |  |
| pacc_company_id | Unknown |  |
| pad_unique_identifier | Unknown |  |
| partner_name | Unknown |  |
| phone_number | Unknown |  |
| qp_action_center | Unknown |  |
| qp_campaign_finance | Unknown |  |
| qp_consultant | Unknown |  |
| qp_contacts_document | Unknown |  |
| qp_custom_contact | Unknown |  |
| qp_custom_data | Unknown |  |
| qp_custom_event | Unknown |  |
| qp_custom_outbox | Unknown |  |
| qp_custom_permission | Unknown |  |
| qp_eu | Unknown |  |
| qp_external_interaction | Unknown |  |
| qp_external_relationship | Unknown |  |
| qp_federal | Unknown |  |
| qp_grass_root | Json |  |
| qp_internal_relationship | Unknown |  |
| qp_international | Json |  |
| qp_legislation_page | Unknown |  |
| qp_live_chat | Unknown |  |
| qp_local | Json |  |
| qp_local_agenda | Unknown |  |
| qp_media_monitoring | Json |  |
| qp_media_relation | Json |  |
| qp_officials_outbox | Unknown |  |
| qp_pac | Unknown |  |
| qp_project_management | Unknown |  |
| qp_stakeholder | Unknown |  |
| qp_unique_ids_in_download | Unknown |  |
| require_issue_on_interaction | Unknown |  |
| require_issue_on_outbox | Unknown |  |
| share_all_custom_region | Unknown |  |
| should_display_grassroots_registration_action | Unknown |  |
| should_limit_editing_notes_to_admins_and_creator | Unknown |  |
| should_org_admin_see_all_org_data | Unknown |  |
| should_share_with_partners_by_default | Unknown |  |
| should_show_only_users_on_team | Unknown |  |
| sms_limit | Unknown |  |
| sms_messages_toward_limit | Unknown |  |
| sso_enabled_for_all_user | Unknown |  |
| sso_profile | Unknown |  |
| subdomain | Unknown |  |
| trial_expiration | Unknown |  |
| unsubscribe_link_text | Unknown |  |
| updated | Unknown |  |
| upper_tier_bound | Unknown |  |
| zapier_token | Unknown |  |

### custom_field_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| user_id | Unknown | FK |
| created | Unknown |  |
| creator | Unknown |  |
| data_type | Unknown |  |
| extra | Json |  |
| name | Unknown |  |
| organization | Unknown |  |
| precedence | Unknown |  |
| resource_uri | Unknown |  |
| updated | Unknown |  |
| users | Unknown |  |

### committee_keyword

| Column | Type | Keys |
| --- | --- | --- |
| keyword_id | Unknown | PK |
| committee_id | Unknown | PK, FK |

### committee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| abbrev | Unknown |  |
| address | Unknown |  |
| chairs_string | Unknown |  |
| code | Unknown |  |
| committee | Unknown |  |
| created | Unknown |  |
| facebook_url_array | Json |  |
| fax | Unknown |  |
| icon | Unknown |  |
| kw_abbrev | Unknown |  |
| meeting_document | Unknown |  |
| name | Unknown |  |
| num_dem_member | Unknown |  |
| num_female_member | Unknown |  |
| num_ind_member | Unknown |  |
| num_male_member | Unknown |  |
| num_member | Unknown |  |
| num_rep_member | Unknown |  |
| parent_committee_abbrev | Unknown |  |
| parent_committee_name | Unknown |  |
| ph_ie_id | Unknown |  |
| ph_lc_org_id | Unknown |  |
| ph_ls_core_organization_id | Unknown |  |
| phone | Unknown |  |
| rank | Unknown |  |
| ranking_members_string | Unknown |  |
| region | Unknown |  |
| search_name | Unknown |  |
| state_name | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| url | Unknown |  |
| url_minority | Unknown |  |
| witnesses | Unknown |  |
| wiw_name | Unknown |  |

### supporter_action_project

| Column | Type | Keys |
| --- | --- | --- |
| project | Unknown | PK, FK |
| supporter_action_id | Unknown | PK, FK |

### supporter_action_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| supporter_action_id | Unknown | PK, FK |
| region | Unknown |  |

### supporter_action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bulk_email_id | Unknown | FK |
| organization_id | Unknown | FK |
| person_id | Unknown | FK |
| supporter_id | Unknown | FK |
| action_center | Unknown |  |
| amount | Unknown |  |
| archived | Unknown |  |
| audit_trail | Json |  |
| cache_json | Json |  |
| call_duration | Unknown |  |
| campaign_id | Unknown |  |
| click | Unknown |  |
| confirmed | Unknown |  |
| created | Unknown |  |
| date | Unknown |  |
| delivered | Unknown |  |
| delivered_timestamp | Unknown |  |
| delivery_id | Unknown |  |
| extra | Json |  |
| failed_delivery | Unknown |  |
| first_open | Unknown |  |
| from_grassroot | Unknown |  |
| http_referer | Unknown |  |
| humanized_text | Unknown |  |
| interaction_type | Unknown |  |
| link_dict | Json |  |
| message_status | Unknown |  |
| note_type | Unknown |  |
| num_attempt | Unknown |  |
| opens | Unknown |  |
| payroll_frequency_type | Unknown |  |
| person | Unknown |  |
| points_earned | Unknown |  |
| raw_content | Unknown |  |
| searchable_date | Unknown |  |
| social_media_type | Unknown |  |
| source_type | Unknown |  |
| subject | Unknown |  |
| submitting_org_name | Unknown |  |
| supporter | Unknown |  |
| text | Unknown |  |
| time_stamp | Json |  |
| transaction_method_type | Unknown |  |
| type | Unknown |  |
| unique_identifier | Unknown |  |
| updated | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |

### municipality

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| extra | Json |  |
| fips_code | Unknown |  |
| full_fips_string | Unknown |  |
| geojson | Unknown |  |
| legislator | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| number_string | Unknown |  |
| population | Unknown |  |
| state_abbrev | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| member | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| archived | Unknown |  |
| defaults | Unknown |  |
| name | Unknown |  |
| organization | Unknown |  |
| resource_uri | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| public_organization | Unknown | FK |
| user_id | Unknown | FK |
| activated | Unknown |  |
| active | Unknown |  |
| address | Unknown |  |
| address_geocoded | Unknown |  |
| alert_cache_override_datetime | Unknown |  |
| alert_cached_data_tag_dict | Json |  |
| alert_cached_field_override_tag_dict | Unknown |  |
| alternate_address | Unknown |  |
| archived | Unknown |  |
| birth_date | Unknown |  |
| bulk_email_unsubscribe_key | Unknown |  |
| cached_limited_to_team | Unknown |  |
| calculated_unsubscribed_from_texting | Unknown |  |
| city | Unknown |  |
| coordinate | Unknown |  |
| country_name | Unknown |  |
| county_name | Unknown |  |
| created | Unknown |  |
| date_unsubscribed_from_bulk_email | Unknown |  |
| date_unsubscribed_from_texting | Unknown |  |
| email | Unknown |  |
| email_related_person | Unknown |  |
| email_related_person_id | Unknown |  |
| employer | Unknown |  |
| extension | Unknown |  |
| extra | Json |  |
| facebook_array | Json |  |
| facebook_url_array | Json |  |
| fax | Unknown |  |
| fb_id | Unknown |  |
| formatted_primary_phone | Unknown |  |
| formatted_secondary_phone | Unknown |  |
| has_ever_received_email_dn | Unknown |  |
| has_participated_in_any_campaign_dn | Unknown |  |
| has_shared_campaign_on_social_dn | Unknown |  |
| http_referer | Unknown |  |
| icon | Unknown |  |
| image_url | Unknown |  |
| input_address | Unknown |  |
| instagram_array | Json |  |
| is_grassroots_supporter | Unknown |  |
| is_recently_active_email_recipient | Unknown |  |
| is_stakeholder_supporter | Unknown |  |
| last_action_date | Unknown |  |
| last_activated_at | Unknown |  |
| last_kind_action | Unknown |  |
| last_user_id | Unknown |  |
| latitude | Unknown |  |
| limited_to_team | Json |  |
| longitude | Unknown |  |
| major_organization_type | Unknown |  |
| medium_array | Json |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| num_action | Unknown |  |
| num_campaigns_interacted | Unknown |  |
| occupation | Unknown |  |
| pac_eligibility | Json |  |
| pacc_individual_id | Unknown |  |
| pacc_organization_id | Unknown |  |
| phone_number | Unknown |  |
| postal_code | Unknown |  |
| postal_code_ext | Unknown |  |
| preferred_name | Unknown |  |
| prefix | Unknown |  |
| public_organization_id | Unknown |  |
| region | Unknown |  |
| registered_with_text_keyword | Unknown |  |
| secondary_email | Unknown |  |
| secondary_extension | Unknown |  |
| secondary_phone | Unknown |  |
| should_display_in_external_logger | Unknown |  |
| source_type | Unknown |  |
| state_abbreviation | Unknown |  |
| state_name | Unknown |  |
| street_address | Unknown |  |
| street_address_2 | Unknown |  |
| stripe_customer_id | Unknown |  |
| suffix | Unknown |  |
| supporter_type | Unknown |  |
| tag_dict | Json |  |
| title | Unknown |  |
| twitter_array | Json |  |
| unique_identifier | Unknown |  |
| unsubscribed_from_bulk_email | Unknown |  |
| unsubscribed_from_texting | Unknown |  |
| updated | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| valid_email | Unknown |  |
| waiting_to_be_created_by_user | Unknown |  |
| website | Unknown |  |
| work_fax | Unknown |  |
| work_phone | Unknown |  |
| youtube_array | Json |  |

### email_cached_limited_to_team

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| email_id | Unknown | PK, FK |
| cached_limited_to_team | Unknown |  |

### email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bulk_email_id | Unknown | FK |
| person_id | Unknown | FK |
| supporter_id | Unknown | FK |
| alert_cache | Json |  |
| archived | Unknown |  |
| bounce | Unknown |  |
| click | Unknown |  |
| contact_organization | Unknown |  |
| created | Unknown |  |
| did_reply | Unknown |  |
| email_address | Unknown |  |
| email_alert | Unknown |  |
| external_id | Unknown |  |
| extra | Json |  |
| first_click | Unknown |  |
| first_open | Unknown |  |
| initial_open | Unknown |  |
| instant | Unknown |  |
| link_dict | Json |  |
| medium | Unknown |  |
| opens | Unknown |  |
| person_primary_organization | Unknown |  |
| person_type | Unknown |  |
| push_notification_error_enum | Unknown |  |
| push_notification_error_info | Unknown |  |
| push_notification_error_status_code | Unknown |  |
| push_notification_extra | Json |  |
| rcpt_dict_address_email | Unknown |  |
| rcpt_dict_address_name | Unknown |  |
| rcpt_dict_has_gr_link | Unknown |  |
| rcpt_dict_substitution_data | Json |  |
| recipient_name | Unknown |  |
| sent | Unknown |  |
| sent_datetime | Unknown |  |
| sparkpost_id | Unknown |  |
| sparkpost_reject_reason | Unknown |  |
| sparkpost_status | Unknown |  |
| staffer_id | Unknown |  |
| text | Unknown |  |
| title | Unknown |  |
| transmission_id | Unknown |  |
| updated | Unknown |  |
| view_in_browser_id | Unknown |  |
| was_imported | Unknown |  |

### bill_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | FK |
| content | Unknown |  |
| extra | Json |  |
| resource_uri | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| source_committee_id | Unknown | FK |
| address | Unknown |  |
| alert_cache | Json |  |
| amendment_mention | Json |  |
| archived | Unknown |  |
| availability | Unknown |  |
| bill_mention | Json |  |
| chamber | Unknown |  |
| committee_mention | Unknown |  |
| created | Unknown |  |
| cspan_channel | Unknown |  |
| cspan_id | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| end_time | Unknown |  |
| event_subtype | Unknown |  |
| event_type | Unknown |  |
| expected_number_of_transcript | Unknown |  |
| extra | Json |  |
| extra_info | Json |  |
| fact_squared_meeting_status | Unknown |  |
| fact_squared_slug | Unknown |  |
| full_transcript_url | Unknown |  |
| is_cancelled | Unknown |  |
| is_custom_all_day_event | Unknown |  |
| issue_mention | Json |  |
| local_video_path | Unknown |  |
| location | Unknown |  |
| meeting_video_pipeline_status | Unknown |  |
| occured_date | Unknown |  |
| original_content | Unknown |  |
| original_number_of_transcript | Unknown |  |
| person_mention | Json |  |
| plain_subject | Unknown |  |
| point_person | Unknown |  |
| point_person_name | Unknown |  |
| region | Unknown |  |
| related_document | Json |  |
| revai_job_id | Unknown |  |
| search_date | Unknown |  |
| sequence_time_cache | Unknown |  |
| source_url | Unknown |  |
| source_video_url | Unknown |  |
| sponsoring_organization | Unknown |  |
| sponsoring_organization_name | Unknown |  |
| status | Unknown |  |
| status_text | Unknown |  |
| subject | Unknown |  |
| transcript_s_3_file_name | Unknown |  |
| transcription_pipeline_history_download_ended | Json |  |
| transcription_pipeline_history_download_error | Json |  |
| transcription_pipeline_history_no_source_video_url | Json |  |
| transcription_pipeline_history_parsing_transcription_ended | Json |  |
| transcription_pipeline_history_parsing_transcription_error | Json |  |
| transcription_pipeline_history_source_video_url_added | Json |  |
| transcription_pipeline_history_transcription_ended | Json |  |
| transcription_pipeline_history_transcription_error | Json |  |
| transcription_pipeline_history_transcription_in_progress | Json |  |
| transcription_pipeline_history_transcription_sending_error | Json |  |
| transcription_pipeline_history_transcription_sending_started | Json |  |
| updated | Unknown |  |
| user_id | Unknown |  |
| video_url | Unknown |  |
| vote_mention | Json |  |
| witness | Json |  |

### person_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| adascore | Unknown |  |
| address | Unknown |  |
| aflscore | Unknown |  |
| appointed_by_type | Unknown |  |
| ccusscore | Unknown |  |
| cfgscore | Unknown |  |
| comstaffer_type | Unknown |  |
| created | Unknown |  |
| current | Unknown |  |
| district | Unknown |  |
| district_char | Unknown |  |
| district_obj | Unknown |  |
| electcode | Unknown |  |
| end_date | Unknown |  |
| extra | Json |  |
| intrado_preferred_distribution_mode | Unknown |  |
| intrado_tag | Json |  |
| is_primary_from_source | Unknown |  |
| lastelection | Unknown |  |
| leadership_title | Unknown |  |
| lower_district_obj | Unknown |  |
| major_person_type | Unknown |  |
| minor_person_type | Unknown |  |
| office | Unknown |  |
| office_building | Unknown |  |
| office_city | Unknown |  |
| office_country | Unknown |  |
| office_room | Unknown |  |
| office_state | Unknown |  |
| office_street_1 | Unknown |  |
| office_street_2 | Unknown |  |
| office_zipcode | Unknown |  |
| party | Unknown |  |
| party_name | Unknown |  |
| pay_scale_type | Unknown |  |
| person_id | Unknown |  |
| ph_intrado_last_updated | Unknown |  |
| ph_lc_position_id | Unknown |  |
| ph_ls_state_legislator_staff_history_id | Unknown |  |
| ph_nominated_date | Unknown |  |
| ph_nomination_confirmed_date | Unknown |  |
| ph_public_organization_desc | Unknown |  |
| ph_region_represented | Unknown |  |
| ph_term_number | Unknown |  |
| phone | Unknown |  |
| reelection_year | Unknown |  |
| region | Unknown |  |
| resource_uri | Unknown |  |
| role_type | Unknown |  |
| senator_class | Unknown |  |
| senator_rank | Unknown |  |
| specific_person_type | Unknown |  |
| start_date | Unknown |  |
| state_obj | Unknown |  |
| status | Unknown |  |
| updated | Unknown |  |
| upper_district_obj | Unknown |  |
| website | Unknown |  |

### bill_sponsor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_id | Unknown | FK |
| committee_id | Unknown | FK |
| amendment | Unknown |  |
| created | Unknown |  |
| extra | Json |  |
| joined | Unknown |  |
| party | Unknown |  |
| person | Unknown |  |
| sponsor_icon | Unknown |  |
| sponsor_image_url | Unknown |  |
| sponsor_name | Unknown |  |
| sponsor_type | Unknown |  |
| sponsor_url | Unknown |  |
| state_name | Unknown |  |
| updated | Unknown |  |
| withdrawn | Unknown |  |

### county

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| executive | Unknown |  |
| extra | Json |  |
| fips_code | Unknown |  |
| full_fips_string | Unknown |  |
| geojson | Unknown |  |
| legislator | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| number_string | Unknown |  |
| population | Unknown |  |
| state_abbrev | Unknown |  |

### all_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### yea_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### missed_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### nay_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### other_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### present_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| related_bill_id | Unknown | FK |
| alert_cache | Json |  |
| category | Unknown |  |
| chamber | Unknown |  |
| congress_number | Unknown |  |
| created | Unknown |  |
| democrat_result | Unknown |  |
| display_name | Unknown |  |
| extra | Json |  |
| fts_index | Unknown |  |
| icon | Unknown |  |
| majority_result | Unknown |  |
| missing_data | Unknown |  |
| newly_index | Unknown |  |
| number | Unknown |  |
| openstates_id | Unknown |  |
| original_question | Unknown |  |
| question | Unknown |  |
| question_details | Unknown |  |
| region | Unknown |  |
| region_session | Unknown |  |
| related_amendment | Unknown |  |
| republican_result | Unknown |  |
| required | Unknown |  |
| result | Unknown |  |
| result_type | Unknown |  |
| session | Unknown |  |
| source | Unknown |  |
| source_link | Unknown |  |
| total_abstain | Unknown |  |
| total_all | Unknown |  |
| total_dem_abstain | Unknown |  |
| total_dem_all | Unknown |  |
| total_dem_minus | Unknown |  |
| total_dem_other | Unknown |  |
| total_dem_plus | Unknown |  |
| total_minus | Unknown |  |
| total_other | Unknown |  |
| total_plus | Unknown |  |
| total_rep_abstain | Unknown |  |
| total_rep_all | Unknown |  |
| total_rep_minus | Unknown |  |
| total_rep_other | Unknown |  |
| total_rep_plus | Unknown |  |
| type | Unknown |  |
| voted_against_majority | Unknown |  |

### note_article

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| note_id | Unknown | PK, FK |
| article | Unknown |  |

### note_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| note_id | Unknown | PK, FK |
| region | Unknown |  |

### note_cache_vote

| Column | Type | Keys |
| --- | --- | --- |
| note_id | Unknown | PK, FK |
| vote_id | Unknown | PK, FK |

### note_project

| Column | Type | Keys |
| --- | --- | --- |
| note_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |

### note_limited_team

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| note_id | Unknown | PK, FK |
| team | Unknown |  |

### note_cache_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |
| region | Unknown |  |
| title | Unknown |  |

### note_team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| amendment_id | Unknown | FK |
| bill_id | Unknown | FK |
| bulk_email_id | Unknown | FK |
| event_id | Unknown | FK |
| organization_id | Unknown | FK |
| person_id | Unknown | FK |
| project_id | Unknown | FK |
| supporter_id | Unknown | FK |
| user_id | Unknown | FK |
| vote_id | Unknown | FK |
| alert_cache | Json |  |
| amendment | Unknown |  |
| amount | Unknown |  |
| archived | Unknown |  |
| attachemnt_id | Unknown |  |
| audit_trail | Json |  |
| auto_created | Unknown |  |
| bill | Unknown |  |
| bulk_email | Unknown |  |
| cache_json_amendment | Json |  |
| cache_json_article | Json |  |
| cache_json_attachment | Json |  |
| cache_json_campaign | Json |  |
| cache_json_comment_type | Unknown |  |
| cache_json_comment_type_string | Unknown |  |
| cache_json_date | Unknown |  |
| cache_json_date_with_tz | Unknown |  |
| cache_json_document | Json |  |
| cache_json_from_grassroot | Unknown |  |
| cache_json_id | Unknown |  |
| cache_json_initial | Unknown |  |
| cache_json_is_comment | Unknown |  |
| cache_json_is_interaction | Unknown |  |
| cache_json_is_private | Unknown |  |
| cache_json_is_relationship | Unknown |  |
| cache_json_member | Json |  |
| cache_json_mention | Json |  |
| cache_json_note_type | Unknown |  |
| cache_json_object_description | Unknown |  |
| cache_json_object_id | Unknown |  |
| cache_json_object_title | Unknown |  |
| cache_json_organization_id | Unknown |  |
| cache_json_privacy | Unknown |  |
| cache_json_project | Json |  |
| cache_json_public_organization | Json |  |
| cache_json_regulation | Json |  |
| cache_json_social_media_type | Unknown |  |
| cache_json_supporter | Json |  |
| cache_json_team | Json |  |
| cache_json_user_id | Unknown |  |
| cache_json_vote | Json |  |
| campaign | Unknown |  |
| check_number | Unknown |  |
| click | Unknown |  |
| comment_type | Unknown |  |
| confirmed | Unknown |  |
| created | Unknown |  |
| custom_interaction_type | Unknown |  |
| data_type | Unknown |  |
| date | Unknown |  |
| delivered | Unknown |  |
| delivery_id | Unknown |  |
| doument_id | Unknown |  |
| duration | Unknown |  |
| extra | Json |  |
| failed_delivery | Unknown |  |
| first_open | Unknown |  |
| from_grassroot | Unknown |  |
| from_note | Unknown |  |
| from_parser | Unknown |  |
| from_qnote | Unknown |  |
| frozen_cache_json | Json |  |
| http_referer | Unknown |  |
| humanized_text | Unknown |  |
| ical_id | Unknown |  |
| icon | Unknown |  |
| interaction_type | Unknown |  |
| is_ical | Unknown |  |
| is_visible_to_partner | Unknown |  |
| link_dict | Json |  |
| members_count | Unknown |  |
| message | Unknown |  |
| message_status | Unknown |  |
| note_type | Unknown |  |
| num_attempt | Unknown |  |
| opens | Unknown |  |
| person | Unknown |  |
| privacy | Unknown |  |
| public_organizations_count | Unknown |  |
| raw_content | Unknown |  |
| relationship_status | Unknown |  |
| relationship_type | Unknown |  |
| searchable_date | Unknown |  |
| social_media_type | Unknown |  |
| source_type | Unknown |  |
| subject | Unknown |  |
| submitting_org_name | Unknown |  |
| supporter_action_type | Unknown |  |
| supporters_count | Unknown |  |
| tag_dict | Json |  |
| team_members_count | Unknown |  |
| text | Unknown |  |
| text_with_html | Unknown |  |
| time_stamp | Json |  |
| unique_identifier | Unknown |  |
| updated | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |

### people_ph_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| region_code | Unknown |  |

### people_ph_major_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| major_role | Unknown |  |

### people_ph_meta_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| meta_role | Unknown |  |

### people_ph_minor_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| minor_role | Unknown |  |

### people_ph_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| language_code | Unknown |  |

### people_ph_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| tag_id | Unknown |  |

### people_ph_source_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| source_url | Unknown |  |

### people_dn_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| type | Unknown |  |

### people_dn_scale_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| scale_type | Unknown |  |

### people_major_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| type | Unknown |  |

### people_minor_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| type | Unknown |  |

### people_recent_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| region | Unknown |  |

### people_specific_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| type | Unknown |  |

### people_staffer_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| official_staffer_id | Unknown | PK, FK |
| type | Unknown |  |

### official_staffer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| committee_id | Unknown | FK |
| most_recent_role_id | Unknown | FK |
| address | Unknown |  |
| age | Unknown |  |
| birthday | Unknown |  |
| committee_string | Unknown |  |
| comstaffertype | Unknown |  |
| congressional_district_kw_id | Unknown |  |
| cook_pvi | Unknown |  |
| current | Unknown |  |
| email | Unknown |  |
| extra | Json |  |
| facebook_url | Unknown |  |
| firstname | Unknown |  |
| freshman_legislator | Unknown |  |
| gender | Unknown |  |
| has_been_legislator | Unknown |  |
| high_quality_image_url | Unknown |  |
| image_url | Unknown |  |
| intrado_other_email | Unknown |  |
| is_cwc | Unknown |  |
| lastname | Unknown |  |
| legislator_id | Unknown |  |
| linkedin_username | Unknown |  |
| location | Unknown |  |
| lower_district_kw_id | Unknown |  |
| member_name | Unknown |  |
| most_recent_country | Unknown |  |
| most_recent_executive_role | Unknown |  |
| most_recent_party | Unknown |  |
| most_recent_person_type | Unknown |  |
| most_recent_role_address | Unknown |  |
| most_recent_role_building | Unknown |  |
| most_recent_role_city | Unknown |  |
| most_recent_role_phone | Unknown |  |
| most_recent_role_room | Unknown |  |
| most_recent_role_state | Unknown |  |
| most_recent_role_street_1 | Unknown |  |
| most_recent_role_street_2 | Unknown |  |
| most_recent_role_type | Unknown |  |
| most_recent_role_zipcode | Unknown |  |
| name | Unknown |  |
| new_legislator | Unknown |  |
| num_term | Unknown |  |
| office_code | Unknown |  |
| party_string | Unknown |  |
| person | Unknown |  |
| ph_dn_intrado_preferred_distribution_mode | Unknown |  |
| ph_intrado_last_updated | Unknown |  |
| ph_intrado_person_id | Unknown |  |
| ph_lc_person_id | Unknown |  |
| ph_ls_core_person_id | Unknown |  |
| ph_should_flush_next_run | Unknown |  |
| precedence_local | Unknown |  |
| precedence_state | Unknown |  |
| precedence_state_and_local | Unknown |  |
| prefix | Unknown |  |
| primary_organization | Unknown |  |
| pronunciation | Unknown |  |
| public_organization_descriptor | Unknown |  |
| region_represented | Unknown |  |
| resource_uri | Unknown |  |
| responsibilities_string | Unknown |  |
| should_deliver_via_fill_form | Unknown |  |
| show_in_quicksearch | Unknown |  |
| staffer_name | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| titlecode_order | Unknown |  |
| twitter_id | Unknown |  |
| upper_district_kw_id | Unknown |  |
| valid_email | Unknown |  |
| wikipedia_url | Unknown |  |

### bill_achieved_status

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bill_id | Unknown | PK, FK |
| id | Unknown |  |

### bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| achieved_general_statuses | Unknown |  |
| committee | Unknown |  |
| current_general_status | Unknown |  |
| current_status | Unknown |  |
| current_status_date | Unknown |  |
| current_status_text | Unknown |  |
| draft_number | Unknown |  |
| executive | Unknown |  |
| extra | Json |  |
| introduced_date | Unknown |  |
| is_approp | Unknown |  |
| label | Unknown |  |
| last_action_text | Unknown |  |
| major_action | Json |  |
| most_recent_action_date | Unknown |  |
| num_democrat_co_sponsor | Unknown |  |
| num_female_co_sponsor | Unknown |  |
| num_independent_co_sponsor | Unknown |  |
| num_male_co_sponsor | Unknown |  |
| num_repubilican_co_sponsor | Unknown |  |
| number | Unknown |  |
| procedure_code | Unknown |  |
| public_law_number | Unknown |  |
| region | Unknown |  |
| session | Unknown |  |
| slug | Unknown |  |
| snippet | Json |  |
| source_link | Unknown |  |
| sponsor | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

## Relationships

- custom_field_limited_to_team(custom_field_id) → custom_field(id)
- custom_field(group_id) → custom_field_group(id)
- custom_field(organization_id) → organization(id)
- issue_management_search_term(issue_management_id) → issue_management(id)
- issue_management_category(issue_management_id) → issue_management(id)
- issue_management_magic_board(issue_management_id) → issue_management(id)
- issue_management_team(team_id) → team(id)
- issue_management_team(issue_management_id) → issue_management(id)
- issue_management_organization(oragnization_id) → organization(id)
- issue_management_organization(issue_management_id) → issue_management(id)
- issue_management_participant(issue_management_id) → issue_management(id)
- issue_management(creator_id) → users(id)
- bulk_email_search_param_dehydrate(bulk_email_id) → bulk_email(id)
- bulk_email_search_param_dehydrate(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_search_param_dehydrate(_fivetran_id) → bulk_email_search_param(_fivetran_id)
- bulk_email_search_param_most_recent(bulk_email_id) → bulk_email(id)
- bulk_email_search_param_most_recent(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_search_param_most_recent(_fivetran_id) → bulk_email_search_param(_fivetran_id)
- bulk_email_search_param_minor_role(bulk_email_id) → bulk_email(id)
- bulk_email_search_param_minor_role(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_search_param_minor_role(_fivetran_id) → bulk_email_search_param(_fivetran_id)
- bulk_email_search_param_staffer_chamber(bulk_email_id) → bulk_email(id)
- bulk_email_search_param_staffer_chamber(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_search_param_staffer_chamber(_fivetran_id) → bulk_email_search_param(_fivetran_id)
- bulk_email_search_param_added_id(bulk_email_id) → bulk_email(id)
- bulk_email_search_param_added_id(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_search_param_added_id(_fivetran_id) → bulk_email_search_param(_fivetran_id)
- bulk_email_search_param(bulk_email_id) → bulk_email(id)
- bulk_email_search_param(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_region(bulk_email_id) → bulk_email(id)
- bulk_email_region(bulk_email_data_id) → bulk_email_data(id)
- bulk_email_data(bulk_email_id) → bulk_email(id)
- bulk_email(user_id) → users(id)
- message_event(bulk_email_id) → bulk_email(id)
- bill_amendment_sponsor(sponsor) → bill_sponsor(id)
- bill_amendment_sponsor(bill_amendment_id) → bill_amendment(id)
- bill_amendment_text(bill_amendment_id) → bill_amendment(id)
- bill_amendment(bill) → bill(id)
- users_current_region(users_id) → users(id)
- users_other_persona(users_id) → users(id)
- users_permissioned_region(users_id) → users(id)
- users_search_data_type_order(users_id) → users(id)
- users_sidebar_setting_list(users_id) → users(id)
- users(user_info_organization_id) → organization(id)
- organization_allowed_user_domain(organization_id) → organization(id)
- organization_allowed_domain(organization_id) → organization(id)
- organization_interaction_type(organization_id) → organization(id)
- organization_relationship_type(organization_id) → organization(id)
- organization_qp_executive(organization_id) → organization(id)
- organization_qp_legislative_data(organization_id) → organization(id)
- organization_qp_legislative_profile(organization_id) → organization(id)
- organization_qp_legislative(organization_id) → organization(id)
- organization_qp_official_document(organization_id) → organization(id)
- organization_qp_regulation(organization_id) → organization(id)
- organization_qp_staffer(organization_id) → organization(id)
- organization_qp_state(organization_id) → organization(id)
- organization_ip_address(organization_id) → organization(id)
- organization_qp_grassroot(organization_id) → organization(id)
- organization_qp_international(organization_id) → organization(id)
- organization_qp_local(organization_id) → organization(id)
- organization_qp_media(organization_id) → organization(id)
- organization_qp_media_relation(organization_id) → organization(id)
- organization_cs_manager(organization_id) → organization(id)
- organization_partner(organization_id) → organization(id)
- custom_field_group(user_id) → users(id)
- custom_field_group(organization_id) → organization(id)
- committee_keyword(committee_id) → committee(id)
- supporter_action_project(project) → issue_management(id)
- supporter_action_project(supporter_action_id) → supporter_action(id)
- supporter_action_region(supporter_action_id) → supporter_action(id)
- supporter_action(bulk_email_id) → bulk_email(id)
- supporter_action(person_id) → official_staffer(id)
- supporter_action(organization_id) → organization(id)
- supporter_action(supporter_id) → contact(id)
- team_member(team_id) → team(id)
- team(organization_id) → organization(id)
- contact(user_id) → users(id)
- contact(public_organization) → organization(id)
- email_cached_limited_to_team(email_id) → email(id)
- email(supporter_id) → contact(id)
- email(bulk_email_id) → bulk_email(id)
- email(person_id) → official_staffer(id)
- bill_summary(bill_id) → bill(id)
- event(organization_id) → organization(id)
- event(source_committee_id) → committee(id)
- bill_sponsor(committee_id) → committee(id)
- bill_sponsor(bill_id) → bill(id)
- all_vote(id) → official_staffer(id)
- all_vote(vote_id) → vote(id)
- yea_vote(id) → official_staffer(id)
- yea_vote(vote_id) → vote(id)
- missed_vote(id) → official_staffer(id)
- missed_vote(vote_id) → vote(id)
- nay_vote(id) → official_staffer(id)
- nay_vote(vote_id) → vote(id)
- other_vote(id) → official_staffer(id)
- other_vote(vote_id) → vote(id)
- present_vote(id) → official_staffer(id)
- present_vote(vote_id) → vote(id)
- vote(related_bill_id) → bill(id)
- note_article(note_id) → note(id)
- note_region(note_id) → note(id)
- note_cache_vote(vote_id) → vote(id)
- note_cache_vote(note_id) → note(id)
- note_project(project_id) → issue_management(id)
- note_project(note_id) → note(id)
- note_limited_team(note_id) → note(id)
- note_cache_bill(id) → bill(id)
- note_cache_bill(note_id) → note(id)
- note_team_member(id) → users(id)
- note_team_member(note_id) → note(id)
- note(event_id) → event(id)
- note(user_id) → users(id)
- note(supporter_id) → contact(id)
- note(amendment_id) → bill_amendment(id)
- note(vote_id) → vote(id)
- note(bill_id) → bill(id)
- note(bulk_email_id) → bulk_email(id)
- note(person_id) → official_staffer(id)
- note(organization_id) → organization(id)
- note(project_id) → issue_management(id)
- people_ph_region(official_staffer_id) → official_staffer(id)
- people_ph_major_role(official_staffer_id) → official_staffer(id)
- people_ph_meta_role(official_staffer_id) → official_staffer(id)
- people_ph_minor_role(official_staffer_id) → official_staffer(id)
- people_ph_language(official_staffer_id) → official_staffer(id)
- people_ph_tag(official_staffer_id) → official_staffer(id)
- people_ph_source_url(official_staffer_id) → official_staffer(id)
- people_dn_type(official_staffer_id) → official_staffer(id)
- people_dn_scale_type(official_staffer_id) → official_staffer(id)
- people_major_type(official_staffer_id) → official_staffer(id)
- people_minor_type(official_staffer_id) → official_staffer(id)
- people_recent_region(official_staffer_id) → official_staffer(id)
- people_specific_type(official_staffer_id) → official_staffer(id)
- people_staffer_type(official_staffer_id) → official_staffer(id)
- official_staffer(committee_id) → committee(id)
- official_staffer(most_recent_role_id) → person_role(id)
- bill_achieved_status(bill_id) → bill(id)