Quorum

Explore the interactive ERD

Table & Field Reference

custom_field_limited_to_team

Column	Type	Keys
`team_id`	Unknown	PK
`custom_field_id`	Unknown	PKFK

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	PKFK
`term`	Unknown

issue_management_category

Column	Type	Keys
`index`	Unknown	PK
`issue_management_id`	Unknown	PKFK
`category`	Unknown

issue_management_magic_board

Column	Type	Keys
`index`	Unknown	PK
`issue_management_id`	Unknown	PKFK
`magic_board`	Unknown

issue_management_team

Column	Type	Keys
`issue_management_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

issue_management_organization

Column	Type	Keys
`issue_management_id`	Unknown	PKFK
`oragnization_id`	Unknown	PKFK

issue_management_participant

Column	Type	Keys
`participant_id`	Unknown	PK
`issue_management_id`	Unknown	PKFK

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	PKFK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`name`	Unknown

bulk_email_search_param_most_recent

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`param`	Unknown

bulk_email_search_param_minor_role

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`id`	Unknown

bulk_email_search_param_staffer_chamber

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`id`	Unknown

bulk_email_search_param_added_id

Column	Type	Keys
`index`	Unknown	PK
`_fivetran_id`	Unknown	PKFK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`id`	Unknown

bulk_email_search_param

Column	Type	Keys
`_fivetran_id`	String	PK
`bulk_email_data_id`	Unknown	PKFK
`bulk_email_id`	Unknown	PKFK
`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	PKFK
`bulk_email_id`	Unknown	PKFK
`region`	Unknown

bulk_email_data

Column	Type	Keys
`id`	Unknown	PK
`bulk_email_id`	Unknown	PKFK
`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	PKFK
`sponsor`	Unknown	PKFK

bill_amendment_text

Column	Type	Keys
`text`	Unknown	PK
`bill_amendment_id`	Unknown	PKFK

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	PKFK
`current_region`	Unknown

users_other_persona

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`other_personas`	Unknown

users_permissioned_region

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`permissioned_region`	Unknown

users_search_data_type_order

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`search_data_type_order`	Unknown

users_sidebar_setting_list

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`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	PKFK
`domain`	Unknown

organization_interaction_type

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`internal_interaction_type`	Unknown

organization_relationship_type

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`internal_relationship_type`	Unknown

organization_qp_executive

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_executive`	Unknown

organization_qp_legislative_data

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_legislative_data`	Unknown

organization_qp_legislative_profile

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_legislative_profile`	Unknown

organization_qp_legislative

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_legislative`	Unknown

organization_qp_official_document

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_official_document`	Unknown

organization_qp_regulation

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_regulation`	Unknown

organization_qp_staffer

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_staffer`	Unknown

organization_qp_state

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_state`	Unknown

organization_ip_address

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`ip_address`	Unknown

organization_qp_grassroot

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_grassroot`	Unknown

organization_qp_international

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_international`	Unknown

organization_qp_local

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_local`	Unknown

organization_qp_media

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_media`	Unknown

organization_qp_media_relation

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`qp_media_relaton`	Unknown

organization_cs_manager

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`id`	Unknown

organization_partner

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`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	PKFK

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	PKFK
`supporter_action_id`	Unknown	PKFK

supporter_action_region

Column	Type	Keys
`index`	Unknown	PK
`supporter_action_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`vote_id`	Unknown	PKFK

yea_vote

Column	Type	Keys
`id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

missed_vote

Column	Type	Keys
`id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

nay_vote

Column	Type	Keys
`id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

other_vote

Column	Type	Keys
`id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

present_vote

Column	Type	Keys
`id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

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	PKFK
`article`	Unknown

note_region

Column	Type	Keys
`index`	Unknown	PK
`note_id`	Unknown	PKFK
`region`	Unknown

note_cache_vote

Column	Type	Keys
`note_id`	Unknown	PKFK
`vote_id`	Unknown	PKFK

note_project

Column	Type	Keys
`note_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

note_limited_team

Column	Type	Keys
`index`	Unknown	PK
`note_id`	Unknown	PKFK
`team`	Unknown

note_cache_bill

Column	Type	Keys
`id`	Unknown	PKFK
`note_id`	Unknown	PKFK
`region`	Unknown
`title`	Unknown

note_team_member

Column	Type	Keys
`id`	Unknown	PKFK
`note_id`	Unknown	PKFK
`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	PKFK
`region_code`	Unknown

people_ph_major_role

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`major_role`	Unknown

people_ph_meta_role

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`meta_role`	Unknown

people_ph_minor_role

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`minor_role`	Unknown

people_ph_language

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`language_code`	Unknown

people_ph_tag

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`tag_id`	Unknown

people_ph_source_url

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`source_url`	Unknown

people_dn_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`type`	Unknown

people_dn_scale_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`scale_type`	Unknown

people_major_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`type`	Unknown

people_minor_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`type`	Unknown

people_recent_region

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`region`	Unknown

people_specific_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`type`	Unknown

people_staffer_type

Column	Type	Keys
`index`	Unknown	PK
`official_staffer_id`	Unknown	PKFK
`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	PKFK
`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