Partnerize

Explore the interactive ERD

Table & Field Reference

deal

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`active`	Unknown
`advertiser_reference`	Unknown
`category`	Unknown
`country_iso`	Unknown
`coupon_code`	Unknown
`description`	Unknown
`destination`	Unknown
`end_date_time`	Unknown
`offer_type`	Unknown
`offer_value`	Unknown
`start_date_time`	Unknown
`terms`	Unknown
`title`	Unknown

state_history

Column	Type	Keys
`transaction_query_state_id`	Unknown	PK
`transaction_query_id`	Unknown	PKFK
`conversion_expected_commission`	Unknown
`conversion_item_id`	Unknown
`created_at`	Unknown
`notes`	Unknown
`state`	Unknown
`user_id`	Unknown

action_available

Column	Type	Keys
`index`	Unknown	PK
`campaign_transaction_transaction_query_id`	Unknown	PKFK
`actions_available`	Unknown

campaign_transaction

Column	Type	Keys
`transaction_query_id`	Unknown	PK
`advertiser_id`	Unknown	FK
`campaign_id`	Unknown	FK
`publisher_id`	Unknown	FK
`agreed_to_latest_network_terms`	Unknown
`camref`	Unknown
`conversion_currency`	Unknown
`conversion_date_time`	Unknown
`conversion_id`	Unknown
`conversion_reference`	Unknown
`conversion_value`	Unknown
`created`	Unknown
`created_at`	Unknown
`created_by`	Unknown
`current_state`	Unknown
`default_override`	Unknown
`expected_commission`	Unknown
`hidden_campaign`	Unknown
`ignore_cookie_period_rejection`	Unknown
`last_modified`	Unknown
`name`	Unknown
`network_fee`	Unknown
`network_id`	Unknown
`network_status`	Unknown
`note`	Unknown
`payment_date`	Unknown
`publisher_created_by`	Unknown
`publisher_reference`	Unknown
`publisher_reporting_timezone`	Unknown
`ref_terms_and_conditions_locale_id`	Unknown
`reporting_timezone`	Unknown
`signup_ip`	Unknown
`status`	Unknown
`title`	Unknown
`transaction_query_type`	Unknown
`type`	Unknown
`updated_at`	Unknown
`vertical_id`	Unknown
`week_start`	Unknown

impression_explode

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`advertiser_reference`	Unknown
`browser_family`	Unknown
`browser_major`	Unknown
`browser_minor`	Unknown
`browser_patch`	Unknown
`campaign_name`	Unknown
`creative_advertiser_reference`	Unknown
`creative_descriptio`	Unknown
`creative_id`	Unknown
`date_time`	Unknown
`device_id`	Unknown
`device_name`	Unknown
`os_family`	Unknown
`os_major`	Unknown
`os_minor`	Unknown
`os_patch`	Unknown
`partner_id`	Unknown
`partner_name`	Unknown
`partnership_model_id`	Unknown
`partnership_model_name`	Unknown
`sku`	Unknown
`traffic_source_id`	Unknown
`traffic_source_name`	Unknown
`user_context_id`	Unknown
`user_context_name`	Unknown

promotional_commission_publisher

Column	Type	Keys
`id`	Unknown	PK
`promotional_commission_id`	Unknown	PKFK
`name`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`promotional_commission_id`	Unknown	PKFK
`name`	Unknown

promotional_commission

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`commission_based_on_field`	Unknown
`cookie_period`	Unknown
`description`	Unknown
`end_date`	Unknown
`last_modified`	Unknown
`last_modified_by`	Unknown
`performance_model`	Unknown
`performance_value`	Unknown
`start_date`	Unknown
`status`	Unknown

transaction_query

