WP_DATA_MODEL model documentation

WP Data Model

Tables 12	Columns 94		Triggers 0	Sequences 0
Tables 12	Relationships 0	Views 0	Procedures 0	Domains 0

Diagram

All Items

Tables

#	Caption	Name	Description
1	wp_commentmeta	wp_commentmeta	Each comment features information called the meta data and it is stored in the wp_commentmeta.
2	wp_comments	wp_comments	The comments within WordPress are stored in the wp_comments table.
3	wp_links	wp_links	The wp_links holds information related to the links entered into the Links feature of WordPress. (This feature has been deprecated, but can be re-enabled with the Links Manager plugin.)
4	wp_options	wp_options	The Options set under the Administration > Settings panel are stored in the wp_options table. See Option Reference for option_name and default values.
5	wp_postmeta	wp_postmeta	Each post features information called the meta data and it is stored in the wp_postmeta. Some plugins may add their own information to this table.
6	wp_posts	wp_posts	The core of the WordPress data is the posts. It is stored in the wp_posts table. Also Pages and navigation menu items are stored in this table.
7	wp_term_relationships	wp_term_relationships	Posts are associated with categories and tags from the wp_terms table and this association is maintained in the wp_term_relationships table. The association of links to their respective categories are also kept in this table.
8	wp_term_taxonomy	wp_term_taxonomy	This table describes the taxonomy (category, link, or tag) for the entries in the wp_terms table.
9	wp_termmeta	wp_termmeta	Each term features information called the meta data and it is stored in wp_termmeta.
10	wp_terms	wp_terms	The categories for both posts and links and the tags for posts are found within the wp_terms table.
11	wp_usermeta	wp_usermeta	Each user features information called the meta data and it is stored in wp_usermeta.
12	wp_users	wp_users	The list of users is maintained in table wp_users.

Tables : wp_commentmeta

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 2	Contraints 0

Columns :

Name	Caption	Primary Key	type
meta_id	meta_id	true	BIGINT(20)
comment_id	comment_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT

Keys :

Name	Primary Key	Description
PK_wp_commentmeta	true

Indexes

Name	UNIQUE	Type	Description
comment_id		Ascending
meta_key		Ascending

Columns Detail :

Name	meta_id
Table	wp_commentmeta
Description	unique number assigned to each row of the table.
Type	BIGINT(20)
Domain
Primary Key	true
Not null	true
Identity	true

Name	comment_id
Table	wp_commentmeta
Description	the ID of the post the data relates to. (Reference to the wp_comments table.)
Type	BIGINT(20)
Domain
Not null	true
Default Value	0

Name	meta_key
Table	wp_commentmeta
Description	an identifying key for the piece of data.
Type	VARCHAR(255)
Domain
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	meta_value
Table	wp_commentmeta
Description	the actual piece of data.
Type	LONGTEXT
Domain
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Tables : wp_comments

Columns 15	Keys 1	Triggers 0	Comment: Description:
Indexes 5	Contraints 0

Columns :

Name	Caption	Primary Key	type
comment_ID	comment_ID	true	BIGINT(20)
comment_post_ID	comment_post_ID		BIGINT(20)
comment_author	comment_author		TINYTEXT
comment_author_email	comment_author_email		VARCHAR(100)
comment_author_url	comment_author_url		VARCHAR(200)
comment_author_IP	comment_author_IP		VARCHAR(100)
comment_date	comment_date		DATETIME
comment_date_gmt	comment_date_gmt		DATETIME
comment_content	comment_content		TEXT(65535)
comment_karma	comment_karma		INT(10)
comment_approved	comment_approved		VARCHAR(20)
comment_agent	comment_agent		VARCHAR(255)
comment_type	comment_type		VARCHAR(20)
comment_parent	comment_parent		BIGINT(20)
user_id	user_id		BIGINT(20)

Keys :

Name	Primary Key	Description
PK_wp_comments	true

Indexes

Name	UNIQUE	Type	Description
comment_post_ID		Ascending
comment_approved_date_gmt		Ascending
comment_date_gmt		Ascending
comment_parent		Ascending
comment_author_email		Ascending

Columns Detail :

Name	comment_ID
Table	wp_comments
Description	unique number assigned to each comment.
Type	BIGINT(20)
Domain
Primary Key	true
Not null	true
Identity	true

Name	comment_post_ID
Table	wp_comments
Description	ID of the post this comment relates to. (Reference to the wp_posts table.)
Type	BIGINT(20)
Domain
Not null	true
Default Value	0

