Forum OpenACS Improvement Proposals (TIPs): Re: TIP #42 (Proposal) Adding package_id to acs_objects

Posted by Andrew Piskorski on
It don't personally really care either way, but I'd like to see a clear explanation of using either a single package_id column in the acs_objects table (one-to-many mapping), vs. a mapping table to give a possibly many-to-many mapping.

Which is the better data model and why? And what are the precise semantics that OpenACS will ascribe to this field or mapping table? Note: Not insinuations of performance implications, which is the better and more useful model. Dirk's thread above from Oct-Nov 2003 never answered that.