| Previous: qrtz_cron_triggers | Unanet Data Model | Next: qrtz_job_details |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | sched_name | varchar(120) | |||
| 2. | trigger_name | varchar(200) | ||||
| 3. | trigger_group | varchar(200) | ||||
| 4. | PK | entry_id | varchar(95) | |||
| 5. | instance_name | varchar(200) | ||||
| 6. | fired_time | bigint | ||||
| 7. | priority | int | ||||
| 8. | state | varchar(16) | ||||
| 9. | job_name | varchar(200) | ||||
| 10. | job_group | varchar(200) | ||||
| 11. | is_nonconcurrent | varchar(1) | ||||
| 12. | requests_recovery | varchar(1) | ||||
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_qrtz_fired_triggers | true | sched_name | Asc |
| entry_id | |||
| idx_qrtz_fired_triggers1 | false | sched_name | Asc |
| job_group | |||
| idx_qrtz_fired_triggers2 | false | sched_name | Asc |
| job_name | |||
| job_group | |||
| idx_qrtz_fired_triggers3 | false | sched_name | Asc |
| instance_name | |||
| requests_recovery | |||
| idx_qrtz_fired_triggers4 | false | sched_name | Asc |
| trigger_group | |||
| idx_qrtz_fired_triggers5 | false | sched_name | Asc |
| instance_name | |||
| idx_qrtz_fired_triggers6 | false | sched_name | Asc |
| trigger_name | |||
| trigger_group |