# Podio schema ERD

Table and field reference for the Fivetran Podio connector.

## Table & Field Reference

### contact_address

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| address | Unknown |  |

### contact_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| location | Unknown |  |

### contact_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| rights | Unknown |  |

### contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| phone | Unknown |  |

### contact_skill

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| skill | Unknown |  |

### contact_mail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_profile_id | Unknown | PK, FK |
| mail | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| profile_id | Unknown | PK |
| org_id | Unknown | FK |
| space_id | Unknown | FK |
| user_id | Unknown | FK |
| avatar | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| external_id | Unknown |  |
| image | Json |  |
| last_seen_on | Unknown |  |
| link | Unknown |  |
| name | Unknown |  |
| skype | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |
| zip | Unknown |  |

### user_status_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| phone | Unknown |  |

### user_status_mail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| disabled | Unknown |  |
| is_primary | Unknown |  |
| mail | Unknown |  |
| verified | Unknown |  |

### user_status

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK |
| org_id | Unknown | FK |
| profile_id | Unknown | FK |
| space_id | Unknown | FK |
| betas | Json |  |
| calendar_code | Unknown |  |
| flags | Json |  |
| inbox | Unknown |  |
| inbox_new | Unknown |  |
| mailbox | Unknown |  |
| message_unread_count | Unknown |  |
| presence_ref_id | Unknown |  |
| presence_ref_type | Unknown |  |
| presence_signature | Unknown |  |
| presence_user_id | Unknown |  |
| profile_external_id | Unknown |  |
| profile_image | Unknown |  |
| profile_last_seen_on | Unknown |  |
| profile_link | Unknown |  |
| profile_mail | Unknown |  |
| profile_name | Unknown |  |
| profile_org_id | Unknown |  |
| profile_phone | Unknown |  |
| profile_push | Unknown |  |
| profile_space_id | Unknown |  |
| profile_type | Unknown |  |
| profile_user_id | Unknown |  |
| push_channel | Unknown |  |
| push_expires_in | Unknown |  |
| push_signature | Unknown |  |
| push_timestamp | Unknown |  |
| referral_code | Unknown |  |
| referral_status | Unknown |  |
| user_activated_on | Unknown |  |
| user_created_on | Unknown |  |
| user_domain | Unknown |  |
| user_flags | Json |  |
| user_from_sharefile | Unknown |  |
| user_is_partner | Unknown |  |
| user_locale | Unknown |  |
| user_sf_mail | Unknown |  |
| user_status | Unknown |  |
| user_timezone | Unknown |  |

### application

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| space_id | Unknown | PK, FK |
| accounting_info_org_id | Unknown | FK |
| accounting_info_count | Unknown |  |
| accounting_info_limit | Unknown |  |
| accounting_info_percent | Unknown |  |
| config_allow_create | Unknown |  |
| config_allow_edit | Unknown |  |
| config_description | Unknown |  |
| config_external_id | Unknown |  |
| config_icon | Unknown |  |
| config_icon_id | Unknown |  |
| config_item_name | Unknown |  |
| config_name | Unknown |  |
| config_type | Unknown |  |
| config_usage | Unknown |  |
| current_revision | Unknown |  |
| default_view_id | Unknown |  |
| is_default | Unknown |  |
| link | Unknown |  |
| link_add | Unknown |  |
| original | Unknown |  |
| share_file_vault_url | Unknown |  |
| status | Unknown |  |
| url | Unknown |  |
| url_add | Unknown |  |
| url_label | Unknown |  |

### organization_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| domain | Unknown |  |

### organization_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| organization_id | Unknown | PK, FK |
| rights | Unknown |  |

### organization_space

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |
| archived | Unknown |  |
| tops | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_status | Unknown |  |
| grants_count | Unknown |  |
| image | Unknown |  |
| logo | Unknown |  |
| name | Unknown |  |
| premium | Unknown |  |
| rank | Unknown |  |
| role | Unknown |  |
| sales_agent_id | Unknown |  |
| segment | Unknown |  |
| segment_size | Unknown |  |
| status | Unknown |  |
| tier | Unknown |  |
| trial_expired_on | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| url_label | Unknown |  |
| user_limit | Unknown |  |