Name	comment_author
Table	wp_comments
Description	Name of the comment author.
Type	TINYTEXT
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_author_email
Table	wp_comments
Description	Email of the comment author.
Type	VARCHAR(100)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_author_url
Table	wp_comments
Description	URL for the comment author.
Type	VARCHAR(200)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_author_IP
Table	wp_comments
Description	IP Address of the comment author.
Type	VARCHAR(100)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_date
Table	wp_comments
Description	Time and data the comment was posted.
Type	DATETIME
Domain
Not null	true
Default Value	'0000-00-00 00:00:00'

Name	comment_date_gmt
Table	wp_comments
Description	GMT time and data the comment was posted.
Type	DATETIME
Domain
Not null	true
Default Value	'0000-00-00 00:00:00'

Name	comment_content
Table	wp_comments
Description	the actual comment text.
Type	TEXT(65535)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_karma
Table	wp_comments
Description	unused by WordPress core, can be used by plugins to help manage comments.
Type	INT(10)
Domain
Not null	true
Default Value	0

Name	comment_approved
Table	wp_comments
Description	if the comment has been approved.
Type	VARCHAR(20)
Domain
Not null	true
Default Value	'1'
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_agent
Table	wp_comments
Description	where the comment was posted from, eg. browser, operating system etc.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_type
Table	wp_comments
Description	type of comment: comment, pingback or trackback.
Type	VARCHAR(20)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	comment_parent
Table	wp_comments
Description	refers to another comment when this comment is a reply.
Type	BIGINT(20)
Domain
Not null	true
Default Value	0

Name	user_id
Table	wp_comments
Description	ID of the comment author if they are a registered user on the site. (Reference to the wp_users table.)
Type	BIGINT(20)
Domain
Not null	true
Default Value	0

Tables : wp_links

Columns 13	Keys 1	Triggers 0	Comment: Description:
Indexes 1	Contraints 0

Columns :

Name	Caption	Primary Key	type
link_id	link_id	true	BIGINT(20)
link_url	link_url		VARCHAR(255)
link_name	link_name		VARCHAR(255)
link_image	link_image		VARCHAR(255)
link_target	link_target		VARCHAR(25)
link_description	link_description		VARCHAR(255)
link_visible	link_visible		VARCHAR(20)
link_owner	link_owner		BIGINT(20)
link_rating	link_rating		INT(10)
link_updated	link_updated		DATETIME
link_rel	link_rel		VARCHAR(255)
link_notes	link_notes		MEDIUMTEXT
link_rss	link_rss		VARCHAR(255)

Keys :

Name	Primary Key	Description
PK_wp_links	true

Indexes

Name	UNIQUE	Type	Description
link_visible		Ascending

Columns Detail :

Name	link_id
Table	wp_links
Description	unique number assigned to each row of the table.
Type	BIGINT(20)
Domain
Primary Key	true
Not null	true
Identity	true

Name	link_url
Table	wp_links
Description	URL of the link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_name
Table	wp_links
Description	name of the link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_image
Table	wp_links
Description	URL of an image related to the link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_target
Table	wp_links
Description	the target frame for the link. e.g. _blank, _top, _none.
Type	VARCHAR(25)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_description
Table	wp_links
Description	description of the link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_visible
Table	wp_links
Description	control if the link is public or private.
Type	VARCHAR(20)
Domain
Not null	true
Default Value	'Y'
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_owner
Table	wp_links
Description	ID of user who created the link. (Reference to the wp_users table.)
Type	BIGINT(20)
Domain
Not null	true
Default Value	1

Name	link_rating
Table	wp_links
Description	add a rating between 0-10 for the link.
Type	INT(10)
Domain
Not null	true
Default Value	0

Name	link_updated
Table	wp_links
Description	time and date of link update.
Type	DATETIME
Domain
Not null	true
Default Value	'0000-00-00 00:00:00'

Name	link_rel
Table	wp_links
Description	relationship of link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_notes
Table	wp_links
Description	notes about the link.
Type	MEDIUMTEXT
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Name	link_rss
Table	wp_links
Description	RSS address for the link.
Type	VARCHAR(255)
Domain
Not null	true
Collate	utf8mb4_unicode_520_ci
Charset	utf8mb4

Tables : wp_options

Columns 4	Keys 2	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
option_id	option_id	true	BIGINT(20)
option_name	option_name		VARCHAR(191)
option_value	option_value		LONGTEXT
autoload	autoload		VARCHAR(20)

Keys :

Name	Primary Key	Description
option_name
PK_wp_options	true

Columns Detail :

Name	option_id
Table	wp_options
Description	unique number assigned to each row of the table.
Type	BIGINT(20)
Domain
Primary Key	true
Not null	true
Identity	true

