Database version log
The database version log table holds a list of all patches which have been applied to the database. Every patch which is run will add a new row to the table. It can be useful to check on which version the database schema is on.
Database table TIDMA_DB_VERSION_LOG
| DB attribute | Java data type (max. size), defaults | Description |
|---|---|---|
| db_version_log_id | Long, not NULL | Primary key (uniquely identifies each in |
| install_end_dat | date, nullable | The date when the run of the patch was finished. |
| install_start_dat | date, not NULL | The date when the patch was started. |
| install_type | string(16), not NULL | "created" if the database was created and "patch" for applied patches. |
| version | String(32), not NULL | Version number of the applied patch. |