# Xsolla schema ERD

Table and field reference for the Fivetran Xsolla connector.

## Table & Field Reference

### subscription_plan_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| subscription_plan_id | Unknown | PK, FK |
| amount | Unknown |  |
| currency | Unknown |  |
| setup_fee | Unknown |  |

### subscription_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| active_period_date_end | Unknown |  |
| active_period_date_start | Unknown |  |
| billing_retry_value | Unknown |  |
| charge_amount | Unknown |  |
| charge_currency | Unknown |  |
| charge_period_type | Unknown |  |
| charge_period_value | Unknown |  |
| expiration_type | Unknown |  |
| expiration_value | Unknown |  |
| external_id | Unknown |  |
| grace_period_type | Unknown |  |
| grace_period_value | Unknown |  |
| group_id | Unknown |  |
| localized_name | Unknown |  |
| recurrent_bonus | Unknown |  |
| refund_period | Unknown |  |
| remind_days_before_charge | Unknown |  |
| remind_days_before_notify | Unknown |  |
| status_counter_active | Unknown |  |
| status_counter_canceled | Unknown |  |
| status_counter_frozen | Unknown |  |
| status_counter_non_renewing | Unknown |  |
| status_value | Unknown |  |
| tags | Json |  |
| trial_type | Unknown |  |
| trial_value | Unknown |  |
| type | Unknown |  |
| description_** |  |  |
| name_** |  |  |

