Difference between revisions of "Public.qrtz triggers (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.qrtz_triggers |- |} {| border="1" cellpadding="5" cellspacing="0" sty...) |
|||
| Line 20: | Line 20: | ||
|- | |- | ||
| trigger_name | | trigger_name | ||
| − | | | + | | varchar(80) |
| not null | | not null | ||
| | | | ||
| Line 27: | Line 27: | ||
|- | |- | ||
| trigger_group | | trigger_group | ||
| − | | | + | | varchar(80) |
| not null | | not null | ||
| | | | ||
| Line 34: | Line 34: | ||
|- | |- | ||
| job_name | | job_name | ||
| − | | | + | | varchar(80) |
| not null | | not null | ||
| | | | ||
| Line 41: | Line 41: | ||
|- | |- | ||
| job_group | | job_group | ||
| − | | | + | | varchar(80) |
| not null | | not null | ||
| | | | ||
| Line 48: | Line 48: | ||
|- | |- | ||
| is_volatile | | is_volatile | ||
| − | | | + | | boolean |
| not null | | not null | ||
| | | | ||
| Line 55: | Line 55: | ||
|- | |- | ||
| description | | description | ||
| − | | | + | | varchar(120) |
| null | | null | ||
| | | | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| next_fire_time | | next_fire_time | ||
| − | | | + | | bigint |
| null | | null | ||
| | | | ||
| Line 69: | Line 69: | ||
|- | |- | ||
| prev_fire_time | | prev_fire_time | ||
| − | | | + | | bigint |
| null | | null | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| trigger_state | | trigger_state | ||
| − | | | + | | varchar(16) |
| not null | | not null | ||
| | | | ||
| Line 83: | Line 83: | ||
|- | |- | ||
| trigger_type | | trigger_type | ||
| − | | | + | | varchar(8) |
| not null | | not null | ||
| | | | ||
| Line 90: | Line 90: | ||
|- | |- | ||
| start_time | | start_time | ||
| − | | | + | | bigint |
| not null | | not null | ||
| | | | ||
| Line 97: | Line 97: | ||
|- | |- | ||
| end_time | | end_time | ||
| − | | | + | | bigint |
| null | | null | ||
| | | | ||
| Line 104: | Line 104: | ||
|- | |- | ||
| calendar_name | | calendar_name | ||
| − | | | + | | varchar(80) |
| null | | null | ||
| | | | ||
| Line 111: | Line 111: | ||
|- | |- | ||
| misfire_instr | | misfire_instr | ||
| − | | | + | | smallint |
| null | | null | ||
| | | | ||
| Line 118: | Line 118: | ||
|- | |- | ||
| job_data | | job_data | ||
| − | | | + | | bytea |
| null | | null | ||
| | | | ||
Revision as of 15:44, 7 August 2009
wikibot
| Table | public.qrtz_triggers |
| Column | Data Type | Nullable | Default | PK | Index |
| trigger_name | varchar(80) | not null | pk_qrtz_triggers | ||
| trigger_group | varchar(80) | not null | pk_qrtz_triggers | ||
| job_name | varchar(80) | not null | |||
| job_group | varchar(80) | not null | |||
| is_volatile | boolean | not null | |||
| description | varchar(120) | null | |||
| next_fire_time | bigint | null | |||
| prev_fire_time | bigint | null | |||
| trigger_state | varchar(16) | not null | |||
| trigger_type | varchar(8) | not null | |||
| start_time | bigint | not null | |||
| end_time | bigint | null | |||
| calendar_name | varchar(80) | null | |||
| misfire_instr | smallint | null | |||
| job_data | bytea | null |
| Relation | Column | Referenced Column |
| public.qrtz_job_details | job_name | job_name |
| Detail Table | Column | Referencing Column |
| public.qrtz_blob_triggers | trigger_name | trigger_name |
| public.qrtz_blob_triggers | trigger_name | trigger_name |
| public.qrtz_cron_triggers | trigger_name | trigger_name |
| public.qrtz_cron_triggers | trigger_name | trigger_name |
| public.qrtz_simple_triggers | trigger_name | trigger_name |
| public.qrtz_simple_triggers | trigger_name | trigger_name |
| public.qrtz_trigger_listeners | trigger_name | trigger_name |
| public.qrtz_trigger_listeners | trigger_name | trigger_name |
