Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ScreenID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each screen access record |
||||
| GroupID | int | 4 | null |
|
|
Group reference - Links to the user group (UserGroup.GroupID) |
|||||
| TabID | int | 4 | √ | null |
|
|
Tab reference - Links to the specific tab for access control |
||||
| SubTabID | int | 4 | √ | null |
|
|
Sub-tab reference - Links to the specific sub-tab for granular access control |
||||
| AccessRight | varchar | 20 | null |
|
|
Access rights - Type of access granted (Read, Write, Admin, etc.) |
|||||
| FilterBy | char | 10 | √ | null |
|
|
Filter criteria - Additional filtering criteria for data access |
||||
| AgencyID | int | 4 | √ | null |
|
|
Agency reference - Links to the agency for agency-specific access control |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_UserScreen | Primary key | Asc | ScreenID |
| IX_groupid | Performance | Asc | GroupID |
| IX_tabid | Performance | Asc | ScreenID |
Relationships
Close relationships within degrees of separation
