# FullStory schema ERD

Table and field reference for the Fivetran FullStory connector.

## Table & Field Reference

### privacy_domain_settings_history

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| created_by | Unknown | PK |
| last_updated | Unknown | PK |
| domains | Json |  |
| last_updated_by | Unknown |  |
| only_record_known_domain | Unknown |  |
| type | Unknown |  |

### segment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created | Instant |  |
| creator | String |  |
| name | String |  |

### privacy_block_rule_history

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| created_by | Unknown | PK |
| last_updated | Unknown | PK |
| blocked_app_ids | Json |  |
| blocked_ips | Json |  |
| blocked_uas | Json |  |
| last_updated_by | Unknown |  |

### privacy_recording_feature_history

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| created_by | Unknown | PK |
| last_updated | Unknown | PK |
| ajax_watcher | Unknown |  |
| client_side_rage_click | Unknown |  |
| console_watcher | Unknown |  |
| enabled | Unknown |  |
| last_updated_by | Unknown |  |
| recording_shutoff | Unknown |  |
| resource_uploading | Unknown |  |
| type | Unknown |  |

### privacy_geo_settings_history

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| created_by | Unknown | PK |
| last_updated | Unknown | PK |
| last_updated_by | Unknown |  |
| record_geo_mode | Unknown |  |
| record_geo_zones | Json |  |

### privacy_ajax_watch

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| privacy_setting_history_created | Unknown | FK |
| privacy_setting_history_created_by | Unknown | FK |
| record_req | Unknown |  |
| record_rsp | Unknown |  |
| url_regex | Unknown |  |
| white_list_req | Unknown |  |
| white_list_rsp | Unknown |  |

### privacy_element_block

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| privacy_setting_history_created | Unknown | PK, FK |
| privacy_setting_history_created_by | Unknown | PK, FK |
| consent | Unknown |  |
| editable | Unknown |  |
| exception_selectors | Json |  |
| label | Unknown |  |
| last_updated | Unknown |  |
| notes | Unknown |  |
| scope | Unknown |  |
| selector | Unknown |  |
| targeting_condition | Json |  |
| type | Unknown |  |

### privacy_element_group

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK |
| privacy_setting_history_created | Unknown | PK, FK |
| privacy_setting_history_created_by | Unknown | PK, FK |
| editable | Unknown |  |
| note | Unknown |  |
| scope | Unknown |  |
| template_id | Unknown |  |

### privacy_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| created | Unknown | PK |
| created_by | Unknown | PK |
| last_updated | Unknown | PK |
| default_privacy_mode | Unknown |  |
| discard_ip_addresse | Unknown |  |
| last_updated_by | Unknown |  |

### user_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | String | PK, FK |
| value | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| app_url | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| is_being_deleted | Unknown |  |
| schema | Unknown |  |
| type_conflict | Unknown |  |
| uid | String |  |

### segment_event

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| active_sec | Unknown |  |
| app_device_model | Unknown |  |
| app_device_vendor | Unknown |  |
| app_name | Unknown |  |
| app_os_version | Unknown |  |
| app_package_name | Unknown |  |
| app_version | Unknown |  |
| app_view_name | Unknown |  |
| avg_session_active_sec | Unknown |  |
| avg_session_sec | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| event_cumulative_layout_shift | Unknown |  |
| event_custom_name | Unknown |  |
| event_duration | Unknown |  |
| event_first_input_delay | Unknown |  |
| event_mobile_source_file | Unknown |  |
| event_mod_dead | Unknown |  |
| event_mod_error | Unknown |  |
| event_mod_frustrated | Unknown |  |
| event_mod_suspicious | Unknown |  |
| event_page_offset | Unknown |  |
| event_secondary_duration | Unknown |  |
| event_session_offset | Unknown |  |
| event_start | Unknown |  |
| event_sub_type | Unknown |  |
| event_target_selector | Unknown |  |
| event_target_text | Unknown |  |
| event_type | Unknown |  |
| event_var_error_kind | Unknown |  |
| event_var_fields | Unknown |  |
| event_web_source_file_url | Unknown |  |
| indv_id | Unknown |  |
| last_browser | Unknown |  |
| last_device | Unknown |  |
| last_event_start | Unknown |  |
| last_ip | Unknown |  |
| last_lat_long | Unknown |  |
| last_opperating_system | Unknown |  |
| last_page | Unknown |  |
| last_platform | Unknown |  |
| last_session_active_sec | Unknown |  |
| last_session_num_events | Unknown |  |
| last_session_num_pages | Unknown |  |
| last_session_sec | Unknown |  |
| last_session_start | Unknown |  |
| load_dom_content_time | Unknown |  |
| load_event_time | Unknown |  |
| load_first_paint_time | Unknown |  |
| load_largest_paint_time | Unknown |  |
| max_session_sec | Unknown |  |
| page_active_duration | Unknown |  |
| page_browser | Unknown |  |
| page_browser_version | Unknown |  |
| page_cluster_id | Unknown |  |
| page_device | Unknown |  |
| page_duration | Unknown |  |
| page_id | Unknown |  |
| page_ip | Unknown |  |
| page_lat_long | Unknown |  |
| page_max_scroll_depth_percent | Unknown |  |
| page_name | Unknown |  |
| page_num_derived_events | Unknown |  |
| page_num_errors | Unknown |  |
| page_num_events | Unknown |  |
| page_num_infos | Unknown |  |
| page_num_warnings | Unknown |  |
| page_operating_system | Unknown |  |
| page_platform | Unknown |  |
| page_referer_url | Unknown |  |
| page_screen_height | Unknown |  |
| page_screen_width | Unknown |  |
| page_start | Unknown |  |
| page_url | Unknown |  |
| page_user_agent | Unknown |  |
| page_viewport_height | Unknown |  |
| page_viewport_width | Unknown |  |
| req_method | Unknown |  |
| req_status | Unknown |  |
| req_url | Unknown |  |
| session_id | Unknown |  |
| session_start | Unknown |  |
| total_sec | Unknown |  |
| uid | Unknown |  |
| user_app_key | Unknown |  |
| user_business_id_real | Unknown |  |
| user_created | Unknown |  |
| user_display_name | Unknown |  |
| user_email | Unknown |  |

## Relationships

- privacy_ajax_watch(privacy_setting_history_created_by) → privacy_setting_history(created_by)
- privacy_ajax_watch(privacy_setting_history_created) → privacy_setting_history(created)
- privacy_element_block(privacy_setting_history_created_by) → privacy_setting_history(created_by)
- privacy_element_block(privacy_setting_history_created) → privacy_setting_history(created)
- privacy_element_group(privacy_setting_history_created_by) → privacy_setting_history(created_by)
- privacy_element_group(privacy_setting_history_created) → privacy_setting_history(created)
- user_property(users_id) → users(id)
- segment_event(user_id) → users(id)