Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||
| batch_id | varchar | 255 | √ | null |
|
|
||||
| created_time | timestamp | 29,6 | null |
|
|
|||||
| device_name | varchar | 255 | null |
|
|
|||||
| exporter_id | varchar | 255 | √ | null |
|
|
||||
| num_failures | int4 | 10 | √ | null |
|
|
||||
| num_instances | int4 | 10 | √ | null |
|
|
||||
| series_iuid | varchar | 255 | √ | null |
|
|
||||
| sop_iuid | varchar | 255 | √ | null |
|
|
||||
| stgcmt_status | int4 | 10 | null |
|
|
|||||
| study_iuid | varchar | 255 | null |
|
|
|||||
| task_fk | int8 | 19 | √ | null |
|
|
||||
| transaction_uid | varchar | 255 | null |
|
|
|||||
| updated_time | timestamp | 29,6 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| stgcmt_result_pkey | Primary key | Asc | pk |
| uk_7ltjgxoijy15rrwihl8euv7vh | Performance | Asc | device_name |
| uk_ey6qpep2qtiwayou7pd0vj22w | Must be unique | Asc | transaction_uid |
| uk_f718gnu5js0mdg39q6j7fklia | Performance | Asc | batch_id |
| uk_gu96kxnbf2p84d1katepo0btq | Performance | Asc | exporter_id |
| uk_j292rvji1d7hintidhgkkcbpw | Performance | Asc | task_fk |
| uk_nyoefler7agcmxc8t8yfngq7e | Performance | Asc | stgcmt_status |
| uk_p65blcj4h0uh2itb0bp49mc07 | Performance | Asc | study_iuid |
| uk_qko59fn9pb87j1eu070ilfkhm | Performance | Asc | updated_time |
Relationships
Close relationships within degrees of separation
