Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
pk |
int8 |
19 |
|
|
|
|
|
access_control_id |
varchar |
255 |
|
|
|
|
|
access_time |
timestamp |
29,6 |
|
|
|
|
|
accession_no |
varchar |
255 |
|
|
|
|
|
created_time |
timestamp |
29,6 |
|
|
|
|
|
failed_retrieves |
int4 |
10 |
|
|
|
|
|
failed_iuids |
varchar |
4000 |
√ |
|
null |
|
|
study_custom1 |
varchar |
255 |
|
|
|
|
|
study_custom2 |
varchar |
255 |
|
|
|
|
|
study_custom3 |
varchar |
255 |
|
|
|
|
|
study_date |
varchar |
255 |
|
|
|
|
|
study_desc |
varchar |
255 |
|
|
|
|
|
study_id |
varchar |
255 |
|
|
|
|
|
study_iuid |
varchar |
255 |
|
|
|
|
|
study_time |
varchar |
255 |
|
|
|
|
|
updated_time |
timestamp |
29,6 |
|
|
|
|
|
version |
int8 |
19 |
√ |
|
null |
|
|
dicomattrs_fk |
int8 |
19 |
|
|
|
|
|
accno_issuer_fk |
int8 |
19 |
√ |
|
null |
|
issuer.pk
|
fk_lp0rdx659kewq8qrqg702yfyv R |
|
patient_fk |
int8 |
19 |
|
|
|
|
patient.pk
|
fk_e3fdaqhw7u60trs5aspf4sna9 R |
|
ref_phys_name_fk |
int8 |
19 |
√ |
|
null |
|
|
storage_ids |
varchar |
255 |
|
|
|
|
|
rejection_state |
int4 |
10 |
|
|
|
|
|
expiration_date |
varchar |
255 |
√ |
|
null |
|
|
Table contained 359 rows at Wed Jun 29 14:02 CEST 2016
|