Canny
Explore the interactive ERD
Table & Field Reference
board
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created | Unknown | |
is_private | Unknown | |
name | Unknown | |
post_count | Unknown | |
private_comments | Unknown | |
token | Unknown | |
url | Unknown |
vote_zendesk_ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
vote_id | Unknown | PKFK |
created | Unknown | |
description | Unknown | |
subject | Unknown | |
url | Unknown |
vote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
by_user_id | Unknown | FK |
voter_user_id | Unknown | FK |
created | Unknown | |
post_id | Unknown |
entry_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
entry_id | Unknown | PKFK |
created | Unknown | |
entry_count | Unknown | |
name | Unknown | |
url | Unknown |
entry_type
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
entry_id | Unknown | PKFK |
entry_post
| Column | Type | Keys |
|---|---|---|
entry_id | Unknown | PKFK |
id | Unknown | PKFK |
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 |
post_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
post_id | Unknown | PKFK |
post_linked_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
post_id | Unknown | PKFK |
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 | PKFK |
created | Unknown |
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 |
comment_mention
| Column | Type | Keys |
|---|---|---|
comment_id | Unknown | PKFK |
id | Unknown | PKFK |
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 |
company_attribute
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
company_id | Unknown | PKFK |
value | Unknown |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created | Unknown | |
domain | Unknown | |
member_count | Unknown | |
monthly_spend | Unknown | |
name | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
created | Unknown | |
name | Unknown | |
parent_id | Unknown | |
post_count | Unknown | |
url | 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 |
user_attribute
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
users_id | Unknown | PKFK |
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 |
opporunity_post
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
opportunity_id | Unknown | PKFK |
opportunity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
closed | Unknown | |
name | Unknown | |
salesforce_opportunity_id | Unknown | |
value | Unknown | |
won | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
created | Unknown | |
name | Unknown | |
post_count | Unknown | |
url | Unknown |