Table shrdb.LAWRS.EJS_JOB_DETAILS Generated by
SchemaSpy
Legend: SourceForge.net
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
JOB_NAME nvarchar2 80
EJS_JOB_LISTENERS.JOB_NAME SYS_C0011693 R
EJS_TRIGGERS.JOB_NAME SYS_C0011695 R
JOB_GROUP nvarchar2 80
EJS_JOB_LISTENERS.JOB_GROUP SYS_C0011693 R
EJS_TRIGGERS.JOB_GROUP SYS_C0011695 R
DESCRIPTION nvarchar2 120  √  null
JOB_CLASS_NAME nvarchar2 128  √  null
IS_DURABLE number 22  √  null
IS_VOLATILE number 22  √  null
IS_STATEFUL number 22  √  null
REQUESTS_RECOVERY number 22  √  null
JOB_DATA blob 4000  √  null

Table contained 160 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
JOB_NAME + JOB_GROUP Primary key Asc/Asc SYS_C0011513

Close relationships  within of separation: