Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||||||||
| availability | int2 | 5 | 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 |
| fke92yganh695k2y4hxfqxtesg1 | Performance | Asc | series_fk |
| fkqmk050ojwer9ujsbl74d4kf6e | Performance | Asc | srcode_fk |
| idx5ikkfk17vijvsvtyied2xa225 | Performance | Asc | content_date |
| idxdglm8ndp9y9i0uo6fgaa5rhbb | Performance | Asc | sop_cuid |
| idxeg0khesxr81gdimwhjiyrylw7 | Performance | Asc | sop_iuid |
| idxfncb1s641rrnoek7j47k0j06n | Performance | Asc | inst_custom1 |
| idxgisd09x31lphi4437hwgh7ihg | Performance | Asc | sr_complete |
| idxouh6caecancvsa05lknojy30j | Performance | Asc | inst_no |
| idxpck1ovyd4t96mjkbbw6f8jiam | Performance | Asc | content_time |
| idxq5i0hxt1iyahxjiroux2h8imm | Performance | Asc | inst_custom3 |
| idxqh8jqpe8ulsb5t7iv24scho00 | Performance | Asc | sr_verified |
| idxrr1ro1oxv6s4riib9hjkcuvuo | Performance | Asc | inst_custom2 |
| instance_dicomattrs_fk_key | Must be unique | Asc | dicomattrs_fk |
| instance_series_fk_sop_iuid_key | Must be unique | Asc/Asc | series_fk + sop_iuid |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| instance_availability_check | (((availability >= 0) AND (availability <= 3))) |
Relationships
Close relationships within degrees of separation
