Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
CHANNEL_ID | NUMBER(38) | N | ||
NAME_ID | NUMBER(38) | N | ||
EVR_ID | NUMBER(38) | N | ||
PACKAGE_ARCH_ID | NUMBER(38) | N | ||
PACKAGE_ID | NUMBER(38) | N |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_CNP_CID_FK | CHANNEL_ID | RHNCHANNEL | RHN_CHANNEL_ID_PK | CASCADE |
RHN_CNP_EID_FK | EVR_ID | RHNPACKAGEEVR | RHN_PE_ID_PK | NO ACTION |
RHN_CNP_NID_FK | NAME_ID | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
RHN_CNP_PAID_FK | PACKAGE_ARCH_ID | RHNPACKAGEARCH | RHN_PARCH_ID_PK | NO ACTION |
RHN_CNP_PID_FK | PACKAGE_ID | RHNPACKAGE | RHN_PACKAGE_ID_PK | CASCADE |
Constraint name | Columns |
---|---|
RHN_CNP_CID_NID_UQ | CHANNEL_ID , NAME_ID , PACKAGE_ARCH_ID |
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_CNP_CID_NID_UQ | NORMAL | UNIQUE | CHANNEL_ID , NAME_ID , PACKAGE_ARCH_ID | DDL script |
RHN_CNP_PID_IDX | NORMAL | NONUNIQUE | PACKAGE_ID | DDL script |