[wp-trac] [WordPress Trac] #14513: Time for a wp_post_relationships table?

WordPress Trac wp-trac at lists.automattic.com
Sat Mar 12 02:03:44 UTC 2011


#14513: Time for a wp_post_relationships table?
-----------------------------+-----------------------------
 Reporter:  mikeschinkel     |       Owner:
     Type:  feature request  |      Status:  reopened
 Priority:  normal           |   Milestone:  Future Release
Component:  Post Types       |     Version:  3.0.1
 Severity:  normal           |  Resolution:
 Keywords:                   |
-----------------------------+-----------------------------

Comment (by cogmios):

 FYI: The discussion reminds me of the Siebel S_PARTY model which uses
 S_PARTY, S_PARTY_REL and S_PARTY_PER for this. (the last two for the many
 to many relations e.g. from households to companies to contacts)

 Maybe also handy to know that in Siebel each record holds a unique key
 over all tables.
 And that this model has proven to work for most of the largest
 corporations.

 many google links e.g. how they moved from the old model to the party
 model:
 http://download.oracle.com/docs/cd/B40099_02/books/ConfigApps/ConfigApps_TablesColumns15.html#wp1072693

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14513#comment:70>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list