| Previous: qrtz_simprop_triggers | Unanet Data Model | Next: request_allocation |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | sched_name | varchar(120) | qrtz_job_details | fk_qrtz_triggers1 | |
| 2. | PK | trigger_name | varchar(200) | |||
| 3. | PK | trigger_group | varchar(200) | |||
| 4. | job_name | varchar(200) | qrtz_job_details | fk_qrtz_triggers1 | ||
| 5. | job_group | varchar(200) | qrtz_job_details | fk_qrtz_triggers1 | ||
| 6. | description | varchar(250) | ||||
| 7. | next_fire_time | bigint | ||||
| 8. | prev_fire_time | bigint | ||||
| 9. | priority | int | ||||
| 10. | trigger_state | varchar(16) | ||||
| 11. | trigger_type | varchar(8) | ||||
| 12. | start_time | bigint | ||||
| 13. | end_time | bigint | ||||
| 14. | calendar_name | varchar(200) | ||||
| 15. | misfire_instr | smallint | ||||
| 16. | job_data | image | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| sched_name | qrtz_job_details | sched_name | fk_qrtz_triggers1 |
| job_name | job_name | ||
| job_group | job_group | ||
| Table | Column | Foreign Key Name |
| qrtz_blob_triggers | sched_name | fk_qrtz_blob_triggers1 |
| trigger_name | ||
| trigger_group | ||
| qrtz_cron_triggers | sched_name | fk_qrtz_cron_triggers1 |
| trigger_name | ||
| trigger_group | ||
| qrtz_simple_triggers | sched_name | fk_qrtz_simple_triggers1 |
| trigger_name | ||
| trigger_group | ||
| qrtz_simprop_triggers | sched_name | fk_qrtz_simprop_triggers1 |
| trigger_name | ||
| trigger_group |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_qrtz_triggers | true | sched_name | Asc |
| trigger_name | |||
| trigger_group | |||
| idx_qrtz_triggers1 | false | sched_name | Asc |
| next_fire_time | |||
| idx_qrtz_triggers10 | false | sched_name | Asc |
| misfire_instr | |||
| next_fire_time | |||
| idx_qrtz_triggers11 | false | sched_name | Asc |
| misfire_instr | |||
| next_fire_time | |||
| trigger_state | |||
| idx_qrtz_triggers12 | false | sched_name | Asc |
| misfire_instr | |||
| next_fire_time | |||
| trigger_group | |||
| trigger_state | |||
| idx_qrtz_triggers2 | false | sched_name | Asc |
| trigger_state | |||
| idx_qrtz_triggers3 | false | sched_name | Asc |
| trigger_state | |||
| next_fire_time | |||
| idx_qrtz_triggers4 | false | sched_name | Asc |
| job_name | |||
| job_group | |||
| idx_qrtz_triggers5 | false | sched_name | Asc |
| job_group | |||
| idx_qrtz_triggers6 | false | sched_name | Asc |
| calendar_name | |||
| idx_qrtz_triggers7 | false | sched_name | Asc |
| trigger_group | |||
| idx_qrtz_triggers8 | false | sched_name | Asc |
| trigger_name | |||
| trigger_group | |||
| trigger_state | |||
| idx_qrtz_triggers9 | false | sched_name | Asc |
| trigger_group | |||
| trigger_state |