Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||
| batch_id | varchar | 255 | √ | null |
|
|
||||
| check_different | bool | 1 | √ | null |
|
|
||||
| check_missing | bool | 1 | √ | null |
|
|
||||
| compare_fields | varchar | 255 | √ | null |
|
|
||||
| completed | int4 | 10 | √ | null |
|
|
||||
| created_time | timestamp | 29,6 | null |
|
|
|||||
| destination_aet | varchar | 255 | √ | null |
|
|
||||
| device_name | varchar | 255 | null |
|
|
|||||
| different | int4 | 10 | null |
|
|
|||||
| error_comment | varchar | 255 | √ | null |
|
|
||||
| error_msg | varchar | 255 | √ | null |
|
|
||||
| exporter_id | varchar | 255 | √ | null |
|
|
||||
| failed | int4 | 10 | √ | null |
|
|
||||
| local_aet | varchar | 255 | √ | null |
|
|
||||
| matches | int4 | 10 | null |
|
|
|||||
| missing | int4 | 10 | null |
|
|
|||||
| modalities | varchar | 255 | √ | null |
|
|
||||
| num_failures | int4 | 10 | null |
|
|
|||||
| num_instances | int4 | 10 | √ | null |
|
|
||||
| outcome_msg | varchar | 255 | √ | null |
|
|
||||
| payload | bytea | 2147483647 | √ | null |
|
|
||||
| proc_end_time | timestamp | 29,6 | √ | null |
|
|
||||
| proc_start_time | timestamp | 29,6 | √ | null |
|
|
||||
| query_str | varchar | 255 | √ | null |
|
|
||||
| queue_name | varchar | 255 | null |
|
|
|||||
| remaining | int4 | 10 | √ | null |
|
|
||||
| remote_aet | varchar | 255 | √ | null |
|
|
||||
| rq_uri | varchar | 4000 | √ | null |
|
|
||||
| rq_host | varchar | 255 | √ | null |
|
|
||||
| rq_user_id | varchar | 255 | √ | null |
|
|
||||
| scheduled_time | timestamp | 29,6 | null |
|
|
|||||
| series_iuid | varchar | 255 | √ | null |
|
|
||||
| sop_iuid | varchar | 255 | √ | null |
|
|
||||
| task_status | int2 | 5 | null |
|
|
|||||
| status_code | int4 | 10 | √ | null |
|
|
||||
| storage_ids | varchar | 255 | √ | null |
|
|
||||
| stgcmt_policy | int2 | 5 | √ | null |
|
|
||||
| study_iuid | varchar | 255 | √ | null |
|
|
||||
| task_type | int2 | 5 | null |
|
|
|||||
| update_location_status | bool | 1 | √ | null |
|
|
||||
| updated_time | timestamp | 29,6 | null |
|
|
|||||
| version | int8 | 19 | √ | null |
|
|
||||
| warning | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| task_pkey | Primary key | Asc | pk |
| idx17gcm1xo6fkujauguyjfxfb2k | Performance | Asc | local_aet |
| idx1lchdfbbwkjbg7a6coy5t8iq7 | Performance | Asc | check_different |
| idx6a0y0rsssms4mtm9bpkw8vgl6 | Performance | Asc/Asc/Asc | study_iuid + series_iuid + sop_iuid |
| idx76hkd9mjludoohse4g0ru1mg8 | Performance | Asc | created_time |
| idx7y5ucdiygunyg2nh7qrs70e7k | Performance | Asc | task_status |
| idx81xi6wnv5b10x3723fxt5bmew | Performance | Asc | remote_aet |
| idx9htwq4ofarp6m88r3ao0grt8j | Performance | Asc | updated_time |
| idxa582by7kuyuhk8hi41tkelhrw | Performance | Asc | task_type |
| idxe6odcfrgswxke8wtlj8bdehet | Performance | Asc | exporter_id |
| idxf7c43c242ybnvcn3o50lrcpkh | Performance | Asc | destination_aet |
| idxk6dxmm1gu6u23xq03hbk80m4r | Performance | Asc | batch_id |
| idxm47ruxpag7pq4gtn12lc63yfe | Performance | Asc | device_name |
| idxow0nufrtniev7nkh7d0uv5mxe | Performance | Asc | compare_fields |
| idxpknlk8ggf8lnq38lq3gacvvpt | Performance | Asc | check_missing |
| idxr2bcfyreh4n9h392iik1aa6sh | Performance | Asc | queue_name |
| idxxwqht1afwe7k27iulvggnwwl | Performance | Asc | scheduled_time |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| task_stgcmt_policy_check | (((stgcmt_policy >= 0) AND (stgcmt_policy <= 5))) |
| task_task_type_check | (((task_type >= 0) AND (task_type <= 10))) |
| task_task_status_check | (((task_status >= 0) AND (task_status <= 6))) |
Relationships
Close relationships within degrees of separation
