study

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
pk int8 19 null
rel_study_pcode.study_fk fkta5515ogakmavm1swi6tw1n2n R
series.study_fk fk3196nws7ngapmsmtoafb4e88j R
study_query_attrs.study_fk fkmu32jq25y6qkimi7hn7d4s2hp R
access_control_id varchar 255 null
access_time timestamp 29,6 null
accession_no varchar 255 null
accno_entity_id varchar 255 √ null
accno_entity_uid varchar 255 √ null
accno_entity_uid_type varchar 255 √ null
admission_id varchar 255 null
admid_entity_id varchar 255 √ null
admid_entity_uid varchar 255 √ null
admid_entity_uid_type varchar 255 √ null
completeness int2 5 null
created_time timestamp 29,6 null
study_deleting bool 1 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
modified_time timestamp 29,6 null
rejection_state int2 5 null
study_size int8 19 null
storage_ids varchar 255 √ null
study_custom1 varchar 255 null
study_custom2 varchar 255 null
study_custom3 varchar 255 null
study_date varchar 255 null
study_desc varchar 255 null
study_id varchar 255 null
study_iuid varchar 255 null
study_time varchar 255 null
updated_time timestamp 29,6 null
version int8 19 √ null
dicomattrs_fk int8 19 null
dicomattrs.pk fk2ktu3hbxxalrngfhyp4j6pf70 R
patient_fk int8 19 null
patient.pk fkocnq3so9ej7h0mnd6a6arjf6c R
ref_phys_name_fk int8 19 √ null
person_name.pk fkndwmntu3lsjd78erctnbposyr R

Indexes

Constraint Name Type Sort Column(s)
study_pkey Primary key Asc pk
fkndwmntu3lsjd78erctnbposyr Performance Asc ref_phys_name_fk
fkocnq3so9ej7h0mnd6a6arjf6c Performance Asc patient_fk
idx16t2xvj9ttyvbwh1ijeve01ii Performance Asc study_time
idx24av2ewa70e7cykl340n63aqd Performance Asc access_control_id
idx2ofn5q0fdfc6941e5j34bplmv Performance Asc accession_no
idx6ry2squ4qcv129lxpae1oy93m Performance Asc created_time
idx8xolm3oljt08cuheepwq3fls7 Performance Asc study_custom3
idx9qvng5j8xnli8yif7p0rjngb2 Performance Asc failed_retrieves
idxa1rewlmf8uxfgshk25f6uawx2 Performance Asc study_date
idxcl9dmi0kb97ov1cjh7rn3dhve Performance Asc ext_retrieve_aet
idxfyasyw3wco6hoj2entr7l6d09 Performance Asc expiration_state
idxfypbtohf5skbd3bkyd792a6dt Performance Asc storage_ids
idxgl5rq54a0tr8nreu27c2t04rb Performance Asc completeness
idxhwu9omd369ju3nufufxd3vof2 Performance Asc rejection_state
idxj3q7fkhhiu4bolglyve3lv385 Performance Asc study_desc
idxj63d3ip6x4xslkmyks1l89aay Performance Asc study_custom2
idxksy103xef0hokd33y8ux7afxl Performance Asc study_custom1
idxmlk5pdi8une92kru8g2ppappx Performance Asc expiration_date
idxn5froudmhk14pbhgors43xi68 Performance Asc admission_id
idxq7vxiaj1q6ojfxdq1g9jjxgqv Performance Asc study_size
idxq8k2sl3kjl18qg1nr19l47tl1 Performance Asc access_time
study_desc_upper_idx Performance
study_dicomattrs_fk_key Must be unique Asc dicomattrs_fk
study_ref_phys_name_fk_key Must be unique Asc ref_phys_name_fk
study_study_iuid_key Must be unique Asc study_iuid

Check Constraints

Constraint Name Constraint
study_expiration_state_check (((expiration_state >= 0) AND (expiration_state <= 5)))
study_completeness_check (((completeness >= 0) AND (completeness <= 2)))
study_rejection_state_check (((rejection_state >= 0) AND (rejection_state <= 3)))

Relationships

Close relationships within degrees of separation