Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pk | int8 | 19 | null |
|
|
|||||||||
| body_part | varchar | 255 | null |
|
|
|||||||||
| completeness | int4 | 10 | null |
|
|
|||||||||
| compress_failures | int4 | 10 | null |
|
|
|||||||||
| compress_params | varchar | 255 | √ | null |
|
|
||||||||
| compress_time | timestamp | 29,6 | √ | null |
|
|
||||||||
| compress_tsuid | varchar | 255 | √ | null |
|
|
||||||||
| created_time | timestamp | 29,6 | null |
|
|
|||||||||
| expiration_date | varchar | 255 | √ | null |
|
|
||||||||
| expiration_exporter_id | varchar | 255 | √ | null |
|
|
||||||||
| expiration_state | int4 | 10 | null |
|
|
|||||||||
| ext_retrieve_aet | varchar | 255 | √ | null |
|
|
||||||||
| failed_retrieves | int4 | 10 | null |
|
|
|||||||||
| stgver_failures | int4 | 10 | null |
|
|
|||||||||
| inst_purge_state | int4 | 10 | null |
|
|
|||||||||
| inst_purge_time | timestamp | 29,6 | √ | null |
|
|
||||||||
| institution | varchar | 255 | null |
|
|
|||||||||
| department | varchar | 255 | null |
|
|
|||||||||
| laterality | varchar | 255 | null |
|
|
|||||||||
| metadata_update_time | timestamp | 29,6 | √ | null |
|
|
||||||||
| metadata_update_failures | int4 | 10 | null |
|
|
|||||||||
| modality | varchar | 255 | null |
|
|
|||||||||
| modified_time | timestamp | 29,6 | null |
|
|
|||||||||
| pps_cuid | varchar | 255 | null |
|
|
|||||||||
| pps_iuid | varchar | 255 | null |
|
|
|||||||||
| pps_start_date | varchar | 255 | null |
|
|
|||||||||
| pps_start_time | varchar | 255 | null |
|
|
|||||||||
| receiving_aet | varchar | 255 | √ | null |
|
|
||||||||
| receiving_hl7_app | varchar | 255 | √ | null |
|
|
||||||||
| receiving_hl7_facility | varchar | 255 | √ | null |
|
|
||||||||
| receiving_pres_addr | varchar | 255 | √ | null |
|
|
||||||||
| rejection_state | int4 | 10 | null |
|
|
|||||||||
| sending_aet | varchar | 255 | √ | null |
|
|
||||||||
| sending_hl7_app | varchar | 255 | √ | null |
|
|
||||||||
| sending_hl7_facility | varchar | 255 | √ | null |
|
|
||||||||
| sending_pres_addr | varchar | 255 | √ | null |
|
|
||||||||
| series_custom1 | varchar | 255 | null |
|
|
|||||||||
| series_custom2 | varchar | 255 | null |
|
|
|||||||||
| series_custom3 | varchar | 255 | null |
|
|
|||||||||
| series_desc | varchar | 255 | null |
|
|
|||||||||
| series_iuid | varchar | 255 | null |
|
|
|||||||||
| series_no | int4 | 10 | √ | null |
|
|
||||||||
| series_size | int8 | 19 | null |
|
|
|||||||||
| sop_cuid | varchar | 255 | null |
|
|
|||||||||
| station_name | varchar | 255 | null |
|
|
|||||||||
| stgver_time | timestamp | 29,6 | √ | null |
|
|
||||||||
| tsuid | varchar | 255 | null |
|
|
|||||||||
| updated_time | timestamp | 29,6 | null |
|
|
|||||||||
| version | int8 | 19 | √ | null |
|
|
||||||||
| dicomattrs_fk | int8 | 19 | null |
|
|
|||||||||
| inst_code_fk | int8 | 19 | √ | null |
|
|
||||||||
| dept_code_fk | int8 | 19 | √ | null |
|
|
||||||||
| metadata_fk | int8 | 19 | √ | null |
|
|
||||||||
| perf_phys_name_fk | int8 | 19 | √ | null |
|
|
||||||||
| study_fk | int8 | 19 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| series_pkey | Primary key | Asc | pk |
| fk_1og1krtgxfh207rtqjg0r7pbd | Performance | Asc | study_fk |
| fk_5n4bxxb2xa7bvvq26ao7wihky | Performance | Asc | perf_phys_name_fk |
| fk_avp2oeuufo8axv5j184cchrop | Performance | Asc | dept_code_fk |
| fk_oiq81nulcmtg6p85iu31igtf5 | Performance | Asc | inst_code_fk |
| fk_pu4p7k1o9hleuk9rmxvw2ybj6 | Performance | Asc | metadata_fk |
| series_desc_upper_idx | Performance | ||
| uk_1e4aqxc5w1557hr3fb3lqm2qb | Performance | Asc | sending_hl7_facility |
| uk_38mfgfnjhan2yhnwqtcrawe4 | Performance | Asc | compress_time |
| uk_4lnegvfs65fbkjn7nmg9s8usy | Performance | Asc | completeness |
| uk_6xqpk4cvy49wj41p2qwixro8w | Performance | Asc | metadata_update_failures |
| uk_75oc6w5ootkuwyvmrhe3tbown | Performance | Asc | series_no |
| uk_82qea56c0kdhod3b1wu8wbrny | Performance | Asc | institution |
| uk_83y2fx8cou17h3xggxspgikna | Must be unique | Asc/Asc | study_fk + series_iuid |
| uk_889438ocqfrvybu3k2eo65lpa | Performance | Asc | compress_failures |
| uk_9fi64g5jjycg9dp24jjk5txg1 | Performance | Asc | series_iuid |
| uk_a8vyikwd972jomyb3f6brcfh5 | Performance | Asc | inst_purge_time |
| uk_achxn1rtfm3fbkkswlsyr75t0 | Performance | Asc | series_desc |
| uk_amr00xwlatxewgj1sjp5mnf76 | Performance | Asc | pps_start_time |
| uk_b126hub0dc1o9dqp6awoispx2 | Performance | Asc | modality |
| uk_b9e2bptvail8xnmb62h30h4d2 | Performance | Asc | sending_aet |
| uk_bdj2kuutidekc2en6dckev7l6 | Must be unique | Asc | dicomattrs_fk |
| uk_bqu32v5v76p4qi0etptnrm0pc | Performance | Asc | department |
| uk_d8b8irasiw8eh9tsigmwkbvae | Performance | Asc | series_custom3 |
| uk_e15a6qnq8jcq931agc2v48nvt | Performance | Asc | receiving_pres_addr |
| uk_er4ife08f6eaki91gt3hxt5e | Performance | Asc | inst_purge_state |
| uk_ffpftwfkijejj09tlbxr7u5g8 | Performance | Asc | sending_hl7_app |
| uk_ftv3ijh2ud6ogoknneyqc6t9i | Performance | Asc | stgver_time |
| uk_gj0bxgi55bhjic9s3i4dp2aee | Performance | Asc | receiving_hl7_app |
| uk_gwp46ofa26am9ohhccq1ohdj | Performance | Asc | body_part |
| uk_gxun7s005k8qf7qwhjhkkkkng | Performance | Asc | sending_pres_addr |
| uk_hm39592a9n7m54dgso17irlhv | Performance | Asc | series_custom1 |
| uk_hwkcpd7yv0nca7o918wm4bn69 | Performance | Asc | metadata_update_time |
| uk_ih49lthl3udoca5opvgsdcerj | Performance | Asc | expiration_state |
| uk_j6aadbh7u93bpmv18s1inrl1r | Performance | Asc | failed_retrieves |
| uk_jlgy9ifvqak4g2bxkchismw8x | Performance | Asc | rejection_state |
| uk_lnck3a2qjo1vc430n1sy51vbr | Performance | Asc | receiving_aet |
| uk_mrn00m45lkq1xbehmbw5d9jbl | Performance | Asc | sop_cuid |
| uk_pbay159cdhwbtjvlmel6d6em2 | Performance | Asc | receiving_hl7_facility |
| uk_pq1yi70ftxhh391lhcq3e08nf | Performance | Asc | station_name |
| uk_q3wayt2ke25fdcghaohhrjiu7 | Performance | Asc | series_custom2 |
| uk_rvlxc150uexwmr1l9ojp8fgd | Performance | Asc | pps_start_date |
| uk_s1vceb8cu9c45j0q8tbldgol9 | Performance | Asc | stgver_failures |
| uk_ta3pi6exqft5encv389hwjytw | Performance | Asc | expiration_date |
| uk_tahx0q1ejidnsam40ans7oecx | Performance | Asc | tsuid |
| uk_tbdrfrmkmifsqhpf43065jrbs | Performance | Asc | laterality |
Relationships
Close relationships within degrees of separation
