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