# sticky.io schema ERD

Table and field reference for the Fivetran sticky.io connector.

## Table & Field Reference

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| warehouse_info_id | Unknown | FK |
| allocated_quantity | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |
| variant_info_description | Unknown |  |
| variant_info_type | Unknown |  |

### offer_product

| Column | Type | Keys |
| --- | --- | --- |
| offer_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### offer_billing_model

| Column | Type | Keys |
| --- | --- | --- |
| billing_model_id | Unknown | PK, FK |
| offer_id | Unknown | PK, FK |

### offer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| terminating_product_id | Unknown | FK |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| cycle_products | Unknown |  |
| cycle_type_id | Unknown |  |
| cycle_type_name | Unknown |  |
| expire_cycles | Unknown |  |
| is_archived | Unknown |  |
| is_available_on_syncable | Unknown |  |
| is_immutable | Unknown |  |
| is_prepaid | Unknown |  |
| is_seasonal | Unknown |  |
| is_series | Unknown |  |
| is_store | Unknown |  |
| is_trial | Unknown |  |
| name | Unknown |  |
| prepaid_profile | Unknown |  |
| seasonal_products | Unknown |  |
| terminating_cycle_type_description | Unknown |  |
| terminating_cycle_type_id | Unknown |  |
| terminating_cycle_type_name | Unknown |  |
| trial | Json |  |
| trial_days | Unknown |  |
| trial_is_custom_duration | Unknown |  |
| trial_is_custom_price | Unknown |  |
| trial_is_delayed_billing | Unknown |  |
| trial_workflows | Json |  |
| type_active | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| type_smc_active | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |

### gateway_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| type | Unknown |  |

### product_image

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| alias | Unknown |  |
| created_at | Unknown |  |
| is_default | Unknown |  |
| is_default_email | Unknown |  |
| path | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_description | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| cost_of_goods | Unknown |  |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| custom_fields | Json |  |
| declared_value | Unknown |  |
| description | Unknown |  |
| is_bundle | Unknown |  |
| is_custom_bundle | Unknown |  |
| is_licensed | Unknown |  |
| is_shippable | Unknown |  |
| is_trial_product | Unknown |  |
| is_variant_enabled | Unknown |  |
| legacy_subscription_cycle | Unknown |  |
| legacy_subscription_next_product_id | Unknown |  |
| legacy_subscription_type | Unknown |  |
| max_items | Unknown |  |
| max_quantity | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| restocking_fee | Unknown |  |
| sku | Unknown |  |
| taxable | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |
| vertical_id | Unknown |  |
| vertical_name | Unknown |  |

### coupon_promo_code

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| code | Unknown |  |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| created_by | Unknown |  |
| is_active | Unknown |  |
| is_deleted | Unknown |  |
| use_count | Unknown |  |

### coupon_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coupon_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| variant_id | Unknown | FK |
| is_eligible | Unknown |  |

### coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| updator_id | Unknown | FK |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| description | Unknown |  |
| discount_amount | Unknown |  |
| discount_amt | Unknown |  |
| discount_pct | Unknown |  |
| discount_percent | Unknown |  |
| expires_at | Unknown |  |
| is_active | Unknown |  |
| is_bogo | Unknown |  |
| is_buy_x_get_y | Unknown |  |
| is_free_shipping | Unknown |  |
| is_lifetime | Unknown |  |
| limits | Unknown |  |
| limits_per_code | Unknown |  |
| limits_per_code_per_customer | Unknown |  |
| limits_per_customer | Unknown |  |
| limits_total | Unknown |  |
| max_qty | Unknown |  |
| maximum_quantity | Unknown |  |
| min_qty | Unknown |  |
| minimum_purchase | Unknown |  |
| minimum_quantity | Unknown |  |
| name | Unknown |  |
| promo_code_count | Unknown |  |
| type_id | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |
| use_count | Unknown |  |

### billing_model

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| updator_id | Unknown | FK |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| date | Unknown |  |
| dates | Unknown |  |
| day | Unknown |  |
| days | Unknown |  |
| description | Unknown |  |
| expire_cycles | Unknown |  |
| frequency | Unknown |  |
| frequency_type_id | Unknown |  |
| is_archived | Unknown |  |
| is_default | Unknown |  |
| is_preserve_quantity | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| updated_at | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |

### product_variant_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| product_variant_id | Unknown | PK, FK |
| attribute_id | Unknown |  |
| attribute_name | Unknown |  |
| attribute_option_id | Unknown |  |
| attribute_option_name | Unknown |  |

### product_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| price | Unknown |  |
| quantity | Unknown |  |
| sku_num | Unknown |  |
| weight | Unknown |  |

### warehouse

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| country_id | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |
| zip | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_center_provider_id | Unknown |  |
| created_at | Unknown |  |
| department_id | Unknown |  |
| email | Unknown |  |
| is_active | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |

### gateway_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gateway_account_id | Unknown | PK, FK |
| alias | Unknown |  |
| created_on | Unknown |  |
| currency_code | Unknown |  |
| currency_id | Unknown |  |
| currency_symbol_left | Unknown |  |
| currency_title | Unknown |  |
| current_monthly_amount | Unknown |  |
| processing_percent | Unknown |  |

### campaign_country

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| calling_code | Unknown |  |
| iso_2 | Unknown |  |
| iso_3 | Unknown |  |
| iso_numeric | Unknown |  |
| name | Unknown |  |

### campaign_offer

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| offer_id | Unknown | PK, FK |

### campaign_payment_method

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### campaign_postback_profile_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| campaign_postback_profile_id | Unknown | PK, FK |

### campaign_postback_profile_header

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| campaign_postback_profile_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| key | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### campaign_postback_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| creator_id | Unknown | FK |
| updator_id | Unknown | FK |
| created_at | Unknown |  |
| http_method | Unknown |  |
| is_active | Unknown |  |
| is_global | Unknown |  |
| name | Unknown |  |
| trigger_type_id | Unknown |  |
| triggers | Json |  |
| type | Unknown |  |
| type_id | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### campaign_shipping_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| amount_recurring | Unknown |  |
| amount_trial | Unknown |  |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| description | Unknown |  |
| freight_code | Unknown |  |
| name | Unknown |  |
| threshold_amount | Unknown |  |
| threshold_charge_amount | Unknown |  |
| type_code | Unknown |  |
| type_created_at_date | Unknown |  |
| type_created_at_timezone | Unknown |  |
| type_created_at_timezone_type | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| type_updated_at | Unknown |  |

### campaign_product

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| is_trial_allowed | Unknown |  |

### campaign_coupon_profile

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| coupon_id | Unknown | PK, FK |

### campaign_fraud_provider

| Column | Type | Keys |
| --- | --- | --- |
| fraud_providers_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| updator_id | Unknown | FK |
| alternative_payments | Json |  |
| archived_at_date | Unknown |  |
| archived_at_timezone | Unknown |  |
| archived_at_timezone_type | Unknown |  |
| call_confirm_provider_id | Unknown |  |
| channel_id | Unknown |  |
| channel_name | Unknown |  |
| chargeback_provider_id | Unknown |  |
| check_provider_id | Unknown |  |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| data_verification_provider_id | Unknown |  |
| description | Unknown |  |
| email_provider_id | Unknown |  |
| fulfillment_id | Unknown |  |
| gateway_id | Unknown |  |
| is_active | Unknown |  |
| is_archived | Unknown |  |
| is_avs_enabled | Unknown |  |
| is_collections_enabled | Unknown |  |
| is_custom_price_allowed | Unknown |  |
| is_prepaid_blocked | Unknown |  |
| max_grace_period | Unknown |  |
| membership_provider_id | Unknown |  |
| name | Unknown |  |
| pre_auth_amount | Unknown |  |
| prospect_provider_id | Unknown |  |
| return_profiles | Json |  |
| site_url | Unknown |  |
| tax_provider_id | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |

### orders_product

| Column | Type | Keys |
| --- | --- | --- |
| orders_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |
| billing_model_id | Unknown | FK |
| offer_id | Unknown | FK |
| billing_model_discount | Unknown |  |
| forecasted_revenue | Unknown |  |
| hold_date | Unknown |  |
| is_add_on | Unknown |  |
| is_full_refund | Unknown |  |
| is_in_trial | Unknown |  |
| is_recurring | Unknown |  |
| is_shippable | Unknown |  |
| is_terminal | Unknown |  |
| next_subscription_product | Unknown |  |
| next_subscription_product_id | Unknown |  |
| next_subscription_product_price | Unknown |  |
| next_subscription_qty | Unknown |  |
| on_hold | Unknown |  |
| recurring_date | Unknown |  |
| refund_amount | Unknown |  |
| step_number | Unknown |  |
| subscription_id | Unknown |  |