Tables : wp_postmeta

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 2	Contraints 0

Columns :

Name	Caption	Primary Key	type
meta_id	meta_id	true	BIGINT(20)
post_id	post_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT

Keys :

Indexes

Columns Detail :

Tables : wp_posts

Columns 23	Keys 1	Triggers 0	Comment: Description:
Indexes 4	Contraints 0

Columns :

Name	Caption	Primary Key	type
ID	ID	true	BIGINT(20)
post_author	post_author		BIGINT(20)
post_date	post_date		DATETIME
post_date_gmt	post_date_gmt		DATETIME
post_content	post_content		LONGTEXT
post_title	post_title		TEXT(65535)
post_excerpt	post_excerpt		TEXT(65535)
post_status	post_status		VARCHAR(20)
comment_status	comment_status		VARCHAR(20)
ping_status	ping_status		VARCHAR(20)
post_password	post_password		VARCHAR(255)
post_name	post_name		VARCHAR(200)
to_ping	to_ping		TEXT(65535)
pinged	pinged		TEXT(65535)
post_modified	post_modified		DATETIME
post_modified_gmt	post_modified_gmt		DATETIME
post_content_filtered	post_content_filtered		LONGTEXT
post_parent	post_parent		BIGINT(20)
guid	guid		VARCHAR(255)
menu_order	menu_order		INT(10)
post_type	post_type		VARCHAR(20)
post_mime_type	post_mime_type		VARCHAR(100)
comment_count	comment_count		BIGINT(19)

Keys :

Indexes

Columns Detail :

Tables : wp_term_relationships

Columns 3	Keys 1	Triggers 0	Comment: Description:
Indexes 1	Contraints 0

Columns :

Name	Caption	Primary Key	type
object_id	object_id	true	BIGINT(20)
term_taxonomy_id	term_taxonomy_id	true	BIGINT(20)
term_order	term_order		INT(10)

Keys :

Indexes

Columns Detail :

Tables : wp_term_taxonomy

Columns 6	Keys 2	Triggers 0	Comment: Description:
Indexes 1	Contraints 0

Columns :

Name	Caption	Primary Key	type
term_taxonomy_id	term_taxonomy_id	true	BIGINT(20)
term_id	term_id		BIGINT(20)
taxonomy	taxonomy		VARCHAR(32)
description	description		LONGTEXT
parent	parent		BIGINT(20)
count	count		BIGINT(19)

Keys :

Indexes

Columns Detail :

Tables : wp_termmeta

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 2	Contraints 0

Columns :

Name	Caption	Primary Key	type
meta_id	meta_id	true	BIGINT(20)
term_id	term_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT

Keys :

Indexes

Columns Detail :

Tables : wp_terms

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 2	Contraints 0

Columns :

Name	Caption	Primary Key	type
term_id	term_id	true	BIGINT(20)
name	name		VARCHAR(200)
slug	slug		VARCHAR(200)
term_group	term_group		BIGINT(19)

Keys :

Indexes

Columns Detail :

Tables : wp_usermeta

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 2	Contraints 0

Columns :

Name	Caption	Primary Key	type
umeta_id	umeta_id	true	BIGINT(20)
user_id	user_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT

Keys :

Indexes

Columns Detail :

Tables : wp_users

Columns 10	Keys 1	Triggers 0	Comment: Description:
Indexes 3	Contraints 0

Columns :

Name	Caption	Primary Key	type
ID	ID	true	BIGINT(20)
user_login	user_login		VARCHAR(60)
user_pass	user_pass		VARCHAR(255)
user_nicename	user_nicename		VARCHAR(50)
user_email	user_email		VARCHAR(100)
user_url	user_url		VARCHAR(100)
user_registered	user_registered		DATETIME
user_activation_key	user_activation_key		VARCHAR(255)
user_status	user_status		INT(10)
display_name	display_name		VARCHAR(250)

Keys :

Indexes

Columns Detail :

Columns