### validity_period

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| froms | Unknown |  |
| offsets | Unknown |  |
| tos | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_detail_user_id | Unknown | PK |
| project_id | Unknown | FK |
| project_payment_method_id | Unknown | FK |
| checkout_amount | Unknown |  |
| checkout_currency | Unknown |  |
| customer_billing_address | Unknown |  |
| customer_bin | Unknown |  |
| customer_browser_language | Unknown |  |
| customer_id | Unknown |  |
| customer_paystation_country | Unknown |  |
| customer_timezone | Unknown |  |
| direct_account | Unknown |  |
| dry_run | Unknown |  |
| external_id | Unknown |  |
| finance_balance_sum_amount | Unknown |  |
| finance_balance_sum_currency | Unknown |  |
| finance_chargeback_penalty_amount | Unknown |  |
| finance_chargeback_penalty_currency | Unknown |  |
| finance_payment_amount | Unknown |  |
| finance_payment_currency | Unknown |  |
| finance_payment_method_fee_amount | Unknown |  |
| finance_payment_method_fee_currency | Unknown |  |
| finance_payment_method_sum_amount | Unknown |  |
| finance_payment_method_sum_currency | Unknown |  |
| finance_payout_amount | Unknown |  |
| finance_payout_currency | Unknown |  |
| finance_payout_currency_rate | Unknown |  |
| finance_refund_penalty_amount | Unknown |  |
| finance_refund_penalty_currency | Unknown |  |
| finance_repatriation_commission_amount | Unknown |  |
| finance_repatriation_commission_currency | Unknown |  |
| finance_sales_tax_amount | Unknown |  |
| finance_sales_tax_currency | Unknown |  |
| finance_vat_amount | Unknown |  |
| finance_vat_currency | Unknown |  |
| finance_xsolla_fee_amount | Unknown |  |
| finance_xsolla_fee_currency | Unknown |  |
| is_payment_from_subscription | Unknown |  |
| is_subscription_created | Unknown |  |
| payment_card_holder_name | Unknown |  |
| payment_card_issuer | Unknown |  |
| payment_card_month | Unknown |  |
| payment_card_number | Unknown |  |
| payment_card_scheme | Unknown |  |
| payment_card_year | Unknown |  |
| payment_customer_first_name | Unknown |  |
| payment_customer_last_name | Unknown |  |
| payment_detail_amount | Unknown |  |
| payment_detail_amount_from_ps | Unknown |  |
| payment_detail_chargeback_penalty_amount | Unknown |  |
| payment_detail_commission_agent_amount | Unknown |  |
| payment_detail_commission_agent_fixed | Unknown |  |
| payment_detail_commission_agent_percent | Unknown |  |
| payment_detail_commission_ps_amount | Unknown |  |
| payment_detail_commission_ps_fixed_amount | Unknown |  |
| payment_detail_commission_ps_percent | Unknown |  |
| payment_detail_commission_ps_vat_amount | Unknown |  |
| payment_detail_commission_user_amount | Unknown |  |
| payment_detail_commission_user_percent | Unknown |  |
| payment_detail_commission_xsolla_amount | Unknown |  |
| payment_detail_commission_xsolla_fixed_amount | Unknown |  |
| payment_detail_commission_xsolla_percent | Unknown |  |
| payment_detail_cpa_network_commission_amount | Unknown |  |
| payment_detail_cpa_network_commission_percent | Unknown |  |
| payment_detail_currency | Unknown |  |
| payment_detail_direct_wht_amount | Unknown |  |
| payment_detail_direct_wht_percent | Unknown |  |
| payment_detail_payout_amount | Unknown |  |
| payment_detail_payout_amount_from_ps | Unknown |  |
| payment_detail_payout_currency | Unknown |  |
| payment_detail_payout_fx_rate | Unknown |  |
| payment_detail_payout_percent | Unknown |  |
| payment_detail_refund_penalty_amount | Unknown |  |
| payment_detail_repatriation_cost_amount | Unknown |  |
| payment_detail_repatriation_cost_percent | Unknown |  |
| payment_detail_sales_tax_amount | Unknown |  |
| payment_detail_sales_tax_percent | Unknown |  |
| payment_detail_vat_amount | Unknown |  |
| payment_detail_vat_percent | Unknown |  |
| payment_detail_vat_user_amount | Unknown |  |
| payment_detail_vat_user_percent | Unknown |  |
| payment_enrollment | Unknown |  |
| payment_method_class | Unknown |  |
| payment_ps_account | Unknown |  |
| payment_zip_code | Unknown |  |
| purchase_amount | Unknown |  |
| purchase_friend_user_id | Unknown |  |
| purchase_items_amount | Unknown |  |
| purchase_order_id | Unknown |  |
| purchase_order_store_cart | Unknown |  |
| purchase_pin_code_amount | Unknown |  |
| purchase_pin_code_content | Unknown |  |
| purchase_pin_code_currency | Unknown |  |
| purchase_pin_code_drm | Unknown |  |
| purchase_pin_code_sku | Unknown |  |
| purchase_shipping_address | Unknown |  |
| purchase_simple_checkout_amount | Unknown |  |
| purchase_simple_checkout_currency | Unknown |  |
| purchase_subscription_id | Unknown |  |
| purchase_subscription_name | Unknown |  |
| purchase_subscription_plan_id | Unknown |  |
| purchase_subscription_product_id | Unknown |  |
| purchase_subscription_product_name | Unknown |  |
| purchase_virtual_currency | Unknown |  |
| purchase_virtual_currency_amount | Unknown |  |
| purchase_virtual_currency_name | Unknown |  |
| purchase_virtual_currency_quantity | Unknown |  |
| purchase_virtual_item_amount | Unknown |  |
| purchase_virtual_item_content | Unknown |  |
| purchase_virtual_item_currency | Unknown |  |
| purchase_virtual_items | Unknown |  |
| refund_reason_comment | Unknown |  |
| status | Unknown |  |
| total_amount | Unknown |  |
| total_currency | Unknown |  |
| transaction_detail_amount | Unknown |  |
| transaction_detail_cancellation_date | Unknown |  |
| transaction_detail_country | Unknown |  |
| transaction_detail_currency | Unknown |  |
| transaction_detail_custom_parameters | Json |  |
| transaction_detail_foreign_invoice | Unknown |  |
| transaction_detail_gift_recipient_email | Unknown |  |
| transaction_detail_gift_recipient_id | Unknown |  |
| transaction_detail_payment_date | Unknown |  |
| transaction_detail_refund_comment | Unknown |  |
| transaction_detail_refund_reason | Unknown |  |
| transaction_detail_saved_payment_method | Unknown |  |
| transaction_detail_status | Unknown |  |
| transaction_purchase_virtual_currency_amount | Unknown |  |
| transfer_date | Unknown |  |
| user_balance_deduction_amount | Unknown |  |
| user_balance_payout_amount_from_balance | Unknown |  |
| user_balance_purchase_amount_from_balance | Unknown |  |
| user_country | Unknown |  |
| user_custom | Unknown |  |
| user_email | Unknown |  |
| user_id | Unknown |  |
| user_ip | Unknown |  |
| user_marketplace | Unknown |  |
| user_name | Unknown |  |
| user_phone | Unknown |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | FK |
| author_name | Unknown |  |
| created_at | Unknown |  |
| is_audio | Unknown |  |
| requester_email | Unknown |  |
| sender | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| vote | Unknown |  |

