Chameleon

Explore the interactive ERD

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	PKFK

rate_limit_group_tag

Column	Type	Keys
`rate_limit_group_id`	String	PKFK
`tag_id`	String	PKFK

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	PKFK
`tag_id`	String	PKFK

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	PKFK
`tooltip_id`	String	PKFK

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	PKFK

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	PKFK
`tag_id`	String	PKFK

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	PKFK
`tag_id`	String	PKFK

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

tour_tag

Column	Type	Keys
`tag_id`	String	PKFK
`tour_id`	String	PKFK

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

Chameleon

Explore the interactive ERD

Table & Field Reference

company_property

domain

environment

micro_survey_response

tour_interaction

rate_limit_group_campaign

rate_limit_group_tag

rate_limit_group

webhook

profile_property

experience_delivery

segment_item

segment

launcher_item

launcher_tag

launcher

zapier_hook

user_profile

user_profile_segment

company

data_import_property

data_import_head_column

data_import

tooltip_tag

tooltip

alert_group_campaign

alert_group_experience

alert_group_tag

alert_group

micro_survey_tag

micro_survey

tags

tour_tag

tour