Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
ORG_ID | NUMBER(38) | N | ||
TASK_NAME | VARCHAR2(64) | N | ||
TASK_DATA | NUMBER(38) | Y | ||
PRIORITY | NUMBER(38) | Y | (0) | |
EARLIEST | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_TASK_QUEUE_ORG_ID_FK | ORG_ID | WEB_CUSTOMER | WEB_CUSTOMER_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_TASK_QUEUE_EARLIEST | NORMAL | NONUNIQUE | EARLIEST | DDL script |
RHN_TASK_QUEUE_ORG_TASK_IDX | NORMAL | NONUNIQUE | ORG_ID , TASK_NAME | DDL script |