Previous Topic: Wgn3ResourceNext Topic: Wgn3ResourceType


Wgn3ResourceRole

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