Column	Type	Keys
`transaction_query_reason_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`created_at`	Unknown
`reason`	Unknown

voucher_code_commission_group

Column	Type	Keys
`commission_group_id`	Unknown	PKFK
`voucher_code_id`	Unknown	PKFK

voucher_code

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`active`	Unknown
`description`	Unknown
`end_date_time`	Unknown
`on_expiry`	Unknown
`on_invalid_user`	Unknown
`start_date_time`	Unknown
`voucher_code`	Unknown

network

Column	Type	Keys
`id`	Unknown	PK
`auto_approve_publisher`	Unknown
`cm_client_id`	Unknown
`default_campaign_id`	Unknown
`network_application_id`	Unknown
`network_contact_email`	Unknown
`network_description`	Unknown
`network_locale`	Unknown
`network_name`	Unknown
`network_note`	Unknown

partner_commission_group_publisher

Column	Type	Keys
`id`	Unknown	PK
`partner_commission_group_commission_group_id`	Unknown	PKFK
`added`	Unknown
`publisher_name`	Unknown

partner_commission_group

Column	Type	Keys
`commission_group_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`active`	Unknown
`description`	Unknown
`end_date_time`	Unknown
`last_modified`	Unknown
`name`	Unknown
`start_date_time`	Unknown

preferred_partner

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`end_date`	Unknown
`partner_id`	Unknown
`partner_name`	Unknown
`partner_status`	Unknown
`start_date`	Unknown
`status`	Unknown

click_explode

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`device_id`	Unknown	FK
`advertiser_reference`	Unknown
`browser_family`	Unknown
`browser_major`	Unknown
`browser_minor`	Unknown
`browser_patch`	Unknown
`campaign_name`	Unknown
`click_conversion_rate`	Unknown
`country`	Unknown
`country_name`	Unknown
`creative_advertiser_reference`	Unknown
`creative_description`	Unknown
`creative_id`	Unknown
`date_time`	Unknown
`device_name`	Unknown
`os_family`	Unknown
`os_major`	Unknown
`os_minor`	Unknown
`os_patch`	Unknown
`partner_id`	Unknown
`partner_name`	Unknown
`partnership_model_id`	Unknown
`partnership_model_name`	Unknown
`total_clicks`	Unknown
`total_clicks_converted`	Unknown
`total_unique_clicks`	Unknown
`traffic_source_id`	Unknown
`traffic_source_name`	Unknown
`type`	Unknown
`user_context_id`	Unknown
`user_context_name`	Unknown

brand_campaign

Column	Type	Keys
`advertiser_id`	Unknown	PKFK
`campaign_id`	Unknown	PKFK
`allow_deep_linking`	Unknown
`allow_third_party_pixel`	Unknown
`app_android_fingerprint`	Unknown
`app_ios_bundle`	Unknown
`app_ios_prefix`	Unknown
`app_tracking_integration_mapping`	Unknown
`app_tracking_provider`	Unknown
`app_tracking_provider_tracking_link`	Unknown
`append_url_parameters`	Unknown
`associated_campaigns`	Unknown
`auto_approve_publisher`	Unknown
`auto_rejected_ips`	Unknown
`automated_invoicing_date`	Unknown
`automated_invoicing_po_number`	Unknown
`basket_value_cap`	Unknown
`budget_summary_interval`	Unknown
`budget_summary_start_time`	Unknown
`campaign_icon`	Unknown
`campaign_invoice_locale`	Unknown
`campaign_languages`	Unknown
`campaign_logo`	Unknown
`campaign_notes`	Unknown
`commission_by_meta`	Unknown
`commission_by_meta_label`	Unknown
`consolidate_invoices`	Unknown
`conversion_hiatus_period`	Unknown
`conversion_type`	Unknown
`cookie_period`	Unknown
`cookie_status`	Unknown
`created`	Unknown
`created_by`	Unknown
`creative_prepend`	Unknown
`deeplink_method`	Unknown
`default_currency`	Unknown
`default_mobile_destination`	Unknown
`default_override`	Unknown
`deferred_lead_submission`	Unknown
`description`	Unknown
`destination_url`	Unknown
`dont_consolidate`	Unknown
`dont_invoice`	Unknown
`finance_contact_email`	Unknown
`force_approve_period`	Unknown
`hash_ip_addresses`	Unknown
`hidden_campaign`	Unknown
`ignore_cookie_period_rejections`	Unknown
`invalid_voucher_conversion_metric_id`	Unknown
`invoice_address_1`	Unknown
`invoice_address_2`	Unknown
`invoice_address_3`	Unknown
`invoice_address_4`	Unknown
`invoice_address_country`	Unknown
`invoice_address_postcode`	Unknown
`invoice_company`	Unknown
`invoice_contact`	Unknown
`invoice_only`	Unknown
`ip_tracking_time`	Unknown
`is_cpc`	Unknown
`is_cpc_default`	Unknown
`last_modified`	Unknown
`lead_confirmation_url_fail`	Unknown
`lead_confirmation_url_success`	Unknown
`meta_field_values_field_limit`	Unknown
`meta_field_values_total_limit`	Unknown
`multiple_conversions_per_click`	Unknown
`network_fee`	Unknown
`pay_publisher_directly`	Unknown
`payment_date`	Unknown
`prepend_url_string`	Unknown
`recurring_payment_setup`	Unknown
`reporting_timezone`	Unknown
`secure_tracking`	Unknown
`short_link_subdomain`	Unknown
`status`	Unknown
`test_mode`	Unknown
`title`	Unknown
`tq_auto_approve`	Unknown
`tq_enabled`	Unknown
`tracking_method`	Unknown
`tracking_subdomain`	Unknown
`unique_conversion_refs`	Unknown
`vertical_id`	Unknown
`week_start`	Unknown

