Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkSecurityID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each security permission record |
||||
| fkActivityCategoryID | int | 4 | null |
|
|
Activity category reference - Links to ActivityCategory for the secured category |
|||||
| IDtypeID | int | 4 | √ | null |
|
|
ID type - Type of identifier (1=User, 2=Group) for permission assignment |
||||
| IDValue | int | 4 | null |
|
|
ID value - User ID or Group ID that receives the permissions |
|||||
| ViewSecurity | varchar | 15 | √ | null |
|
|
View permission - Permission level for viewing activities in this category |
||||
| ViewSummaryInfo | bit | 1 | √ | null |
|
|
View summary flag - Boolean indicating if user can view summary information |
||||
| CreateNew | bit | 1 | √ | null |
|
|
Create permission - Boolean indicating if user can create new activities in this category |
||||
| EditSecurity | varchar | 15 | √ | null |
|
|
Edit permission - Permission level for editing activities in this category |
||||
| EditStatus | bit | 1 | √ | null |
|
|
Edit status flag - Boolean indicating if user can edit activity status |
||||
| DeleteSecurity | varchar | 15 | √ | null |
|
|
Delete permission - Permission level for deleting activities in this category |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ActivityCategorySecurity | Primary key | Asc | pkSecurityID |
Relationships
Close relationships within degrees of separation
