Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
SERVER_ID | NUMBER(38) | N | ||
LOCKER_ID | NUMBER(38) | Y | ||
REASON | VARCHAR2(4000) | Y | ||
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SERVER_LOCK_LID_FK | LOCKER_ID | WEB_CONTACT | WEB_CONTACT_PK | SET NULL |
RHN_SERVER_LOCK_SID_FK | SERVER_ID | RHNSERVER | RHN_SERVER_ID_PK | NO ACTION |
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_SERVER_LOCK_LID_UNQ | NORMAL | NONUNIQUE | LOCKER_ID | DDL script |
RHN_SERVER_LOCK_SID_UNQ | NORMAL | UNIQUE | SERVER_ID | DDL script |