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_FIRED_TRIGGERS

DDL script

Columns

NameTypeNullableDefault valueComment
ENTRY_IDVARCHAR2(95)N  
TRIGGER_NAMEVARCHAR2(200)N  
TRIGGER_GROUPVARCHAR2(200)N  
IS_VOLATILEVARCHAR2(1)N  
INSTANCE_NAMEVARCHAR2(200)N  
FIRED_TIMENUMBER(13)N  
PRIORITYNUMBER(13)N  
STATEVARCHAR2(16)N  
JOB_NAMEVARCHAR2(200)Y  
JOB_GROUPVARCHAR2(200)Y  
IS_STATEFULVARCHAR2(1)Y  
REQUESTS_RECOVERYVARCHAR2(1)Y  

Primary key:

Constraint NameColumns
SYS_C009307ENTRY_ID

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
IDX_QRTZ_FT_JOB_GROUPNORMALNONUNIQUEJOB_GROUP DDL script
IDX_QRTZ_FT_JOB_NAMENORMALNONUNIQUEJOB_NAME DDL script
IDX_QRTZ_FT_JOB_REQ_RECOVERYNORMALNONUNIQUEREQUESTS_RECOVERY DDL script
IDX_QRTZ_FT_JOB_STATEFULNORMALNONUNIQUEIS_STATEFUL DDL script
IDX_QRTZ_FT_TRIG_GROUPNORMALNONUNIQUETRIGGER_GROUP DDL script
IDX_QRTZ_FT_TRIG_INST_NAMENORMALNONUNIQUEINSTANCE_NAME DDL script
IDX_QRTZ_FT_TRIG_NAMENORMALNONUNIQUETRIGGER_NAME DDL script
IDX_QRTZ_FT_TRIG_NM_GPNORMALNONUNIQUETRIGGER_NAME , TRIGGER_GROUP DDL script
IDX_QRTZ_FT_TRIG_VOLATILENORMALNONUNIQUEIS_VOLATILE DDL script
SYS_C009307NORMALUNIQUEENTRY_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Wed Mar 4 07:58:24 2020