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 |