pacsdb.public contains 369 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
task	check_different	bool	1	√		null
task	check_missing	bool	1	√		null
global_subscription	deletion_lock	bool	1
subscription	deletion_lock	bool	1
task	update_location_status	bool	1	√		null
dicomattrs	attrs	bytea	2147483647
task	payload	bytea	2147483647	√		null
uidmap	uidmap	bytea	2147483647
instance	availability	int4	10
series_query_attrs	availability	int4	10	√		null
study_query_attrs	availability	int4	10	√		null
task	completed	int4	10	√		null
series	completeness	int4	10
study	completeness	int4	10
series	compress_failures	int4	10
task	different	int4	10
series	expiration_state	int4	10
study	expiration_state	int4	10
task	failed	int4	10	√		null
series	failed_retrieves	int4	10
study	failed_retrieves	int4	10
patient	failed_verifications	int4	10
ups	input_readiness_state	int4	10
instance	inst_no	int4	10	√		null
series	inst_purge_state	int4	10
task	matches	int4	10
series	metadata_update_failures	int4	10
task	missing	int4	10
location	multi_ref	int4	10	√		null
id_sequence	next_value	int4	10
stgcmt_result	num_failures	int4	10	√		null
task	num_failures	int4	10
instance	num_frames	int4	10	√		null
series_query_attrs	num_instances	int4	10	√		null
stgcmt_result	num_instances	int4	10	√		null
study_query_attrs	num_instances	int4	10	√		null
task	num_instances	int4	10	√		null
study_query_attrs	num_series	int4	10	√		null
patient	num_studies	int4	10
location	object_type	int4	10
mpps	pps_status	int4	10
series	rejection_state	int4	10
study	rejection_state	int4	10
task	remaining	int4	10	√		null
series	series_no	int4	10	√		null
mwl_item	sps_status	int4	10
location	status	int4	10
metadata	status	int4	10
task	status_code	int4	10	√		null
task	stgcmt_policy	int4	10	√		null
stgcmt_result	stgcmt_status	int4	10
series	stgver_failures	int4	10
soundex_code	sx_pn_comp	int4	10
soundex_code	sx_pn_comp_part	int4	10
task	task_status	int4	10
task	task_type	int4	10
ups	ups_priority	int4	10
ups	ups_state	int4	10
patient	verification_status	int4	10
task	warning	int4	10
mpps	accno_issuer_fk	int8	19	√		null
mwl_item	accno_issuer_fk	int8	19	√		null
series_req	accno_issuer_fk	int8	19	√		null
study	accno_issuer_fk	int8	19	√		null
ups_req	accno_issuer_fk	int8	19	√		null
mwl_item	admid_issuer_fk	int8	19	√		null
study	admid_issuer_fk	int8	19	√		null
ups	admission_issuer_fk	int8	19	√		null
content_item	code_fk	int8	19	√		null
mwl_item	dept_code_fk	int8	19	√		null
series	dept_code_fk	int8	19	√		null
instance	dicomattrs_fk	int8	19
mpps	dicomattrs_fk	int8	19
mwl_item	dicomattrs_fk	int8	19
patient	dicomattrs_fk	int8	19
rel_task_dicomattrs	dicomattrs_fk	int8	19
series	dicomattrs_fk	int8	19
study	dicomattrs_fk	int8	19
ups	dicomattrs_fk	int8	19
mpps	discreason_code_fk	int8	19	√		null
mwl_item	inst_code_fk	int8	19	√		null
series	inst_code_fk	int8	19	√		null
content_item	instance_fk	int8	19	√		null
location	instance_fk	int8	19	√		null
verify_observer	instance_fk	int8	19	√		null
patient_id	issuer_fk	int8	19	√		null
global_subscription	matchkeys_fk	int8	19	√		null
patient	merge_fk	int8	19	√		null
series	metadata_fk	int8	19	√		null
hl7psu_task	mpps_fk	int8	19	√		null
ian_task	mpps_fk	int8	19	√		null
sps_station_aet	mwl_item_fk	int8	19
content_item	name_fk	int8	19
location	object_size	int8	19
metadata	object_size	int8	19
verify_observer	observer_name_fk	int8	19	√		null
patient	pat_name_fk	int8	19	√		null
mpps	patient_fk	int8	19
mwl_item	patient_fk	int8	19
study	patient_fk	int8	19
ups	patient_fk	int8	19
patient	patient_id_fk	int8	19	√		null
rel_study_pcode	pcode_fk	int8	19
rel_ups_perf_code	perf_code_fk	int8	19
mwl_item	perf_phys_name_fk	int8	19	√		null
series	perf_phys_name_fk	int8	19	√		null
soundex_code	person_name_fk	int8	19
code	pk	int8	19
content_item	pk	int8	19
dicomattrs	pk	int8	19
global_subscription	pk	int8	19
hl7psu_task	pk	int8	19
ian_task	pk	int8	19
instance	pk	int8	19
issuer	pk	int8	19
location	pk	int8	19
metadata	pk	int8	19
mpps	pk	int8	19
mwl_item	pk	int8	19
patient	pk	int8	19
patient_id	pk	int8	19
person_name	pk	int8	19
rejected_instance	pk	int8	19
series	pk	int8	19
series_query_attrs	pk	int8	19
series_req	pk	int8	19
soundex_code	pk	int8	19
stgcmt_result	pk	int8	19
study	pk	int8	19
study_query_attrs	pk	int8	19
subscription	pk	int8	19
task	pk	int8	19
uidmap	pk	int8	19
ups	pk	int8	19
ups_req	pk	int8	19
verify_observer	pk	int8	19
study	ref_phys_name_fk	int8	19	√		null
rejected_instance	reject_code_fk	int8	19	√		null
series_req	req_phys_name_fk	int8	19	√		null
ups_req	req_phys_name_fk	int8	19	√		null
patient	resp_person_fk	int8	19	√		null
instance	series_fk	int8	19
series_query_attrs	series_fk	int8	19
series_req	series_fk	int8	19	√		null
series	series_size	int8	19
instance	srcode_fk	int8	19	√		null
ups	station_class_fk	int8	19	√		null
ups	station_location_fk	int8	19	√		null
ups	station_name_fk	int8	19	√		null
rel_study_pcode	study_fk	int8	19
series	study_fk	int8	19
study_query_attrs	study_fk	int8	19
study	study_size	int8	19
rel_task_dicomattrs	task_fk	int8	19
stgcmt_result	task_fk	int8	19	√		null
location	uidmap_fk	int8	19	√		null
ups	ups_code_fk	int8	19	√		null
rel_ups_perf_code	ups_fk	int8	19
subscription	ups_fk	int8	19
ups_req	ups_fk	int8	19	√		null
id_sequence	version	int8	19	√		null
instance	version	int8	19	√		null
mpps	version	int8	19	√		null
mwl_item	version	int8	19	√		null
patient	version	int8	19	√		null
patient_id	version	int8	19	√		null
series	version	int8	19	√		null
study	version	int8	19	√		null
task	version	int8	19	√		null
ups	version	int8	19	√		null
study	access_time	timestamp	29,6
series	compress_time	timestamp	29,6	√		null
hl7psu_task	created_time	timestamp	29,6
instance	created_time	timestamp	29,6
location	created_time	timestamp	29,6
metadata	created_time	timestamp	29,6
mpps	created_time	timestamp	29,6
mwl_item	created_time	timestamp	29,6
patient	created_time	timestamp	29,6
rejected_instance	created_time	timestamp	29,6
series	created_time	timestamp	29,6
stgcmt_result	created_time	timestamp	29,6
study	created_time	timestamp	29,6
task	created_time	timestamp	29,6
ups	created_time	timestamp	29,6
series	inst_purge_time	timestamp	29,6	√		null
series	metadata_update_time	timestamp	29,6	√		null
study	modified_time	timestamp	29,6
task	proc_end_time	timestamp	29,6	√		null
task	proc_start_time	timestamp	29,6	√		null
hl7psu_task	scheduled_time	timestamp	29,6	√		null
ian_task	scheduled_time	timestamp	29,6	√		null
task	scheduled_time	timestamp	29,6
series	stgver_time	timestamp	29,6	√		null
instance	updated_time	timestamp	29,6
mpps	updated_time	timestamp	29,6
mwl_item	updated_time	timestamp	29,6
patient	updated_time	timestamp	29,6
series	updated_time	timestamp	29,6
stgcmt_result	updated_time	timestamp	29,6
study	updated_time	timestamp	29,6
task	updated_time	timestamp	29,6
ups	updated_time	timestamp	29,6
patient	verification_time	timestamp	29,6	√		null
study	access_control_id	varchar	255
mpps	accession_no	varchar	255
mwl_item	accession_no	varchar	255
series_req	accession_no	varchar	255
study	accession_no	varchar	255
ups_req	accession_no	varchar	255
mwl_item	admission_id	varchar	255
study	admission_id	varchar	255
ups	admission_id	varchar	255
hl7psu_task	aet	varchar	255
person_name	alphabetic_name	varchar	255
stgcmt_result	batch_id	varchar	255	√		null
task	batch_id	varchar	255	√		null
series	body_part	varchar	255
ian_task	calling_aet	varchar	255
code	code_designator	varchar	255
code	code_meaning	varchar	255
code	code_value	varchar	255
code	code_version	varchar	255
task	compare_fields	varchar	255	√		null
series	compress_params	varchar	255	√		null
series	compress_tsuid	varchar	255	√		null
instance	content_date	varchar	255
instance	content_time	varchar	255
series_query_attrs	cuids_in_series	varchar	255	√		null
mwl_item	department	varchar	255
series	department	varchar	255
task	destination_aet	varchar	255	√		null
hl7psu_task	device_name	varchar	255
ian_task	device_name	varchar	255
stgcmt_result	device_name	varchar	255
task	device_name	varchar	255
location	digest	varchar	255	√		null
metadata	digest	varchar	255	√		null
issuer	entity_id	varchar	255	√		null
issuer	entity_uid	varchar	255	√		null
issuer	entity_uid_type	varchar	255	√		null
task	error_comment	varchar	255	√		null
task	error_msg	varchar	255	√		null
ups	expected_end_date_time	varchar	255
series	expiration_date	varchar	255	√		null
study	expiration_date	varchar	255	√		null
ups	expiration_date_time	varchar	255
series	expiration_exporter_id	varchar	255	√		null
study	expiration_exporter_id	varchar	255	√		null
stgcmt_result	exporter_id	varchar	255	√		null
task	exporter_id	varchar	255	√		null
instance	ext_retrieve_aet	varchar	255	√		null
series	ext_retrieve_aet	varchar	255	√		null
study	ext_retrieve_aet	varchar	255
ian_task	ian_dests	varchar	255
person_name	ideographic_name	varchar	255
instance	inst_custom1	varchar	255
instance	inst_custom2	varchar	255
instance	inst_custom3	varchar	255
mwl_item	institution	varchar	255
series	institution	varchar	255
series	laterality	varchar	255
mwl_item	local_aet	varchar	255
task	local_aet	varchar	255	√		null
task	modalities	varchar	255	√		null
mwl_item	modality	varchar	255
series	modality	varchar	255
study_query_attrs	mods_in_study	varchar	255	√		null
id_sequence	name	varchar	255
task	outcome_msg	varchar	255	√		null
patient	pat_birthdate	varchar	255
patient	pat_custom1	varchar	255
patient	pat_custom2	varchar	255
patient	pat_custom3	varchar	255
patient_id	pat_id	varchar	255
patient_id	pat_id_type_code	varchar	255	√		null
patient	pat_sex	varchar	255
ups	performer_aet	varchar	255	√		null
person_name	phonetic_name	varchar	255
series	pps_cuid	varchar	255
series	pps_iuid	varchar	255
mpps	pps_start_date	varchar	255
series	pps_start_date	varchar	255
mpps	pps_start_time	varchar	255
series	pps_start_time	varchar	255
task	query_str	varchar	255	√		null
task	queue_name	varchar	255
series	receiving_aet	varchar	255	√		null
series	receiving_pres_addr	varchar	255	√		null
content_item	rel_type	varchar	255
task	remote_aet	varchar	255	√		null
ups	replaced_iuid	varchar	255
mwl_item	req_proc_id	varchar	255
series_req	req_proc_id	varchar	255
ups_req	req_proc_id	varchar	255
series_req	req_service	varchar	255
ups_req	req_service	varchar	255
instance	retrieve_aets	varchar	255	√		null
series_query_attrs	retrieve_aets	varchar	255	√		null
study_query_attrs	retrieve_aets	varchar	255	√		null
task	rq_host	varchar	255	√		null
task	rq_user_id	varchar	255	√		null
series	sending_aet	varchar	255	√		null
series	sending_pres_addr	varchar	255	√		null
series	series_custom1	varchar	255
series	series_custom2	varchar	255
series	series_custom3	varchar	255
series	series_desc	varchar	255
hl7psu_task	series_iuid	varchar	255	√		null
rejected_instance	series_iuid	varchar	255
series	series_iuid	varchar	255
stgcmt_result	series_iuid	varchar	255	√		null
task	series_iuid	varchar	255	√		null
instance	sop_cuid	varchar	255
rejected_instance	sop_cuid	varchar	255
series	sop_cuid	varchar	255
instance	sop_iuid	varchar	255
mpps	sop_iuid	varchar	255
rejected_instance	sop_iuid	varchar	255
stgcmt_result	sop_iuid	varchar	255	√		null
task	sop_iuid	varchar	255	√		null
mwl_item	sps_id	varchar	255
series_req	sps_id	varchar	255
mwl_item	sps_start_date	varchar	255
mwl_item	sps_start_time	varchar	255
instance	sr_complete	varchar	255
instance	sr_verified	varchar	255
ups	start_date_time	varchar	255
sps_station_aet	station_aet	varchar	255	√		null
series	station_name	varchar	255
location	storage_id	varchar	255
metadata	storage_id	varchar	255
study	storage_ids	varchar	255	√		null
task	storage_ids	varchar	255	√		null
location	storage_path	varchar	255
metadata	storage_path	varchar	255
study	study_custom1	varchar	255
study	study_custom2	varchar	255
study	study_custom3	varchar	255
study	study_date	varchar	255
study	study_desc	varchar	255
study	study_id	varchar	255
hl7psu_task	study_iuid	varchar	255	√		null
ian_task	study_iuid	varchar	255	√		null
mpps	study_iuid	varchar	255
mwl_item	study_iuid	varchar	255
rejected_instance	study_iuid	varchar	255
series_req	study_iuid	varchar	255
stgcmt_result	study_iuid	varchar	255
study	study_iuid	varchar	255
task	study_iuid	varchar	255	√		null
ups_req	study_iuid	varchar	255
study	study_time	varchar	255
global_subscription	subscriber_aet	varchar	255
subscription	subscriber_aet	varchar	255
soundex_code	sx_code_value	varchar	255
content_item	text_value	varchar	255	√		null
ups	transaction_iuid	varchar	255	√		null
stgcmt_result	transaction_uid	varchar	255
location	tsuid	varchar	255	√		null
series	tsuid	varchar	255
ups	ups_iuid	varchar	255
ups	ups_label	varchar	255
verify_observer	verify_datetime	varchar	255
series_query_attrs	view_id	varchar	255	√		null
study_query_attrs	view_id	varchar	255	√		null
ups	worklist_label	varchar	255
study_query_attrs	cuids_in_study	varchar	4000	√		null
task	rq_uri	varchar	4000	√		null