|
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 |