### reward_bonus

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| reward_id | Unknown | PK, FK |
| localized_name | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### reward_discount

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| reward_id | Unknown | PK, FK |
| discount_percent | Unknown |  |
| localized_name | Unknown |  |
| max_amount | Unknown |  |
| sku | Unknown |  |

### reward

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| package_bonus_amount | Unknown |  |
| package_bonus_percent | Unknown |  |
| purchase_discount_percent | Unknown |  |
| subscription_trial_days | Unknown |  |

### event_tag

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

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown |  |
| complete_description | Unknown |  |
| sender | Unknown |  |
| short_message | Unknown |  |

### product_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| product_id | Unknown | PK, FK |
| project_id | Unknown | PK, FK |
| description_id | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| group_id | Unknown |  |
| name | Unknown |  |

### subscription_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| subscription_id | Unknown | FK |
| subscription_plan_id | Unknown | FK |
| subscription_product_id | Unknown | FK |
| subscription_user_id | Unknown | FK |
| date_payment | Unknown |  |
| id_payment | Unknown |  |
| status | Unknown |  |

### project_payment_method_price

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| project_payment_method_id | Unknown | PK, FK |
| currencies | Unknown |  |
| description | Unknown |  |
| fee_fixed_currency | Unknown |  |
| fee_fixed_value | Unknown |  |
| fee_percent | Unknown |  |
| is_unknown_commission | Unknown |  |
| repatriation_cost | Unknown |  |
| transaction_limit_currency_iso | Unknown |  |
| transaction_limit_max | Unknown |  |
| transaction_limit_min | Unknown |  |

### project_payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| can_be_enabled | Unknown |  |
| categories | Unknown |  |
| countries | Unknown |  |
| enabled | Unknown |  |
| image_url | Unknown |  |
| market_shares | Json |  |
| name | Unknown |  |
| region | Unknown |  |

### payout_breakdown_in_currency

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| direct_taxes_of_payments | Unknown |  |
| iso_currency | Unknown |  |
| payments_amount | Unknown |  |
| status | Unknown |  |
| sum_commission_agent | Unknown |  |
| sum_commission_user_taxes | Unknown |  |
| sum_items | Unknown |  |
| sum_nominal_sum | Unknown |  |
| sum_out_project | Unknown |  |
| sum_payout_sum | Unknown |  |
| taxes_of_payments | Unknown |  |

### promotion_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| project_id | Unknown | FK |
| enabled | Unknown |  |
| read_only | Unknown |  |
| show_banner | Unknown |  |
| technical_name | Unknown |  |
| description_** |  |  |
| label_** |  |  |
| name_** |  |  |

### project_monetization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |
| name_canonical | Unknown |  |
| order_position | Unknown |  |
| translation_label | Unknown |  |

### project_platform

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| name | Unknown |  |
| name_canonical | Unknown |  |
| order_position | Unknown |  |
| translation_label | Unknown |  |

