SecurableItems


Description

Securable item definitions defining items that can be secured through the access control system. This lookup table manages securable items including names and descriptions for objects that can have security permissions applied, supporting comprehensive access control, permission management, and security administration for healthcare system components and data elements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkSecurableID int identity 4 √ null
Categories.fkSecurableID FK_Categories_SecurableItems R
QlOptionSecurity.fkSecurableID FK_QlOptionSecurity_SecurableItems R
Security.fkSecurable1ID FK_Security_SecurableItems R
Security.fkSecurable2ID FK_Security_SecurableItems1 R

Primary key - Unique identifier for each securable item
SecurableName varchar 20 null

Securable name - Name of the item that can be secured (e.g., ‘Reports’, ‘Forms’, ‘Patients’)
SecurableDesc varchar 200 √ null

Securable description - Detailed description of the securable item and its security implications

Indexes

Constraint Name Type Sort Column(s)
PK_SecurableItems Primary key Asc pkSecurableID

Relationships

Close relationships within degrees of separation