### orders_system_note

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_id | Unknown | PK, FK |
| system_note | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| coupon_id | Unknown | FK |
| acquisition_date | Unknown |  |
| affid | Unknown |  |
| affiliate | Unknown |  |
| afid | Unknown |  |
| aid | Unknown |  |
| amount_refunded | Unknown |  |
| amount_refunded_to_date | Unknown |  |
| ancestor_id | Unknown |  |
| auth_id | Unknown |  |
| billing_city | Unknown |  |
| billing_company_name | Unknown |  |
| billing_country | Unknown |  |
| billing_cycle | Unknown |  |
| billing_first_name | Unknown |  |
| billing_last_name | Unknown |  |
| billing_postcode | Unknown |  |
| billing_state | Unknown |  |
| billing_state_id | Unknown |  |
| billing_street_address | Unknown |  |
| billing_street_address_2 | Unknown |  |
| c_1 | Unknown |  |
| c_2 | Unknown |  |
| c_3 | Unknown |  |
| cc_expires | Unknown |  |
| cc_first_6 | Unknown |  |
| cc_last_4 | Unknown |  |
| cc_number | Unknown |  |
| cc_orig_first_6 | Unknown |  |
| cc_orig_last_4 | Unknown |  |
| cc_type | Unknown |  |
| chargeback_date | Unknown |  |
| check_account_last_4 | Unknown |  |
| check_routing_last_4 | Unknown |  |
| check_ssn_last_4 | Unknown |  |
| check_transitnum | Unknown |  |
| child_id | Unknown |  |
| click_id | Unknown |  |
| consent_received | Unknown |  |
| consent_required | Unknown |  |
| coupon_discount_amount | Unknown |  |
| created_by_employee_name | Unknown |  |
| created_by_user_name | Unknown |  |
| credit_applied | Unknown |  |
| credit_card_number | Unknown |  |
| current_rebill_discount_percent | Unknown |  |
| customer_id | Unknown |  |
| customers_telephone | Unknown |  |
| decline_reason | Unknown |  |
| decline_reason_details | Unknown |  |
| decline_salvage_discount_percent | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| gateway_descriptor | Unknown |  |
| gateway_id | Unknown |  |
| hold_date | Unknown |  |
| ip_address | Unknown |  |
| ip_address_lookup | Unknown |  |
| is_3_d_protected | Unknown |  |
| is_any_product_recurring | Unknown |  |
| is_blacklisted | Unknown |  |
| is_cascaded | Unknown |  |
| is_chargeback | Unknown |  |
| is_fraud | Unknown |  |
| is_recurring | Unknown |  |
| is_refund | Unknown |  |
| is_rma | Unknown |  |
| is_test_cc | Unknown |  |
| is_void | Unknown |  |
| last_name | Unknown |  |
| main_product_id | Unknown |  |
| main_product_quantity | Unknown |  |
| next_subscription_product | Unknown |  |
| next_subscription_product_id | Unknown |  |
| on_hold | Unknown |  |
| on_hold_by | Unknown |  |
| opt | Unknown |  |
| order_confirmed | Unknown |  |
| order_confirmed_date | Unknown |  |
| order_customer_types | Json |  |
| order_sales_tax | Unknown |  |
| order_sales_tax_amount | Unknown |  |
| order_status | Unknown |  |
| order_total | Unknown |  |
| parent_id | Unknown |  |
| prepaid_match | Unknown |  |
| preserve_gateway | Unknown |  |
| processor_id | Unknown |  |
| promo_code | Unknown |  |
| rebill_discount_percent | Unknown |  |
| recurring_date | Unknown |  |
| refund_amount | Unknown |  |
| refund_date | Unknown |  |
| refunded | Unknown |  |
| restocking_fee | Unknown |  |
| retry_attempt | Unknown |  |
| retry_date | Unknown |  |
| return_reason | Unknown |  |
| rma_number | Unknown |  |
| rma_reason | Unknown |  |
| shippable | Unknown |  |
| shipping | Unknown |  |
| shipping_amount | Unknown |  |
| shipping_city | Unknown |  |
| shipping_company_name | Unknown |  |
| shipping_country | Unknown |  |
| shipping_date | Unknown |  |
| shipping_first_name | Unknown |  |
| shipping_id | Unknown |  |
| shipping_last_name | Unknown |  |
| shipping_method_name | Unknown |  |
| shipping_postcode | Unknown |  |
| shipping_state | Unknown |  |
| shipping_state_id | Unknown |  |
| shipping_street_address | Unknown |  |
| shipping_street_address_2 | Unknown |  |
| sid | Unknown |  |
| stop_after_next_rebill | Unknown |  |
| sub_affiliate | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| tax_pct | Unknown |  |
| time_stamp | Unknown |  |
| total | Unknown |  |
| tracking_number | Unknown |  |
| transaction_id | Unknown |  |
| upsell_product_id | Unknown |  |
| upsell_product_quantity | Unknown |  |
| utm_info_campaign | Unknown |  |
| utm_info_content | Unknown |  |
| utm_info_device_category | Unknown |  |
| utm_info_medium | Unknown |  |
| utm_info_source | Unknown |  |
| utm_info_term | Unknown |  |
| vat_tax | Unknown |  |
| vat_tax_pct | Unknown |  |
| void_amount | Unknown |  |
| void_date | Unknown |  |
| volume_discount | Unknown |  |
| website_received | Unknown |  |
| website_sent | Unknown |  |

