sticky.io

Explore the interactive ERD

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	PKFK
`product_id`	Unknown	PKFK

offer_billing_model

Column	Type	Keys
`billing_model_id`	Unknown	PKFK
`offer_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`product_variant_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`calling_code`	Unknown
`iso_2`	Unknown
`iso_3`	Unknown
`iso_numeric`	Unknown
`name`	Unknown

campaign_offer

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`offer_id`	Unknown	PKFK

campaign_payment_method

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown

campaign_postback_profile_campaign

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`campaign_postback_profile_id`	Unknown	PKFK

campaign_postback_profile_header

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`campaign_postback_profile_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`product_id`	Unknown	PKFK
`is_trial_allowed`	Unknown

campaign_coupon_profile

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`coupon_id`	Unknown	PKFK

campaign_fraud_provider

Column	Type	Keys
`fraud_providers_id`	Unknown	PK
`campaign_id`	Unknown	PKFK

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	PKFK
`product_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`contact_id`	Unknown	PKFK
`value`	Unknown

contact_custom_field

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