# Chameleon schema ERD

Table and field reference for the Fivetran Chameleon connector.

## Table & Field Reference

### company_property

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| description | String |  |
| integration | String |  |
| kind | String |  |
| last_seen_at | Instant |  |
| name | String |  |
| prop | String |  |
| types | Json |  |
| updated_at | Instant |  |
| values | Json |  |

### domain

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| url_group_id_ | Unknown | FK |
| archived_at | Instant |  |
| created_at | Instant |  |
| domain | String |  |
| enabled | String |  |
| first_seen_at | Instant |  |
| host | String |  |
| installed_at | Instant |  |
| last_seen_at | Instant |  |
| updated_at | Instant |  |
| url_group_id | String |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived_at | Instant |  |
| created_at | Instant |  |
| description | String |  |
| name | String |  |
| short_name | String |  |
| style_short_name_color | String |  |
| updated_at | Instant |  |

### micro_survey_response

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| profile_company_id | String | FK |
| profile_id | String | FK |
| survey_id | String | FK |
| button_id | String |  |
| button_order | String |  |
| button_text | String |  |
| comment_step_button_selected | Unknown |  |
| comment_step_button_selected_2 | Unknown |  |
| comment_step_dropdown_item | Unknown |  |
| comment_step_dropdown_item_2 | Unknown |  |
| comment_step_input_text | Unknown |  |
| comment_step_input_text_2 | Unknown |  |
| comment_step_other_text | Unknown |  |
| comment_step_other_text_2 | Unknown |  |
| created_at | Instant |  |
| dropdown_items | String |  |
| finished_at | Instant |  |
| href | String |  |
| input_text | String |  |
| input_text_2 | Unknown |  |
| other_text | Unknown |  |
| profile_company_uid | String |  |
| profile_uid | String |  |
| updated_at | Instant |  |

### tour_interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| profile_company_id | String | FK |
| profile_id | String | FK |
| tour_id | String | FK |
| created_at | Instant |  |
| defer_count | Unknown |  |
| defer_until | String |  |
| goal_at | Instant |  |
| group_id | String |  |
| group_kind | String |  |
| profile_company_uid | String |  |
| profile_uid | String |  |
| state | String |  |
| updated_at | Instant |  |

### rate_limit_group_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| rate_limit_group_id | String | PK, FK |

### rate_limit_group_tag

| Column | Type | Keys |
| --- | --- | --- |
| rate_limit_group_id | String | PK, FK |
| tag_id | String | PK, FK |

### rate_limit_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| kind | String |  |
| name | String |  |
| rate_limit_kind | String |  |
| rate_limit_size | Unknown |  |
| updated_at | Instant |  |

### webhook

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | String |  |
| last_item_at | Instant |  |
| last_item_error | String |  |
| last_item_state | String |  |
| name | String |  |
| uid | String |  |

### profile_property

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| description | String |  |
| integration | String |  |
| kind | String |  |
| last_seen_at | Instant |  |
| name | String |  |
| prop | String |  |
| types | Json |  |
| updated_at | Instant |  |
| values | Json |  |

### experience_delivery

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| interaction_id | String | FK |
| profile_id | String | FK |
| at | Instant |  |
| at_href | String |  |
| created_at | Instant |  |
| delivery_ids_at_limit | Unknown |  |
| delivery_ids_limit | Unknown |  |
| delivery_ids_position | Unknown |  |
| from_date | Instant |  |
| group_kind | String |  |
| idempotency_key | String |  |
| model_id | String |  |
| model_kind | String |  |
| once | Boolean |  |
| options | String |  |
| skip_triggers | Boolean |  |
| skip_url_match | Boolean |  |
| until | Instant |  |
| updated_at | Instant |  |
| use_segmentation | Boolean |  |

### segment_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| segment_id | String | FK |
| created_at | Instant |  |
| kind | String |  |
| mod | String |  |
| op | String |  |
| prop | String |  |
| range | String |  |
| updated_at | Instant |  |
| value | String |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| name | String |  |
| updated_at | Instant |  |

### launcher_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| segment_id | String | FK |
| campaign_id | String |  |
| created_at | Instant |  |
| description | String |  |
| hide | Boolean |  |
| kind | String |  |
| script | String |  |
| title | String |  |
| updated_at | Instant |  |
| url | String |  |

### launcher_tag

| Column | Type | Keys |
| --- | --- | --- |
| launcher_id | String | PK, FK |
| tag_id | String | PK, FK |

### launcher

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| segment_id | String | FK |
| blocked_domains | String |  |
| created_at | Instant |  |
| description | String |  |
| empty_state_content | String |  |
| icon_size | String |  |
| list_type | String |  |
| name | String |  |
| position_type | String |  |
| preset | String |  |
| published_at | Instant |  |
| quantifier_url | String |  |
| quantifier_urls | Json |  |
| screen_position | String |  |
| search_placeholder | String |  |
| stats_completed_count | Unknown |  |
| stats_exited_count | Unknown |  |
| stats_last_completed_at | Instant |  |
| stats_last_exited_at | Instant |  |
| stats_last_started_at | Instant |  |
| stats_started_count | Unknown |  |
| title | String |  |
| trigger | String |  |
| trigger_text | String |  |
| trigger_type | String |  |
| updated_at | Instant |  |

### zapier_hook

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| id | String |  |
| last_item_at | Instant |  |
| last_item_error | String |  |
| last_item_state | String |  |
| name | String |  |
| uid | String |  |

