# Showpad schema ERD

Table and field reference for the Fivetran Showpad connector.

## Table & Field Reference

### shared_space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| last_activity_at | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |

### user_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### crm_share_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| share_id | Unknown | FK |
| account_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| deleted_at | Unknown |  |
| is_global | Unknown |  |
| is_personal | Unknown |  |
| name | Unknown |  |

### division_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| user_id | Unknown | FK |
| content_reporting | Unknown |  |
| create_user_groups | Unknown |  |
| created_at | Instant |  |
| delete_experiences | Unknown |  |
| expired_at | Instant |  |
| external_id | Unknown |  |
| href | Unknown |  |
| manage_ai_roleplays | Unknown |  |
| manage_announcements | Unknown |  |
| manage_assets | Unknown |  |
| manage_content | Unknown |  |
| manage_courses_and_checklists | Unknown |  |
| manage_experiences | Unknown |  |
| manage_sharing_themes | Unknown |  |
| manage_tags | Unknown |  |
| manage_users | Unknown |  |
| messaging | Unknown |  |
| metadata | Unknown |  |
| notify_users_by_email | Unknown |  |
| readiness_reporting | Unknown |  |
| reporting | Unknown |  |
| resource_type | Unknown |  |
| updated_at | Instant |  |
| view_users | Unknown |  |

### recommendation_asset_new

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| content_applink | Unknown |  |
| content_cover_focal_point | Unknown |  |
| content_extension | Unknown |  |
| content_preview_urls | Json |  |
| content_thumbnail_urls | Json |  |
| model | Unknown |  |
| score | Unknown |  |

### asset_author

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### asset_country

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| asset_id | Unknown | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| deleted_at | Unknown |  |
| name | Unknown |  |

### shared_space_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| division_id | Unknown | FK |
| created_at | Instant |  |
| description | Unknown |  |
| is_published | Unknown |  |
| name | Unknown |  |
| shared_space_data_description | Unknown |  |
| shared_space_data_theme_id | Unknown |  |
| shared_space_data_title | Unknown |  |
| updated_at | Instant |  |
| usage_count | Unknown |  |

### tag_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| published_at | Unknown |  |

### tag_category_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| tag_category_id | Unknown | PK, FK |

### share

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| recipients | Unknown |  |
| revoked_at | Unknown |  |
| salesforce | Unknown |  |
| shared_at | Unknown |  |
| theme | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### map

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| context_id | Unknown | FK |
| context_type | Unknown |  |
| created_at | Instant |  |
| updated_at | Instant |  |

### asset_tag

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted_at | Unknown |  |
| name | Unknown |  |

### map_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| map_id | Unknown | FK |
| user_id | Unknown | FK |
| avatar | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| status | Unknown |  |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| provisional_asset_id | Unknown | FK |
| asset | Unknown |  |
| asset_file_type | Unknown |  |
| asset_filename | Unknown |  |
| can_be_force_used | Unknown |  |
| completed_at | LocalDate |  |
| division_location | Unknown |  |
| include_non_required | Unknown |  |
| materialised_path | Unknown |  |
| only_customer_types | Unknown |  |
| only_unfinished | Unknown |  |
| preview_url | Unknown |  |
| queued_at | LocalDate |  |
| started_at | LocalDate |  |
| status | Unknown |  |
| thumbnail_url | Unknown |  |
| type | Unknown |  |
| user_location | Unknown |  |

### collection_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| collection_id | Unknown | PK, FK |
| asset_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| page | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |

### division_user_group

| Column | Type | Keys |
| --- | --- | --- |
| division_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### shared_space_quick_action

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shared_space_id | Unknown | FK |
| is_internal | Unknown |  |
| shared_space_extension_description | Unknown |  |
| shared_space_extension_icon | Unknown |  |
| shared_space_extension_id | Unknown |  |
| shared_space_extension_name | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### asset_language

| Column | Type | Keys |
| --- | --- | --- |
| code | Unknown | PK |
| asset_id | Unknown | PK, FK |

