Table slot9.WORLD.TSTA.EJS_JOB_QUEUES
Legacy table. This table is not currently used
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
EJS_QUEUE_ID number 38
PROGRAM_NAME varchar2 4000
START_TIME date 7
REPEAT_EVERY number 5  √  null
TIMING varchar2 1  √  null
JOB_TITLE varchar2 255  √  null
JOB_NUMBER number 38  √  null
FAILURES number 38  √  null
BROKEN varchar2 1  √  null
SYSTEM_JOB varchar2 1  √  null
LAST_RUN_TIME date 7  √  null
NEXT_RUN_TIME date 7  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EJS_QUEUE_ID" IS NOT NULL EJQ_EJS_QUEUE_ID_NN
"PROGRAM_NAME" IS NOT NULL EJQ_PROGRAM_NAME_NN
"START_TIME" IS NOT NULL EJQ_START_TIME_NN

Indexes:
Column(s) Type Sort Constraint Name
EJS_QUEUE_ID Primary key Asc EJQ_PK