Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
USER_ID | NUMBER(38) | N | ||
LABEL | VARCHAR2(32) | N | ||
ELEMENT | NUMBER(38) | N | ||
ELEMENT_TWO | NUMBER(38) | Y | ||
ELEMENT_THREE | NUMBER(38) | Y |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SET_USER_FK | USER_ID | WEB_CONTACT | WEB_CONTACT_PK | CASCADE |
Constraint name | Columns |
---|---|
RHN_SET_USER_LABEL_ELEM_UNQ | USER_ID , LABEL , ELEMENT , ELEMENT_TWO , ELEMENT_THREE |
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_SET_USER_LABEL_ELEM_UNQ | NORMAL | UNIQUE | USER_ID , LABEL , ELEMENT , ELEMENT_TWO , ELEMENT_THREE | DDL script |