# VWO schema ERD

Table and field reference for the Fivetran VWO connector.

## Table & Field Reference

### variation_stack

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| variation_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| creator | Unknown |  |
| depending | Unknown |  |
| el | Unknown |  |
| el_dependent_on | Unknown |  |
| identifier | Unknown |  |
| leading_comments | Unknown |  |
| meta_info | Json |  |
| modified | Unknown |  |
| op_name | Unknown |  |
| op_vwo_css_display | Unknown |  |
| original_short_selector_path | Unknown |  |
| parent_short_selector_path | Unknown |  |
| parent_tag | Unknown |  |
| segment_active | Unknown |  |
| segment_class | Unknown |  |
| segment_device | Unknown |  |
| segment_real_device | Unknown |  |
| segment_real_url | Unknown |  |
| segment_url | Unknown |  |
| segment_url_regex | Unknown |  |
| short_selector_path | Unknown |  |
| trailing_comments | Unknown |  |
| variables | Json |  |
| xpath | Unknown |  |

### variation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| section_id | Unknown | FK |
| editor_data_registered_triggers | Json |  |
| heatmap_thumb_url | Unknown |  |
| is_control | Unknown |  |
| is_disabled | Unknown |  |
| name | Unknown |  |
| percent_split | Unknown |  |
| screenshots_quick | Unknown |  |

### campaign_detail_variation

| Column | Type | Keys |
| --- | --- | --- |
| campaign_detail_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |

### campaign_detail_goal

| Column | Type | Keys |
| --- | --- | --- |
| campaign_detail_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |

### campaign_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| data_interval_range | Json |  |
| device | Unknown |  |
| integrations_clicktaleenabled | Unknown |  |
| integrations_gaenabled | Unknown |  |
| integrations_gaprefix | Unknown |  |
| integrations_gaslot | Unknown |  |
| integrations_gtmenabled | Unknown |  |
| integrations_uadimension | Unknown |  |
| integrations_uaenabled | Unknown |  |
| integrations_uaprefix | Unknown |  |
| is_cross_domain_enabled | Unknown |  |
| is_deleted | Unknown |  |
| is_global_segment_enabled | Unknown |  |
| schedules | Json |  |
| thershold_losing_percent | Unknown |  |
| thershold_visitors | Unknown |  |
| thershold_winning_percent | Unknown |  |
| variation_goal_data | Json |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| name | Unknown |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_name | Unknown |  |
| company_size | Unknown |  |
| company_website | Unknown |  |
| created_on | Unknown |  |
| enabled | Unknown |  |
| is_active | Unknown |  |
| is_main_account | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

### campaign_url

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

### campaign_goal_partial_collection

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| id | Unknown | FK |
| average_data_conversion_count | Unknown |  |
| average_data_conversion_rate | Unknown |  |
| average_data_visitor_count | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| created_by_id | Unknown | FK |
| associate_campaign | Json |  |
| campaign_group | Json |  |
| created_by_image_url | Unknown |  |
| created_on | Unknown |  |
| excluded_urls | Json |  |
| is_bayesian | Unknown |  |
| is_deleted | Unknown |  |
| labels | Json |  |
| name | Unknown |  |
| platform | Unknown |  |
| primary_goal | Unknown |  |
| primary_url | Unknown |  |
| stats_expected_conversion_rate | Unknown |  |
| stats_expected_daily_visitor | Unknown |  |
| stats_expected_improvement_rate | Unknown |  |
| stats_expected_revenue_per_visitor | Unknown |  |
| stats_threshold_of_caring | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| variation_partial_collection | Json |  |
| variation_total_count | Unknown |  |

### partner

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| commission_disbursed | Unknown |  |
| commission_percent | Unknown |  |
| free_users | Unknown |  |
| paid_users | Unknown |  |
| referral_code | Unknown |  |
| sales | Unknown |  |
| total_commission | Unknown |  |

### project_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| languages | Unknown |  |

### project_environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| is_enabled | Unknown |  |
| name | Unknown |  |
| token | Unknown |  |
| webhook_is_enabled | Unknown |  |
| webhook_secret_key | Unknown |  |
| webhook_url | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| created_by_image_url | Unknown |  |
| created_by_name | Unknown |  |
| created_on | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |

### billing_cycle_invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| billing_cycle_id | Unknown | PK, FK |
| link | Unknown |  |
| type | Unknown |  |

### billing_cycle_usage

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| billing_cycle_id | Unknown | PK, FK |
| account | Unknown |  |
| visitors_used | Unknown |  |

