DB_Version, 187 (ver5.0.0)
This table maintains the database-specific version information. Used primarily for database schema migration purposes.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CreatedBy | 5.0.0 | Varchar(32) | Name of the User who inserted this string. |
CreatedDT | 5.0.0 | Date | Date of the implementation of this DB version. |
ID | 5.0.0 | Number(10,0) | A unique sequential number generated by the application. |
MajorVersion | 5.0.0 | Varchar(4) | Major version value, such as 4, 5, etc.. |
MinorVersion | 5.0.0 | Varchar(12) | Major version value, such as 2.1.2, 2.1.3, etc.. |
Version | 5.0.0 | Varchar16) | Unique version string specifying the database version, such as 4.2.1.3. |