platform_communication

Column	Type	Keys
`id`	Unknown	PK
`conditions`	Json
`disabled`	Unknown
`event_id`	Unknown
`from_name`	Unknown
`name`	Unknown
`reply_to_email`	Unknown
`subject`	Unknown
`updated_at`	Unknown

product_feed

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`active`	Unknown
`dynamic`	Unknown
`fetch_frequency`	Unknown
`filesize`	Unknown
`last_processed`	Unknown
`location`	Unknown
`location_local`	Unknown
`name`	Unknown
`updated`	Unknown

communication_campaign

Column	Type	Keys
`index`	Unknown	PK
`communication_id`	Unknown	PKFK
`campaign`	Unknown

communication

Column	Type	Keys
`id`	Unknown	PK
`from_email`	Unknown
`from_name`	Unknown
`last_updated`	Unknown
`name`	Unknown
`preview_url`	Unknown
`recipient_count`	Unknown
`reply_to_email`	Unknown
`send_date`	Unknown
`status`	Unknown
`subject`	Unknown
`timezone`	Unknown
`type`	Unknown

brand

Column	Type	Keys
`advertiser_id`	Unknown	PK
`account_name`	Unknown
`address_1`	Unknown
`address_2`	Unknown
`address_3`	Unknown
`address_4`	Unknown
`advertiser_icon`	Unknown
`allowed_deep_linking_domain`	Unknown
`budget_summary_interval`	Unknown
`budget_summary_start_time`	Unknown
`company_name`	Unknown
`contact_email`	Unknown
`country`	Unknown
`current_balance`	Unknown
`default_currency`	Unknown
`description`	Unknown
`display_name`	Unknown
`payment_currency`	Unknown
`phone`	Unknown
`postcode`	Unknown
`pre_payment`	Unknown
`signup_ip`	Unknown
`status`	Unknown
`vat_number`	Unknown

conversion_item

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`conversion_id`	Unknown	PKFK
`invoice_id`	Unknown	FK
`approved_at`	Unknown
`category`	Unknown
`display_to_publisher`	Unknown
`item_commission`	Unknown
`item_publisher_commission`	Unknown
`item_status`	Unknown
`item_status_id`	Unknown
`item_value`	Unknown
`last_update`	Unknown
`meta_data_gclid`	Unknown
`reject_reason`	Unknown
`sku`	Unknown
`voucher_codes`	Json

conversion

