|
Online Policy Group Online Community Forum Schema
[Revision 0.1 of February 24, 2002]
This ERD is a quick attempt to nail down some issues at both the database
and the functional (permissions) layer. Note that by no means is this
a complete representation whatsoever- many fields are glossed over,
and obviously supporting and relate tables are missing.
- Forums are composed of entities. Examples of entities
could be message boards, calendars, news listings, etc.
- Every forum has a default permission setting, which determines
what user_roles can perform what tasks.
- Every entity has a default permission setting
- Every forum and every entity can have user-specific permissions
which override the default permissions... Every user subscribed
to a forum has a user_role specific to that forum. Users also
have a global role that applies across all forums and entities
(sysadmin, superleader, etc.)
- Permissions suggested: read, write, delete.
Obviously, there are lots of open issues here, and this is just the
first stab at what hopefully will be a very dynamic and evolving
architectural document... Extreme programming methodologies will
be used very liberally :-)
Project Links
Online Community Forum Project Page
Product Comparison and Feature Analysis
Feature Specification and User Guide
top of page
|