### channel_user

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| email_address | Unknown |  |
| first_name | Unknown |  |
| is_active | Unknown |  |
| is_forgotten | Unknown |  |
| last_name | Unknown |  |
| user_role | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### shared_space_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| shared_space_id | Unknown | FK |
| user_id | Unknown | FK |
| access_granted_at | Unknown |  |
| access_revoked_at | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| job_title | Unknown |  |
| organisation | Unknown |  |
| page | Unknown |  |
| updated_at | Unknown |  |

### crm_shared_space_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shared_space_id | Unknown | FK |
| account_id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### channel_user_group

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### user_permission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users | Unknown | FK |
| advanced_reporting | Unknown |  |
| can_content_reporting | Unknown |  |
| can_delete_experiences | Unknown |  |
| can_manage_ai_roleplays | Unknown |  |
| can_manage_announcements | Unknown |  |
| can_manage_assets | Unknown |  |
| can_manage_content_profiles | Unknown |  |
| can_manage_courses_and_checklists | Unknown |  |
| can_manage_experiences | Unknown |  |
| can_manage_tags | Unknown |  |
| can_manage_users | Unknown |  |
| can_manage_users_and_groups | Unknown |  |
| can_training_reporting | Unknown |  |
| can_view_users | Unknown |  |
| channel_template | Unknown |  |
| collections | Unknown |  |
| contact_browser | Unknown |  |
| contact_export | Unknown |  |
| contact_form | Unknown |  |
| contact_sync | Unknown |  |
| created_at | LocalDate |  |
| crm | Unknown |  |
| external_file_system_import | Unknown |  |
| external_id | Unknown |  |
| file_commenting | Unknown |  |
| file_rating | Unknown |  |
| kiosk_mode | Unknown |  |
| location_sharing | Unknown |  |
| name | Unknown |  |
| notifications | Unknown |  |
| personal_catalog | Unknown |  |
| personal_content | Unknown |  |
| resource_type | Unknown |  |
| sales_engagement | Unknown |  |
| salesforce_integration | Unknown |  |
| shared_spaces | Unknown |  |
| sharing | Unknown |  |
| smart_phone_access | Unknown |  |
| tag_search | Unknown |  |
| updated_at | LocalDate |  |
| web_access | Unknown |  |

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset | Unknown | FK |
| collection_item | Unknown | FK |
| division | Unknown | FK |
| share | Unknown | FK |
| user_id | Unknown | FK |
| created_at | LocalDate |  |
| external_id | Unknown |  |
| is_unregistered_user_comment | Unknown |  |
| message | Unknown |  |
| parent | Unknown |  |
| parent_comment | Unknown |  |
| parent_mobile_api_id | Unknown |  |
| parent_type | Unknown |  |
| resource_type | Unknown |  |
| unregistered_user_first_name | Unknown |  |
| unregistered_user_last_name | Unknown |  |
| updated_at | LocalDate |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| division_id | Unknown | FK |
| original_asset_id | Unknown | FK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| expires_at | Unknown |  |
| is_annotatable | Unknown |  |
| is_division_shared | Unknown |  |
| is_downloadable | Unknown |  |
| is_sensitive | Unknown |  |
| is_shareable | Unknown |  |
| optimized_file_size | Unknown |  |
| original_file_size | Unknown |  |
| released_at | Unknown |  |
| slug | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| uploaded_at | Unknown |  |

### device

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| last_active_user_id | Unknown | FK |
| app_used | Unknown |  |
| location | Unknown |  |
| model | Unknown |  |
| type | Unknown |  |

### recommendation_rule_condition

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| recommendation_rule_id | Unknown | PK, FK |
| child_object_name | Unknown |  |
| field_name | Unknown |  |
| object_name | Unknown |  |
| operator | Unknown |  |
| value | Unknown |  |

### recommendation_rule_tags_all

| Column | Type | Keys |
| --- | --- | --- |
| recommendation_rule_id | Unknown | PK, FK |
| recommendation_rule_tags_all | Unknown | PK, FK |

### recommendation_rule_tags_any

| Column | Type | Keys |
| --- | --- | --- |
| recommendation_rule_id | Unknown | PK, FK |
| recommendation_rule_tags_any | Unknown | PK, FK |

