FormSecurity


Description

Form security and access control managing user permissions, role-based access, and signature requirements for form access and modification. This table defines granular security settings for forms including view permissions, edit permissions, signature requirements, and role-based access control, supporting secure form workflows, compliance requirements, and audit trails for healthcare documentation and data protection.

Columns

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

Primary key - Unique identifier for each form security configuration record
FormDesignId int 4 null

Form design reference - Links to the specific form design for which security settings are configured
SignatureTypeId int 4 null

Signature type reference - Links to signature type requirements for form completion and validation
GroupId int 4 null

Group reference - Links to user group for group-based access control and permissions
AllActions bit 1 √ null

All actions permission - Boolean flag granting full access to all form actions and operations
ViewForm bit 1 √ null

View permission - Boolean flag allowing users to view and read form content
ViewEditForm bit 1 √ null

Edit permission - Boolean flag allowing users to modify and update form content
CreatedDate datetime 16,3 √ null

Creation timestamp - Date and time when security configuration was created
CreatedBy int 4 √ null

Creator reference - Links to AccessUser table for the user who created this security configuration
ModifiedDate datetime 16,3 √ null

Modification timestamp - Date and time when security configuration was last modified
ModifiedBy int 4 √ null

Modifier reference - Links to AccessUser table for the user who last modified this security configuration
DeletedDate datetime 16,3 √ null

Deletion timestamp - Date and time when security configuration was marked as deleted for audit trail
DeletedBy int 4 √ null

Deletion user reference - Links to AccessUser table for the user who deleted this security configuration
RoleId uniqueidentifier 16 √ null

Role reference - Links to role-based access control system for permission inheritance
FormSignatureId int 4 √ null

Form signature reference - Links to specific signature requirements for this form security configuration

Indexes

Constraint Name Type Sort Column(s)
PK_FormSecurity Primary key Asc Id

Relationships

Close relationships within degrees of separation