# GoFundMe Pro schema ERD

Table and field reference for the Fivetran GoFundMe Pro connector.

## Table & Field Reference

### ticket_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| commitment_deadline | Unknown |  |
| commitment_id | Unknown |  |
| commitment_value | Unknown |  |
| created_at | Unknown |  |
| deductible_amount | Unknown |  |
| deductible_percent | Unknown |  |
| description | Unknown |  |
| ended_at | Unknown |  |
| entries_per_ticket | Unknown |  |
| is_active | Unknown |  |
| is_classy_mode | Unknown |  |
| max_per_transaction | Unknown |  |
| min_per_transaction | Unknown |  |
| name | Unknown |  |
| org_percent | Unknown |  |
| price | Unknown |  |
| quantity_available | Unknown |  |
| quantity_reserved | Unknown |  |
| quantity_sold | Unknown |  |
| started_at | Unknown |  |
| updated_at | Unknown |  |
| weight | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| allow_download_annual_receipts | Unknown |  |
| are_activity_feeds_disabled | Unknown |  |
| background_color | Unknown |  |
| background_image | Unknown |  |
| background_image_asset_id | Unknown |  |
| background_image_style | Unknown |  |
| billing_provider_name | Unknown |  |
| canceled_at | Unknown |  |
| city | Unknown |  |
| classy_fee_percent | Unknown |  |
| classy_subscription_plan_id | Unknown |  |
| contact_first_name | Unknown |  |
| contact_last_name | Unknown |  |
| contact_phone | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| ein | Unknown |  |
| email_address | Unknown |  |
| facebook | Unknown |  |
| favicon | Unknown |  |
| favicon_asset_id | Unknown |  |
| fixed_fot_percent | Unknown |  |
| flex_rate_percent | Unknown |  |
| gfm_charity_community_id | Unknown |  |
| gfm_connect_banner_count | Unknown |  |
| gfm_connect_banner_dismissed_at | Unknown |  |
| gfm_npo_page_slug | Unknown |  |
| has_double_the_donation_employer_match | Unknown |  |
| has_double_the_donation_enployer_match | Unknown |  |
| has_employer_match | Unknown |  |
| has_gfm_npo_transactions | Unknown |  |
| header_background_image | Unknown |  |
| header_background_image_asset_id | Unknown |  |
| header_color | Unknown |  |
| header_footer_color | Unknown |  |
| header_image | Unknown |  |
| header_image_asset_id | Unknown |  |
| header_image_height | Unknown |  |
| header_image_style | Unknown |  |
| hero_image_asset_id | Unknown |  |
| hide_classy_logo | Unknown |  |
| is_gfm_npo_page_claimed | Unknown |  |
| is_gift_aid_available | Unknown |  |
| logo_id | Unknown |  |
| mission | Unknown |  |
| name | Unknown |  |
| opt_in_wording | Unknown |  |
| past_due_at | Unknown |  |
| payment_provider_id | Unknown |  |
| payment_provider_name | Unknown |  |
| plan_name | Unknown |  |
| plan_type | Unknown |  |
| postal_code | Unknown |  |
| primary_color | Unknown |  |
| resend_receipt_flag | Unknown |  |
| restricted_country_information | Unknown |  |
| secondary_color | Unknown |  |
| show_donation_stats_on_home_page | Unknown |  |
| show_donation_stats_on_rgp | Unknown |  |
| signature_id | Unknown |  |
| signature_name | Unknown |  |
| signature_title | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| tax_identifier | Unknown |  |
| thumbnail | Unknown |  |
| timezone_identifier | Unknown |  |
| twitter | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| welcome_message | Unknown |  |

### question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| is_required | Unknown |  |
| label | Unknown |  |
| location | Unknown |  |
| product_id | Unknown |  |
| tags | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| weight | Unknown |  |

