Xsolla

Explore the interactive ERD

Table & Field Reference

subscription_plan_price

Column	Type	Keys
`index`	Unknown	PK
`subscription_plan_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`reward_id`	Unknown	PKFK
`localized_name`	Unknown
`quantity`	Unknown
`sku`	Unknown

reward_discount

Column	Type	Keys
`index`	Unknown	PK
`promotion_id`	Unknown	PKFK
`reward_id`	Unknown	PKFK
`discount_percent`	Unknown
`localized_name`	Unknown
`max_amount`	Unknown
`sku`	Unknown

reward

Column	Type	Keys
`id`	Unknown	PK
`promotion_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`project_id`	Unknown	PKFK
`description_id`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`group_id`	Unknown
`name`	Unknown

subscription_payment

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`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	PKFK
`project_payment_method_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`name`	Unknown
`name_canonical`	Unknown
`order_position`	Unknown
`translation_label`	Unknown

project_platform

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

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	PKFK
`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	PKFK
`subject_id`	Unknown	PKFK
`localized_name`	Unknown
`sku`	Unknown

subject_subscription_plan

Column	Type	Keys
`plan_id`	Unknown	PKFK
`promotion_id`	Unknown	PKFK
`subject_id`	Unknown	PKFK

subject_subscription_product

Column	Type	Keys
`product_id`	Unknown	PKFK
`promotion_id`	Unknown	PKFK
`subject_id`	Unknown	PKFK

subject

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