The UserRoles table (Table 5.9) defines user security roles used by secures applications. This table isn’t related to any of the other tables.
|Column||Data Type||Description and Size|
|UserRoleID||Numeric||Unique ID of user roles; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)|
|UserRoleName||Text||User role name (title)|
|UserRoleFunction||Text||User role description|
The primary key for this table is the UserRoleID column.
This table contains no foreign keys.