### fundraising_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| designation_id | Unknown | FK |
| organization_id | Unknown | FK |
| parent_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| cover_photo | Unknown |  |
| cover_photo_id | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| description | Unknown |  |
| goal | Unknown |  |
| logo_id | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_goal | Unknown |  |
| root_id | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| team_lead_id | Unknown |  |
| team_lead_supporter_id | Unknown |  |
| team_policy_id | Unknown |  |
| thank_you_text | Unknown |  |
| updated_at | Unknown |  |

### dedication

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| ecard_campaign_id | Unknown | FK |
| transaction_id | Unknown | FK |
| address | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| ecard_asset_id | Unknown |  |
| ecard_id | Unknown |  |
| ecard_is_deleted | Unknown |  |
| ecard_message | Unknown |  |
| ecard_order | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| honoree_first_name | Unknown |  |
| honoree_last_name | Unknown |  |
| honoree_name | Unknown |  |
| is_gift_amount_msg_included | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| additional_configurations | Json |  |
| channel_integration_details_id | Unknown |  |
| channel_name | Unknown |  |
| disabled_at | Unknown |  |
| feature_tier | Unknown |  |
| status | Unknown |  |
| step_status_authorize_granted | Unknown |  |
| step_status_granted_fundraiser_permission | Unknown |  |

### recurring_donation_plan_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| recurring_donation_plan_id | Unknown | PK, FK |
| day | Unknown |  |
| mmdd | Unknown |  |
| month | Unknown |  |

### recurring_donation_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| designation_id | Unknown | FK |
| fundraising_page_id | Unknown | FK |
| fundraising_team_id | Unknown | FK |
| organization_id | Unknown | FK |
| supporter_id | Unknown | FK |
| ach_last_four | Unknown |  |
| address | Unknown |  |
| address_2 | Unknown |  |
| applied_application_fee_percent | Unknown |  |
| applied_flex_rate_percent | Unknown |  |
| applied_fot_percent | Unknown |  |
| applied_processor_fee_percent | Unknown |  |
| applied_raw_processor_fee_flat | Unknown |  |
| cancel_by | Unknown |  |
| cancel_reason_code | Unknown |  |
| cancel_reason_text | Unknown |  |
| canceled_at | Unknown |  |
| cc_card_exp | Unknown |  |
| cc_last_four | Unknown |  |
| cc_type | Unknown |  |
| city | Unknown |  |
| classy_mode_enabled | Unknown |  |
| classy_pay_app_id | Unknown |  |
| classy_pay_recurring_amount | Unknown |  |
| classy_pay_recurring_created_date | Unknown |  |
| classy_pay_recurring_currency | Unknown |  |
| classy_pay_recurring_descriptor | Unknown |  |
| classy_pay_recurring_fot | Unknown |  |
| classy_pay_recurring_history_created_date | Unknown |  |
| classy_pay_recurring_history_id | Unknown |  |
| classy_pay_recurring_history_state | Unknown |  |
| classy_pay_recurring_history_state_detail_action | Unknown |  |
| classy_pay_recurring_history_state_detail_by | Unknown |  |
| classy_pay_recurring_history_state_detail_should_process_date | Unknown |  |
| classy_pay_recurring_id | Unknown |  |
| classy_pay_recurring_last_modified_date | Unknown |  |
| classy_pay_recurring_migrated | Unknown |  |
| classy_pay_recurring_next_processing_date | Unknown |  |
| classy_pay_recurring_recur_until | Unknown |  |
| classy_pay_recurring_recurring_start_date | Unknown |  |
| classy_pay_recurring_recurring_time_zone | Unknown |  |
| classy_pay_recurring_recurring_unit | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| dcf_allowed | Unknown |  |
| dcf_enabled | Unknown |  |
| donation_amount | Unknown |  |
| effective_fixed_fot_percent | Unknown |  |
| failed_at | Unknown |  |
| fee_on_top | Unknown |  |
| first_name | Unknown |  |
| frequency | Unknown |  |
| hide_amount | Unknown |  |
| is_anonymous | Unknown |  |
| is_donor_covered_fee | Unknown |  |
| is_gift_aid | Unknown |  |
| is_paused | Unknown |  |
| last_name | Unknown |  |
| member_id | Unknown |  |
| migrated | Unknown |  |
| migration_date | Unknown |  |
| next_processing_date | Unknown |  |
| pause_until | Unknown |  |
| payer_address_1 | Unknown |  |
| payer_city | Unknown |  |
| payer_country | Unknown |  |
| payer_email | Unknown |  |
| payer_first_name | Unknown |  |
| payer_id | Unknown |  |
| payer_last_name | Unknown |  |
| payer_state | Unknown |  |
| payer_zip | Unknown |  |
| payment_gateway | Unknown |  |
| payment_provider_configuration_name | Unknown |  |
| payment_token_detail_expiration_month | Unknown |  |
| payment_token_detail_expiration_year | Unknown |  |
| payment_token_detail_source | Unknown |  |
| payment_token_id | Unknown |  |
| payment_token_name | Unknown |  |
| payment_token_type | Unknown |  |
| payment_type | Unknown |  |
| plan_paused_on_date | Unknown |  |
| postal_code | Unknown |  |
| pp_plan_id | Unknown |  |
| raw_adjustment_amount | Unknown |  |
| raw_application_fee_amount | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_donation_amount | Unknown |  |
| raw_flex_rate_amount | Unknown |  |
| raw_initial_gross_amount | Unknown |  |
| raw_processor_fee_amount | Unknown |  |
| recur_until | Unknown |  |
| started_at | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| timezone_identifier | Unknown |  |
| updated_at | Unknown |  |

