Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
SERVER_ID | NUMBER(38) | N | ||
ERRATA_ID | NUMBER(38) | Y | ||
PACKAGE_ID | NUMBER(38) | N | ||
CHANNEL_ID | NUMBER(38) | Y |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SNCP_CID_FK | CHANNEL_ID | RHNCHANNEL | RHN_CHANNEL_ID_PK | CASCADE |
RHN_SNCP_EID_FK | ERRATA_ID | RHNERRATA | RHN_ERRATA_ID_PK | CASCADE |
RHN_SNCP_PID_FK | PACKAGE_ID | RHNPACKAGE | RHN_PACKAGE_ID_PK | CASCADE |
RHN_SNCP_SID_FK | SERVER_ID | RHNSERVER | RHN_SERVER_ID_PK | CASCADE |
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_SNC_CID_IDX | NORMAL | NONUNIQUE | CHANNEL_ID | DDL script |
RHN_SNC_EID_IDX | NORMAL | NONUNIQUE | ERRATA_ID | DDL script |
RHN_SNC_PID_IDX | NORMAL | NONUNIQUE | PACKAGE_ID | DDL script |
RHN_SNC_SPEID_IDX | NORMAL | NONUNIQUE | SERVER_ID , PACKAGE_ID , ERRATA_ID | DDL script |