Podio

Explore the interactive ERD

Table & Field Reference

contact_address

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`address`	Unknown

contact_location

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`location`	Unknown

contact_right

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`rights`	Unknown

contact_phone

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`phone`	Unknown

contact_skill

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`skill`	Unknown

contact_mail

Column	Type	Keys
`index`	Unknown	PK
`contact_profile_id`	Unknown	PKFK
`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	PKFK
`phone`	Unknown

user_status_mail

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`domain`	Unknown

organization_right

Column	Type	Keys
`index`	Unknown	PK
`organization_id`	Unknown	PKFK
`rights`	Unknown

organization_space

Column	Type	Keys
`organization_id`	Unknown	PKFK
`space_id`	Unknown	PKFK
`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	PKFK
`space_id`	Unknown	PKFK
`rights`	Unknown

space

Column	Type	Keys
`id`	Unknown	PK
`org_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`rights`	Unknown

file

Column	Type	Keys
`id`	Unknown	PK
`app_id`	Unknown	PKFK
`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