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_SIMPLE_TRIGGERS

DDL script

Columns

NameTypeNullableDefault valueComment
TRIGGER_NAMEVARCHAR2(200)N  
TRIGGER_GROUPVARCHAR2(200)N  
REPEAT_COUNTNUMBER(7)N  
REPEAT_INTERVALNUMBER(12)N  
TIMES_TRIGGEREDNUMBER(10)N  

Primary key:

Constraint NameColumns
SYS_C009278TRIGGER_NAME , TRIGGER_GROUP

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C009279TRIGGER_NAME , TRIGGER_GROUP QRTZ_TRIGGERS SYS_C009271 NO ACTION

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

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