Table |
Type |
Column |
Type |
Size |
Nulls |
Auto |
Default |
Comments |
qrtz_blob_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_triggers |
Table |
job_group |
varchar |
200 |
|
|
null |
|
qrtz_locks |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_triggers |
Table |
end_time |
int8 |
19 |
√ |
|
null |
|
qrtz_blob_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
long_prop_1 |
int8 |
19 |
√ |
|
null |
|
qrtz_job_details |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_simple_triggers |
Table |
repeat_interval |
int8 |
19 |
|
|
null |
|
qrtz_fired_triggers |
Table |
job_group |
varchar |
200 |
√ |
|
null |
|
qrtz_triggers |
Table |
priority |
int4 |
10 |
√ |
|
null |
|
qrtz_simprop_triggers |
Table |
str_prop_2 |
varchar |
512 |
√ |
|
null |
|
qrtz_simple_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_fired_triggers |
Table |
is_nonconcurrent |
bool |
1 |
√ |
|
null |
|
qrtz_triggers |
Table |
job_name |
varchar |
200 |
|
|
null |
|
qrtz_fired_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
int_prop_2 |
int4 |
10 |
√ |
|
null |
|
qrtz_cron_triggers |
Table |
cron_expression |
varchar |
120 |
|
|
null |
|
qrtz_job_details |
Table |
is_nonconcurrent |
bool |
1 |
|
|
null |
|
qrtz_job_details |
Table |
job_data |
bytea |
2147483647 |
√ |
|
null |
|
qrtz_locks |
Table |
lock_name |
varchar |
40 |
|
|
null |
|
qrtz_fired_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_job_details |
Table |
job_name |
varchar |
200 |
|
|
null |
|
qrtz_triggers |
Table |
prev_fire_time |
int8 |
19 |
√ |
|
null |
|
qrtz_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
bool_prop_1 |
bool |
1 |
√ |
|
null |
|
qrtz_job_details |
Table |
description |
varchar |
250 |
√ |
|
null |
|
qrtz_triggers |
Table |
calendar_name |
varchar |
200 |
√ |
|
null |
|
qrtz_simple_triggers |
Table |
repeat_count |
int8 |
19 |
|
|
null |
|
qrtz_calendars |
Table |
calendar_name |
varchar |
200 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
int_prop_1 |
int4 |
10 |
√ |
|
null |
|
qrtz_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_triggers |
Table |
next_fire_time |
int8 |
19 |
√ |
|
null |
|
qrtz_job_details |
Table |
is_durable |
bool |
1 |
|
|
null |
|
qrtz_triggers |
Table |
misfire_instr |
int2 |
5 |
√ |
|
null |
|
qrtz_simple_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_paused_trigger_grps |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_fired_triggers |
Table |
requests_recovery |
bool |
1 |
√ |
|
null |
|
qrtz_job_details |
Table |
requests_recovery |
bool |
1 |
|
|
null |
|
qrtz_simple_triggers |
Table |
times_triggered |
int8 |
19 |
|
|
null |
|
qrtz_job_details |
Table |
is_update_data |
bool |
1 |
|
|
null |
|
qrtz_fired_triggers |
Table |
sched_time |
int8 |
19 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
dec_prop_1 |
numeric |
13 |
√ |
|
null |
|
qrtz_calendars |
Table |
calendar |
bytea |
2147483647 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
long_prop_2 |
int8 |
19 |
√ |
|
null |
|
qrtz_scheduler_state |
Table |
last_checkin_time |
int8 |
19 |
|
|
null |
|
qrtz_cron_triggers |
Table |
time_zone_id |
varchar |
80 |
√ |
|
null |
|
qrtz_calendars |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_job_details |
Table |
job_group |
varchar |
200 |
|
|
null |
|
qrtz_cron_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_scheduler_state |
Table |
checkin_interval |
int8 |
19 |
|
|
null |
|
qrtz_fired_triggers |
Table |
entry_id |
varchar |
95 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
bool_prop_2 |
bool |
1 |
√ |
|
null |
|
qrtz_paused_trigger_grps |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_scheduler_state |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_fired_triggers |
Table |
state |
varchar |
16 |
|
|
null |
|
qrtz_triggers |
Table |
description |
varchar |
250 |
√ |
|
null |
|
qrtz_simprop_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_scheduler_state |
Table |
instance_name |
varchar |
200 |
|
|
null |
|
qrtz_cron_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_triggers |
Table |
trigger_state |
varchar |
16 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
dec_prop_2 |
numeric |
13 |
√ |
|
null |
|
qrtz_triggers |
Table |
job_data |
bytea |
2147483647 |
√ |
|
null |
|
qrtz_fired_triggers |
Table |
fired_time |
int8 |
19 |
|
|
null |
|
qrtz_fired_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_simple_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
str_prop_1 |
varchar |
512 |
√ |
|
null |
|
qrtz_triggers |
Table |
start_time |
int8 |
19 |
|
|
null |
|
qrtz_blob_triggers |
Table |
blob_data |
bytea |
2147483647 |
√ |
|
null |
|
qrtz_cron_triggers |
Table |
sched_name |
varchar |
120 |
|
|
null |
|
qrtz_triggers |
Table |
trigger_type |
varchar |
8 |
|
|
null |
|
qrtz_fired_triggers |
Table |
instance_name |
varchar |
200 |
|
|
null |
|
qrtz_fired_triggers |
Table |
priority |
int4 |
10 |
|
|
null |
|
qrtz_simprop_triggers |
Table |
str_prop_3 |
varchar |
512 |
√ |
|
null |
|
qrtz_fired_triggers |
Table |
job_name |
varchar |
200 |
√ |
|
null |
|
qrtz_simprop_triggers |
Table |
trigger_group |
varchar |
200 |
|
|
null |
|
qrtz_blob_triggers |
Table |
trigger_name |
varchar |
200 |
|
|
null |
|
qrtz_job_details |
Table |
job_class_name |
varchar |
250 |
|
|
null |
|