Reference
|
Post Types / Media
|
Taxonomy
|
Users
|
Comments
|
Advanced Content Type
|
---|---|---|---|---|---|
ID | t.ID | t.term_id | t.ID | t.comment_ID | t.id |
Title / Name | t.post_title | t.name | t.display_name | t.comment_date | t.name |
Relationship / File Field | related_field_name.field_name | related_field_name.field_name | related_field_name.field_name | related_field_name.field_name | related_field_name.field_name |
Relationship (Custom Simple) | related_field_name.meta_value | related_field_name.meta_value | related_field_name.meta_value | related_field_name.meta_value | t.related_field_name |
Built-in Taxonomy | taxonomy_name.field_name | N/A | N/A | N/A | N/A |
Custom Field (meta-based) | field_name.meta_value | field_name.meta_value | field_name.meta_value | field_name.meta_value | N/A |
Custom Field (table-based) | d.field_name | d.field_name | d.field_name | d.field_name | t.field_name |
“t” prefix | wp_posts table | wp_terms table | wp_users table | wp_comments table | wp_pods_podname table |
“d” prefix | wp_pods_podname table | wp_pods_podname table | wp_pods_podname table | wp_pods_podname table | N/A |
“tt” prefix | N/A | wp_term_taxonomy table | N/A | N/A | N/A |
“meta_value” affix | wp_postmeta table | wp_termmeta table | wp_usermeta table | wp_commentmeta table | N/A |