Column	Type	Keys
`campaign_id`	Unknown	PK
`id`	Unknown	PK
`device_id`	Unknown	FK
`publisher_id`	Unknown	FK
`ref_device_id`	Unknown	FK
`advertiser_reference`	Unknown
`campaign_title`	Unknown
`click_id`	Unknown
`click_last_ip`	Unknown
`click_last_used`	Unknown
`click_set_ip`	Unknown
`click_set_time`	Unknown
`click_status`	Unknown
`click_type`	Unknown
`clickref`	Unknown
`conversion_lag`	Unknown
`conversion_reference`	Unknown
`conversion_time`	Unknown
`conversion_type`	Unknown
`conversion_value_commission`	Unknown
`conversion_value_conversion_status`	Unknown
`conversion_value_id`	Unknown
`conversion_value_publisher_commission`	Unknown
`conversion_value_value`	Unknown
`country`	Unknown
`creative_id`	Unknown
`creative_type`	Unknown
`currency`	Unknown
`currency_conversion_rate`	Unknown
`currency_original`	Unknown
`customer_reference`	Unknown
`customer_type`	Unknown
`end_date`	Unknown
`last_modified`	Unknown
`meta_data_commission_category`	Unknown
`meta_data_customer_country`	Unknown
`meta_data_dispute_date`	Unknown
`meta_data_event_date`	Unknown
`meta_data_event_name`	Unknown
`meta_data_event_organizer`	Unknown
`meta_data_event_series`	Unknown
`meta_data_tuid`	Unknown
`publisher_name`	Unknown
`ref_conversion_metric`	Unknown
`ref_conversion_metric_id`	Unknown
`ref_device`	Unknown
`ref_partnership_model`	Unknown
`ref_partnership_model_id`	Unknown
`ref_traffic_source`	Unknown
`ref_traffic_source_id`	Unknown
`ref_user_context`	Unknown
`ref_user_context_id`	Unknown
`referer_ip`	Unknown
`source_referer`	Unknown
`specific_creative_id`	Unknown
`start_date`	Unknown
`was_disputed`	Unknown

publisher_participating_partner_website

Column	Type	Keys
`website_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`publisher_id`	Unknown	PKFK
`active`	Unknown
`created`	Unknown
`created_by`	Unknown
`description`	Unknown
`meta`	Json
`primaries`	Unknown
`website_country`	Unknown
`website_name`	Unknown
`website_type`	Unknown
`website_type_name`	Unknown
`website_url`	Unknown
`website_vertical`	Unknown
`website_vertical_name`	Unknown

publisher_participating_partner_database

Column	Type	Keys
`id`	Unknown	PK
`publisher_participating_partner_publisher_id`	Unknown	PKFK
`active`	Unknown
`creation_method`	Unknown
`database_name`	Unknown
`female`	Unknown
`male`	Unknown
`max_age`	Unknown
`min_age`	Unknown
`size`	Unknown

publisher_participating_partner_legal_entity

Column	Type	Keys
`publisher_id`	Unknown	PK
`ref_legal_entity_id`	Unknown	PK
`publisher_participating_partner_publisher_id`	Unknown	PKFK
`associated_date`	Unknown
`publisher_contract_id`	Unknown

publisher_participating_partner_group

Column	Type	Keys
`index`	Unknown	PK
`publisher_participating_partner_publisher_id`	Unknown	PKFK
`groups`	Unknown

publisher_participating_partner

Column	Type	Keys
`publisher_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`network_id`	Unknown	FK
`abn`	Unknown
`account_name`	Unknown
`campaign_approved`	Unknown
`campaign_custom_terms_and_conditions_id`	Unknown
`campaign_custom_terms_and_conditions_title`	Unknown
`campaign_overload`	Json
`campaign_select`	Unknown
`campaign_status`	Unknown
`camref`	Unknown
`company_division`	Unknown
`company_logo`	Unknown
`company_name`	Unknown
`contact_email`	Unknown
`contact_locale`	Unknown
`contact_name`	Unknown
`created`	Unknown
`created_by`	Unknown
`default_currency`	Unknown
`description`	Unknown
`foreign_identifier`	Unknown
`gst_registered`	Unknown
`im_provider`	Unknown
`im_username`	Unknown
`is_affiliate_user`	Unknown
`is_company`	Unknown
`is_foreign_network`	Unknown
`is_lead_user`	Unknown
`is_us_registered`	Unknown
`meta`	Json
`network_meta_data`	Json
`network_note`	Unknown
`network_status`	Unknown
`operating_country`	Unknown
`opt_in`	Unknown
`phone`	Unknown
`phone_area`	Unknown
`promotional_method`	Unknown
`promotional_method_name`	Unknown
`reference_id`	Unknown
`reporting_identifier`	Unknown
`reporting_timezone`	Unknown
`signup_ip`	Unknown
`terms_and_conditions_id`	Unknown
`tin_number`	Unknown
`tracking_link`	Unknown
`uk_vat_registered`	Unknown
`us_tax_state`	Unknown
`vat_number`	Unknown
`vertical`	Unknown
`vertical_name`	Unknown
`week_start`	Unknown

