QRTZ_CALENDARS Table

Added in Version 8.0

The QRTZ_CALENDARS table contains information used by the Job Service.  

If an index entry appears in multiple table columns, then it is a composite index. A composite index requires multiple columns in order to create a unique index.

Legend
 

Field Datatype (Length) Allow Nulls Indexes Relationship Related Table and Field

SCHED_NAME (PK)

varchar(100)

NOT NULL

PK_QRTZ_CALENDARS (AK)

 

Per PZ: not going to guess what might be related or FK for quartz

QRTZ_BLOB_TRIGGERS.SCHED_NAME

 

QRTZ_CRON_TRIGGERS.SCHED_NAME

 

QRTZ_FIRED_TRIGGERS.SCHED_NAME

 

QRTZ_JOB_DETAILS.SCHED_NAME

 

QRTZ_LOCKS.SCHED_NAME

 

QRTZ_PAUSED_TRIGGER_GRPS.SCHED_NAME

 

QRTZ_SCHEDULER_STATE.SCHED_NAME

 

QRTZ_SIMPLE_TRIGGERS.SCHED_NAME

 

QRTZ_SIMPROP_TRIGGERS.SCHED_NAME

 

QRTZ_TRIGGERS.SCHED_NAME

CALENDAR_NAME (PK)

varchar(200)

NOT NULL

PK_QRTZ_CALENDARS (AK)

 

QRTZ_TRIGGERS.CALENDAR_NAME

CALENDAR

image(16)

NOT NULL