### space_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| org_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |
| rights | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| org_id | Unknown | PK, FK |
| profile_id | Unknown | FK |
| user_id | Unknown | FK |
| auto_join | Unknown |  |
| created_by_avatar | Unknown |  |
| created_by_image | Unknown |  |
| created_by_last_seen_on | Unknown |  |
| created_by_link | Unknown |  |
| created_by_name | Unknown |  |
| created_by_profile_id | Unknown |  |
| created_by_space_id | Unknown |  |
| created_by_type | Unknown |  |
| created_by_user_id | Unknown |  |
| created_on | Unknown |  |
| description | Unknown |  |
| is_overdue | Unknown |  |
| item_accounting_info | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |
| post_on_new_app | Unknown |  |
| post_on_new_member | Unknown |  |
| premium | Unknown |  |
| privacy | Unknown |  |
| push_channel | Unknown |  |
| push_expires_in | Unknown |  |
| push_signature | Unknown |  |
| push_timestamp | Unknown |  |
| role | Unknown |  |
| sharefile_vault_url | Unknown |  |
| subscribed | Unknown |  |
| tier | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |
| url_label | Unknown |  |
| video | Unknown |  |

### item_field

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK |
| item_id | Unknown | PK, FK |
| config_label | Unknown |  |
| config_mapping | Unknown |  |
| config_setting | Json |  |
| external_id | Unknown |  |
| field_value | Json |  |
| label | Unknown |  |
| type | Unknown |  |

### item_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| item_id | Unknown | PK, FK |
| rights | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_item_id | Unknown |  |
| app_item_id_formatted | Unknown |  |
| comment_count | Unknown |  |
| created_by_avatar | Unknown |  |
| created_by_avatar_id | Unknown |  |
| created_by_avatar_type | Unknown |  |
| created_by_id | Unknown |  |
| created_by_image | Unknown |  |
| created_by_last_seen_on | Unknown |  |
| created_by_name | Unknown |  |
| created_by_type | Unknown |  |
| created_by_url | Unknown |  |
| created_by_user_id | Unknown |  |
| created_on | Unknown |  |
| created_via_auth_client_id | Unknown |  |
| created_via_display | Unknown |  |
| created_via_id | Unknown |  |
| created_via_name | Unknown |  |
| created_via_url | Unknown |  |
| current_revision_avatar | Unknown |  |
| current_revision_created_by_avatar | Unknown |  |
| current_revision_created_by_avatar_id | Unknown |  |
| current_revision_created_by_avatar_type | Unknown |  |
| current_revision_created_by_id | Unknown |  |
| current_revision_created_by_image | Unknown |  |
| current_revision_created_by_type | Unknown |  |
| current_revision_created_by_url | Unknown |  |
| current_revision_created_by_user_id | Unknown |  |
| current_revision_created_on | Unknown |  |
| current_revision_created_via_auth_client_id | Unknown |  |
| current_revision_created_via_display | Unknown |  |
| current_revision_created_via_id | Unknown |  |
| current_revision_created_via_name | Unknown |  |
| current_revision_created_via_url | Unknown |  |
| current_revision_item_revision_id | Unknown |  |
| current_revision_revision | Unknown |  |
| current_revision_type | Unknown |  |
| current_revision_user_avatar | Unknown |  |
| current_revision_user_avatar_id | Unknown |  |
| current_revision_user_avatar_type | Unknown |  |
| current_revision_user_id | Unknown |  |
| current_revision_user_image | Unknown |  |
| current_revision_user_last_seen_on | Unknown |  |
| current_revision_user_name | Unknown |  |
| current_revision_user_type | Unknown |  |
| current_revision_user_url | Unknown |  |
| current_revision_user_user_id | Unknown |  |
| external_id | Unknown |  |
| file_count | Unknown |  |
| initial_revision_created_by_avatar | Unknown |  |
| initial_revision_created_by_avatar_id | Unknown |  |
| initial_revision_created_by_avatar_type | Unknown |  |
| initial_revision_created_by_id | Unknown |  |
| initial_revision_created_by_image | Unknown |  |
| initial_revision_created_by_last_seen_on | Unknown |  |
| initial_revision_created_by_name | Unknown |  |
| initial_revision_created_by_type | Unknown |  |
| initial_revision_created_by_url | Unknown |  |
| initial_revision_created_by_user_id | Unknown |  |
| initial_revision_created_on | Unknown |  |
| initial_revision_created_via_auth_client_id | Unknown |  |
| initial_revision_created_via_display | Unknown |  |
| initial_revision_created_via_id | Unknown |  |
| initial_revision_created_via_name | Unknown |  |
| initial_revision_created_via_url | Unknown |  |
| initial_revision_item_revision_id | Unknown |  |
| initial_revision_revision | Unknown |  |
| initial_revision_type | Unknown |  |
| initial_revision_user_avatar | Unknown |  |
| initial_revision_user_avatar_id | Unknown |  |
| initial_revision_user_avatar_type | Unknown |  |
| initial_revision_user_id | Unknown |  |
| initial_revision_user_image | Unknown |  |
| initial_revision_user_last_seen_on | Unknown |  |
| initial_revision_user_name | Unknown |  |
| initial_revision_user_type | Unknown |  |
| initial_revision_user_url | Unknown |  |
| initial_revision_user_user_id | Unknown |  |
| last_event_on | Unknown |  |
| link | Unknown |  |
| priority | Unknown |  |
| rating | Json |  |
| revision | Unknown |  |
| sharefile_vault_folder_id | Unknown |  |
| sharefile_vault_url | Unknown |  |
| title | Unknown |  |