conversation_explode

Column	Type	Keys
`_fivetran_id`	String	PK
`campaign_id`	Unknown	FK
`advertiser_reference`	Unknown
`average_commission`	Unknown
`average_order_size`	Unknown
`average_order_value`	Unknown
`average_partner_commission`	Unknown
`average_roas`	Unknown
`browser_family`	Unknown
`browser_major`	Unknown
`browser_minor`	Unknown
`browser_patch`	Unknown
`campaign_name`	Unknown
`category`	Unknown
`conversion_metric_id`	Unknown
`conversion_rejection_rate`	Unknown
`conversion_type_name`	Unknown
`country`	Unknown
`country_name`	Unknown
`creative_advertiser_reference`	Unknown
`creative_descriptio`	Unknown
`creative_id`	Unknown
`currency`	Unknown
`customer_reference`	Unknown
`customer_type`	Unknown
`date_time`	Unknown
`device_id`	Unknown
`device_name`	Unknown
`e_cpa`	Unknown
`os_family`	Unknown
`os_major`	Unknown
`os_minor`	Unknown
`os_patch`	Unknown
`partner_id`	Unknown
`partner_name`	Unknown
`partnership_model_id`	Unknown
`partnership_model_name`	Unknown
`percentage_average_partner_commission`	Unknown
`percentage_commission`	Unknown
`percentage_order_value`	Unknown
`percentage_partner_commission`	Unknown
`sku`	Unknown
`total_commission`	Unknown
`total_conversion_items`	Unknown
`total_conversions`	Unknown
`total_order_value`	Unknown
`total_partner_commission`	Unknown
`total_roas`	Unknown
`traffic_source_id`	Unknown
`traffic_source_name`	Unknown
`type`	Unknown
`user_context_id`	Unknown
`user_context_name`	Unknown
`voucher_code`	Unknown
`voucher_status`	Unknown
`voucher_status_name`	Unknown

metric

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`count`	Unknown
`last_raised_at`	Unknown
`metric`	Unknown
`type`	Unknown

campaign_promotional_country

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`iso`	Unknown
`name`	Unknown

campaign_commission

Column	Type	Keys
`commission_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`active`	Unknown
`advertiser_reference`	Unknown
`category`	Unknown
`commission_category`	Unknown
`commission_rate`	Unknown
`commission_value`	Unknown
`conversion_type`	Unknown
`cookie_period`	Unknown
`cookie_status`	Unknown
`country`	Unknown
`customer_reference`	Unknown
`customer_type`	Unknown
`end_date_time`	Unknown
`event_date`	Unknown
`event_name`	Unknown
`event_organizer`	Unknown
`event_series`	Unknown
`last_modified`	Unknown
`last_modified_by`	Unknown
`override`	Unknown
`override_type`	Unknown
`promotion`	Unknown
`reference_id`	Unknown
`reference_type`	Unknown
`sale_type`	Unknown
`sku`	Unknown
`start_date_time`	Unknown
`update_description`	Unknown
`vertical`	Unknown

campaign_overload

Column	Type	Keys
`index`	Unknown	PK
`publisher_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`is_cpc`	Unknown