Column Name	Column Caption	Primary Key	Type
meta_id	meta_id	true	BIGINT(20)
comment_id	comment_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT
comment_ID	comment_ID	true	BIGINT(20)
comment_post_ID	comment_post_ID		BIGINT(20)
comment_author	comment_author		TINYTEXT
comment_author_email	comment_author_email		VARCHAR(100)
comment_author_url	comment_author_url		VARCHAR(200)
comment_author_IP	comment_author_IP		VARCHAR(100)
comment_date	comment_date		DATETIME
comment_date_gmt	comment_date_gmt		DATETIME
comment_content	comment_content		TEXT(65535)
comment_karma	comment_karma		INT(10)
comment_approved	comment_approved		VARCHAR(20)
comment_agent	comment_agent		VARCHAR(255)
comment_type	comment_type		VARCHAR(20)
comment_parent	comment_parent		BIGINT(20)
user_id	user_id		BIGINT(20)
link_id	link_id	true	BIGINT(20)
link_url	link_url		VARCHAR(255)
link_name	link_name		VARCHAR(255)
link_image	link_image		VARCHAR(255)
link_target	link_target		VARCHAR(25)
link_description	link_description		VARCHAR(255)
link_visible	link_visible		VARCHAR(20)
link_owner	link_owner		BIGINT(20)
link_rating	link_rating		INT(10)
link_updated	link_updated		DATETIME
link_rel	link_rel		VARCHAR(255)
link_notes	link_notes		MEDIUMTEXT
link_rss	link_rss		VARCHAR(255)
option_id	option_id	true	BIGINT(20)
option_name	option_name		VARCHAR(191)
option_value	option_value		LONGTEXT
autoload	autoload		VARCHAR(20)
meta_id	meta_id	true	BIGINT(20)
post_id	post_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT
ID	ID	true	BIGINT(20)
post_author	post_author		BIGINT(20)
post_date	post_date		DATETIME
post_date_gmt	post_date_gmt		DATETIME
post_content	post_content		LONGTEXT
post_title	post_title		TEXT(65535)
post_excerpt	post_excerpt		TEXT(65535)
post_status	post_status		VARCHAR(20)
comment_status	comment_status		VARCHAR(20)
ping_status	ping_status		VARCHAR(20)
post_password	post_password		VARCHAR(255)
post_name	post_name		VARCHAR(200)
to_ping	to_ping		TEXT(65535)
pinged	pinged		TEXT(65535)
post_modified	post_modified		DATETIME
post_modified_gmt	post_modified_gmt		DATETIME
post_content_filtered	post_content_filtered		LONGTEXT
post_parent	post_parent		BIGINT(20)
guid	guid		VARCHAR(255)
menu_order	menu_order		INT(10)
post_type	post_type		VARCHAR(20)
post_mime_type	post_mime_type		VARCHAR(100)
comment_count	comment_count		BIGINT(19)
object_id	object_id	true	BIGINT(20)
term_taxonomy_id	term_taxonomy_id	true	BIGINT(20)
term_order	term_order		INT(10)
term_taxonomy_id	term_taxonomy_id	true	BIGINT(20)
term_id	term_id		BIGINT(20)
taxonomy	taxonomy		VARCHAR(32)
description	description		LONGTEXT
parent	parent		BIGINT(20)
count	count		BIGINT(19)
meta_id	meta_id	true	BIGINT(20)
term_id	term_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT
term_id	term_id	true	BIGINT(20)
name	name		VARCHAR(200)
slug	slug		VARCHAR(200)
term_group	term_group		BIGINT(19)
umeta_id	umeta_id	true	BIGINT(20)
user_id	user_id		BIGINT(20)
meta_key	meta_key		VARCHAR(255)
meta_value	meta_value		LONGTEXT
ID	ID	true	BIGINT(20)
user_login	user_login		VARCHAR(60)
user_pass	user_pass		VARCHAR(255)
user_nicename	user_nicename		VARCHAR(50)
user_email	user_email		VARCHAR(100)
user_url	user_url		VARCHAR(100)
user_registered	user_registered		DATETIME
user_activation_key	user_activation_key		VARCHAR(255)
user_status	user_status		INT(10)
display_name	display_name		VARCHAR(250)

Project

WP Data Model

Company

softbuilder

Author

Version

Copyright

Comment

WordPress 5.0.3 database reverse engineering with tables and columns description

Description

Tables and fields description are taken from WordPress codex

Generated by

ERBuilder data modeler (Professional version)

General

WP Data Model

Tables

12

Columns

94

Triggers

0

Sequences

0

Relationships

0

Views

0

Procedures

0

Domains

0

Diagram

All Items

Tables

Tables : wp_commentmeta

Columns

4

Keys

1

Triggers

0

Comment:

Description:

Indexes

2

Contraints

0

Columns :

Keys :

Indexes

Columns Detail :

Tables : wp_comments

Columns

15

Keys

1

Triggers

0

Comment:

Description:

Indexes

5

Contraints

0

Columns :

Keys :

Indexes

Columns Detail :

Tables : wp_links

Columns

13

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0

Columns :

Keys :

Indexes

Columns Detail :

Tables : wp_options

Columns

4

Keys

2

Triggers

0

Comment: