# Consensus Demo Automation Platform schema ERD

Table and field reference for the Fivetran Consensus Demo Automation Platform connector.

## Table & Field Reference

### track_demo_board_demo_uuid

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| track_demo_board_id | Unknown | PK, FK |
| demo_uuid | Unknown | FK |

### track_demo_board_invite_view_data_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| track_demo_board_id | Unknown | PK, FK |
| track_demo_board_invite_view_data_index | Unknown | PK, FK |
| title | Unknown |  |
| uuid | Unknown |  |
| value | Unknown |  |

### track_demo_board_invite_view_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| track_demo_board_id | Unknown | PK, FK |
| track_demo_board_invite_index | Unknown | PK, FK |
| demo_uuid | Unknown | FK |
| answer_index | Unknown |  |
| answer_name | Unknown |  |
| date_view | Unknown |  |
| demo_title | Unknown |  |
| duration | Unknown |  |
| features | Json |  |
| files | Unknown |  |
| is_replay | Unknown |  |
| link_uuid | Unknown |  |
| selected_demo_uuid | Unknown |  |
| view_id | Unknown |  |

### track_demo_board_invite

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| track_demo_board_id | Unknown | PK, FK |
| contact_uuid | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| hash | Unknown |  |
| invite_status | Unknown |  |
| invite_uuid | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| primaries | Unknown |  |
| shared_by_name | Unknown |  |
| shared_by_uuid | Unknown |  |
| shares | Unknown |  |
| source | Unknown |  |
| source_hr | Unknown |  |
| title | Unknown |  |
| total_duration | Unknown |  |
| total_hotspot_opened | Unknown |  |
| total_page_view | Unknown |  |
| total_tour_view | Unknown |  |

### track_demo_board

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| demo_uuid | Unknown | FK |
| creation_date | Unknown |  |
| creation_source | Unknown |  |
| external_account_id | Unknown |  |
| external_account_name | Unknown |  |
| external_opportunity_id | Unknown |  |
| external_opportunity_name | Unknown |  |
| is_test | Unknown |  |
| name | Unknown |  |
| organization | Unknown |  |
| owner_name | Unknown |  |
| owner_uuid | Unknown |  |
| parent_demo_uuid | Json |  |
| send_demo_hash | Unknown |  |
| shared_count | Unknown |  |
| time_last_view | Unknown |  |
| total_hotspot_opened | Unknown |  |
| total_page_views | Unknown |  |
| total_tour_views | Unknown |  |
| view_count | Unknown |  |
| view_time | Unknown |  |

### sales_by_customer_detailed

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| demo_uuid | Unknown | FK |
| branching_response | Unknown |  |
| created_by | Unknown |  |
| creation_source | Unknown |  |
| date_created | Unknown |  |
| date_invited | Unknown |  |
| days_from_last_activity | Unknown |  |
| demo_creator_email | Unknown |  |
| demo_title | Unknown |  |
| email | Unknown |  |
| invited_by | Unknown |  |
| not_important_selected | Unknown |  |
| organization | Unknown |  |
| recipient | Unknown |  |
| shares_by_viewer | Unknown |  |
| some_what_important_selected | Unknown |  |
| sub_demo_title | Unknown |  |
| time_diff | Unknown |  |
| very_important_selected | Unknown |  |
| view_date | Unknown |  |
| view_location | Unknown |  |
| view_time | Unknown |  |

### search_lead_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| search_lead_id | Unknown | PK, FK |
| title | Unknown |  |
| uuid | Unknown |  |
| value | Unknown |  |

### search_lead_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| search_lead_id | Unknown | PK, FK |
| value | Unknown |  |

### search_lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| demo_uuid | Unknown | FK |
| view_id | Unknown | FK |
| answer_index | Unknown |  |
| answer_name | Unknown |  |
| answer_parent_demo_title | Unknown |  |
| answer_parent_demo_uuid | Unknown |  |
| answer_selected_demo_title | Unknown |  |
| answer_selected_demo_uuid | Unknown |  |
| answer_selected_index | Unknown |  |
| answer_selected_title | Unknown |  |
| creation_date | Unknown |  |
| date_view | Unknown |  |
| demo_title | Unknown |  |
| doc_download | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| form_comments | Unknown |  |
| form_country | Unknown |  |
| form_email | Unknown |  |
| form_first_name | Unknown |  |
| form_last_name | Unknown |  |
| form_organization | Unknown |  |
| form_phone_number | Unknown |  |
| form_session_eu | Unknown |  |
| form_session_i | Unknown |  |
| form_session_nostat | Unknown |  |
| form_session_organization_id | Unknown |  |
| form_session_u | Unknown |  |
| form_session_v | Unknown |  |
| form_state | Unknown |  |
| form_title | Unknown |  |
| geo_data_location_name | Unknown |  |
| geo_data_time_zone | Unknown |  |
| last_name | Unknown |  |
| lead_owner_group | Unknown |  |
| organization | Unknown |  |
| utm | Json |  |
| view_time | Unknown |  |

