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