EcmSettings Table

EcmSettings stores operator-specific settings for the Compliance portal.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `EcmSettings` table
Database Column	Details
`EcmSettingID`	Type: integer. Key. Generated ID A unique identifier for the record.
`ComplianceOperatorID`	Type: integer. Key An operator of the Compliance portal. Foreign key to the `ComplianceOperator` table.
`SettingKey`	Type: text (max 512 characters). Key A resource describing the operator setting.
`SettingType`	Type: text (max 512 characters) The data type of the operator setting.
`SettingValueString`	Type: text Serialized value of the operator setting.
`LastUpdated`	Type: datetime Date and time when this setting was last updated.