### file_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| file_id | Unknown | PK, FK |
| rights | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| app_id | Unknown | PK, FK |
| item_id | Unknown | FK |
| context_created_on | Unknown |  |
| context_data_app_item_id | Unknown |  |
| context_data_created_on | Unknown |  |
| context_data_created_via | Unknown |  |
| context_data_excerpt | Unknown |  |
| context_data_link | Unknown |  |
| context_data_revision | Unknown |  |
| context_data_sharefile_vault_folder_id | Unknown |  |
| context_data_sharefile_vault_url | Unknown |  |
| context_data_title | Unknown |  |
| context_excerpt_label | Unknown |  |
| context_excerpt_text | Unknown |  |
| context_id | Unknown |  |
| context_link | Unknown |  |
| context_title | Unknown |  |
| context_type | Unknown |  |
| context_type_name | Unknown |  |
| created_by_avatar | Unknown |  |
| created_by_avatar_id | Unknown |  |
| created_by_avatar_type | Unknown |  |
| created_by_id | Unknown |  |
| created_by_image | Unknown |  |
| created_by_last_seen_on | Unknown |  |
| created_by_name | Unknown |  |
| created_by_type | Unknown |  |
| created_by_url | Unknown |  |
| created_by_user_id | Unknown |  |
| created_on | Unknown |  |
| created_via_auth_client_id | Unknown |  |
| created_via_display | Unknown |  |
| created_via_id | Unknown |  |
| created_via_name | Unknown |  |
| created_via_url | Unknown |  |
| description | Unknown |  |
| external_file_id | Unknown |  |
| hosted_by | Unknown |  |
| hosted_by_humanized_name | Unknown |  |
| initial_revision_created_by_avatar | Unknown |  |
| initial_revision_created_by_avatar_id | Unknown |  |
| initial_revision_created_by_avatar_type | Unknown |  |
| initial_revision_created_by_id | Unknown |  |
| initial_revision_created_by_image | Unknown |  |
| initial_revision_created_by_last_seen_on | Unknown |  |
| initial_revision_created_by_name | Unknown |  |
| initial_revision_created_by_type | Unknown |  |
| initial_revision_created_by_url | Unknown |  |
| initial_revision_created_by_user_id | Unknown |  |
| initial_revision_created_on | Unknown |  |
| initial_revision_created_via_auth_client_id | Unknown |  |
| initial_revision_created_via_display | Unknown |  |
| initial_revision_created_via_id | Unknown |  |
| initial_revision_created_via_name | Unknown |  |
| initial_revision_created_via_url | Unknown |  |
| initial_revision_item_revision_id | Unknown |  |
| initial_revision_revision | Unknown |  |
| initial_revision_type | Unknown |  |
| link | Unknown |  |
| link_target | Unknown |  |
| mimetype | Unknown |  |
| name | Unknown |  |
| perma_link | Unknown |  |
| presence | Unknown |  |
| push | Unknown |  |
| replaces | Json |  |
| size | Unknown |  |
| thumbnail_link | Unknown |  |

## Relationships

- contact_address(contact_profile_id) → contact(profile_id)
- contact_location(contact_profile_id) → contact(profile_id)
- contact_right(contact_profile_id) → contact(profile_id)
- contact_phone(contact_profile_id) → contact(profile_id)
- contact_skill(contact_profile_id) → contact(profile_id)
- contact_mail(contact_profile_id) → contact(profile_id)
- contact(user_id) → user_status(user_id)
- contact(space_id) → space(id)
- contact(org_id) → organization(id)
- user_status_phone(user_id) → user_status(user_id)
- user_status_mail(user_id) → user_status(user_id)
- user_status(profile_id) → contact(profile_id)
- user_status(space_id) → space(id)
- user_status(org_id) → organization(id)
- application(space_id) → space(id)
- application(accounting_info_org_id) → organization(id)
- organization_domain(organization_id) → organization(id)
- organization_right(organization_id) → organization(id)
- organization_space(space_id) → space(id)
- organization_space(organization_id) → organization(id)
- space_right(space_id) → space(id)
- space_right(org_id) → space(org_id)
- space(org_id) → organization(id)
- space(user_id) → user_status(user_id)
- space(profile_id) → contact(profile_id)
- item_field(item_id) → item(id)
- item_right(item_id) → item(id)
- file_right(file_id) → file(id)
- file(item_id) → item(id)
- file(app_id) → application(id)