Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
SERVER_ID | NUMBER(38) | N | ||
ACTION_ID | NUMBER(38) | N | ||
NAME_ID | NUMBER(38) | N | ||
EVR_ID | NUMBER(38) | N | ||
CAPABILITY_ID | NUMBER(38) | N | ||
FLAGS | NUMBER(38) | N | ||
SUGGESTED | NUMBER(38) | Y | ||
SENSE | NUMBER(38) | N |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_APR_FAILURE_AID_FK | ACTION_ID | RHNACTION | RHN_ACTION_PK | CASCADE |
RHN_APR_FAILURE_CAPID_FK | CAPABILITY_ID | RHNPACKAGECAPABILITY | RHN_PKG_CAPABILITY_ID_PK | NO ACTION |
RHN_APR_FAILURE_EID_FK | EVR_ID | RHNPACKAGEEVR | RHN_PE_ID_PK | NO ACTION |
RHN_APR_FAILURE_NID_FK | NAME_ID | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
RHN_APR_FAILURE_SID_FK | SERVER_ID | RHNSERVER | RHN_SERVER_ID_PK | NO ACTION |
RHN_APR_FAILURE_SUGGESTED_FK | SUGGESTED | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
Option | Settings |
---|---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns | DDL script |
---|---|---|---|---|
RHN_APR_FAILURE_AID_SID_IDX | NORMAL | NONUNIQUE | ACTION_ID , SERVER_ID | DDL script |
RHN_APR_FAILURE_SID_IDX | NORMAL | NONUNIQUE | SERVER_ID | DDL script |