### user_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| browser_k | String |  |
| browser_l | String |  |
| browser_n | String |  |
| browser_tz | Unknown |  |
| browser_x | Unknown |  |
| company | Json |  |
| created_at | Instant |  |
| delivery_ids | Json |  |
| email | String |  |
| first_name | String |  |
| invited_users_count | Unknown |  |
| last_import_at | Instant |  |
| last_seen_at | Instant |  |
| last_seen_session_count | Unknown |  |
| percents | Unknown |  |
| role | String |  |
| uid | String |  |
| updated_at | Instant |  |

### user_profile_segment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_profile_temp_segment_id | String |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| clv | String |  |
| created_at | Instant |  |
| domain | String |  |
| last_action_at | Instant |  |
| name | String |  |
| plan | String |  |
| uid | String |  |
| updated_at | Instant |  |

### data_import_property

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| data_import_id | String | FK |
| name | String |  |
| prop | String |  |

### data_import_head_column

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| data_import_id | String | FK |
| name | String |  |
| values | Json |  |

### data_import

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| import_at | Instant |  |
| kind | String |  |
| model_kind | String |  |
| name | String |  |
| on_model_missing | String |  |
| stats_last_import_at | Instant |  |
| stats_last_import_state | String |  |
| stats_last_row | Long |  |
| stats_rows_count | Long |  |
| tag_import_id | String |  |
| updated_at | Instant |  |

### tooltip_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | String | PK, FK |
| tooltip_id | String | PK, FK |

### tooltip

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| name | String |  |
| position | String |  |
| published_at | Instant |  |
| updated_at | Instant |  |

### alert_group_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | String | PK |
| alert_group_id | String | PK, FK |

### alert_group_experience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| alert_group_id | String | FK |
| name | String |  |

### alert_group_tag

| Column | Type | Keys |
| --- | --- | --- |
| alert_group_id | String | PK, FK |
| tag_id | String | PK, FK |

### alert_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| emails | Json |  |
| interval | Unknown |  |
| kind | String |  |
| last_notified_at | Instant |  |
| name | String |  |
| opt_in_email_at | Instant |  |
| opt_in_slack_at | Instant |  |
| published_at | Instant |  |
| slack_uid | String |  |
| style | String |  |
| updated_at | Instant |  |

### micro_survey_tag

| Column | Type | Keys |
| --- | --- | --- |
| micro_survey_id | String | PK, FK |
| tag_id | String | PK, FK |

### micro_survey

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| segment_id | String | FK |
| created_at | Instant |  |
| last_dropdown_items | String |  |
| name | String |  |
| position | String |  |
| published_at | Instant |  |
| rate_unlimit_at | String |  |
| stats_completed_count | Unknown |  |
| stats_exited_count | Unknown |  |
| stats_last_completed_at | Instant |  |
| stats_last_exited_at | Instant |  |
| stats_last_started_at | Instant |  |
| stats_started_count | Unknown |  |
| updated_at | Instant |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| description | String |  |
| disabled_at | Instant |  |
| last_seen_at | Instant |  |
| models_count | Unknown |  |
| name | String |  |
| uid | String |  |
| updated_at | Instant |  |

### tour_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | String | PK, FK |
| tour_id | String | PK, FK |

### tour

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| segment_id | String | FK |
| archived_at | Instant |  |
| created_at | Instant |  |
| experiment_at | Instant |  |
| experiment_range | String |  |
| name | String |  |
| position | String |  |
| published_at | Instant |  |
| rate_unlimit_at | Instant |  |
| stats_completed_count | Unknown |  |
| stats_exited_count | Unknown |  |
| stats_last_completed_at | Instant |  |
| stats_last_exited_at | Instant |  |
| stats_last_started_at | Instant |  |
| stats_started_count | Unknown |  |
| style | String |  |
| tour_link_url | String |  |
| updated_at | Instant |  |

## Relationships

- domain(url_group_id_) → environment(id)
- micro_survey_response(profile_id) → user_profile(id)
- micro_survey_response(survey_id) → micro_survey(id)
- micro_survey_response(profile_company_id) → company(id)
- tour_interaction(profile_id) → user_profile(id)
- tour_interaction(tour_id) → tour(id)
- tour_interaction(profile_company_id) → company(id)
- rate_limit_group_campaign(rate_limit_group_id) → rate_limit_group(id)
- rate_limit_group_tag(tag_id) → tags(id)
- rate_limit_group_tag(rate_limit_group_id) → rate_limit_group(id)
- experience_delivery(profile_id) → user_profile(id)
- experience_delivery(interaction_id) → tour_interaction(id)
- segment_item(segment_id) → segment(id)
- launcher_item(segment_id) → segment(id)
- launcher_tag(tag_id) → tags(id)
- launcher_tag(launcher_id) → launcher(id)
- launcher(segment_id) → segment(id)
- user_profile(company_id) → company(id)
- data_import_property(data_import_id) → data_import(id)
- data_import_head_column(data_import_id) → data_import(id)
- tooltip_tag(tag_id) → tags(id)
- tooltip_tag(tooltip_id) → tooltip(id)
- alert_group_campaign(alert_group_id) → alert_group(id)
- alert_group_experience(alert_group_id) → alert_group(id)
- alert_group_tag(tag_id) → tags(id)
- alert_group_tag(alert_group_id) → alert_group(id)
- micro_survey_tag(tag_id) → tags(id)
- micro_survey_tag(micro_survey_id) → micro_survey(id)
- micro_survey(segment_id) → segment(id)
- tour_tag(tag_id) → tags(id)
- tour_tag(tour_id) → tour(id)
- tour(segment_id) → segment(id)