series

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
instance.series_fk fke92yganh695k2y4hxfqxtesg1 R
series_query_attrs.series_fk fksk791fnscydy7whj3lvrp3j1a R
series_req.series_fk fk1gs2u7w7uefvi7dcjg9vlp23x R
access_control_id varchar 255 null
body_part varchar 255 null
completeness int2 5 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 int2 5 null
ext_retrieve_aet varchar 255 null
failed_retrieves int4 10 null
stgver_failures int4 10 null
inst_purge_state int2 5 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 int2 5 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
id_sequence.name Implied Constraint R
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
dicomattrs.pk fktih7mdqwcklym58jd9wn3itjq R
inst_code_fk int8 19 √ null
code.pk fk6nn55bx7pqlmimgfnhfpjra94 R
dept_code_fk int8 19 √ null
code.pk fknpdeeclrflvuxajeqjmk6utf R
metadata_fk int8 19 √ null
metadata.pk fk84fpblugeadm5u6dw1idi80a0 R
perf_phys_name_fk int8 19 √ null
person_name.pk fk5p2gub2u40fyh2ch6bp6nan4l R
study_fk int8 19 null
study.pk fk3196nws7ngapmsmtoafb4e88j R

Indexes

Constraint Name Type Sort Column(s)
series_pkey Primary key Asc pk
fk3196nws7ngapmsmtoafb4e88j Performance Asc study_fk
fk5p2gub2u40fyh2ch6bp6nan4l Performance Asc perf_phys_name_fk
fk6nn55bx7pqlmimgfnhfpjra94 Performance Asc inst_code_fk
fk84fpblugeadm5u6dw1idi80a0 Performance Asc metadata_fk
fknpdeeclrflvuxajeqjmk6utf Performance Asc dept_code_fk
idx1e4aqxc5w1557hr3fb3lqm2qb Performance Asc sending_hl7_facility
idx38mfgfnjhan2yhnwqtcrawe4 Performance Asc compress_time
idx4lnegvfs65fbkjn7nmg9s8usy Performance Asc completeness
idx6xqpk4cvy49wj41p2qwixro8w Performance Asc metadata_update_failures
idx75oc6w5ootkuwyvmrhe3tbown Performance Asc series_no
idx82qea56c0kdhod3b1wu8wbrny Performance Asc institution
idx889438ocqfrvybu3k2eo65lpa Performance Asc compress_failures
idx9fi64g5jjycg9dp24jjk5txg1 Performance Asc series_iuid
idxa8vyikwd972jomyb3f6brcfh5 Performance Asc inst_purge_time
idxachxn1rtfm3fbkkswlsyr75t0 Performance Asc series_desc
idxamr00xwlatxewgj1sjp5mnf76 Performance Asc pps_start_time
idxb126hub0dc1o9dqp6awoispx2 Performance Asc modality
idxb9e2bptvail8xnmb62h30h4d2 Performance Asc sending_aet
idxbqu32v5v76p4qi0etptnrm0pc Performance Asc department
idxd8b8irasiw8eh9tsigmwkbvae Performance Asc series_custom3
idxe15a6qnq8jcq931agc2v48nvt Performance Asc receiving_pres_addr
idxer4ife08f6eaki91gt3hxt5e Performance Asc inst_purge_state
idxffpftwfkijejj09tlbxr7u5g8 Performance Asc sending_hl7_app
idxftv3ijh2ud6ogoknneyqc6t9i Performance Asc stgver_time
idxgj0bxgi55bhjic9s3i4dp2aee Performance Asc receiving_hl7_app
idxgwp46ofa26am9ohhccq1ohdj Performance Asc body_part
idxgxun7s005k8qf7qwhjhkkkkng Performance Asc sending_pres_addr
idxhm39592a9n7m54dgso17irlhv Performance Asc series_custom1
idxhwkcpd7yv0nca7o918wm4bn69 Performance Asc metadata_update_time
idxih49lthl3udoca5opvgsdcerj Performance Asc expiration_state
idxj6aadbh7u93bpmv18s1inrl1r Performance Asc failed_retrieves
idxjlgy9ifvqak4g2bxkchismw8x Performance Asc rejection_state
idxlnck3a2qjo1vc430n1sy51vbr Performance Asc receiving_aet
idxmrn00m45lkq1xbehmbw5d9jbl Performance Asc sop_cuid
idxpbay159cdhwbtjvlmel6d6em2 Performance Asc receiving_hl7_facility
idxpq1yi70ftxhh391lhcq3e08nf Performance Asc station_name
idxq3wayt2ke25fdcghaohhrjiu7 Performance Asc series_custom2
idxr9qbr5jv4ejclglvyvtsynuo9 Performance Asc access_control_id
idxrvlxc150uexwmr1l9ojp8fgd Performance Asc pps_start_date
idxs1vceb8cu9c45j0q8tbldgol9 Performance Asc stgver_failures
idxta3pi6exqft5encv389hwjytw Performance Asc expiration_date
idxtahx0q1ejidnsam40ans7oecx Performance Asc tsuid
idxtbdrfrmkmifsqhpf43065jrbs Performance Asc laterality
series_desc_upper_idx Performance
series_dicomattrs_fk_key Must be unique Asc dicomattrs_fk
series_metadata_fk_key Must be unique Asc metadata_fk
series_perf_phys_name_fk_key Must be unique Asc perf_phys_name_fk
series_study_fk_series_iuid_key Must be unique Asc/Asc study_fk + series_iuid

Check Constraints

Constraint Name Constraint
series_expiration_state_check (((expiration_state >= 0) AND (expiration_state <= 5)))
series_inst_purge_state_check (((inst_purge_state >= 0) AND (inst_purge_state <= 2)))
series_rejection_state_check (((rejection_state >= 0) AND (rejection_state <= 3)))
series_completeness_check (((completeness >= 0) AND (completeness <= 2)))

Relationships

Close relationships within degrees of separation