Security


Description

Security permission assignments managing access control relationships between securable items and security principals. This table implements the core security model by linking securable items to users, groups, or roles with assignment tracking, criteria display options, and ordering controls to support comprehensive access control and permission management for healthcare system security.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkSecurityID int identity 4 √ null

Primary key - Unique identifier for each security permission assignment
fkSecurable1ID int 4 null
SecurableItems.pkSecurableID FK_Security_SecurableItems R

Primary securable reference - Links to SecurableItems table for the first securable item in the relationship
Securable1ID int 4 null

Primary securable ID - Identifier value for the first securable item
fkSecurable2ID int 4 null
SecurableItems.pkSecurableID FK_Security_SecurableItems1 R

Secondary securable reference - Links to SecurableItems table for the second securable item in the relationship
Securable2ID int 4 null

Secondary securable ID - Identifier value for the second securable item
DateAssigned smalldatetime 16 (getdate())

Assignment date - Date when the security permission was assigned
AssignedBy int 4 √ null

Assigned by user - UserID of the person who assigned the security permission
showCriteria bit 1 √ null

Show criteria flag - Boolean indicating whether to display criteria for this security assignment
itemOrder int 4 √ null

Item order - Numeric order for displaying security items in user interfaces

Indexes

Constraint Name Type Sort Column(s)
PK_Security Primary key Asc pkSecurityID

Relationships

Close relationships within degrees of separation