Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||||||||
| availability | int4 | 10 | null |
|
|
|||||||||||
| sr_complete | varchar | 255 | null |
|
|
|||||||||||
| content_date | varchar | 255 | null |
|
|
|||||||||||
| content_time | varchar | 255 | null |
|
|
|||||||||||
| created_time | timestamp | 29,6 | null |
|
|
|||||||||||
| ext_retrieve_aet | varchar | 255 | √ | null |
|
|
||||||||||
| inst_custom1 | varchar | 255 | null |
|
|
|||||||||||
| inst_custom2 | varchar | 255 | null |
|
|
|||||||||||
| inst_custom3 | varchar | 255 | null |
|
|
|||||||||||
| inst_no | int4 | 10 | √ | null |
|
|
||||||||||
| num_frames | int4 | 10 | √ | null |
|
|
||||||||||
| retrieve_aets | varchar | 255 | √ | null |
|
|
||||||||||
| sop_cuid | varchar | 255 | null |
|
|
|||||||||||
| sop_iuid | varchar | 255 | null |
|
|
|||||||||||
| updated_time | timestamp | 29,6 | null |
|
|
|||||||||||
| sr_verified | varchar | 255 | null |
|
|
|||||||||||
| version | int8 | 19 | √ | null |
|
|
||||||||||
| dicomattrs_fk | int8 | 19 | null |
|
|
|||||||||||
| srcode_fk | int8 | 19 | √ | null |
|
|
||||||||||
| series_fk | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| instance_pkey | Primary key | Asc | pk |
| fk_7w6f9bi2w91qr2abl6ddxnrwq | Performance | Asc | srcode_fk |
| fk_s4tgrew4sh4qxoupmk3gihtrk | Performance | Asc | series_fk |
| uk_247lgirehl8i2vuanyfjnuyjb | Must be unique | Asc/Asc | series_fk + sop_iuid |
| uk_5ikkfk17vijvsvtyied2xa225 | Performance | Asc | content_date |
| uk_dglm8ndp9y9i0uo6fgaa5rhbb | Performance | Asc | sop_cuid |
| uk_eg0khesxr81gdimwhjiyrylw7 | Performance | Asc | sop_iuid |
| uk_fncb1s641rrnoek7j47k0j06n | Performance | Asc | inst_custom1 |
| uk_gisd09x31lphi4437hwgh7ihg | Performance | Asc | sr_complete |
| uk_jxfu47kwjk3kkkyrwewjw8a4n | Must be unique | Asc | dicomattrs_fk |
| uk_ouh6caecancvsa05lknojy30j | Performance | Asc | inst_no |
| uk_pck1ovyd4t96mjkbbw6f8jiam | Performance | Asc | content_time |
| uk_q5i0hxt1iyahxjiroux2h8imm | Performance | Asc | inst_custom3 |
| uk_qh8jqpe8ulsb5t7iv24scho00 | Performance | Asc | sr_verified |
| uk_rr1ro1oxv6s4riib9hjkcuvuo | Performance | Asc | inst_custom2 |
Relationships
Close relationships within degrees of separation
