Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
ID | NUMBER(38) | N | ||
ACTION_ID | NUMBER(38) | N | ||
PARAMETER | VARCHAR2(128) | N | ('upgrade') | |
NAME_ID | NUMBER(38) | N | ||
EVR_ID | NUMBER(38) | Y | ||
PACKAGE_ARCH_ID | NUMBER(38) | Y |
Constraint Name | Columns |
---|---|
RHN_ACT_P_ID_PK | ID |
Constraint Name | Check Condition |
---|---|
RHN_ACT_P_PARAM_CK | parameter IN ('upgrade', 'install', 'remove', 'downgrade') |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_ACT_P_ACT_FK | ACTION_ID | RHNACTION | RHN_ACTION_PK | CASCADE |
RHN_ACT_P_EVR_FK | EVR_ID | RHNPACKAGEEVR | RHN_PE_ID_PK | NO ACTION |
RHN_ACT_P_NAME_FK | NAME_ID | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
RHN_ACT_P_PAID_FK | PACKAGE_ARCH_ID | RHNPACKAGEARCH | RHN_PARCH_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_ACT_P_AID_IDX | NORMAL | NONUNIQUE | ACTION_ID | DDL script |
RHN_ACT_P_ID_PK | NORMAL | UNIQUE | ID | DDL script |
Table | Constraint |
---|---|
RHNACTIONPACKAGEANSWERFILE | RHN_ACT_P_AF_APID_FK |
RHNSERVERACTIONPACKAGERESULT | RHN_SAP_RESULT_APID_FK |