Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| sched_name | varchar | 120 | null |
|
|
||||||
| trigger_name | varchar | 200 | null |
|
|
||||||
| trigger_group | varchar | 200 | null |
|
|
||||||
| str_prop_1 | varchar | 512 | √ | null |
|
|
|||||
| str_prop_2 | varchar | 512 | √ | null |
|
|
|||||
| str_prop_3 | varchar | 512 | √ | null |
|
|
|||||
| int_prop_1 | int4 | 10 | √ | null |
|
|
|||||
| int_prop_2 | int4 | 10 | √ | null |
|
|
|||||
| long_prop_1 | int8 | 19 | √ | null |
|
|
|||||
| long_prop_2 | int8 | 19 | √ | null |
|
|
|||||
| dec_prop_1 | numeric | 13,4 | √ | null |
|
|
|||||
| dec_prop_2 | numeric | 13,4 | √ | null |
|
|
|||||
| bool_prop_1 | bool | 1 | √ | null |
|
|
|||||
| bool_prop_2 | bool | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| qrtz_simprop_triggers_pkey | Primary key | Asc/Asc/Asc | sched_name + trigger_name + trigger_group |

