Forum OpenACS Q&A: oacs core data model

Collapse
1: oacs core data model
Posted by David Kuczek on 05/19/04 08:38 AM
I already posted a similar question some time ago:

https://openacs.org/forums/message-view?message_id=171517

and found out about the following OACS kernel scheme:

https://openacs.org/doc/openacs-HEAD/simulation/internals.html

So we basicall have:

## Objects
acs_objects

## Content Repository
cr_items, cr_item_rels, cr_revisions

## Users
users, parties, persons, groups

## Workflow
workflows, workflow_rows, workflow_actions, workflow_cases, wokflow_case_enabled_actions, workflow_case_role_party_map, wokflow_case_log, workflow_case_data

Any other major table groups within the core? What about categories?

Thanks

Collapse
2: Re: oacs core data model (response to 1)
Posted by Jeff Davis on 05/19/04 09:27 AM
I would think you would want to include acs_object_types, acs_attributes, acs_privileges, acs_rels (and maybe the associated group tables like membership_rels etc), site_nodes, and maybe some of the apm tables within a diagram of the core datamodel.

In CR, cr_child_rels is important (and a lot of the other tables like cr_folders and cr_templates are worth covering).

Collapse
3: Re: oacs core data model (response to 1)
Posted by Alfred Werner on 05/19/04 02:59 PM
acs_datatypes ..