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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
code	code_designator	varchar	255
code	code_meaning	varchar	255
code	code_value	varchar	255
code	code_version	varchar	255
code	pk	int8	19
content_item	code_fk	int8	19	√		null
content_item	instance_fk	int8	19	√		null
content_item	name_fk	int8	19
content_item	pk	int8	19
content_item	rel_type	varchar	255
content_item	text_value	varchar	255	√		null
dicomattrs	attrs	bytea	2147483647
dicomattrs	pk	int8	19
diff_task	check_different	bool	1
diff_task	check_missing	bool	1
diff_task	compare_fields	varchar	255	√		null
diff_task	created_time	timestamp	29,6
diff_task	different	int4	10
diff_task	local_aet	varchar	255
diff_task	matches	int4	10
diff_task	missing	int4	10
diff_task	pk	int8	19
diff_task	primary_aet	varchar	255
diff_task	query_str	varchar	255
diff_task	queue_msg_fk	int8	19
diff_task	secondary_aet	varchar	255
diff_task	updated_time	timestamp	29,6
diff_task_attrs	dicomattrs_fk	int8	19
diff_task_attrs	diff_task_fk	int8	19
export_task	batch_id	varchar	255	√		null
export_task	created_time	timestamp	29,6
export_task	device_name	varchar	255
export_task	exporter_id	varchar	255
export_task	modalities	varchar	255	√		null
export_task	num_instances	int4	10	√		null
export_task	pk	int8	19
export_task	queue_msg_fk	int8	19	√		null
export_task	scheduled_time	timestamp	29,6	√		null
export_task	series_iuid	varchar	255
export_task	sop_iuid	varchar	255
export_task	study_iuid	varchar	255
export_task	updated_time	timestamp	29,6
export_task	version	int8	19	√		null
global_subscription	deletion_lock	bool	1
global_subscription	matchkeys_fk	int8	19	√		null
global_subscription	pk	int8	19
global_subscription	subscriber_aet	varchar	255
hl7psu_task	aet	varchar	255
hl7psu_task	created_time	timestamp	29,6
hl7psu_task	device_name	varchar	255
hl7psu_task	mpps_fk	int8	19	√		null
hl7psu_task	pk	int8	19
hl7psu_task	scheduled_time	timestamp	29,6	√		null
hl7psu_task	study_iuid	varchar	255	√		null
ian_task	calling_aet	varchar	255
ian_task	device_name	varchar	255
ian_task	ian_dests	varchar	255
ian_task	mpps_fk	int8	19	√		null
ian_task	pk	int8	19
ian_task	scheduled_time	timestamp	29,6	√		null
ian_task	study_iuid	varchar	255	√		null
id_sequence	name	varchar	255
id_sequence	next_value	int4	10
id_sequence	version	int8	19	√		null
instance	availability	int4	10
instance	content_date	varchar	255
instance	content_time	varchar	255
instance	created_time	timestamp	29,6
instance	dicomattrs_fk	int8	19
instance	ext_retrieve_aet	varchar	255	√		null
instance	inst_custom1	varchar	255
instance	inst_custom2	varchar	255
instance	inst_custom3	varchar	255
instance	inst_no	int4	10	√		null
instance	num_frames	int4	10	√		null
instance	pk	int8	19
instance	retrieve_aets	varchar	255	√		null
instance	series_fk	int8	19
instance	sop_cuid	varchar	255
instance	sop_iuid	varchar	255
instance	sr_complete	varchar	255
instance	sr_verified	varchar	255
instance	srcode_fk	int8	19	√		null
instance	updated_time	timestamp	29,6
instance	version	int8	19	√		null
issuer	entity_id	varchar	255	√		null
issuer	entity_uid	varchar	255	√		null
issuer	entity_uid_type	varchar	255	√		null
issuer	pk	int8	19
location	created_time	timestamp	29,6
location	digest	varchar	255	√		null
location	instance_fk	int8	19	√		null
location	multi_ref	int4	10	√		null
location	object_size	int8	19
location	object_type	int4	10
location	pk	int8	19
location	status	int4	10
location	storage_id	varchar	255
location	storage_path	varchar	255
location	tsuid	varchar	255	√		null
location	uidmap_fk	int8	19	√		null
metadata	created_time	timestamp	29,6
metadata	digest	varchar	255	√		null
metadata	object_size	int8	19
metadata	pk	int8	19
metadata	status	int4	10
metadata	storage_id	varchar	255
metadata	storage_path	varchar	255
mpps	accession_no	varchar	255
mpps	accno_issuer_fk	int8	19	√		null
mpps	created_time	timestamp	29,6
mpps	dicomattrs_fk	int8	19
mpps	discreason_code_fk	int8	19	√		null
mpps	patient_fk	int8	19
mpps	pk	int8	19
mpps	pps_start_date	varchar	255
mpps	pps_start_time	varchar	255
mpps	pps_status	int4	10
mpps	sop_iuid	varchar	255
mpps	study_iuid	varchar	255
mpps	updated_time	timestamp	29,6
mpps	version	int8	19	√		null
mwl_item	accession_no	varchar	255
mwl_item	accno_issuer_fk	int8	19	√		null
mwl_item	created_time	timestamp	29,6
mwl_item	dicomattrs_fk	int8	19
mwl_item	modality	varchar	255
mwl_item	patient_fk	int8	19
mwl_item	perf_phys_name_fk	int8	19	√		null
mwl_item	pk	int8	19
mwl_item	req_proc_id	varchar	255
mwl_item	sps_id	varchar	255
mwl_item	sps_start_date	varchar	255
mwl_item	sps_start_time	varchar	255
mwl_item	sps_status	int4	10
mwl_item	study_iuid	varchar	255
mwl_item	updated_time	timestamp	29,6
mwl_item	version	int8	19	√		null
patient	created_time	timestamp	29,6
patient	dicomattrs_fk	int8	19
patient	failed_verifications	int4	10
patient	merge_fk	int8	19	√		null
patient	num_studies	int4	10
patient	pat_birthdate	varchar	255
patient	pat_custom1	varchar	255
patient	pat_custom2	varchar	255
patient	pat_custom3	varchar	255
patient	pat_name_fk	int8	19	√		null
patient	pat_sex	varchar	255
patient	patient_id_fk	int8	19	√		null
patient	pk	int8	19
patient	resp_person_fk	int8	19	√		null
patient	updated_time	timestamp	29,6
patient	verification_status	int4	10
patient	verification_time	timestamp	29,6	√		null
patient	version	int8	19	√		null
patient_id	issuer_fk	int8	19	√		null
patient_id	pat_id	varchar	255
patient_id	pat_id_type_code	varchar	255	√		null
patient_id	pk	int8	19
patient_id	version	int8	19	√		null
person_name	family_name	varchar	255	√		null
person_name	given_name	varchar	255	√		null
person_name	i_family_name	varchar	255	√		null
person_name	i_given_name	varchar	255	√		null
person_name	i_middle_name	varchar	255	√		null
person_name	i_name_prefix	varchar	255	√		null
person_name	i_name_suffix	varchar	255	√		null
person_name	middle_name	varchar	255	√		null
person_name	name_prefix	varchar	255	√		null
person_name	name_suffix	varchar	255	√		null
person_name	p_family_name	varchar	255	√		null
person_name	p_given_name	varchar	255	√		null
person_name	p_middle_name	varchar	255	√		null
person_name	p_name_prefix	varchar	255	√		null
person_name	p_name_suffix	varchar	255	√		null
person_name	pk	int8	19
queue_msg	batch_id	varchar	255	√		null
queue_msg	created_time	timestamp	29,6
queue_msg	device_name	varchar	255
queue_msg	error_msg	varchar	255	√		null
queue_msg	msg_body	bytea	2147483647
queue_msg	msg_id	varchar	255
queue_msg	msg_props	varchar	4000
queue_msg	msg_status	int4	10
queue_msg	num_failures	int4	10
queue_msg	outcome_msg	varchar	255	√		null
queue_msg	pk	int8	19
queue_msg	priority	int4	10
queue_msg	proc_end_time	timestamp	29,6	√		null
queue_msg	proc_start_time	timestamp	29,6	√		null
queue_msg	queue_name	varchar	255
queue_msg	scheduled_time	timestamp	29,6
queue_msg	updated_time	timestamp	29,6
queue_msg	version	int8	19	√		null
rejected_instance	created_time	timestamp	29,6
rejected_instance	pk	int8	19
rejected_instance	reject_code_fk	int8	19	√		null
rejected_instance	series_iuid	varchar	255
rejected_instance	sop_cuid	varchar	255
rejected_instance	sop_iuid	varchar	255
rejected_instance	study_iuid	varchar	255
rel_study_pcode	pcode_fk	int8	19
rel_study_pcode	study_fk	int8	19
rel_ups_perf_code	perf_code_fk	int8	19
rel_ups_perf_code	ups_fk	int8	19
retrieve_task	batch_id	varchar	255	√		null
retrieve_task	completed	int4	10
retrieve_task	created_time	timestamp	29,6
retrieve_task	destination_aet	varchar	255
retrieve_task	device_name	varchar	255
retrieve_task	error_comment	varchar	255	√		null
retrieve_task	failed	int4	10
retrieve_task	local_aet	varchar	255
retrieve_task	pk	int8	19
retrieve_task	queue_msg_fk	int8	19	√		null
retrieve_task	queue_name	varchar	255
retrieve_task	remaining	int4	10
retrieve_task	remote_aet	varchar	255
retrieve_task	scheduled_time	timestamp	29,6	√		null
retrieve_task	series_iuid	varchar	255	√		null
retrieve_task	sop_iuid	varchar	255	√		null
retrieve_task	status_code	int4	10
retrieve_task	study_iuid	varchar	255
retrieve_task	updated_time	timestamp	29,6
retrieve_task	warning	int4	10
series	body_part	varchar	255
series	completeness	int4	10
series	compress_failures	int4	10
series	compress_params	varchar	255	√		null
series	compress_time	timestamp	29,6	√		null
series	compress_tsuid	varchar	255	√		null
series	created_time	timestamp	29,6
series	department	varchar	255
series	dicomattrs_fk	int8	19
series	expiration_date	varchar	255	√		null
series	expiration_exporter_id	varchar	255	√		null
series	expiration_state	int4	10
series	ext_retrieve_aet	varchar	255	√		null
series	failed_retrieves	int4	10
series	inst_code_fk	int8	19	√		null
series	inst_purge_state	int4	10
series	inst_purge_time	timestamp	29,6	√		null
series	institution	varchar	255
series	laterality	varchar	255
series	metadata_fk	int8	19	√		null
series	metadata_update_failures	int4	10
series	metadata_update_time	timestamp	29,6	√		null
series	modality	varchar	255
series	perf_phys_name_fk	int8	19	√		null
series	pk	int8	19
series	pps_cuid	varchar	255
series	pps_iuid	varchar	255
series	pps_start_date	varchar	255
series	pps_start_time	varchar	255
series	rejection_state	int4	10
series	series_custom1	varchar	255
series	series_custom2	varchar	255
series	series_custom3	varchar	255
series	series_desc	varchar	255
series	series_iuid	varchar	255
series	series_no	int4	10	√		null
series	series_size	int8	19
series	sop_cuid	varchar	255
series	src_aet	varchar	255	√		null
series	station_name	varchar	255
series	stgver_failures	int4	10
series	stgver_time	timestamp	29,6	√		null
series	study_fk	int8	19
series	tsuid	varchar	255
series	updated_time	timestamp	29,6
series	version	int8	19	√		null
series_query_attrs	availability	int4	10	√		null
series_query_attrs	cuids_in_series	varchar	255	√		null
series_query_attrs	num_instances	int4	10	√		null
series_query_attrs	pk	int8	19
series_query_attrs	retrieve_aets	varchar	255	√		null
series_query_attrs	series_fk	int8	19
series_query_attrs	view_id	varchar	255	√		null
series_req	accession_no	varchar	255
series_req	accno_issuer_fk	int8	19	√		null
series_req	pk	int8	19
series_req	req_phys_name_fk	int8	19	√		null
series_req	req_proc_id	varchar	255
series_req	req_service	varchar	255
series_req	series_fk	int8	19	√		null
series_req	sps_id	varchar	255
series_req	study_iuid	varchar	255
soundex_code	person_name_fk	int8	19
soundex_code	pk	int8	19
soundex_code	sx_code_value	varchar	255
soundex_code	sx_pn_comp	int4	10
soundex_code	sx_pn_comp_part	int4	10
sps_station_aet	mwl_item_fk	int8	19
sps_station_aet	station_aet	varchar	255	√		null
stgcmt_result	batch_id	varchar	255	√		null
stgcmt_result	created_time	timestamp	29,6
stgcmt_result	device_name	varchar	255
stgcmt_result	exporter_id	varchar	255	√		null
stgcmt_result	msg_id	varchar	255	√		null
stgcmt_result	num_failures	int4	10	√		null
stgcmt_result	num_instances	int4	10	√		null
stgcmt_result	pk	int8	19
stgcmt_result	series_iuid	varchar	255	√		null
stgcmt_result	sop_iuid	varchar	255	√		null
stgcmt_result	stgcmt_status	int4	10
stgcmt_result	study_iuid	varchar	255
stgcmt_result	transaction_uid	varchar	255
stgcmt_result	updated_time	timestamp	29,6
stgver_task	completed	int4	10
stgver_task	created_time	timestamp	29,6
stgver_task	failed	int4	10
stgver_task	local_aet	varchar	255
stgver_task	pk	int8	19
stgver_task	queue_msg_fk	int8	19
stgver_task	series_iuid	varchar	255	√		null
stgver_task	sop_iuid	varchar	255	√		null
stgver_task	stgcmt_policy	int4	10	√		null
stgver_task	storage_ids	varchar	255	√		null
stgver_task	study_iuid	varchar	255
stgver_task	update_location_status	bool	1	√		null
stgver_task	updated_time	timestamp	29,6
study	access_control_id	varchar	255
study	access_time	timestamp	29,6
study	accession_no	varchar	255
study	accno_issuer_fk	int8	19	√		null
study	completeness	int4	10
study	created_time	timestamp	29,6
study	dicomattrs_fk	int8	19
study	expiration_date	varchar	255	√		null
study	expiration_exporter_id	varchar	255	√		null
study	expiration_state	int4	10
study	ext_retrieve_aet	varchar	255
study	failed_retrieves	int4	10
study	modified_time	timestamp	29,6
study	patient_fk	int8	19
study	pk	int8	19
study	ref_phys_name_fk	int8	19	√		null
study	rejection_state	int4	10
study	storage_ids	varchar	255	√		null
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
study	study_iuid	varchar	255
study	study_size	int8	19
study	study_time	varchar	255
study	updated_time	timestamp	29,6
study	version	int8	19	√		null
study_query_attrs	availability	int4	10	√		null
study_query_attrs	cuids_in_study	varchar	255	√		null
study_query_attrs	mods_in_study	varchar	255	√		null
study_query_attrs	num_instances	int4	10	√		null
study_query_attrs	num_series	int4	10	√		null
study_query_attrs	pk	int8	19
study_query_attrs	retrieve_aets	varchar	255	√		null
study_query_attrs	study_fk	int8	19
study_query_attrs	view_id	varchar	255	√		null
subscription	deletion_lock	bool	1
subscription	pk	int8	19
subscription	subscriber_aet	varchar	255
subscription	ups_fk	int8	19
uidmap	pk	int8	19
uidmap	uidmap	bytea	2147483647
ups	admission_id	varchar	255
ups	admission_issuer_fk	int8	19	√		null
ups	created_time	timestamp	29,6
ups	dicomattrs_fk	int8	19
ups	expected_end_date_time	varchar	255
ups	expiration_date_time	varchar	255
ups	input_readiness_state	int4	10
ups	patient_fk	int8	19
ups	performer_aet	varchar	255	√		null
ups	pk	int8	19
ups	replaced_iuid	varchar	255
ups	start_date_time	varchar	255
ups	station_class_fk	int8	19	√		null
ups	station_location_fk	int8	19	√		null
ups	station_name_fk	int8	19	√		null
ups	transaction_iuid	varchar	255	√		null
ups	updated_time	timestamp	29,6
ups	ups_code_fk	int8	19	√		null
ups	ups_iuid	varchar	255
ups	ups_label	varchar	255
ups	ups_priority	int4	10
ups	ups_state	int4	10
ups	version	int8	19	√		null
ups	worklist_label	varchar	255
ups_req	accession_no	varchar	255
ups_req	accno_issuer_fk	int8	19	√		null
ups_req	pk	int8	19
ups_req	req_phys_name_fk	int8	19	√		null
ups_req	req_proc_id	varchar	255
ups_req	req_service	varchar	255
ups_req	study_iuid	varchar	255
ups_req	ups_fk	int8	19	√		null
verify_observer	instance_fk	int8	19	√		null
verify_observer	observer_name_fk	int8	19	√		null
verify_observer	pk	int8	19
verify_observer	verify_datetime	varchar	255