CapStormPlatformDatabase

CapStormPlatformDatabase Table

The CapStormPlatformDatabase table stores metadata and connection information for databases registered with the application. Each record represents a distinct database environment, including its type, intended usage, and configuration details.

The following table describes each field in the CapStormPlatformDatabase table:

Column Name	Data Type	Required	Description
name	varchar	Yes	A unique name for the record describing the database.
databaseName	varchar	Yes	The name of the database in the database server.
description	varchar	Yes	A description of the database configured.
preventDeletion	boolean	Yes	True if the database can be deleted by the application, otherwise false.
databaseType	varchar	Yes	The type of database being used. Acceptable values include: ‘PostgreSQL’, ‘Oracle’, ‘MySQL’, ‘SQLServer’
databaseUsage	varchar	Yes	How the database is utilized, i.e. CopyStorm, Tracker
connectionModel	varchar	Yes	The XML formatted connection information for the target database.
iscustom	boolean	Yes	True if the database was created outside of the application, otherwise false.
createdDate	datetime	Yes	The date and time when the record was created in the database.
modifiedDate	datetime	Yes	The date and time when the record was last modified in the database.
lastModifiedBy	varchar	Yes	The user who last modified the record in the database.
createdBy	varchar	Yes	The user who created the record in the database.