Forum OpenACS Development: Re: CR Items question

Collapse
2: Re: CR Items question (response to 1)
Posted by Dave Bauer on
In general the new object subtype should refer to cr_revisions (since its a subtype of content_revision) and does not also need an excplicit item_id column. Joins won't hurt you. You are just duplicating data which can cause consistency problems.

If you want to associate an object with an item in the content repository, it is almost always correct to use the item_id to reference the item in the CR.