Showpad
Explore the interactive ERD
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
asset_country
| Column | Type | Keys |
|---|---|---|
code | Unknown | PK |
asset_id | Unknown | PKFK |
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 | PKFK |
tag_category_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
channel_user
| Column | Type | Keys |
|---|---|---|
channel_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
recommendation_rule_tags_all | Unknown | PKFK |
recommendation_rule_tags_any
| Column | Type | Keys |
|---|---|---|
recommendation_rule_id | Unknown | PKFK |
recommendation_rule_tags_any | Unknown | PKFK |
recommendation_rule_tags_none
| Column | Type | Keys |
|---|---|---|
recommendation_rule_id | Unknown | PKFK |
recommendation_rule_tags_none | Unknown | PKFK |
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 |