### affiliate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| created_at | Unknown |  |
| network | Unknown |  |
| type_active | Unknown |  |
| type_id | Unknown |  |
| type_name | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### contact_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| creator_id | Unknown | FK |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_default | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| phone_key | Unknown |  |
| state | Unknown |  |
| street | Unknown |  |
| street_2 | Unknown |  |
| updated_at | Unknown |  |
| uuid | Unknown |  |
| zip | Unknown |  |

### contact_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| creator_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| updated_at | Unknown |  |
| updator | Unknown |  |
| value | Unknown |  |

### contact_custom_field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_custom_field_id | Unknown | PK, FK |
| contact_id | Unknown | PK, FK |
| value | Unknown |  |

### contact_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| field_type_id | Unknown |  |
| is_multi | Unknown |  |
| name | Unknown |  |
| token_key | Unknown |  |
| type_id | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | LocalDateTime |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_member | Unknown |  |
| is_sms_communication_enabled | Unknown |  |
| last_name | Unknown |  |
| opted_communications | Unknown |  |
| origin_id | Unknown |  |
| phone | Unknown |  |
| phone_key | Unknown |  |

## Relationships

- inventory(product_id) → product(id)
- inventory(warehouse_info_id) → warehouse(id)
- offer_product(product_id) → product(id)
- offer_product(offer_id) → offer(id)
- offer_billing_model(billing_model_id) → billing_model(id)
- offer_billing_model(offer_id) → offer(id)
- offer(terminating_product_id) → product(id)
- product_image(product_id) → product(id)
- coupon_promo_code(coupon_id) → coupon(id)
- coupon_product(product_id) → product(id)
- coupon_product(variant_id) → product_variant(id)
- coupon_product(coupon_id) → coupon(id)
- coupon(updator_id) → users(id)
- coupon(creator_id) → users(id)
- billing_model(updator_id) → users(id)
- billing_model(creator_id) → users(id)
- product_variant_attribute(product_variant_id) → product_variant(id)
- product_variant_attribute(product_id) → product_variant(product_id)
- product_variant(product_id) → product(id)
- warehouse(updated_by_id) → users(id)
- warehouse(created_by_id) → users(id)
- gateway_profile(gateway_account_id) → gateway_account(id)
- campaign_country(campaign_id) → campaign(id)
- campaign_offer(offer_id) → offer(id)
- campaign_offer(campaign_id) → campaign(id)
- campaign_payment_method(campaign_id) → campaign(id)
- campaign_postback_profile_campaign(campaign_id) → campaign(id)
- campaign_postback_profile_campaign(campaign_postback_profile_id) → campaign_postback_profile(id)
- campaign_postback_profile_header(created_by_id) → users(id)
- campaign_postback_profile_header(updated_by_id) → users(id)
- campaign_postback_profile_header(campaign_postback_profile_id) → campaign_postback_profile(id)
- campaign_postback_profile_header(campaign_id) → campaign_postback_profile(campaign_id)
- campaign_postback_profile(updator_id) → users(id)
- campaign_postback_profile(creator_id) → users(id)
- campaign_postback_profile(campaign_id) → campaign(id)
- campaign_shipping_profile(campaign_id) → campaign(id)
- campaign_product(product_id) → product(id)
- campaign_product(campaign_id) → campaign(id)
- campaign_coupon_profile(coupon_id) → coupon(id)
- campaign_coupon_profile(campaign_id) → campaign(id)
- campaign_fraud_provider(campaign_id) → campaign(id)
- campaign(updator_id) → users(id)
- campaign(creator_id) → users(id)
- orders_product(product_id) → product(id)
- orders_product(billing_model_id) → billing_model(id)
- orders_product(offer_id) → offer(id)
- orders_product(orders_id) → orders(id)
- orders_system_note(orders_id) → orders(id)
- orders(campaign_id) → campaign(id)
- orders(coupon_id) → coupon(id)
- orders(contact_id) → contact(id)
- affiliate(updated_by_id) → users(id)
- affiliate(created_by_id) → users(id)
- contact_address(creator_id) → users(id)
- contact_address(contact_id) → contact(id)
- contact_note(creator_id) → users(id)
- contact_note(contact_id) → contact(id)
- contact_custom_field_option(contact_custom_field_id) → contact_custom_field(id)
- contact_custom_field_option(contact_id) → contact_custom_field(contact_id)
- contact_custom_field(contact_id) → contact(id)