### recommendation_rule_tags_none

| Column | Type | Keys |
| --- | --- | --- |
| recommendation_rule_id | Unknown | PK, FK |
| recommendation_rule_tags_none | Unknown | PK, FK |

### recommendation_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| crm_instance_id | Unknown |  |
| updated_at | Instant |  |

### shared_space_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| shared_space_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| page | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| channel_id | Unknown | FK |
| contact_id | Unknown | FK |
| device_id | Unknown | FK |
| division_id | Unknown | FK |
| share_id | Unknown | FK |
| shared_space_id | Unknown | FK |
| shared_space_participant_id | Unknown | FK |
| user_id | Unknown | FK |
| end_time | Unknown |  |
| logged_at | Unknown |  |
| page | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |

## Relationships

- shared_space(owner_id) → users(id)
- user_group_member(id) → user_group(id)
- user_group_member(user_id) → users(id)
- crm_share_record(share_id) → share(id)
- division(owner_user_id) → users(id)
- division_permission(user_id) → users(id)
- division_permission(division_id) → division(id)
- recommendation_asset_new(id) → asset(id)
- asset_author(id) → users(id)
- asset_author(asset_id) → asset(id)
- asset_country(asset_id) → asset(id)
- contact(user_id) → users(id)
- shared_space_template(division_id) → division(id)
- shared_space_template(creator_id) → users(id)
- tag_category_tag(id) → tags(id)
- tag_category_tag(tag_category_id) → tag_category(id)
- share(creator_id) → users(id)
- map(context_id) → shared_space(id)
- asset_tag(id) → tags(id)
- asset_tag(asset_id) → asset(id)
- map_participant(user_id) → users(id)
- map_participant(map_id) → map(id)
- ticket(provisional_asset_id) → asset(id)
- ticket(division_id) → division(id)
- collection_item(collection_id) → collection(id)
- collection_item(asset_id) → asset(id)
- division_user_group(id) → user_group(id)
- division_user_group(division_id) → division(id)
- shared_space_quick_action(shared_space_id) → shared_space(id)
- collection(user_id) → users(id)
- asset_language(asset_id) → asset(id)
- channel_user(id) → users(id)
- channel_user(channel_id) → channel(id)
- users(manager_id) → users(id)
- shared_space_participant(user_id) → users(id)
- shared_space_participant(shared_space_id) → shared_space(id)
- shared_space_participant(asset_id) → asset(id)
- crm_shared_space_record(shared_space_id) → shared_space(id)
- channel_user_group(id) → user_group(id)
- channel_user_group(channel_id) → channel(id)
- user_permission(users) → users(id)
- comment(user_id) → users(id)
- comment(asset) → asset(id)
- comment(division) → division(id)
- comment(collection_item) → collection_item(id)
- comment(share) → share(id)
- asset(original_asset_id) → asset(id)
- asset(division_id) → division(id)
- device(last_active_user_id) → users(id)
- recommendation_rule_condition(recommendation_rule_id) → recommendation_rule(id)
- recommendation_rule_tags_all(recommendation_rule_tags_all) → tags(id)
- recommendation_rule_tags_all(recommendation_rule_id) → recommendation_rule(id)
- recommendation_rule_tags_any(recommendation_rule_tags_any) → tags(id)
- recommendation_rule_tags_any(recommendation_rule_id) → recommendation_rule(id)
- recommendation_rule_tags_none(recommendation_rule_tags_none) → tags(id)
- recommendation_rule_tags_none(recommendation_rule_id) → recommendation_rule(id)
- shared_space_item(shared_space_id) → shared_space(id)
- shared_space_item(user_id) → users(id)
- shared_space_item(asset_id) → asset(id)
- event(user_id) → users(id)
- event(channel_id) → channel(id)
- event(device_id) → device(id)
- event(shared_space_id) → shared_space(id)
- event(share_id) → share(id)
- event(asset_id) → asset(id)
- event(division_id) → division(id)
- event(shared_space_participant_id) → shared_space_participant(id)
- event(contact_id) → contact(id)