El siguiente articulo es una descripci贸n general de las tablas que WordPress 5.7.2 genera durante una instalaci贸n normal en la base de datos. Actualmente la unica base de datos soportada por WordPress Versi贸n 5.7.2 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 |
Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
