|
|
|
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 © 2011 CA. All rights reserved. | Email CA Technologies about this topic |