Also, with table inheritance: (oracle)
create table glossaries ( glossary_id constraint glossaries_glossary_id_fk references cr_revisions on delete cascade constraint glossaries_glossary_id_pk primary key, owner_id constraint glossaries_owner_id_fk references parties, package_id constraint glossaries_package_id_fk references apm_packages, workflow_key constraint glossaries_workflow_key_fk references wf_workflows );The owner_id is inherited by parties from acs_object, do I put the constraint-subquery inline? as a trigger proc? as a normal proc? or should parties have duplicated the owner_id (ugly)? Which is best performance wise and which is the standard for OpenACS (I couldn't find a sample of this type of action).