### user_info

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| creator_uuid | Unknown |  |
| date_format | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| group_creator_full_name | Unknown |  |
| group_creator_uuid | Unknown |  |
| group_description | Unknown |  |
| group_expiry_date | Unknown |  |
| group_level | Unknown |  |
| group_name | Unknown |  |
| group_parent_uuid | Unknown |  |
| group_status | Unknown |  |
| group_time_updated | Unknown |  |
| group_type | Unknown |  |
| group_uuid | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| notifications | Json |  |
| phone_number | Unknown |  |
| status | Unknown |  |
| time_created | Unknown |  |
| time_updated | Unknown |  |
| time_zone | Unknown |  |
| title | Unknown |  |
| we_chat | Unknown |  |
| whats_app | Unknown |  |

### mail_merge_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_info_uuids | Unknown | FK |
| combine | Unknown |  |
| contact_info_uuid | Unknown |  |
| created_at | Instant |  |
| demo_internal_title | Unknown |  |
| demo_title | Unknown |  |
| demo_uuid | Unknown |  |
| exclude_owner | Unknown |  |
| hash | Unknown |  |
| owner_name | Unknown |  |
| owner_phone | Unknown |  |
| owner_uuid | Unknown |  |
| platform_id | Unknown |  |
| platform_name | Unknown |  |
| riv_source | Unknown |  |
| riv_uuid | Unknown |  |
| show_user_contact_info | Unknown |  |
| skip_way | Unknown |  |
| title | Unknown |  |

### demo_search_permission

| Column | Type | Keys |
| --- | --- | --- |
| permission_id | Unknown | PK |
| demo_search_id | Unknown | PK, FK |
| display_name | Unknown |  |
| group_level | Unknown |  |
| shared_below | Unknown |  |
| type | Unknown |  |
| value | Json |  |

### demo_search_tour

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| demo_search_id | Unknown | PK, FK |
| feature_uuid | Unknown |  |
| thumbs_default | Json |  |
| tour_id | Unknown |  |

### demo_search_folder_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| demo_search_id | Unknown | PK, FK |
| display_name | Unknown |  |
| folder_name | Unknown |  |
| folder_permission_id | Unknown |  |
| folder_uuid | Unknown |  |
| group_level | Unknown |  |
| shared_below | Unknown |  |
| type | Unknown |  |
| value | Json |  |

### demo_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| creator_email | Unknown |  |
| creator_first_name | Unknown |  |
| creator_last_name | Unknown |  |
| creator_uuid | Unknown |  |
| description | Unknown |  |
| draft | Unknown |  |
| folder_name | Unknown |  |
| folder_uuid | Unknown |  |
| highspot_is_published | Unknown |  |
| highspot_published_date | Unknown |  |
| internal_title | Unknown |  |
| is_archived | Unknown |  |
| is_public | Unknown |  |
| is_published | Unknown |  |
| language_code | Unknown |  |
| language_title | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| uuid_type | Unknown |  |

## Relationships

- track_demo_board_demo_uuid(demo_uuid) → demo_search(id)
- track_demo_board_demo_uuid(track_demo_board_id) → track_demo_board(id)
- track_demo_board_invite_view_data_feature(track_demo_board_invite_view_data_index) → track_demo_board_invite_view_data(index)
- track_demo_board_invite_view_data_feature(track_demo_board_id) → track_demo_board_invite_view_data(track_demo_board_id)
- track_demo_board_invite_view_data(demo_uuid) → demo_search(id)
- track_demo_board_invite_view_data(track_demo_board_invite_index) → track_demo_board_invite(index)
- track_demo_board_invite_view_data(track_demo_board_id) → track_demo_board_invite(track_demo_board_id)
- track_demo_board_invite(track_demo_board_id) → track_demo_board(id)
- track_demo_board(demo_uuid) → demo_search(id)
- sales_by_customer_detailed(demo_uuid) → demo_search(id)
- search_lead_feature(search_lead_id) → search_lead(id)
- search_lead_custom_field(search_lead_id) → search_lead(id)
- search_lead(view_id) → track_demo_board(id)
- search_lead(demo_uuid) → demo_search(id)
- mail_merge_list(contact_info_uuids) → demo_search_permission(permission_id)
- demo_search_permission(demo_search_id) → demo_search(id)
- demo_search_tour(demo_search_id) → demo_search(id)
- demo_search_folder_permission(demo_search_id) → demo_search(id)