El siguiente articulo es una descripción general de las tablas que WordPress 6.7.1 genera durante una instalación normal en la base de datos. Actualmente la unica base de datos soportada por WordPress Versión 6.7.1 es MySQL version 4.0 o mayor.
Puedes ademas leer:
Debido a que WordPress interactua con la base de datos por si mismo, tu como usuario no debes preocuparte demasiado acerca de su estructura. Si estas Creando un Plugin te sera interesante aprender como interactuar con la base de datos. WordPress provee la clase wpdb para hacer esto fácil.
Esta sección es una vista en general de todas las tablas creadas durante la instalación de WordPress. Es seguida por información especifica de lo que hay en cada tabla.
| Tablas de WordPress 2.5(10) | ||
| Nombre de la Tabla | Descripción | Áreas relevantes de la Interface al Usuario |
| wp_comments | Los comentarios en WordPress se mantienen aquí | Los comentarios son creados por lectores y autores como respuestas a entradas en el blog. Son administrados a través de Administration Panels >> Manage >> Comments |
| wp_links | Información relacionada con las ligas ingresadas al Blogroll Manager de WordPress. | Administration Panels >> Blogroll >> Manage Blogroll Administration Panels >> Blogroll >> Add Links Administration Panels >> Blogroll >> Import Links |
| wp_options | Las Opciones configuradas en Administration > Options se mantienen aquí. | Administration Panels >> Options > > General Administration Panels >> Options > >Writing Administration Panels >> Options > >Reading Administration Panels >> Options > >Discussion Administration Panels >> Options > >Permalinks Administration Panels >> Options > >Miscellaneous |
| wp_postmeta | Los metadatos de cada entrada en el blog se mantienen aqui. Algunos plugins de etiquetas (tags) y otros pueden agregar su propia información a esta tabla. | Administration Panels >> Write >> Write a Post |
| wp_posts | La información principal de WordPress son las entradas (posts), que son guardados en esta tabla. | Administration Panels >> Write >> Write a Post |
| wp_terms | Las categorías de las entradas y las ligas se mantienen aquí. | Administration Panels >> Manage >> Categories Administration Panels >> Write >> Write Post Administration Panels >> Manage >> Posts >> Edit |
| wp_term_relationships | Asociaciones de las entradas con categorías y etiquetas de la tabla wp_terms, junto con asociaciones de ligas con sus respectivas categorías. | Administration Panels >> Manage >> Categories Administration Panels >> Write >> Write Post Administration Panels >> Manage >> Posts >> Edit |
| wp_term_taxonomy | Contiene descripciones de la taxonomia(categoria, liga, o etiqueta) para los datos mantenidos en la tabla wp_terms. | Administration Panels >> Manage >> Categories Administration Panels >> Write >> Write Post Administration Panels >> Manage >> Posts >> Edit |
| wp_usermeta | Cada usuario tiene sus propios metadatos, que se guardan en esta tabla. | Administration Panels >> Users |
| wp_users | La lista de usuarios se mantiene aqui. | Administration Panels >> Users |
La siguiente información son los campos específicos en cada de las tablas creadas durante una instalación normal de WordPress
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| comment_ID | bigint(20) unsigned | PRI | NULL | auto_increment | |
| comment_post_ID | int(11) | IND | 0 | FK->wp_posts.ID | |
| comment_author | tinytext | ||||
| comment_author_email | varchar(100) | ||||
| comment_author_url | varchar(200) | ||||
| comment_author_IP | varchar(100) | ||||
| comment_date | datetime | 0000-00-00 00:00:00 | |||
| comment_date_gmt | datetime | IND & IND Pt2 | 0000-00-00 00:00:00 | ||
| comment_content | text | ||||
| comment_karma | int(11) | 0 | |||
| comment_approved | varchar(20) | IND & Ind Pt1 | 1 | ||
| comment_agent | varchar(255) | ||||
| comment_type | varchar(20) | ||||
| comment_parent | bigint(20) | 0 | FK->wp_comment.ID | ||
| user_id | bigint(20) | 0 | FK->wp_users.ID |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 1 | comment_ID |
| comment_approved | INDEX | None | comment_approved |
| comment_post_ID | INDEX | None | comment_post_ID |
| comment_approved_date_gmt | INDEX | None | comment_approved comment_date_gmt |
| comment_date_gmt | INDEX | None | comment_date_gmt |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| link_id | bigint(20) | PRI | NULL | auto_increment | |
| link_url | varchar(255) | ||||
| link_name | varchar(255) | ||||
| link_image | varchar(255) | ||||
| link_target | varchar(25) | ||||
| link_category | bigint(20) | IND | 0 | ||
| link_description | varchar(255) | ||||
| link_visible | varchar(20) | IND | Y | ||
| link_owner | int(11) | 1 | |||
| link_rating | int(11) | 0 | |||
| link_updated | datetime | 0000-00-00 00:00:00 | |||
| link_rel | varchar(255) | ||||
| link_notes | mediumtext | ||||
| link_rss | varchar(255) |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 7 | link_ID |
| link_category | INDEX | None | link_category |
| link_visible | INDEX | None | link_visible |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| option_id | bigint(20) | PRI Pt1 | NULL | auto_increment | |
| blog_id | int(11) | PRI Pt2 | 0 | ||
| option_name | varchar(64) | PRI Pt3 & IND | |||
| option_value | longtext | ||||
| autoload | varchar(20) | yes |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 90 | option_id blog_id option_name |
| option_name | INDEX | None | option_name |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| meta_id | bigint(20) | PRI | NULL | auto_increment | |
| post_id | bigint(20) | IND | 0 | FK->wp_posts.ID | |
| meta_key | varchar(255) | YES | IND | NULL | |
| meta_value | longtext | YES | NULL |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 0 | meta_ID |
| post_id | INDEX | None | post_id |
| meta_key | INDEX | None | meta_key |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| ID | bigint(20) unsigned | PRI & IND Pt4 | auto_increment | ||
| post_author | bigint(20) | 0 | FK->wp_users.ID | ||
| post_date | datetime | IND Pt3 | 0000-00-00 00:00:00 | ||
| post_date_gmt | datetime | 0000-00-00 00:00:00 | |||
| post_content | longtext | ||||
| post_title | text | ||||
| post_category | int(4) | 0 | |||
| post_excerpt | text | ||||
| post_status | varchar(20) | IND PT2 | publish | ||
| comment_status | varchar(20) | open | |||
| ping_status | varchar(20) | open | |||
| post_password | varchar(20) | ||||
| post_name | varchar(200) | IND | |||
| to_ping | text | ||||
| pinged | text | ||||
| post_modified | datetime | 0000-00-00 00:00:00 | |||
| post_modified_gmt | datetime | 0000-00-00 00:00:00 | |||
| post_content_filtered | text | ||||
| post_parent | bigint(20) | 0 | FK->wp_posts.ID | ||
| guid | varchar(255) | ||||
| menu_order | int(11) | 0 | |||
| post_type | varchar(20) | IND Pt1 | post | ||
| post_mime_type | varchar(100) | ||||
| comment_count | bigint(20) | 0 |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 2 | ID |
| post_name | INDEX | None | post_name |
| type_status_date | INDEX | None | post_type post_status post_date ID |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| term_id | bigint(20) | PRI | auto_increment | ||
| name | varchar(55) | ||||
| slug | varchar(200) | UNI | |||
| term_group | bigint(10) | 0 |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 2 | term_ID |
| slug | UNIQUE | 2 | slug |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| object_id | bigint(20) | PRI Pt1 | 0 | ||
| term_taxonomy_id | bigint(20) | PRI Pt2 & IND | 0 | FK->wp_term_taxonomy.term_taxonomy_id | |
| term_order | int(11) | 0 |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 8 | object_id term_taxonomy_id |
| term_taxonomy_id | INDEX | None | term_taxonomy_id |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| term_taxonomy_id | bigint(20) | PRI | auto_increment | ||
| term_id | bigint(20) | UNI Pt1 | 0 | FK->wp_terms.term_id | |
| taxonomy | varchar(32) | UNI Pt2 | |||
| description | longtext | ||||
| parent | bigint(20) | 0 | |||
| count | bigint(20) | 0 |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 2 | term_taxonomy_id |
| term_id_taxonomy | UNIQUE | 2 | term_id taxonomy |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| umeta_id | bigint(20) | PRI | NULL | auto_increment | |
| user_id | bigint(20) | '0' | FK->wp_users.ID | ||
| meta_key | varchar(255) | Yes | IND | NULL | |
| meta_value | longtext | Yes | IND | NULL |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 4 | umeta_id |
| user_id | INDEX | None | user_id |
| meta_key | INDEX | None | meta_key |
| Campo | Tipo | Null | Llave | Valor Predeterminado | Extra |
|---|---|---|---|---|---|
| ID | bigint(20) unsigned | PRI | NULL | auto_increment | |
| user_login | varchar(60) | IND | |||
| user_pass | varchar(64) | ||||
| user_nicename | varchar(50) | IND | |||
| user_email | varchar(100) | ||||
| user_url | varchar(100) | ||||
| user_registered | datetime | 0000-00-00 00:00:00 | |||
| user_activation_key | varchar(60) | ||||
| user_status | int(11) | 0 | |||
| display_name | varchar(250) |
| Keyname | Tipo | Cardinalidad | Campo |
|---|---|---|---|
| PRIMARY | PRIMARY | 1 | ID |
| user_login_key | INDEX | None | user_login |
| user_nicename | INDEX | None | user_nicename |