campaign_currency_conversion

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`active`	Unknown
`created`	Unknown
`created_by`	Unknown
`from_currency`	Unknown
`to_currency`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`advertiser_id`	Unknown	FK
`advertiser_name`	Unknown
`allow_deep_linking`	Unknown
`allow_third_party_pixel`	Unknown
`app_android_fingerprint`	Unknown
`app_ios_bundle`	Unknown
`app_ios_prefix`	Unknown
`app_tracking_integration_mapping`	Unknown
`app_tracking_provider`	Unknown
`app_tracking_provider_tracking_link`	Unknown
`append_url_parameter`	Unknown
`associated_campaign`	Unknown
`auto_approve_publisher`	Unknown
`auto_rejected_ips`	Unknown
`automated_invoicing_date`	Unknown
`automated_invoicing_po_number`	Unknown
`basket_value_cap`	Unknown
`budget_summary_interval`	Unknown
`budget_summary_start_time`	Unknown
`campaign_currency_conversions`	Unknown
`campaign_icon`	Unknown
`campaign_invoice_locale`	Unknown
`campaign_language`	Unknown
`campaign_logo`	Unknown
`campaign_notes`	Unknown
`campaign_overload`	Unknown
`commission_by_meta`	Unknown
`commission_by_meta_label`	Unknown
`consolidate_invoice`	Unknown
`conversion_hiatus_period`	Unknown
`conversion_type`	Unknown
`cookie_period`	Unknown
`cookie_status`	Unknown
`created`	Unknown
`created_by`	Unknown
`creative_prepend`	Unknown
`deeplink_method`	Unknown
`default_commission_rate`	Unknown
`default_commission_value`	Unknown
`default_currency`	Unknown
`default_mobile_destination`	Unknown
`default_override`	Unknown
`deferred_lead_submission`	Unknown
`destination_url`	Unknown
`dont_consolidate`	Unknown
`dont_invoice`	Unknown
`finance_contact_email`	Unknown
`force_approve_period`	Unknown
`hash_ip_address`	Unknown
`hidden_campaign`	Unknown
`ignore_cookie_period_rejection`	Unknown
`invalid_voucher_conversion_metric_id`	Unknown
`invoice_address_1`	Unknown
`invoice_address_2`	Unknown
`invoice_address_3`	Unknown
`invoice_address_4`	Unknown
`invoice_address_country`	Unknown
`invoice_address_postcode`	Unknown
`invoice_company`	Unknown
`invoice_contact`	Unknown
`invoice_only`	Unknown
`ip_tracking_time`	Unknown
`is_cpc`	Unknown
`is_cpc_default`	Unknown
`last_modified`	Unknown
`lead_confirmation_url_fail`	Unknown
`lead_confirmation_url_success`	Unknown
`meta_field_values_field_limit`	Unknown
`meta_field_values_total_limit`	Unknown
`multiple_conversions_per_click`	Unknown
`network_fee`	Unknown
`pay_publisher_directly`	Unknown
`payment_date`	Unknown
`prepend_url_string`	Unknown
`recurring_payment_setup`	Unknown
`reporting_timezone`	Unknown
`secure_tracking`	Unknown
`short_link_subdomain`	Unknown
`status`	Unknown
`test_mode`	Unknown
`title`	Unknown
`tq_auto_approve`	Unknown
`tq_enabled`	Unknown
`tracking_method`	Unknown
`tracking_subdomain`	Unknown
`unique_conversion_ref`	Unknown
`vertical_id`	Unknown
`vertical_name`	Unknown
`week_start`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`average_conversion_age`	Unknown
`creation_date`	Unknown
`currency`	Unknown
`download`	Unknown
`invoice_net_value`	Unknown
`invoice_reference`	Unknown
`invoice_total_value`	Unknown
`invoice_vat_value`	Unknown
`invoiced`	Unknown
`item_download`	Unknown
`merchant_invoice_id`	Unknown
`paid_currency`	Unknown
`payment_date`	Unknown
`payment_due_by_date`	Unknown
`payment_reference`	Unknown
`pdf_generated`	Unknown
`publisher_commission`	Unknown
`publisher_override`	Unknown
`report_generated`	Unknown
`set_end_date`	Unknown
`set_start_date`	Unknown
`set_timezone`	Unknown
`status`	Unknown
`vat_rate`	Unknown

voucher_commission_groups

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

voucher_commission

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`end_date`	Unknown
`group_limit_id`	Unknown
`group_limit_name`	Unknown
`last_modified`	Unknown
`last_modified_by`	Unknown
`meta_fields`	Json
`performance_model`	Unknown
`performance_value`	Unknown
`start_date`	Unknown
`status`	Unknown

device

Column	Type	Keys
`ref_device_id`	Unknown	PK
`description`	Unknown
`key`	Unknown
`skip_invoice`	Unknown
`skip_override`	Unknown
`skip_selfbill`	Unknown
`title`	Unknown

incident

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`deleted_at`	Unknown
`metric`	Unknown
`occurred_at`	Unknown
`partner_id`	Unknown
`partner_name`	Unknown
`status`	Unknown
`time_window`	Unknown
`type`	Unknown