### supporter

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| source_campaign_id | Unknown | FK |
| source_fundraising_page_id | Unknown | FK |
| source_organization_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| last_email_consent_decision_date | Unknown |  |
| last_emailed_at | Unknown |  |
| last_name | Unknown |  |
| last_sms_consent_decision_date | Unknown |  |
| location | Unknown |  |
| member_id | Unknown |  |
| metadata | Json |  |
| nickname | Unknown |  |
| opt_in | Unknown |  |
| origin | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| sms_opt_in | Unknown |  |
| source_member_id | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### paypal_stripe_payout

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | PK, FK |
| classy_transaction_id | Unknown | FK |
| payout_amount | Unknown |  |
| payout_amount_currency | Unknown |  |
| payout_created_at | Unknown |  |
| payout_date | Unknown |  |
| payout_id | Unknown |  |
| payout_updated_at | Unknown |  |

### answer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| question_id | Unknown | FK |
| answer | Unknown |  |
| answerable_id | Unknown |  |
| answerable_type | Unknown |  |
| created_at | Unknown |  |
| member_id | Unknown |  |
| updated_at | Unknown |  |

### campaign_source_tracking_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| c_src | Unknown |  |
| c_src_2 | Unknown |  |
| created_at | Unknown |  |
| event_type | Unknown |  |
| referrer | Unknown |  |
| trackable_id | Unknown |  |
| trackable_type | Unknown |  |
| updated_at | Unknown |  |

