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