# Canny schema ERD

Table and field reference for the Fivetran Canny connector.

## Table & Field Reference

### idea

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| group_id | Unknown | FK |
| owner_id | Unknown | FK |
| parent_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| source_name | Unknown |  |
| source_type | Unknown |  |
| status_name | Unknown |  |
| status_type | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| url_name | Unknown |  |

### post_tag

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

### post_linked_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| post_id | Unknown | PK, FK |
| link_id | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |

### post_linked_issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| post_id | Unknown | FK |
| key | Unknown |  |
| url | Unknown |  |

### post_merge_history

| Column | Type | Keys |
| --- | --- | --- |
| post_id | Unknown | PK, FK |
| created | Unknown |  |

### roadmap

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| created | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### post_roadmap

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

### post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_user_id | Unknown | FK |
| board_id | Unknown | FK |
| by_user_id | Unknown | FK |
| category_id | Unknown | FK |
| owner_id | Unknown | FK |
| comment_count | Unknown |  |
| created | Unknown |  |
| custom_fields | Json |  |
| details | Unknown |  |
| eta | Unknown |  |
| image_urls | Json |  |
| score | Unknown |  |
| status | Unknown |  |
| status_changed_at | Unknown |  |
| title | Unknown |  |
| total_mrr | Unknown |  |
| url | Unknown |  |

### company_attribute

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

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| domain | Unknown |  |
| member_count | Unknown |  |
| monthly_spend | Unknown |  |
| name | Unknown |  |

### vote_zendesk_ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vote_id | Unknown | PK, FK |
| created | Unknown |  |
| description | Unknown |  |
| subject | Unknown |  |
| url | Unknown |  |

### vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| board_id | Unknown | FK |
| by_user_id | Unknown | FK |
| post_id | Unknown | FK |
| voter_user_id | Unknown | FK |
| created | Unknown |  |
| vote_priority | Unknown |  |

### status_change

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| changer_user_id | Unknown | FK |
| post_id | Unknown | FK |
| created | Unknown |  |
| image_urls | Json |  |
| status | Unknown |  |
| value | Unknown |  |

### opporunity_post

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

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| closed | Unknown |  |
| name | Unknown |  |
| salesforce_opportunity_id | Unknown |  |
| value | Unknown |  |
| won | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| description | Unknown |  |
| name | Unknown |  |
| url_name | Unknown |  |

### user_attribute

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| avatar_url | Unknown |  |
| created | Unknown |  |
| email | Unknown |  |
| is_admin | Unknown |  |
| last_activity | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |
| user_id | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| board_id | Unknown | FK |
| created | Unknown |  |
| name | Unknown |  |
| post_count | Unknown |  |
| url | Unknown |  |

### entry_label

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entry_id | Unknown | PK, FK |
| created | Unknown |  |
| entry_count | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### entry_type

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| entry_id | Unknown | PK, FK |

### entry_post

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

### entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| last_saved | Unknown |  |
| likes | Unknown |  |
| markdown_details | Unknown |  |
| plaintext_details | Unknown |  |
| published_at | Unknown |  |
| scheduled_for | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| url | Unknown |  |

### insight_user

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

### insight

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| company_id | Unknown | FK |
| idea_id | Unknown | FK |
| created | Unknown |  |
| priority | Unknown |  |
| source_name | Unknown |  |
| source_type | Unknown |  |
| url | Unknown |  |
| value | Unknown |  |

### comment_mention

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

### comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_id | Unknown | FK |
| board_id | Unknown | FK |
| post_id | Unknown | FK |
| created | Unknown |  |
| image_urls | Json |  |
| internal | Unknown |  |
| like_count | Unknown |  |
| likes | Unknown |  |
| parent_id | Unknown |  |
| private | Unknown |  |
| status | Unknown |  |
| value | Unknown |  |

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| board_id | Unknown | FK |
| created | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| post_count | Unknown |  |
| url | Unknown |  |

### board

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created | Unknown |  |
| is_private | Unknown |  |
| name | Unknown |  |
| post_count | Unknown |  |
| private_comments | Unknown |  |
| token | Unknown |  |
| url | Unknown |  |

## Relationships

- idea(author_id) → users(id)
- idea(group_id) → groups(id)
- idea(owner_id) → users(id)
- idea(parent_id) → idea(id)
- post_tag(id) → tags(id)
- post_tag(post_id) → post(id)
- post_linked_task(post_id) → post(id)
- post_linked_issue(post_id) → post(id)
- post_merge_history(post_id) → post(id)
- post_roadmap(id) → roadmap(id)
- post_roadmap(post_id) → post(id)
- post(by_user_id) → users(id)
- post(board_id) → board(id)
- post(category_id) → category(id)
- post(owner_id) → users(id)
- post(author_user_id) → users(id)
- company_attribute(company_id) → company(id)
- vote_zendesk_ticket(vote_id) → vote(id)
- vote(board_id) → board(id)
- vote(post_id) → post(id)
- vote(voter_user_id) → users(id)
- vote(by_user_id) → users(id)
- status_change(post_id) → post(id)
- status_change(changer_user_id) → users(id)
- opporunity_post(id) → post(id)
- opporunity_post(opportunity_id) → opportunity(id)
- groups(parent_id) → groups(id)
- user_attribute(users_id) → users(id)
- tags(board_id) → board(id)
- entry_label(entry_id) → entry(id)
- entry_type(entry_id) → entry(id)
- entry_post(id) → post(id)
- entry_post(entry_id) → entry(id)
- insight_user(id) → users(id)
- insight_user(insight_id) → insight(id)
- insight(author_id) → users(id)
- insight(idea_id) → idea(id)
- insight(company_id) → company(id)
- comment_mention(id) → users(id)
- comment_mention(comment_id) → comment(id)
- comment(board_id) → board(id)
- comment(author_id) → users(id)
- comment(post_id) → post(id)
- category(board_id) → board(id)