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_SIMPROP_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_SIMPROP_TRIGGERS (AK) |
|
Per PZ: not going to guess what might be related or FK for quartz |
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
TRIGGER_NAME (PK) |
varchar(150) |
NOT NULL |
PK_QRTZ_SIMPROP_TRIGGERS (AK) |
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
TRIGGER_GROUP (PK) |
varchar(150) |
NOT NULL |
PK_QRTZ_SIMPROP_TRIGGERS (AK) |
|
|
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
|
|||||
|
STR_PROP_1 |
varchar(512) |
NULLS |
|
|
|
|
STR_PROP_2 |
varchar(512) |
NULLS |
|
|
|
|
STR_PROP_3 |
varchar(512) |
NULLS |
|
|
|
|
INT_PROP_1 |
int(4) |
NULLS |
|
|
|
|
INT_PROP_2 |
int(4) |
NULLS |
|
|
|
|
LONG_PROP_1 |
int(4) |
NULLS |
|
|
|
|
LONG_PROP_2 |
int(4) |
NULLS |
|
|
|
|
DEC_PROP_1 |
numeric(13,4) |
NULLS |
|
|
|
|
DEC_PROP_2 |
numeric(13,4) |
NULLS |
|
|
|
|
BOOL_PROP_1 |
char(1) |
NULLS |
|
|
|
|
BOOL_PROP_2 |
char(1) |
NULLS |
|
|
|