Trello
Explore the interactive ERD
Table & Field Reference
board_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | PKFK |
board_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
member_id | Unknown | FK |
deactivated | Unknown | |
member_type | Unknown | |
unconfirmed | Unknown |
board_switcher_view
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
board_id | Unknown | FK |
enabled | Unknown | |
id | Unknown | |
view_type | Unknown |
board_premium_feature
| Column | Type | Keys |
|---|---|---|
premium_feature | Unknown | PK |
board_id | Unknown | PKFK |
board_background_image
| Column | Type | Keys |
|---|---|---|
url | Unknown | PK |
board_id | Unknown | PKFK |
height | Unknown | |
width | Unknown |
board_power_up
| Column | Type | Keys |
|---|---|---|
power_up | Unknown | PK |
board_id | Unknown | PKFK |
board
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_creator_id | Unknown | FK |
organization_id | Unknown | FK |
attachment_limit_per_board_disable_at | Unknown | |
attachment_limit_per_board_status | Unknown | |
attachment_limit_per_board_warn_at | Unknown | |
attachment_limit_per_card_disable_at | Unknown | |
attachment_limit_per_card_status | Unknown | |
attachment_limit_per_card_warn_at | Unknown | |
background | Unknown | |
background_bottom_color | Unknown | |
background_brightness | Unknown | |
background_color | Unknown | |
background_image | Unknown | |
background_tile | Unknown | |
background_top_color | Unknown | |
board_limit_access_requests_per_board_disable_at | Unknown | |
board_limit_access_requests_per_board_status | Unknown | |
board_limit_access_requests_per_board_warn_at | Unknown | |
board_limit_members_per_board_disable_at | Unknown | |
board_limit_members_per_board_status | Unknown | |
board_limit_members_per_board_warn_at | Unknown | |
board_source_id | Unknown | |
calendar_feed_enabled | Unknown | |
can_be_enterprise | Unknown | |
can_be_org | Unknown | |
can_be_private | Unknown | |
can_be_public | Unknown | |
can_invite | Unknown | |
card_aging | Unknown | |
card_covers | Unknown | |
card_limit_open_per_board_disable_at | Unknown | |
card_limit_open_per_board_status | Unknown | |
card_limit_open_per_board_warn_at | Unknown | |
card_limit_open_per_list_disable_at | Unknown | |
card_limit_open_per_list_status | Unknown | |
card_limit_open_per_list_warn_at | Unknown | |
card_limit_total_per_board_disable_at | Unknown | |
card_limit_total_per_board_status | Unknown | |
card_limit_total_per_board_warn_at | Unknown | |
card_limit_total_per_list_disable_at | Unknown | |
card_limit_total_per_list_status | Unknown | |
card_limit_total_per_list_warn_at | Unknown | |
check_item_limit_per_checklist_disable_at | Unknown | |
check_item_limit_per_checklist_status | Unknown | |
check_item_limit_per_checklist_warn_at | Unknown | |
checklist_limit_per_board_disable_at | Unknown | |
checklist_limit_per_board_status | Unknown | |
checklist_limit_per_board_warn_at | Unknown | |
checklist_limit_per_card_disable_at | Unknown | |
checklist_limit_per_card_status | Unknown | |
checklist_limit_per_card_warn_at | Unknown | |
closed | Unknown | |
comments | Unknown | |
creation_method | Unknown | |
custom_field_limit_per_board_disable_at | Unknown | |
custom_field_limit_per_board_status | Unknown | |
custom_field_limit_per_board_warn_at | Unknown | |
custom_field_option_limit_per_field_disable_at | Unknown | |
custom_field_option_limit_per_field_status | Unknown | |
custom_field_option_limit_per_field_warn_at | Unknown | |
date_closed | Unknown | |
date_last_activity | Unknown | |
date_last_view | Unknown | |
date_plugin_disable | Unknown | |
description | Unknown | |
emoji | Json | |
enterprise_id | Unknown | |
enterprise_owned | Unknown | |
hidden_plugin_board_buttons | Json | |
hide_votes | Unknown | |
invitations | Unknown | |
is_template | Unknown | |
ix_update | Unknown | |
label_limit_per_board_disable_at | Unknown | |
label_limit_per_board_status | Unknown | |
label_limit_per_board_warn_at | Unknown | |
list_limit_open_per_board_disable_at | Unknown | |
list_limit_open_per_board_status | Unknown | |
list_limit_open_per_board_warn_at | Unknown | |
list_limit_total_per_board_disable_at | Unknown | |
list_limit_total_per_board_status | Unknown | |
list_limit_total_per_board_warn_at | Unknown | |
name | Unknown | |
permission_level | Unknown | |
pinned | Unknown | |
reaction_limit_per_action_disable_at | Unknown | |
reaction_limit_per_action_status | Unknown | |
reaction_limit_per_action_warn_at | Unknown | |
reaction_limit_unique_per_action_disable_at | Unknown | |
reaction_limit_unique_per_action_status | Unknown | |
reaction_limit_unique_per_action_warn_at | Unknown | |
self_join | Unknown | |
short_link | Unknown | |
short_url | Unknown | |
starred | Unknown | |
sticker_limit_per_card_disable_at | Unknown | |
sticker_limit_per_card_status | Unknown | |
sticker_limit_per_card_warn_at | Unknown | |
subscribed | Unknown | |
template_gallery | Unknown | |
url | Unknown | |
voting | Unknown |
organization_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
organization_id | Unknown | FK |
name | Unknown |
board_custom_field_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_custom_field_board_id | Unknown | PKFK |
custom_field_id | Unknown | PKFK |
color | Unknown | |
pos | Unknown | |
value_text | Unknown |
board_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | PKFK |
display_card_front | Unknown | |
field_group | Unknown | |
is_suggested_field | Unknown | |
model_type | Unknown | |
name | Unknown | |
pos | Unknown | |
type | Unknown |
message_dismissed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
count | Unknown | |
last_dismissed | Unknown | |
name | Unknown |
organization_admin
| Column | Type | Keys |
|---|---|---|
admin_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
enterprise_admin
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
member_trophy
| Column | Type | Keys |
|---|---|---|
trophy | Unknown | PK |
member_id | Unknown | PKFK |
organization_member
| Column | Type | Keys |
|---|---|---|
member_id | Unknown | PKFK |
organization_id | Unknown | PKFK |
deactivated_enterprise
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_id | Unknown | PKFK |
member_premium_feature
| Column | Type | Keys |
|---|---|---|
premium_feature | Unknown | PK |
member_id | Unknown | PKFK |
one_time_message_dismissed
| Column | Type | Keys |
|---|---|---|
one_time_message | Unknown | PK |
member_id | Unknown | PKFK |
member_product
| Column | Type | Keys |
|---|---|---|
product | Unknown | PK |
member_id | Unknown | PKFK |
member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_referrer_id | Unknown | FK |
aa_block_sync_until | Unknown | |
aa_email | Unknown | |
aa_enrolled_date | Unknown | |
aa_id | Unknown | |
activity_blocked | Unknown | |
avatar_hash | Unknown | |
avatar_privacy | Unknown | |
avatar_source | Unknown | |
avatar_url | Unknown | |
bio | Unknown | |
board_limit_total_per_member_disable_at | Unknown | |
board_limit_total_per_member_status | Unknown | |
board_limit_total_per_member_warn_at | Unknown | |
color_blind | Unknown | |
confirmed | Unknown | |
credentials_removed_count | Unknown | |
current_offset | Unknown | |
current_timezone | Unknown | |
domain_claimed | Unknown | |
email | Unknown | |
emoji | Json | |
enterprise_id | Unknown | |
full_name | Unknown | |
full_name_privacy | Unknown | |
gold_sunset_free_trial_organization_id | Unknown | |
gravatar_hash | Unknown | |
initials | Unknown | |
is_aa_mastered | Unknown | |
ix_update | Unknown | |
locale | Unknown | |
login_types | Json | |
marketing_opted_in | Unknown | |
marketing_opted_in_date | Unknown | |
member_type | Unknown | |
minutes_before_deadline_to_notify | Unknown | |
minutes_between_summaries | Unknown | |
next_date | Unknown | |
next_offset | Unknown | |
next_timezone | Unknown | |
non_public | Json | |
non_public_available | Unknown | |
org_limit_total_per_member_disable_at | Unknown | |
org_limit_total_per_member_status | Unknown | |
org_limit_total_per_member_warn_at | Unknown | |
send_summaries | Unknown | |
status | Unknown | |
timezone | Unknown | |
two_factor_enabled | Unknown | |
two_factor_needs_new_backups | Unknown | |
uploaded_avatar_hash | Unknown | |
uploaded_avatar_url | Unknown | |
url | Unknown | |
username | Unknown |
card_label
| Column | Type | Keys |
|---|---|---|
board_id | Unknown | PKFK |
card_id | Unknown | PKFK |
label_id | Unknown | PKFK |
card_member
| Column | Type | Keys |
|---|---|---|
card_id | Unknown | PKFK |
id | Unknown | PKFK |
card_member_voted
| Column | Type | Keys |
|---|---|---|
card_id | Unknown | PKFK |
card_member_id | Unknown | PKFK |
card
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attachment_cover_id | Unknown | FK |
board_id | Unknown | FK |
list_id | Unknown | FK |
attachment_cover_brightness | Unknown | |
attachment_cover_color | Unknown | |
attachment_cover_plugin_id | Unknown | |
attachment_cover_size | Unknown | |
attachment_cover_uploaded_background_id | Unknown | |
badge_attachment_by_type_board | Unknown | |
badge_attachment_by_type_card | Unknown | |
badge_attachments | Unknown | |
badge_check_items | Unknown | |
badge_check_items_checked | Unknown | |
badge_check_items_earliest_due | Unknown | |
badge_comments | Unknown | |
badge_description | Unknown | |
badge_fogbugz | Unknown | |
badge_location | Unknown | |
badge_subscribed | Unknown | |
badge_viewing_member_voted | Unknown | |
badge_votes | Unknown | |
card_role | Unknown | |
check_item_states | Json | |
closed | Unknown | |
date_last_activity | Unknown | |
description | Unknown | |
due | Unknown | |
due_complete | Unknown | |
due_reminder | Unknown | |
email | Unknown | |
emoji | Json | |
is_template | Unknown | |
manual_cover_attachment | Unknown | |
name | Unknown | |
position | Unknown | |
short_id | Unknown | |
short_link | Unknown | |
short_url | Unknown | |
start | Unknown | |
subscribed | Unknown | |
url | Unknown |
organization_product
| Column | Type | Keys |
|---|---|---|
product | Unknown | PK |
organization_id | Unknown | PKFK |
organization_power_up
| Column | Type | Keys |
|---|---|---|
power_up | Unknown | PK |
organization_id | Unknown | PKFK |
organization
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
display_name | Unknown | |
emoji | Json | |
logo_hash | Unknown | |
logo_url | Unknown | |
name | Unknown | |
team_type | Unknown | |
url | Unknown | |
website | Unknown |
card_custom_field_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
card_id | Unknown | PKFK |
id_value | Unknown | |
model_type | Unknown | |
custom_** |
card_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
card_id | Unknown | FK |
bytes | Unknown | |
date | Unknown | |
edge_color | Unknown | |
file_name | Unknown | |
is_upload | Unknown | |
member_id | Unknown | |
mime_type | Unknown | |
name | Unknown | |
position | Unknown | |
url | Unknown |
organization_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
member_creator_id | Unknown | FK |
organization_id | Unknown | FK |
app_creator | Unknown | |
data | Json | |
date | Unknown | |
limits | Json | |
type | Unknown |
check_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
checklist_id | Unknown | FK |
member_id | Unknown | FK |
due | Unknown | |
emoji | Json | |
name | Unknown | |
position | Unknown | |
state | Unknown |
checklist
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
card_id | Unknown | FK |
name | Unknown | |
position | Unknown |
board_label
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
color | Unknown | |
name | Unknown |
card_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
card_id | Unknown | FK |
member_creator_id | Unknown | FK |
app_creator | Unknown | |
data | Json | |
date | Unknown | |
limits | Json | |
type | Unknown |
list_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | FK |
member_creator_id | Unknown | FK |
app_creator | Unknown | |
data | Json | |
date | Unknown | |
limits | Json | |
type | Unknown |
board_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
member_creator_id | Unknown | FK |
app_creator | Unknown | |
data | Json | |
date | Unknown | |
limits | Json | |
type | Unknown |
list
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
board_id | Unknown | FK |
closed | Unknown | |
name | Unknown | |
position | Unknown | |
soft_limit | Unknown | |
subscribed | Unknown |