### project_locale

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| name | Unknown | PK |
| project_id | Unknown | PK, FK |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| auto_redirect_from_status_page | Unknown |  |
| auto_redirect_from_status_page_in_second | Unknown |  |
| card_recurring | Unknown |  |
| coupon_custom_name | Json |  |
| coupon_enabled | Unknown |  |
| coupon_live | Unknown |  |
| coupon_status | Unknown |  |
| description | Unknown |  |
| descriptor | Unknown |  |
| enabled | Unknown |  |
| game_delivery_custom_name | Json |  |
| game_delivery_enabled | Unknown |  |
| game_delivery_live | Unknown |  |
| game_delivery_status | Unknown |  |
| game_engine_other | Unknown |  |
| game_engines | Json |  |
| img | Unknown |  |
| integration_type | Unknown |  |
| interface_logo | Unknown |  |
| ipn_enabled | Unknown |  |
| is_cancel_implemented | Unknown |  |
| is_external_id_required | Unknown |  |
| is_project_active | Unknown |  |
| is_sandbox_available | Unknown |  |
| is_send_email | Unknown |  |
| is_universal_item_enabled | Unknown |  |
| item_custom_name | Json |  |
| item_enabled | Unknown |  |
| item_live | Unknown |  |
| item_status | Unknown |  |
| key | Unknown |  |
| keywords | Unknown |  |
| monetization_other | Unknown |  |
| offerwall_enabled | Unknown |  |
| payment_url | Unknown |  |
| payments_available | Unknown |  |
| physical_goods_custom_name | Json |  |
| physical_goods_enabled | Unknown |  |
| physical_goods_live | Unknown |  |
| physical_goods_status | Unknown |  |
| product_anti_fraud_status | Unknown |  |
| product_funding_status | Unknown |  |
| product_launcher_status | Unknown |  |
| product_login_status | Unknown |  |
| product_partner_network_status | Unknown |  |
| product_pay_station_status | Unknown |  |
| product_payout_status | Unknown |  |
| product_site_builder_status | Unknown |  |
| product_store_status | Unknown |  |
| product_subscription_status | Unknown |  |
| release_date | Unknown |  |
| release_period_type_description | Unknown |  |
| release_period_type_id | Unknown |  |
| release_period_type_name | Unknown |  |
| return_url | Unknown |  |
| secondary_market | Json |  |
| send_email_for_user_billing_purchase | Unknown |  |
| send_json_to_paystation | Unknown |  |
| show_user_in_paystation | Unknown |  |
| simple_checkout_custom_name | Json |  |
| simple_checkout_enabled | Unknown |  |
| simple_checkout_live | Unknown |  |
| simple_checkout_status | Unknown |  |
| solution_game_sales | Unknown |  |
| solution_payment | Unknown |  |
| solution_web_shop | Unknown |  |
| status_page_return_to_game_link_name | Unknown |  |
| status_page_show_return_to_game_link | Unknown |  |
| subscription_custom_name | Json |  |
| subscription_enabled | Unknown |  |
| subscription_live | Unknown |  |
| subscription_status | Unknown |  |
| temp_project_protocol_key | Unknown |  |
| url | Unknown |  |
| user_billing_enabled | Unknown |  |
| user_public_id_enabled | Unknown |  |
| users_count | Unknown |  |
| virtual_currency_custom_name | Json |  |
| virtual_currency_enabled | Unknown |  |
| virtual_currency_live | Unknown |  |
| virtual_currency_status | Unknown |  |
| xsolla_tips_enabled | Unknown |  |
| xsolla_tips_settings | Json |  |
| name_** |  |  |

### payout

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_document_id | Unknown | FK |
| amount_in_draft_currency | Unknown |  |
| cancelled_transactions_amount | Unknown |  |
| comment | Unknown |  |
| date_created | Unknown |  |
| date_paid | Unknown |  |
| draft_currency | Unknown |  |
| draft_currency_precision | Unknown |  |
| draft_document_id | Unknown |  |
| legal_entity_id | Unknown |  |
| legal_entity_name | Unknown |  |
| payment_currency | Unknown |  |
| rate | Unknown |  |
| reporting_period | Unknown |  |
| status | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| plan_id | Unknown | FK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| charge_amount | Unknown |  |
| comment | Unknown |  |
| country_iso | Unknown |  |
| currency | Unknown |  |
| date_create | Unknown |  |
| date_end | Unknown |  |
| date_last_charge | Unknown |  |
| date_next_charge | Unknown |  |
| product_id | Unknown |  |
| status | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agreement_document_id | Unknown |  |
| currency | Unknown |  |
| is_direct_payout | Unknown |  |
| is_draft_by_agreement | Unknown |  |
| month | Unknown |  |
| year | Unknown |  |

