[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