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_TRIGGERS

DDL script

Columns

NameTypeNullableDefault valueComment
TRIGGER_NAMEVARCHAR2(200)N  
TRIGGER_GROUPVARCHAR2(200)N  
JOB_NAMEVARCHAR2(200)N  
JOB_GROUPVARCHAR2(200)N  
IS_VOLATILEVARCHAR2(1)N  
DESCRIPTIONVARCHAR2(250)Y  
NEXT_FIRE_TIMENUMBER(13)Y  
PREV_FIRE_TIMENUMBER(13)Y  
PRIORITYNUMBER(13)Y  
TRIGGER_STATEVARCHAR2(16)N  
TRIGGER_TYPEVARCHAR2(8)N  
START_TIMENUMBER(13)N  
END_TIMENUMBER(13)Y  
CALENDAR_NAMEVARCHAR2(200)Y  
MISFIRE_INSTRNUMBER(2)Y  
JOB_DATABLOBY  

Primary key:

Constraint NameColumns
SYS_C009271TRIGGER_NAME , TRIGGER_GROUP

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C009272JOB_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
IDX_QRTZ_T_NEXT_FIRE_TIMENORMALNONUNIQUENEXT_FIRE_TIME DDL script
IDX_QRTZ_T_NFT_STNORMALNONUNIQUENEXT_FIRE_TIME , TRIGGER_STATE DDL script
IDX_QRTZ_T_STATENORMALNONUNIQUETRIGGER_STATE DDL script
IDX_QRTZ_T_VOLATILENORMALNONUNIQUEIS_VOLATILE DDL script
SYS_C009271NORMALUNIQUETRIGGER_NAME , TRIGGER_GROUP DDL script
SYS_IL0000021458C00016$$LOBUNIQUE DDL script

Referenced by:

TableConstraint
QRTZ_SIMPLE_TRIGGERS SYS_C009279
QRTZ_CRON_TRIGGERS SYS_C009284
QRTZ_BLOB_TRIGGERS SYS_C009288
QRTZ_TRIGGER_LISTENERS SYS_C009293
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Wed Mar 4 07:58:24 2020