Guru
Explore the interactive ERD
Table & Field Reference
ticket_link
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
card_id | String | FK |
user_email | String | FK |
conversation_id | String | |
date | Instant | |
platform | String |
alert
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_id | String | FK |
group_id | String | FK |
sent_by_user | String | FK |
card_title | String | |
collection_hex_color | String | |
date_sent | Instant | |
note | String | |
percent_read | Long | |
read_count | Long | |
unread_count | Long | |
user_role | String | |
user_role_level | String |
tags
| Column | Type | Keys |
|---|---|---|
id | String | PK |
category_id | String | FK |
category_name | String | |
number_of_cards | Long | |
value | String |
tag_category
| Column | Type | Keys |
|---|---|---|
id | String | PK |
collection_id | String | FK |
created_by_user | String | FK |
date_created | Instant | |
default_category | Boolean | |
name | String |
event
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
team_id | String | FK |
user_email | String | FK |
event_date | Instant | |
event_type | String | |
id | String | |
type | String | |
additional_prop_** |
user_group_member
| Column | Type | Keys |
|---|---|---|
id | String | PKFK |
user_group_id | String | PKFK |
user_group
| Column | Type | Keys |
|---|---|---|
id | String | PK |
date_created | Instant | |
expert_id_rank | Long | |
group_identifier | String | |
managed_by_scim | Boolean | |
modifiable | Boolean | |
name | String | |
number_of_cards_as_verifier | Long | |
number_of_members | Long | |
role | String | |
single_user | Boolean | |
user_modifiable | Boolean |
team_member_group
| Column | Type | Keys |
|---|---|---|
group_id | String | PKFK |
team_member_id | String | PKFK |
team_member_user_profile_use_case_list
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
team_member_id | String | PKFK |
description | String |
team_member
| Column | Type | Keys |
|---|---|---|
id | String | PK |
highest_role | String | |
managed_by_scim | Boolean | |
number_of_cards_as_verifier | Long | |
token | String | |
user_email | String | |
user_first_name | String | |
user_last_name | String | |
user_profile_pic_url | String | |
user_profile_role | String | |
user_profile_role_level | String | |
user_role | String | |
user_status | String | |
user_attributes_** |
collection_team_domain
| Column | Type | Keys |
|---|---|---|
collection_id | String | PKFK |
domain | String | PKFK |
capture | Boolean | |
verification_code | String | |
verified | Boolean |
collection
| Column | Type | Keys |
|---|---|---|
id | String | PK |
default_group_id | String | FK |
billable_users | Long | |
clear_profile_pic | Boolean | |
collection_created | Boolean | |
company_name | String | |
date_created | Instant | |
default_user_type | String | |
deleted | Boolean | |
domain | String | |
edition_code | String | |
edition_id | String | |
edition_key | String | |
edition_name | String | |
file_sharing_disabled | Boolean | |
hubspot_contact_data | String | |
name | String | |
profile_pic_url | String | |
sfdc_integration_installed | Boolean | |
sfdc_integration_state | String | |
slack_command_installed | Boolean | |
slack_command_state | String | |
status | String | |
team_creation_token | String | |
total_users | Long | |
trial_expiration_date | String | |
use_case | String | |
user_role | String | |
zendesk_assist_installed | Boolean | |
zendesk_assist_state | String | |
zendesk_knowledge_installed | Boolean | |
zendesk_knowledge_state | String | |
zoom_chat_state | String | |
additional_prop_** |
card_template_tag
| Column | Type | Keys |
|---|---|---|
id | String | PK |
template_id | String | PKFK |
category_id | String | FK |
category_name | String | |
number_of_cards | Long | |
value | String |
card_template_board
| Column | Type | Keys |
|---|---|---|
board_id | String | PKFK |
card_template_id | String | PKFK |
card_template
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_verifier_id | String | FK |
collection_id | String | FK |
created_by_user | String | FK |
last_modified_by_user | String | FK |
card_title | String | |
card_verifier_date_created | Instant | |
card_verifier_type | String | |
content | String | |
content_model_version_value | String | |
date_created | Instant | |
description | String | |
json_content | String | |
last_modified | Instant | |
share_status | String | |
template_title | String | |
verification_interval | Long |
team_domain
| Column | Type | Keys |
|---|---|---|
domain | String | PKFK |
team_id | String | PKFK |
capture | Boolean | |
verification_code | String | |
verified | Boolean |
team
| Column | Type | Keys |
|---|---|---|
id | String | PK |
default_group_id | String | FK |
users_email | String | FK |
billable_users | Long | |
clear_profile_pic | Boolean | |
collection_created | Boolean | |
company_name | String | |
date_created | Instant | |
default_user_type | String | |
deleted | Boolean | |
domain | String | |
edition_code | String | |
edition_id | String | |
edition_key | String | |
edition_name | String | |
file_sharing_disabled | Boolean | |
hubspot_contact_data | String | |
name | String | |
profile_pic_url | String | |
sfdc_integration_installed | Boolean | |
sfdc_integration_state | String | |
slack_command_installed | Boolean | |
slack_command_state | String | |
status | String | |
team_creation_token | String | |
total_users | Long | |
trial_expiration_date | String | |
use_case | String | |
user_role | String | |
zendesk_assist_installed | Boolean | |
zendesk_assist_state | String | |
zendesk_knowledge_installed | Boolean | |
zendesk_knowledge_state | String | |
zoom_chat_state | String | |
additional_prop_** |
users
| Column | Type | Keys |
|---|---|---|
email | String | PK |
collection_id | String | FK |
collection_administrator | Boolean | |
collection_boards | Long | |
collection_cards | Long | |
collection_color | String | |
collection_date_created | Instant | |
collection_default_verifier | String | |
collection_description | String | |
collection_last_synced_date | Instant | |
collection_public_cards | Long | |
collection_public_cards_enabled | String | |
collection_slug | String | |
collection_stats_additional_prop_type | String | |
collection_sync_type | String | |
collection_sync_verification_enabled | Boolean | |
collection_tags | Long | |
collection_token | String | |
collection_top_level_sync_location | String | |
collection_type | String | |
collection_type_detail | String | |
collection_verification_interval | Long | |
token_type | String |
card_comment_reply
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_comment_card_id | String | FK |
card_comment_id | String | FK |
content | String | |
date_created | Instant | |
deleted | Boolean | |
last_modified | Instant |
card_comment
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_id | String | PKFK |
owner_email | String | FK |
reply_owner_email | String | FK |
content | String | |
date_created | Instant | |
deleted | Boolean | |
last_modified | Instant | |
status | String | |
total_replies | Long |
folder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
collection_id | Unknown | FK |
collection_team_id | Unknown | FK |
last_modified_by_email | Unknown | FK |
collection_assist_enabled | Unknown | |
collection_collection_type | Unknown | |
collection_collection_type_detail | Unknown | |
collection_color | Unknown | |
collection_date_created | Instant | |
collection_default_verification_interval | Unknown | |
collection_default_verification_type | Unknown | |
collection_description | Unknown | |
collection_home_board_slug | Unknown | |
collection_name | Unknown | |
collection_public_cards_enabled | Unknown | |
collection_slug | Unknown | |
home | Unknown | |
items | Json | |
last_modified | Instant | |
last_modified_by_first_name | Unknown | |
last_modified_by_id | Unknown | |
last_modified_by_last_name | Unknown | |
last_modified_by_status | Unknown | |
last_modified_by_user_type | Unknown | |
number_of_facts | Unknown | |
slug | Unknown | |
title | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_id | String | FK |
comment_id | String | FK |
comment_reply_id | String | FK |
creator | String | FK |
date_sent | Instant | |
mention | String | |
user_task_id | String | |
viewed | Boolean |
card_tag
| Column | Type | Keys |
|---|---|---|
card_id | String | PKFK |
tag_id | String | PKFK |
card_collaborator
| Column | Type | Keys |
|---|---|---|
card_id | String | PKFK |
id | String | PKFK |
date_created | String | |
removed | Boolean | |
type | String |
card_verifier
| Column | Type | Keys |
|---|---|---|
card_id | String | PKFK |
id | String | PKFK |
date_created | Instant | |
type | String |
card_board
| Column | Type | Keys |
|---|---|---|
card_id | String | PKFK |
id | String | PKFK |
card_attachment
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_id | String | PKFK |
extension | String | |
filename | String | |
link | String | |
mimetype | String | |
previewable | Boolean | |
size | Long | |
thumbnail_link | String |
card
| Column | Type | Keys |
|---|---|---|
id | String | PK |
card_template_id | String | FK |
collection_id | String | FK |
last_modified_by_user | String | FK |
last_verified_by_user | String | FK |
original_owner_email | String | FK |
verification_initiator_email | String | FK |
archived | Boolean | |
card_info_members_with_card_view | Long | |
card_info_members_without_card_view | Long | |
card_type | String | |
comment_count | Long | |
content | String | |
date_created | Instant | |
favorited | Boolean | |
favorited_date | Instant | |
last_modified | Instant | |
last_verified | Instant | |
last_viewed | Instant | |
next_verification_date | Instant | |
owner_email | String | |
preferred_phrase | String | |
public_link_allowed | Boolean | |
share_status | String | |
slug | String | |
suppress_verification | Boolean | |
sync_info_content_sync_type | String | |
sync_info_external_url | String | |
sync_info_last_sync_date | Instant | |
sync_info_last_update_date | Instant | |
team_id | String | |
verification_initiation_date | String | |
verification_interval | Long | |
verification_reason | String | |
verification_reasons | Json | |
verification_state | String | |
verification_type | String | |
version | Long | |
additional_prop_** |
board_item
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
board_id | String | PKFK |
type | String |
board_groups_shared_with
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
board_id | String | PKFK |
groups_shared_with | String |
board
| Column | Type | Keys |
|---|---|---|
id | String | PK |
collection_id | String | FK |
last_modified_by_user | String | FK |
board_group_id | String | |
default_list | Boolean | |
description | String | |
favorited | Boolean | |
favorited_date | Instant | |
last_modified | Instant | |
number_of_facts | Long | |
removed | Boolean | |
slug | String | |
title | String |