Wordpress (4.7.3)_ssong
Wordpress ERD
Tables (12)
wp_commentmeta
- meta_id — bigint(20) — Primary key — NOT NULL
- comment_id — bigint(20) — Foreign key → wp_comments.comment_ID — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
wp_comments
- comment_ID — bigint(20) — Primary key — NOT NULL
- comment_post_ID — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
- comment_author — tinytext — NOT NULL
- comment_author_email — varchar(100) — NOT NULL
- comment_author_url — varchar(200) — NOT NULL
- comment_author_IP — varchar(100) — NOT NULL
- comment_date — datetime — NOT NULL — 0000-00-00 00:00:00
- comment_date_gmt — datetime — NOT NULL — 0000-00-00 00:00:00
- comment_content — text — NOT NULL
- comment_karma — int(11) — NOT NULL — 0
- comment_approved — varchar(20) — NOT NULL — 1
- comment_agent — varchar(255) — NOT NULL
- comment_type — varchar(20) — NOT NULL
- comment_parent — bigint(20) — Foreign key → wp_comments.comment_ID — NOT NULL
- user_id — bigint(20) — Foreign key → wp_users.ID — NOT NULL
wp_links
- link_id — bigint(20) — Primary key — NOT NULL
- link_url — varchar(255) — NOT NULL
- link_name — varchar(255) — NOT NULL
- link_image — varchar(255) — NOT NULL
- link_target — varchar(25) — NOT NULL
- link_description — varchar(255) — NOT NULL
- link_visible — varchar(20) — NOT NULL
- link_owner — bigint(20) — NOT NULL
- link_rating — int(11) — NOT NULL
- link_updated — datetime — NOT NULL
- link_rel — varchar(255) — NOT NULL
- link_notes — mediumtext — NOT NULL
- link_rss — varchar(255) — NOT NULL
wp_options
- option_id — bigint(20) — Primary key — NOT NULL
- option_name — varchar(191) — NOT NULL
- option_value — longtext — NOT NULL
- autoload — varchar(20) — NOT NULL
wp_postmeta
- meta_id — bigint(20) — Primary key — NOT NULL
- post_id — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
wp_posts
- ID — bigint(20) — Primary key — NOT NULL
- post_author — bigint(20) — Foreign key → wp_users.ID — NOT NULL
- post_date — datetime — NOT NULL
- post_date_gmt — datetime — NOT NULL
- post_content — longtext — NOT NULL
- post_title — text — NOT NULL
- post_excerpt — text — NOT NULL
- post_status — varchar(20) — NOT NULL
- comment_status — varchar(20) — NOT NULL — open
- ping_status — varchar(20) — NOT NULL
- post_password — varchar(255) — NOT NULL
- post_name — varchar(200) — NOT NULL
- to_ping — text — NOT NULL
- pinged — text — NOT NULL
- post_modified — datetime — NOT NULL
- post_modified_gmt — datetime — NOT NULL
- post_content_filtered — longtext — NOT NULL
- post_parent — bigint(20) — Foreign key → wp_posts.ID — NOT NULL
- guid — varchar(255) — NOT NULL
- menu_order — int(11) — NOT NULL
- post_type — varchar(20) — NOT NULL
- post_mime_type — varchar(100) — NOT NULL
- comment_count — bigint(20) — NOT NULL — 0
wp_term_relationships
- object_id — bigint(20) — Primary key — NOT NULL
- term_taxonomy_id — bigint(20) — Foreign key → wp_term_taxonomy.term_taxonomy_id — NOT NULL
- term_order — int(11) — NOT NULL
wp_term_taxonomy
- term_taxonomy_id — bigint(20) — Primary key — NOT NULL
- term_id — bigint(20) — Foreign key → wp_terms.term_id — NOT NULL
- taxonomy — varchar(32) — NOT NULL
- description — longtext — NOT NULL
- parent — bigint(20) — NOT NULL
- count — bigint(20) — NOT NULL
wp_termmeta
- meta_id — bigint(20) — Primary key — NOT NULL
- term_id — bigint(20) — Foreign key → wp_terms.term_id — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
wp_terms
- term_id — bigint(20) — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- slug — varchar(200) — NOT NULL
- term_group — bigint(10) — NOT NULL
wp_usermeta
- umeta_id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → wp_users.ID — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
wp_users
- ID — bigint(20) — Primary key — NOT NULL
- user_login — varchar(60) — NOT NULL
- user_pass — varchar(255) — NOT NULL
- user_nicename — varchar(50) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_url — varchar(100) — NOT NULL
- user_registered — datetime — NOT NULL
- user_activation_key — varchar(255) — NOT NULL
- user_status — int(11) — NOT NULL
- display_name — varchar(250) — NOT NULL