At 10:17 AM 6/28/00 -0400, you wrote:
>Are these the correct relationships for the base Turbine db;
>
>ROLEPERMISSION.PERMISSIONID -|-------o-< PERMISSION.PERMISSIONID
>ROLEPERMISSION.ROLEID -|-------o-< USERROLE.ROLEID
>VISITORROLE.ROLEID -|----------o-< USERROLE.ROLEID
>VISITORROLE.VISITORID -|----------o-< VISITOR.VISITORID
>
No.
You have these relationships exactly backwards.
You have written that...
* each RolePermission is associated with 0 or more Permissions
* each Permission is associated with exactly one RolePermission
* each RolePermission is associated with 0 or more UserRoles
* each UserRole is associated with exactly one RolePermission
* each VisitorRole is associated with 0 or more UserRoles
* each UserRole is associated with exactly one VisitorRole
* each VisitorRole is associated with 0 or more Visitors
* each Visitor is associated with exactly one VisitorRole
It should be the other way around.
ROLEPERMISSION.PERMISSIONID >o-------|- PERMISSION.PERMISSIONID
ROLEPERMISSION.ROLEID >o-------|- USERROLE.ROLEID
VISITORROLE.ROLEID >o----------|- USERROLE.ROLEID
VISITORROLE.VISITORID >o----------|- VISITOR.VISITORID
* each RolePermission is associated with exactly one Permission
* each Permission is associated with 0 or more RolePermissions
* each RolePermission is associated with exactly one UserRole
* each UserRole is associated with 0 or more RolePermissions
* each VisitorRole is associated with exactly one UserRole
* each UserRole is associated with 0 or more VisitorRoles
* each VisitorRole is associated with exactly one Visitor
* each Visitor is associated with 0 or more VisitorRoles
RolePermission and VisitorRole are really associative entities
implementing a logical many-to-many relationship between
Permissions, UserRoles, and Visitors.
PERMISSION >o-----------o< USERROLE
USERROLE >o-----------o< VISITOR
In other words,
* each Visitor may play many UserRoles
* each UserRole is granted many Permissions
Stephen
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
