DB_SCRIPT_HISTORY |
Default Table Name | DB_SCRIPT_HISTORY |
Definition |
DB_SCRIPT_HISTORY Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SCRIPT_NAME | VARCHAR2(36) | YES | ||
SCRIPT_SUFFIX | VARCHAR2(8) | YES | ||
FILE_NAME | VARCHAR2(36) | YES | ||
APPLY_STATUS | VARCHAR2(12) | YES | ||
PATCH_NAME | VARCHAR2(36) | YES | ||
START_DTT | DATE | YES | ||
LINE_NO | NUMBER(10, 0) | YES | ||
ERR_TYPE | VARCHAR2(12) | YES | ||
ERR_TEXT | VARCHAR2(254) | YES | ||
ERR_DESC | VARCHAR2(254) | YES | ||
END_DTT | DATE | YES | ||
SCRIPT_VER_FROM | VARCHAR2(6) | YES | ||
SCRIPT_VER_TO | VARCHAR2(6) | YES | ||
SCRIPT_PROCESS | VARCHAR2(24) | YES | ||
MODIFIED_BY | VARCHAR2(20) | YES | ||
TIME_STAMP | DATE | YES | ||
ROWVERSION | NUMBER(5, 0) | YES |
DB_SCRIPT_HISTORY Primary and Unique Keys |
Key Name | Key Type | Keys |
DB_SCRIPT_HISTORY Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |