cmdtg command target (cluster or node)
DDL script| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| RECID | NUMBER(12) | N | ||
| TARGET_TYPE | VARCHAR2(10) | N | ||
| CUSTOMER_ID | NUMBER(12) | N |
| Constraint Name | Columns |
|---|---|
| RHN_CMDTG_RECID_TARGET_TYPE_PK | RECID , TARGET_TYPE |
| Constraint Name | Check Condition |
|---|---|
| CMDTG_TARGET_TYPE_CK | target_type in ('cluster','node') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| RHN_CMDTG_CSTMR_CUSTOMER_ID_FK | CUSTOMER_ID | WEB_CUSTOMER | WEB_CUSTOMER_ID_PK | NO ACTION |
| Option | Settings |
|---|---|
| Tablespace | DATA_TBS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|---|---|---|---|
| RHN_CMDTG_CID_IDX | NORMAL | NONUNIQUE | CUSTOMER_ID | DDL script |
| RHN_CMDTG_RECID_PK | NORMAL | UNIQUE | RECID , TARGET_TYPE | DDL script |
| Table | Constraint |
|---|---|
| RHN_COMMAND_QUEUE_EXECS | RHN_CQEXE_SATCL_NSAINT_ID_FK |
| RHN_SAT_CLUSTER | RHN_SATCL_CMDTG_RECID_TAR_FK |
| RHN_SAT_NODE | RHN_SATND_CMDTG_RID_TAR_TY_FK |