### fundraising_page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| designation_id | Unknown | FK |
| fundraising_team_id | Unknown | FK |
| organization_id | Unknown | FK |
| parent_id | Unknown | FK |
| question_id | Unknown | FK |
| supporter_id | Unknown | FK |
| alias | Unknown |  |
| commitment_id | Unknown |  |
| cover_photo_id | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| ended_at | Unknown |  |
| goal | Unknown |  |
| intro_text | Unknown |  |
| is_primary | Unknown |  |
| is_tribute | Unknown |  |
| logo_id | Unknown |  |
| member_email_text | Unknown |  |
| member_id | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_goal | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| team_role | Unknown |  |
| thank_you_email_text | Unknown |  |
| thank_you_text | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | FK |
| designation_id | Unknown | FK |
| organization_id | Unknown | FK |
| add_registration_fee | Unknown |  |
| address_1 | Unknown |  |
| allow_duplicate_fundraiser | Unknown |  |
| allow_ecard | Unknown |  |
| allow_fundraising_page | Unknown |  |
| allow_team_fundraising | Unknown |  |
| campaign_template_id | Unknown |  |
| category_id | Unknown |  |
| channel_keyword | Unknown |  |
| city | Unknown |  |
| classy_live_event_id | Unknown |  |
| classy_mode_appeal | Unknown |  |
| classy_mode_checked_by_default | Unknown |  |
| classy_mode_enabled | Unknown |  |
| contact_email | Unknown |  |
| contact_phone | Unknown |  |
| corporate_donation_enabled | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| created_with | Unknown |  |
| crypto_giving | Unknown |  |
| currency_code | Unknown |  |
| dcf_allowed | Unknown |  |
| dcf_enabled | Unknown |  |
| default_page_appeal | Unknown |  |
| default_page_appeal_email | Unknown |  |
| default_page_goal | Unknown |  |
| default_page_post_asset_id | Unknown |  |
| default_page_post_body | Unknown |  |
| default_page_post_title | Unknown |  |
| default_page_thank_you_email | Unknown |  |
| default_team_appeal | Unknown |  |
| default_team_appeal_email | Unknown |  |
| default_team_goal | Unknown |  |
| default_team_post_asset_id | Unknown |  |
| default_team_post_body | Unknown |  |
| default_team_post_title | Unknown |  |
| default_team_thank_you_email | Unknown |  |
| default_thank_you_text | Unknown |  |
| disable_donation_attribution | Unknown |  |
| display_group_name | Unknown |  |
| effective_fixed_fot_percent | Unknown |  |
| effective_flex_rate_percent | Unknown |  |
| effective_recaptcha_setting | Unknown |  |
| embedded_giving | Unknown |  |
| ended_at | Unknown |  |
| exit_modal | Unknown |  |
| fixed_fot_percent | Unknown |  |
| flex_rate_percent | Unknown |  |
| goal | Unknown |  |
| hide_anonymous_donation | Unknown |  |
| hide_contact_opt_in | Unknown |  |
| hide_dedication | Unknown |  |
| hide_donation_amount | Unknown |  |
| hide_donation_comment | Unknown |  |
| hide_from_profile | Unknown |  |
| hide_recurring_end_date | Unknown |  |
| internal_name | Unknown |  |
| is_billing_address_required | Unknown |  |
| is_ended_at_hidden | Unknown |  |
| is_fees_free | Unknown |  |
| is_general | Unknown |  |
| is_started_at_hidden | Unknown |  |
| location_detail | Unknown |  |
| logo_id | Unknown |  |
| minimum_donation_amount | Unknown |  |
| name | Unknown |  |
| offer_dedication_postal_notification | Unknown |  |
| opt_in_checked_by_default | Unknown |  |
| pages_can_set_appeal | Unknown |  |
| pages_can_set_goal | Unknown |  |
| postal_code | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_goal | Unknown |  |
| send_dedication_email | Unknown |  |
| sort_designation_by | Unknown |  |
| started_at | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| team_cover_photo_id | Unknown |  |
| team_membership_policy | Unknown |  |
| teams_can_set_appeal | Unknown |  |
| teams_can_set_goal | Unknown |  |
| ticket_pass_on_fee | Unknown |  |
| timezone_identifier | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| use_intelligent_ask_onetime | Unknown |  |
| use_intelligent_ask_recurring | Unknown |  |
| venue | Unknown |  |

