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.
Added in Version 8.0
The QRTZ_TRIGGERS 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. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SCHED_NAME (PK) |
varchar(100) |
NOT NULL |
PK_QRTZ_TRIGGERS (AK) IDX_QRTZ_T_C (IE) IDX_QRTZ_T_G (IE) IDX_QRTZ_T_J (IE) IDX_QRTZ_T_JG (IE) IDX_QRTZ_T_N_G_STATE (IE) IDX_QRTZ_T_N_STATE (IE) IDX_QRTZ_T_NEXT_FIRE_TIME (IE) IDX_QRTZ_T_NFT_MISFIRE (IE) IDX_QRTZ_T_NFT_ST (IE) IDX_QRTZ_T_NFT_ST_MISFIRE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE_GRP (IE) IDX_QRTZ_T_STATE (IE) |
|
Per PZ: not going to guess what might be related or FK for quartz |
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
TRIGGER_NAME (PK) |
varchar(150) |
NOT NULL |
PK_QRTZ_TRIGGERS (AK) IDX_QRTZ_T_N_STATE (IE) |
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
TRIGGER_GROUP (PK) |
varchar(150) |
NOT NULL |
PK_QRTZ_TRIGGERS (AK) IDX_QRTZ_T_G (IE) IDX_QRTZ_T_N_G_STATE (IE) IDX_QRTZ_T_N_STATE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE_GRP (IE) |
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
JOB_NAME |
varchar(150) |
NOT NULL |
IDX_QRTZ_T_J (IE) |
|
|
|
|
|||||
|
JOB_GROUP |
varchar(150) |
NOT NULL
|
IDX_QRTZ_T_J (IE) IDX_QRTZ_T_JG (IE) |
|
|
|
|
|||||
|
DESCRIPTION |
varcharR(250) |
NULLS |
|
|
|
|
NEXT_FIRE_TIME |
datetime(8) |
NULLS |
IDX_QRTZ_T_NEXT_FIRE_TIME (IE) IDX_QRTZ_T_NFT_MISFIRE (IE) IDX_QRTZ_T_NFT_ST (IE) IDX_QRTZ_T_NFT_ST_MISFIRE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE_GRP (IE) |
|
|
|
PREVIOUS_FIRE_TIME |
datetime(8) |
NULLS |
|
|
|
|
PRIORITY |
int(4) |
NULLS |
|
|
|
|
TRIGGER_STATE |
varchar(16) |
NOT NULL |
IDX_QRTZ_T_N_G_STATE (IE) IDX_QRTZ_T_N_STATE (IE) IDX_QRTZ_T_NFT_ST (IE)IDX_QRTZ_T_NFT_ST_MISFIRE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE_GRP (IE) IDX_QRTZ_T_STATE (IE) |
|
|
|
TRIGGER_TYPE |
varchar(8) |
NOT NULL |
|
|
|
|
START_TIME |
datetime(8) |
NOT NULL |
|
|
|
|
END_TIME |
datetime(8) |
NULLS |
|
|
|
|
CALENDAR_NAME |
varchar(200) |
NULLS |
IDX_QRTZ_T_C (IE) |
|
|
|
MISFIRE_INSTR |
int(4) |
NULLS |
IDX_QRTZ_T_NFT_MISFIRE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE (IE) IDX_QRTZ_T_NFT_ST_MISFIRE_GRP (IE) |
|
|
|
JOB_DATA |
image(16) |
NULLS |
|
|
|