# WordPress schema ERD

Table and field reference for the Fivetran WordPress connector.

## Table & Field Reference

### site_allowed_file_type

| Column | Type | Keys |
| --- | --- | --- |
| allowed_file_type | Unknown | PK |
| site_id | Unknown | PK, FK |

### site_plan_feature_active

| Column | Type | Keys |
| --- | --- | --- |
| feature_active | Unknown | PK |
| site_id | Unknown | PK, FK |

### site_jetpack_module

| Column | Type | Keys |
| --- | --- | --- |
| jetpack_module | Unknown | PK |
| site_id | Unknown | PK, FK |

### site_user_interaction

| Column | Type | Keys |
| --- | --- | --- |
| user_interaction | Unknown | PK |
| site_id | Unknown | PK, FK |

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

### 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 |  |

## Relationships

- site_allowed_file_type(site_id) → site(id)
- site_plan_feature_active(site_id) → site(id)
- site_jetpack_module(site_id) → site(id)
- site_user_interaction(site_id) → site(id)
- post_metadata(post_id) → post(id)
- post(category_id) → category(id)
- post(author_id) → users(id)
- post(site_id) → site(id)
- comment(post_id) → post(id)
- comment(author_id) → users(id)
- comment(site_id) → site(id)
- category(site_id) → site(id)
- connected_applications_permission(connected_application_id) → connected_application(id)
- connected_application(site_id) → site(id)
- user_role(user_id) → users(id)
- users(site_id) → site(id)
- tags(site_id) → site(id)