### registration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| fundraising_page_id | Unknown | FK |
| fundraising_team_id | Unknown | FK |
| supporter_id | Unknown | FK |
| transaction_id | Unknown | FK |
| transaction_item_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| attendee_id | Unknown |  |
| blog | Unknown |  |
| cell | Unknown |  |
| city | Unknown |  |
| commitment_id | Unknown |  |
| company | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| last_name | Unknown |  |
| member_id | Unknown |  |
| phone | Unknown |  |
| postal_code | Unknown |  |
| product_commitment_deadline | Unknown |  |
| product_commitment_value | Unknown |  |
| product_name | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| t_shirt_size | Unknown |  |
| transaction_last_four | Unknown |  |
| transaction_payment_type | Unknown |  |
| updated_at | Unknown |  |
| website | Unknown |  |

### designation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| city | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| external_reference_id | Unknown |  |
| goal | Unknown |  |
| is_active | Unknown |  |
| is_complete | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| postal_code | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |
| updated_at | Unknown |  |

### transaction_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| charged_fees_amount | Unknown |  |
| charged_final_price | Unknown |  |
| commerce_order_item_id | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| donation_gross_amount | Unknown |  |
| donation_net_amount | Unknown |  |
| fees_amount | Unknown |  |
| final_price | Unknown |  |
| organization_id | Unknown |  |
| overhead_amount | Unknown |  |
| price | Unknown |  |
| product_id | Unknown |  |
| product_name | Unknown |  |
| promo_code_id | Unknown |  |
| quantity | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_donation_gross_amount | Unknown |  |
| raw_final_price | Unknown |  |
| raw_overhead_amount | Unknown |  |
| raw_price | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| designation_id | Unknown | FK |
| fundraising_page_id | Unknown | FK |
| fundraising_team_id | Unknown | FK |
| organization_id | Unknown | FK |
| parent_transaction_id | Unknown | FK |
| recurring_donation_plan_id | Unknown | FK |
| supporter_id | Unknown | FK |
| account_number | Unknown |  |
| account_type | Unknown |  |
| acknowledgements_count | Unknown |  |
| adjustment_amount | Unknown |  |
| app_id | Unknown |  |
| application_fee_amount | Unknown |  |
| applied_application_fee_percent | Unknown |  |
| applied_flex_rate_percent | Unknown |  |
| applied_fot_percent | Unknown |  |
| applied_processor_fee_percent | Unknown |  |
| applied_raw_processor_fee_flat | Unknown |  |
| billing_address_1 | Unknown |  |
| billing_address_2 | Unknown |  |
| billing_city | Unknown |  |
| billing_country | Unknown |  |
| billing_first_name | Unknown |  |
| billing_last_name | Unknown |  |
| billing_postal_code | Unknown |  |
| billing_state | Unknown |  |
| browser_info | Unknown |  |
| card_expiration | Unknown |  |
| card_last_four | Unknown |  |
| card_type | Unknown |  |
| channel_transaction | Unknown |  |
| charged_at | Unknown |  |
| charged_classy_fees_amount | Unknown |  |
| charged_currency_code | Unknown |  |
| charged_fees_amount | Unknown |  |
| charged_pp_fees_amount | Unknown |  |
| charged_total_gross_amount | Unknown |  |
| classy_fees_amount | Unknown |  |
| classy_pay_latest_transaction_history_created_date | Unknown |  |
| classy_pay_latest_transaction_history_state | Unknown |  |
| classy_pay_latest_transaction_history_state_detail_balance_transaction_id | Unknown |  |
| classy_pay_latest_transaction_history_state_detail_customer_id | Unknown |  |
| classy_pay_latest_transaction_history_state_detail_processor_tx_status | Unknown |  |
| classy_pay_latest_transaction_history_state_detail_transfer_id | Unknown |  |
| classy_pay_payer_address_1 | Unknown |  |
| classy_pay_payer_city | Unknown |  |
| classy_pay_payer_country | Unknown |  |
| classy_pay_payer_email | Unknown |  |
| classy_pay_payer_first_name | Unknown |  |
| classy_pay_payer_id | Unknown |  |
| classy_pay_payer_last_name | Unknown |  |
| classy_pay_payer_state | Unknown |  |
| classy_pay_payer_zip | Unknown |  |
| classy_pay_payment_token_detail_expiration_month | Unknown |  |
| classy_pay_payment_token_detail_expiration_year | Unknown |  |
| classy_pay_payment_token_detail_source | Unknown |  |
| classy_pay_payment_token_id | Unknown |  |
| classy_pay_payment_token_name | Unknown |  |
| classy_pay_payment_token_type | Unknown |  |
| classy_pay_processor_id | Unknown |  |
| classy_pay_processor_name | Unknown |  |
| classy_pay_processor_status | Unknown |  |
| classy_pay_transaction_amount | Unknown |  |
| classy_pay_transaction_charge_amount | Unknown |  |
| classy_pay_transaction_created_date | Unknown |  |
| classy_pay_transaction_currency | Unknown |  |
| classy_pay_transaction_id | Unknown |  |
| classy_pay_transaction_processor_object_id | Unknown |  |
| classy_pay_transaction_statement_descriptor | Unknown |  |
| classy_pay_transaction_type | Unknown |  |
| comment | Unknown |  |
| company_name | Unknown |  |
| context_application_fee_campaign_category | Unknown |  |
| context_application_fee_platform_fee_type | Unknown |  |
| context_commerce_confirmation_id | Unknown |  |
| context_commerce_order_id | Unknown |  |
| context_created_by | Unknown |  |
| context_is_passport | Unknown |  |
| context_platform_tip | Unknown |  |
| context_source_campaign_id | Unknown |  |
| context_source_campaign_type | Unknown |  |
| context_vendor_batch_number | Unknown |  |
| context_vendor_batch_sequence | Unknown |  |
| context_vendor_name | Unknown |  |
| created_at | Unknown |  |
| currency_code | Unknown |  |
| dedication | Unknown |  |
| donation_gross_amount | Unknown |  |
| donation_matching_plan_id | Unknown |  |
| donation_net_amount | Unknown |  |
| fee_on_top | Unknown |  |
| fees_amount | Unknown |  |
| flex_rate_amount | Unknown |  |
| frequency | Unknown |  |
| hide_amount | Unknown |  |
| in_honor_of | Unknown |  |
| initial_gross_amount | Unknown |  |
| institution | Unknown |  |
| is_anonymous | Unknown |  |
| is_donor_covered_fee | Unknown |  |
| is_gift_aid | Unknown |  |
| is_reprocess | Unknown |  |
| member_country | Unknown |  |
| member_email_address | Unknown |  |
| member_id | Unknown |  |
| member_name | Unknown |  |
| member_phone | Unknown |  |
| offline_payment_info_check_number | Unknown |  |
| offline_payment_info_description | Unknown |  |
| offline_payment_info_payment_type | Unknown |  |
| offline_payment_info_sync_third_party | Unknown |  |
| opted_into_payment_sync | Unknown |  |
| order_donation_match_amount | Unknown |  |
| order_donation_match_employee_email | Unknown |  |
| order_donation_match_employee_id | Unknown |  |
| order_donation_match_employer_address | Unknown |  |
| order_donation_match_employer_id | Unknown |  |
| order_donation_match_employer_name | Unknown |  |
| order_donation_match_first_name | Unknown |  |
| order_donation_match_id | Unknown |  |
| order_donation_match_last_name | Unknown |  |
| order_donation_match_promise_status | Unknown |  |
| order_donation_match_transaction_id | Unknown |  |
| order_donation_match_type | Unknown |  |
| overhead_net_amount | Unknown |  |
| payment_gateway | Unknown |  |
| payment_method | Unknown |  |
| payment_source | Unknown |  |
| payment_type | Unknown |  |
| pp_fees_amount | Unknown |  |
| pp_reference_id | Unknown |  |
| pp_response | Unknown |  |
| pp_transaction_id | Unknown |  |
| processor_decline_code | Unknown |  |
| processor_fee_amount | Unknown |  |
| promo_code_code | Unknown |  |
| purchased_at | Unknown |  |
| raw_adjustment_amount | Unknown |  |
| raw_application_fee_amount | Unknown |  |
| raw_currency_code | Unknown |  |
| raw_donation_gross_amount | Unknown |  |
| raw_flex_rate_amount | Unknown |  |
| raw_initial_gross_amount | Unknown |  |
| raw_overhead_net_amount | Unknown |  |
| raw_processor_fee_amount | Unknown |  |
| raw_total_gross_amount | Unknown |  |
| receipt_serial | Unknown |  |
| refunded_at | Unknown |  |
| reprocess_attempt_info | Unknown |  |
| reprocess_attempts | Unknown |  |
| reprocess_status | Unknown |  |
| status | Unknown |  |
| tax_entity_id | Unknown |  |
| total_gross_amount | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- ticket_type(campaign_id) → campaign(id)
- ticket_type(organization_id) → organization(id)
- question(campaign_id) → campaign(id)
- question(organization_id) → organization(id)
- fundraising_team(campaign_id) → campaign(id)
- fundraising_team(designation_id) → designation(id)
- fundraising_team(organization_id) → organization(id)
- fundraising_team(parent_id) → fundraising_team(id)
- dedication(transaction_id) → transaction(id)
- dedication(ecard_campaign_id) → campaign(id)
- dedication(organization_id) → organization(id)
- channel(organization_id) → organization(id)
- recurring_donation_plan_schedule(recurring_donation_plan_id) → recurring_donation_plan(id)
- recurring_donation_plan(supporter_id) → supporter(id)
- recurring_donation_plan(campaign_id) → campaign(id)
- recurring_donation_plan(designation_id) → designation(id)
- recurring_donation_plan(organization_id) → organization(id)
- recurring_donation_plan(fundraising_team_id) → fundraising_team(id)
- recurring_donation_plan(fundraising_page_id) → fundraising_page(id)
- supporter(source_organization_id) → organization(id)
- supporter(source_campaign_id) → campaign(id)
- supporter(source_fundraising_page_id) → fundraising_page(id)
- paypal_stripe_payout(classy_transaction_id) → transaction(id)
- paypal_stripe_payout(organization_id) → organization(id)
- answer(question_id) → question(id)
- answer(campaign_id) → campaign(id)
- answer(organization_id) → organization(id)
- campaign_source_tracking_code(campaign_id) → campaign(id)
- fundraising_page(question_id) → question(id)
- fundraising_page(supporter_id) → supporter(id)
- fundraising_page(campaign_id) → campaign(id)
- fundraising_page(designation_id) → designation(id)
- fundraising_page(organization_id) → organization(id)
- fundraising_page(fundraising_team_id) → fundraising_team(id)
- fundraising_page(parent_id) → fundraising_page(id)
- campaign(channel_id) → channel(id)
- campaign(designation_id) → designation(id)
- campaign(organization_id) → organization(id)
- registration(transaction_item_id) → transaction_item(id)
- registration(supporter_id) → supporter(id)
- registration(campaign_id) → campaign(id)
- registration(transaction_id) → transaction(id)
- registration(fundraising_page_id) → fundraising_page(id)
- registration(organization_id) → organization(id)
- registration(fundraising_team_id) → fundraising_team(id)
- designation(organization_id) → organization(id)
- transaction_item(transaction_id) → transaction(id)
- transaction(supporter_id) → supporter(id)
- transaction(campaign_id) → campaign(id)
- transaction(parent_transaction_id) → transaction(id)
- transaction(designation_id) → designation(id)
- transaction(recurring_donation_plan_id) → recurring_donation_plan(id)
- transaction(organization_id) → organization(id)
- transaction(fundraising_team_id) → fundraising_team(id)
- transaction(fundraising_page_id) → fundraising_page(id)