[wp-trac] Re: [WordPress Trac] #4189: Taxonomy Schema and API

[WordPress Trac]

#4189: Taxonomy Schema and API
-------------------------------------------+--------------------------------
 Reporter:  ryan                           |        Owner:  anonymous
     Type:  defect                         |       Status:  new      
 Priority:  normal                         |    Milestone:  2.3      
Component:  General                        |      Version:  2.2      
 Severity:  normal                         |   Resolution:           
 Keywords:  term taxonomy tags categories  |  
-------------------------------------------+--------------------------------
Comment (by jhodgdon):

 Well, the schema is one reason why I was confused: as discussed in the
 hackers list, if the relationships table is storing all relationships
 between posts and term-taxonomy pairings, and also between links and term-
 taxonomy, then you cannot use object ID as the primary key. Two reasons,
 unless again I am not understanding things correctly:

 1) You might have a link with ID=3 as well as a post with ID=3.

 2) I think you will also make one relationship entry for each tag and for
 each category, right? So for your example on post 3, you will end up with
 6 entries all having ID=3.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4189#comment:8>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software