mthtp method types
DDL script| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| RECID | NUMBER(12) | N | ||
| METHOD_TYPE_NAME | VARCHAR2(20) | Y | ||
| NOTIFICATION_FORMAT_ID | NUMBER(12) | N | 4 |
| Constraint Name | Columns |
|---|---|
| RHN_MTHTP_RECID_PK | RECID |
| Constraint Name | Check Condition |
|---|---|
| RHN_MTHTP_RECID_CK | recid > 0 |
| 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_MTHTP_RECID_PK | NORMAL | UNIQUE | RECID | DDL script |
| Table | Constraint |
|---|---|
| RHN_CONTACT_METHODS | RHN_CMETH_METHOD_TYPE_ID_FK |