PPM_HOTFIX_FILE_LIST

This table stores the hotfix file information.

Foreign Keys

This table does not have foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

HOTFIX_FILE_ID

NOT NULL

NUMBER

System-generated identifier

HOTFIX_ID

NOT NULL

NUMBER

Hotfix ID

FILE_PATH

NOT NULL

VARCHAR2(512 CHAR)

Path of the hotfix file

FILE_TYPE

NULLABLE

VARCHAR2(20 CHAR)

Hotfix file type: fs_war, fs_home, or fs_multiserv

FILE_SIZE

NULLABLE

NUMBER

The size of the hotfix file

FILE_LASTMODIFIED

NULLABLE

DATE

Date when the hotfix file was last modified

CREATION_ DATE

NOT NULL

DATE

Date when the record was created

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_HOTFIX_FILE_LIST_PK

UNIQUE

1

HOTFIX_FILE_ID

PPM_HOTFIX_FILE_LIST_N1

NONUNIQUE

1

HOTFIX_ID

PPM_HOTFIX_FILE_LIST_N2

NONUNIQUE

1

FILE_PATH

Sequences

Sequence Name

Sequence Type

PPM_HOTFIX_FILE_LIST_S

HOTFIX_FILE_ID