### ticket_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| author_name | Unknown |  |
| body | Unknown |  |
| created_at | Unknown |  |
| public | Unknown |  |

### promotion

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| datetime_from | Unknown |  |
| datetime_to | Unknown |  |
| is_active | Unknown |  |
| is_infinite | Unknown |  |
| project_localized_name | Unknown |  |

### subject_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| subject_id | Unknown | PK, FK |
| localized_name | Unknown |  |
| sku | Unknown |  |

### subject_subscription_plan

| Column | Type | Keys |
| --- | --- | --- |
| plan_id | Unknown | PK, FK |
| promotion_id | Unknown | PK, FK |
| subject_id | Unknown | PK, FK |

### subject_subscription_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| promotion_id | Unknown | PK, FK |
| subject_id | Unknown | PK, FK |

### subject

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| promotion_id | Unknown | PK, FK |
| digital_contents | Unknown |  |
| packages | Unknown |  |
| purchase | Unknown |  |
| subscription_max_charges_count | Unknown |  |
| subscriptions_plans | Json |  |

### payment_system

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| payment_system_parent_id | Unknown | PK |
| promotion_id | Unknown | PK |
| name | Unknown |  |

## Relationships

- subscription_plan_price(subscription_plan_id) → subscription_plan(id)
- subscription_plan(project_id) → project(id)
- validity_period(promotion_id) → promotion(id)
- transaction(project_id) → project(id)
- transaction(project_payment_method_id) → project_payment_method(id)
- ticket(transaction_id) → transaction(id)
- reward_bonus(promotion_id) → reward(promotion_id)
- reward_bonus(reward_id) → reward(id)
- reward_discount(promotion_id) → reward(promotion_id)
- reward_discount(reward_id) → reward(id)
- reward(promotion_id) → promotion(id)
- event_tag(event_id) → event(id)
- product_description(product_id) → product(id)
- product_description(project_id) → product(project_id)
- product(project_id) → project(id)
- subscription_payment(subscription_id) → subscription(id)
- subscription_payment(subscription_product_id) → product(id)
- subscription_payment(subscription_plan_id) → subscription_plan(id)
- subscription_payment(subscription_user_id) → transaction(user_id)
- subscription_payment(project_id) → project(id)
- project_payment_method_price(project_id) → project_payment_method(project_id)
- project_payment_method_price(project_payment_method_id) → project_payment_method(id)
- project_payment_method(project_id) → project(id)
- promotion_detail(project_id) → project(id)
- promotion_detail(promotion_id) → promotion(id)
- project_monetization(project_id) → project(id)
- project_platform(project_id) → project(id)
- project_locale(project_id) → project(id)
- payout(agreement_document_id) → report(agreement_document_id)
- subscription(user_id) → transaction(user_id)
- subscription(plan_id) → subscription_plan(id)
- subscription(project_id) → project(id)
- ticket_comment(ticket_id) → ticket(id)
- promotion(project_id) → project(id)
- subject_item(promotion_id) → subject(promotion_id)
- subject_item(subject_id) → subject(id)
- subject_subscription_plan(plan_id) → subscription_plan_price(subscription_plan_id)
- subject_subscription_plan(promotion_id) → subject(promotion_id)
- subject_subscription_plan(subject_id) → subject(id)
- subject_subscription_product(product_id) → product(id)
- subject_subscription_product(promotion_id) → subject(promotion_id)
- subject_subscription_product(subject_id) → subject(id)
- subject(promotion_id) → promotion(id)