# Guru schema ERD

Table and field reference for the Fivetran Guru connector.

## 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 | PK, FK |
| user_group_id | String | PK, FK |

### 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 | PK, FK |
| team_member_id | String | PK, FK |

### team_member_user_profile_use_case_list

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_member_id | String | PK, FK |
| 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 | PK, FK |
| domain | String | PK, FK |
| 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 | PK, FK |
| category_id | String | FK |
| category_name | String |  |
| number_of_cards | Long |  |
| value | String |  |

### card_template_board

| Column | Type | Keys |
| --- | --- | --- |
| board_id | String | PK, FK |
| card_template_id | String | PK, FK |

### 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 | PK, FK |
| team_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| tag_id | String | PK, FK |

### card_collaborator

| Column | Type | Keys |
| --- | --- | --- |
| card_id | String | PK, FK |
| id | String | PK, FK |
| date_created | String |  |
| removed | Boolean |  |
| type | String |  |

### card_verifier

| Column | Type | Keys |
| --- | --- | --- |
| card_id | String | PK, FK |
| id | String | PK, FK |
| date_created | Instant |  |
| type | String |  |

### card_board

| Column | Type | Keys |
| --- | --- | --- |
| card_id | String | PK, FK |
| id | String | PK, FK |

### card_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| card_id | String | PK, FK |
| 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 | PK, FK |
| type | String |  |

### board_groups_shared_with

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| board_id | String | PK, FK |
| 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 |  |

## Relationships

- ticket_link(card_id) → card(id)
- ticket_link(user_email) → team_member(id)
- alert(group_id) → user_group(id)
- alert(card_id) → card(id)
- alert(sent_by_user) → team_member(id)
- tags(category_id) → tag_category(id)
- tag_category(collection_id) → collection(id)
- tag_category(created_by_user) → team_member(id)
- event(user_email) → team_member(id)
- event(team_id) → team(id)
- user_group_member(id) → team_member(id)
- user_group_member(user_group_id) → user_group(id)
- team_member_group(group_id) → user_group(id)
- team_member_group(team_member_id) → team_member(id)
- team_member_user_profile_use_case_list(team_member_id) → team_member(id)
- collection_team_domain(domain) → collection(id)
- collection_team_domain(collection_id) → collection(id)
- collection(default_group_id) → user_group(id)
- card_template_tag(category_id) → tag_category(id)
- card_template_tag(template_id) → card_template(id)
- card_template_board(board_id) → board(id)
- card_template_board(card_template_id) → card_template(id)
- card_template(created_by_user) → team_member(id)
- card_template(last_modified_by_user) → team_member(id)
- card_template(collection_id) → collection(id)
- card_template(card_verifier_id) → team_member(id)
- team_domain(domain) → team(domain)
- team_domain(team_id) → team(id)
- team(default_group_id) → user_group(id)
- team(users_email) → users(email)
- users(collection_id) → collection(id)
- card_comment_reply(card_comment_id) → card_comment(id)
- card_comment_reply(card_comment_card_id) → card_comment(card_id)
- card_comment(owner_email) → team_member(id)
- card_comment(reply_owner_email) → team_member(id)
- card_comment(card_id) → card(id)
- folder(collection_team_id) → team(id)
- folder(collection_id) → collection(id)
- folder(last_modified_by_email) → users(email)
- task(comment_id) → card_comment(id)
- task(card_id) → card(id)
- task(creator) → team_member(id)
- task(comment_reply_id) → card_comment_reply(id)
- card_tag(tag_id) → tags(id)
- card_tag(card_id) → card(id)
- card_collaborator(id) → team_member(id)
- card_collaborator(card_id) → card(id)
- card_verifier(id) → team_member(id)
- card_verifier(card_id) → card(id)
- card_board(id) → board(id)
- card_board(card_id) → card(id)
- card_attachment(card_id) → card(id)
- card(last_verified_by_user) → team_member(id)
- card(last_modified_by_user) → team_member(id)
- card(collection_id) → collection(id)
- card(original_owner_email) → team_member(id)
- card(card_template_id) → card_template(id)
- card(verification_initiator_email) → team_member(id)
- board_item(board_id) → board(id)
- board_groups_shared_with(board_id) → board(id)
- board(last_modified_by_user) → team_member(id)
- board(collection_id) → collection(id)