### billing_cycle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| unique_id | Unknown | FK |
| extension_of | Unknown |  |
| extensions | Unknown |  |
| is_current | Unknown |  |
| is_paid | Unknown |  |
| is_v_4_plan_description | Unknown |  |
| is_v_4_plan_id | Unknown |  |
| is_v_4_plan_is_enterprise | Unknown |  |
| is_v_4_plan_is_top_visitor_plan | Unknown |  |
| is_v_4_plan_is_unlimited_plan | Unknown |  |
| is_v_4_plan_is_v_4_plan | Unknown |  |
| is_v_4_plan_price | Unknown |  |
| is_v_4_plan_processor_id | Unknown |  |
| is_v_4_plan_total_visitors | Unknown |  |
| is_v_4_plan_type | Unknown |  |
| research_visitors_allowed | Unknown |  |
| sf_contract_amount | Unknown |  |
| sf_contract_is_paid | Unknown |  |
| sf_contract_is_payment_required | Unknown |  |
| sf_contract_sf_contact_id | Unknown |  |
| visitor_allowed | Unknown |  |
| visitors_used | Unknown |  |
| workspace_from | Unknown |  |
| workspace_to | Unknown |  |

### goal_css_selector

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| goal_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| css_selectors | Unknown |  |

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| excluded_urls | Json |  |
| is_created_in_editor | Unknown |  |
| is_primary | Unknown |  |
| name | Unknown |  |
| p_excluded_urls | Json |  |
| p_urls | Json |  |
| type | Unknown |  |
| urls | Json |  |

### feature_variable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| data_type | Unknown |  |
| default_value | Unknown |  |
| variable_name | Unknown |  |

### feature_associated_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### feature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| created_by_image_url | Unknown |  |
| created_by_name | Unknown |  |
| created_on | Unknown |  |
| modified_on | Unknown |  |
| name | Unknown |  |
| setting_is_editable | Unknown |  |

### campaign_share_link

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| workspace_id | Unknown | FK |
| share_link | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | Unknown | PK, FK |
| country | Unknown |  |
| created_on | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| permission | Unknown |  |
| phone | Unknown |  |
| title | Unknown |  |

### section_variation

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| section_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |

### section

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| css_selector | Unknown |  |
| name | Unknown |  |

## Relationships

- variation_stack(variation_id) → variation(id)
- variation_stack(workspace_id) → variation(workspace_id)
- variation_stack(campaign_id) → variation(campaign_id)
- variation(section_id) → section(id)
- variation(workspace_id) → workspace(id)
- variation(campaign_id) → campaign(id)
- campaign_detail_variation(id) → variation(id)
- campaign_detail_variation(campaign_detail_id) → campaign_detail(id)
- campaign_detail_variation(workspace_id) → campaign_detail(workspace_id)
- campaign_detail_goal(id) → goal(id)
- campaign_detail_goal(campaign_detail_id) → campaign_detail(id)
- campaign_detail_goal(workspace_id) → campaign_detail(workspace_id)
- campaign_detail(id) → campaign(id)
- campaign_detail(workspace_id) → campaign(workspace_id)
- label(workspace_id) → workspace(id)
- campaign_url(campaign_id) → campaign(id)
- campaign_url(workspace_id) → campaign(workspace_id)
- campaign_goal_partial_collection(id) → goal(id)
- campaign_goal_partial_collection(campaign_id) → campaign(id)
- campaign_goal_partial_collection(workspace_id) → campaign(workspace_id)
- campaign(created_by_id) → users(id)
- campaign(workspace_id) → workspace(id)
- project_language(workspace_id) → project(workspace_id)
- project_language(project_id) → project(id)
- project_environment(workspace_id) → project(workspace_id)
- project_environment(project_id) → project(id)
- project(workspace_id) → workspace(id)
- billing_cycle_invoice(billing_cycle_id) → billing_cycle(id)
- billing_cycle_usage(billing_cycle_id) → billing_cycle(id)
- billing_cycle(unique_id) → workspace(id)
- goal_css_selector(goal_id) → goal(id)
- goal_css_selector(workspace_id) → goal(workspace_id)
- goal_css_selector(campaign_id) → goal(campaign_id)
- goal(workspace_id) → workspace(id)
- goal(campaign_id) → campaign(id)
- feature_variable(feature_id) → feature(id)
- feature_variable(workspace_id) → feature(workspace_id)
- feature_associated_campaign(feature_id) → feature(id)
- feature_associated_campaign(workspace_id) → feature(workspace_id)
- feature(workspace_id) → workspace(id)
- campaign_share_link(workspace_id) → workspace(id)
- campaign_share_link(campaign_id) → campaign(id)
- users(workspace_id) → workspace(id)
- section_variation(id) → variation(id)
- section_variation(workspace_id) → section(workspace_id)
- section_variation(campaign_id) → section(campaign_id)
- section_variation(section_id) → section(id)
- section(workspace_id) → workspace(id)
- section(campaign_id) → campaign(id)