ConfigurationFileVersion

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.