This is a simple intersect table and is required to implement the relationship that a resource can be assigned to many roles and a role can be assigned to many resources. It represents the instance of a specific resource being assigned to a specific role.
Column |
Primary Key |
Datatype |
Length |
Notes |
---|---|---|---|---|
ResourceUID ID of the resource |
Yes |
INTEGER |
4 |
Foreign key to WGN3RESOURCE |
RoleUID The ID of the role |
Yes |
INTEGER |
4 |
Foreign Key to WGN3ROLE |
Copyright © 2014 CA.
All rights reserved.
|
|