# Trello schema ERD

Table and field reference for the Fivetran Trello connector.

## Table & Field Reference

### board_tag

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

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

### board_background_image

| Column | Type | Keys |
| --- | --- | --- |
| url | Unknown | PK |
| board_id | Unknown | PK, FK |
| height | Unknown |  |
| width | Unknown |  |

### board_power_up

| Column | Type | Keys |
| --- | --- | --- |
| power_up | Unknown | PK |
| board_id | Unknown | PK, FK |

### 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 | PK, FK |
| custom_field_id | Unknown | PK, FK |
| color | Unknown |  |
| pos | Unknown |  |
| value_text | Unknown |  |

### board_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| board_id | Unknown | PK, FK |
| 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 | PK, FK |
| count | Unknown |  |
| last_dismissed | Unknown |  |
| name | Unknown |  |

### organization_admin

| Column | Type | Keys |
| --- | --- | --- |
| admin_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### enterprise_admin

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

### member_trophy

| Column | Type | Keys |
| --- | --- | --- |
| trophy | Unknown | PK |
| member_id | Unknown | PK, FK |

### organization_member

| Column | Type | Keys |
| --- | --- | --- |
| member_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### deactivated_enterprise

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

### member_premium_feature

| Column | Type | Keys |
| --- | --- | --- |
| premium_feature | Unknown | PK |
| member_id | Unknown | PK, FK |

### one_time_message_dismissed

| Column | Type | Keys |
| --- | --- | --- |
| one_time_message | Unknown | PK |
| member_id | Unknown | PK, FK |

### member_product

| Column | Type | Keys |
| --- | --- | --- |
| product | Unknown | PK |
| member_id | Unknown | PK, FK |

### 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 | PK, FK |
| card_id | Unknown | PK, FK |
| label_id | Unknown | PK, FK |

### card_member

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

### card_member_voted

| Column | Type | Keys |
| --- | --- | --- |
| card_id | Unknown | PK, FK |
| card_member_id | Unknown | PK, FK |

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

### organization_power_up

| Column | Type | Keys |
| --- | --- | --- |
| power_up | Unknown | PK |
| organization_id | Unknown | PK, FK |

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

## Relationships

- board_tag(board_id) → board(id)
- board_member(member_id) → member(id)
- board_member(board_id) → board(id)
- board_switcher_view(board_id) → board(id)
- board_premium_feature(board_id) → board(id)
- board_background_image(board_id) → board(id)
- board_power_up(board_id) → board(id)
- board(member_creator_id) → member(id)
- board(organization_id) → organization(id)
- organization_tag(organization_id) → organization(id)
- board_custom_field_option(custom_field_id) → board_custom_field(id)
- board_custom_field_option(board_custom_field_board_id) → board_custom_field(board_id)
- board_custom_field(board_id) → board(id)
- message_dismissed(member_id) → member(id)
- organization_admin(organization_id) → organization(id)
- organization_admin(admin_id) → member(id)
- enterprise_admin(member_id) → member(id)
- member_trophy(member_id) → member(id)
- organization_member(member_id) → member(id)
- organization_member(organization_id) → organization(id)
- deactivated_enterprise(member_id) → member(id)
- member_premium_feature(member_id) → member(id)
- one_time_message_dismissed(member_id) → member(id)
- member_product(member_id) → member(id)
- member(member_referrer_id) → member(id)
- card_label(label_id) → board_label(id)
- card_label(board_id) → board(id)
- card_label(card_id) → card(id)
- card_member(id) → member(id)
- card_member(card_id) → card(id)
- card_member_voted(card_member_id) → card_member(id)
- card_member_voted(card_id) → card(id)
- card(board_id) → board(id)
- card(list_id) → list(id)
- card(attachment_cover_id) → card_attachment(id)
- organization_product(organization_id) → organization(id)
- organization_power_up(organization_id) → organization(id)
- card_custom_field_item(card_id) → card(id)
- card_attachment(card_id) → card(id)
- organization_action(member_creator_id) → member(id)
- organization_action(organization_id) → organization(id)
- check_item(member_id) → member(id)
- check_item(checklist_id) → checklist(id)
- checklist(board_id) → board(id)
- checklist(card_id) → card(id)
- board_label(board_id) → board(id)
- card_action(member_creator_id) → member(id)
- card_action(card_id) → card(id)
- list_action(member_creator_id) → member(id)
- list_action(list_id) → list(id)
- board_action(member_creator_id) → member(id)
- board_action(board_id) → board(id)
- list(board_id) → board(id)