WordPress database Table Detailed

Table Name: wp_categories

A table to hold information about the classification. 5 fields are included, namely:

Field	Notes
cat_id	The unique ID number for each category, which is a bigint (20) value with an attached property of auto_increment.
Cat_name	The name of a category, which is a varchar (55) value.
Category_nicename	An easy-to-remember name assigned to the taxonomy, known as the Slug, is a varchar (200) value
Category_description	A detailed description of a classification, the Longtext type value.
Category_parent	The superior category of the classification, which is an int (4) value, corresponds to the cat_id in the current table, that is, wp_categories.cat_id. When there is no parent classification, this value is 0.

Table Name: wp_comments

The table used to hold the comment information. 15 fields are included, respectively:

Field	Notes
comment_id	The unique ID number for each comment, which is a bigint (20) value. Auto_increment with attached properties.
comment_post_id	The ID number of the article corresponding to each comment, an int (11) value, equivalent to Wp_posts.id.
Comment_author	The reviewer name for each comment, Tinytext value.
Comment_author_email	The reviewer email address for each comment, varchar (100) value.
Comment_author_url	The reviewer URL for each comment, varchar (200) value.
Comment_author_ip	The IP address of the reviewer for the comment, varchar (100) value.
Comment_date	The time of the publication of each comment, the datetime value (which is the value after the time zone offset).
Comment_date_gmt	The time that each comment was published, the datetime value (the standard GMT).
Comment_content	The text value of the specific content of each comment.
Comment_karma	Unknown, int (11) value, default is 0.
Comment_approved	The current status of each comment is an enumeration value of enum (' 0′, ' 1′, ' spam '), 0 for pending approval, 1 for allow release, and spam for spam comments. The default value is 1.
Comment_agent	The reviewer's client information for each comment, varchar (255) value, mainly includes information about its browser and operating system type, version, and so on.
Comment_type	Unknown, varchar (20) value.
Comment_parent	The superior comment of a comment, int (11) value, corresponds to Wp_comment.id, the default is 0, that is, no superior comment.
user_id	A comment corresponding to the user ID, only when the user registration will not be generated, int (11) value, corresponding to Wp_users.id. Unregistered user, external reviewer, the value of this ID is 0.

WordPress database Table Detailed