Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

QRTZ_JOB_LISTENERS

DDL script

Columns

NameTypeNullableDefault valueComment
JOB_NAMEVARCHAR2(200)N  
JOB_GROUPVARCHAR2(200)N  
JOB_LISTENERVARCHAR2(200)N  

Primary key:

Constraint NameColumns
SYS_C009261JOB_NAME , JOB_GROUP , JOB_LISTENER

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C009262JOB_NAME , JOB_GROUP QRTZ_JOB_DETAILS SYS_C009257 NO ACTION

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
SYS_C009261NORMALUNIQUEJOB_NAME , JOB_GROUP , JOB_LISTENER DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Wed Mar 4 07:58:24 2020