ConfigurationFileVersion Table
The ConfigurationFileVersion table stores individual versions of configuration files used by CapStorm products. Each entry corresponds to a specific version of a file recorded in the ConfigurationFile table, including its full content and associated metadata.
The following table describes each field in the ConfigurationFileVersion table:
| Column Name | Data Type | Required | Description |
|---|---|---|---|
| id | integer | Yes | Unique identifier assigned to the record by the application. |
| configFileId | integer | Yes | The unique id of the configuration file in the ConfigurationFile table. |
| configFileVersion | varchar | Yes | The version of the record. Multiple versions of a configuration file can be stored. |
| contents | varchar | Yes | The actual file body of the configuration file. |
| notes | varchar | No | Optional notes associated with the configuration file. |
| isDeleted | boolean | Yes | True if the configuration file version is considered deleted, otherwise false. |
| createdDate | datetime | Yes | The date and time when the record was created. |
| modifiedDate | datetime | Yes | The date and time when the record was last modified. |
| lastModifiedBy | varchar | Yes | The user who last modified the record. |
| createdBy | varchar | Yes | The user who created the record. |