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 | int2 | 5 | 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 |
| idx7ltjgxoijy15rrwihl8euv7vh | Performance | Asc | device_name |
| idxf718gnu5js0mdg39q6j7fklia | Performance | Asc | batch_id |
| idxgu96kxnbf2p84d1katepo0btq | Performance | Asc | exporter_id |
| idxj292rvji1d7hintidhgkkcbpw | Performance | Asc | task_fk |
| idxnyoefler7agcmxc8t8yfngq7e | Performance | Asc | stgcmt_status |
| idxp65blcj4h0uh2itb0bp49mc07 | Performance | Asc | study_iuid |
| idxqko59fn9pb87j1eu070ilfkhm | Performance | Asc | updated_time |
| stgcmt_result_transaction_uid_key | Must be unique | Asc | transaction_uid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| stgcmt_result_stgcmt_status_check | (((stgcmt_status >= 0) AND (stgcmt_status <= 3))) |
Relationships
Close relationships within degrees of separation
