Fivetran documentation

Search the docs

/

WordPress

Explore the interactive ERD

Table & Field Reference

site_allowed_file_type

Column	Type	Keys
`allowed_file_type`	Unknown	PK
`site_id`	Unknown	PKFK

site_plan_feature_active

Column	Type	Keys
`feature_active`	Unknown	PK
`site_id`	Unknown	PKFK

site_jetpack_module

Column	Type	Keys
`jetpack_module`	Unknown	PK
`site_id`	Unknown	PKFK

site_user_interaction

Column	Type	Keys
`user_interaction`	Unknown	PK
`site_id`	Unknown	PKFK

site

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`is_coming_soon`	Unknown
`is_core_site_editor_enabled`	Unknown
`is_following`	Unknown
`is_fse_active`	Unknown
`is_fse_eligible`	Unknown
`is_multisite`	Unknown
`is_private`	Unknown
`is_vip`	Unknown
`is_wpcom_atomic`	Unknown
`jetpack`	Unknown
`jetpack_connection`	Unknown
`lang`	Unknown
`launch_status`	Unknown
`logo_id`	Unknown
`logo_size`	Json
`logo_url`	Unknown
`meta_links_comments`	Unknown
`meta_links_help`	Unknown
`meta_links_posts`	Unknown
`meta_links_self`	Unknown
`meta_links_xmlrpc`	Unknown
`name`	Unknown
`organization_id`	Unknown
`p_2_thumbnail_elements`	Unknown
`plan_billing_period`	Unknown
`plan_expired`	Unknown
`plan_is_free`	Unknown
`plan_license_key`	Unknown
`plan_product_id`	Unknown
`plan_product_name`	Unknown
`plan_product_name_short`	Unknown
`plan_product_slug`	Unknown
`plan_user_is_owner`	Unknown
`products`	Json
`quota_percent_used`	Unknown
`quota_space_allowed`	Unknown
`quota_space_available`	Unknown
`quota_space_used`	Unknown
`single_user_site`	Unknown
`site_migration`	Json
`site_owner`	Unknown
`subscribers_count`	Unknown
`update_plugins`	Unknown
`update_themes`	Unknown
`update_total`	Unknown
`update_translations`	Unknown
`update_wordpress`	Unknown
`url`	Unknown
`user_can_manage`	Unknown
`visible`	Unknown
`was_ecommerce_trial`	Unknown
`zendesk_site_meta_addon`	Unknown
`zendesk_site_meta_plan`	Unknown
`capability_`
`option_`

post_metadata

Column	Type	Keys
`id`	Unknown	PK
`post_id`	Unknown	PKFK
`key`	Unknown
`value`	Unknown

post

Column	Type	Keys
`id`	Unknown	PK
`author_id`	Unknown	FK
`category_id`	Unknown	FK
`site_id`	Unknown	FK
`attachment_count`	Unknown
`attachments`	Json
`capabilities_delete_post`	Unknown
`capabilities_edit_post`	Unknown
`capabilities_publish_post`	Unknown
`content`	Unknown
`date`	Unknown
`discussion_comment_count`	Unknown
`discussion_comment_status`	Unknown
`discussion_comments_open`	Unknown
`discussion_ping_status`	Unknown
`discussion_pings_open`	Unknown
`excerpt`	Unknown
`featured_image`	Unknown
`format`	Unknown
`geo`	Unknown
`global_id`	Unknown
`guid`	Unknown
`i_like`	Unknown
`is_following`	Unknown
`is_reblogged`	Unknown
`like_count`	Unknown
`likes_enabled`	Unknown
`menu_order`	Unknown
`meta_links_help`	Unknown
`meta_links_likes`	Unknown
`meta_links_replies`	Unknown
`meta_links_self`	Unknown
`meta_links_site`	Unknown
`modified`	Instant
`other_urls`	Json
`page_template`	Unknown
`parent`	Unknown
`password`	Unknown
`post_thumbnail_guid`	Unknown
`post_thumbnail_height`	Unknown
`post_thumbnail_id`	Unknown
`post_thumbnail_mime_type`	Unknown
`post_thumbnail_url`	Unknown
`post_thumbnail_width`	Unknown
`publicize_urls`	Json
`sharing_enabled`	Unknown
`short_url`	Unknown
`slug`	Unknown
`status`	Unknown
`sticky`	Unknown
`tags`	Json
`title`	Unknown
`type`	Unknown
`url`	Unknown

comment

Column	Type	Keys
`id`	Unknown	PK
`author_id`	Unknown	FK
`post_id`	Unknown	FK
`site_id`	Unknown	FK
`can_moderate`	Unknown
`content`	Unknown
`date`	Unknown
`i_like`	Unknown
`i_replied`	Unknown
`like_count`	Unknown
`meta_links_help`	Unknown
`meta_links_likes`	Unknown
`meta_links_post`	Unknown
`meta_links_replies`	Unknown
`meta_links_self`	Unknown
`meta_links_site`	Unknown
`parent`	Json
`post_link`	Unknown
`post_title`	Unknown
`post_type`	Unknown
`raw_content`	Unknown
`short_url`	Unknown
`status`	Unknown
`type`	Unknown
`url`	Unknown

category

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`description`	Unknown
`feed_url`	Unknown
`meta_links_help`	Unknown
`meta_links_self`	Unknown
`meta_links_site`	Unknown
`name`	Unknown
`parent`	Unknown
`post_count`	Unknown
`slug`	Unknown

connected_applications_permission

Column	Type	Keys
`name`	Unknown	PK
`connected_application_id`	Unknown	PKFK
`description`	Unknown

connected_application

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`authorized`	Unknown
`description`	Unknown
`icon`	Unknown
`scope`	Unknown
`title`	Unknown
`url`	Unknown

user_role

Column	Type	Keys
`role`	Unknown	PK
`user_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`avatar_url`	Unknown
`email`	Unknown
`first_name`	Unknown
`ip_address`	Unknown
`is_super_admin`	Unknown
`last_name`	Unknown
`login`	Unknown
`name`	Unknown
`nice_name`	Unknown
`profile_url`	Unknown
`site_visible`	Unknown
`url`	Unknown

tags

Column	Type	Keys
`id`	Unknown	PK
`site_id`	Unknown	FK
`description`	Unknown
`feed_url`	Unknown
`meta_links_help`	Unknown
`meta_links_self`	Unknown
`meta_links_site`	Unknown
`name`	Unknown
`post_count`	Unknown
`slug`	Unknown