ComplianceSetting Table

The ComplianceSetting table holds the settings for the configuration and business rules of the application. With the introduction of SettingName, ComplianceTenantSetting and OperatorTenantSetting tables, if new global setting is to be added to ComplianceSetting table, the ComplianceSettingID must not overlap with those defined in SettingName table.

Table 1. Database columns for ComplianceSetting table

Database Column

Details

ComplianceSettingID

Type: integer. Key. Generated ID

A unique identifier for a setting.

SettingName

Type: text (max 128 characters). Key

A primary key for the setting.

SettingValue

Type: text (max 512 characters)

The setting that indicates specified behavior.