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_CRON_TRIGGERS

DDL script

Columns

NameTypeNullableDefault valueComment
TRIGGER_NAMEVARCHAR2(200)N  
TRIGGER_GROUPVARCHAR2(200)N  
CRON_EXPRESSIONVARCHAR2(120)N  
TIME_ZONE_IDVARCHAR2(80)Y  

Primary key:

Constraint NameColumns
SYS_C009283TRIGGER_NAME , TRIGGER_GROUP

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
SYS_C009284TRIGGER_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_C009283NORMALUNIQUETRIGGER_NAME , TRIGGER_GROUP DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Wed Mar 4 07:58:24 2020