PPM_HOTFIX_LIST
This table stores the hotfixes deployment information.
Foreign Keys
This table does not have foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
HOTFIX_ID |
NOT NULL |
NUMBER |
System-generated identifier |
HOTFIX_NAME |
NOT NULL |
VARCHAR2(100 CHAR) |
Hotfix name |
STATUS |
NOT NULL |
VARCHAR2(10 CHAR) |
Hotfix status: deployed, undeployed, or failed |
MACHINE_NAME |
NULLABLE |
VARCHAR2(240 CHAR) |
The name of machine where the hotfix is deployed |
CREATION_ DATE |
NOT NULL |
DATE |
Date when the record was created |
LAST_ UPDATE_ DATE |
NULLABLE |
DATE |
Date when the record was last updated |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
PPM_HOTFIX_LIST_PK |
UNIQUE |
1 |
HOTFIX_ID |
PPM_HOTFIX_LIST_N1 |
NONUNIQUE |
1 |
HOTFIX_NAME |
PPM_HOTFIX_LIST_N2 |
NONUNIQUE |
1 |
MACHINE_NAME |
Sequences
Sequence Name |
Sequence Type |
---|---|
PPM_HOTFIX_LIST_S |
HOTFIX_ID |