COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS
SEQ_NUMBER NUMBER(6,0) Yes null 1 Sequence number of release
PATCH_TYPE VARCHAR2(2 BYTE) Yes null 2 Type of patch
PATCH_NUMBER NUMBER(5,0) Yes null 3 Number of the patch
SCRIPT_NAME VARCHAR2(200 BYTE) Yes null 4 Script name
CREATED_BY VARCHAR2(50 BYTE) Yes null 5 Author of the patch
CREATE_DATE DATE Yes null 6 Date of ceration of the patch
APPLIED_BY VARCHAR2(50 BYTE) Yes null 7 Applied by Oracle user
APPLY_DATE DATE Yes null 8 Date of apply
DESCRIPTION VARCHAR2(2000 BYTE) Yes null 9 Description of the patch