Page History

csm_group

csm_application.APPLICATION_ID = csm_group.APPLICATION_ID

FK_APPLICATION_GROUP

csm_mapping

csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID

FK_PE_APPLICATION

csm_protection_group

csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D

FK_PG_APPLICATION

csm_role

csm_application.APPLICATION_ID = csm_role.APPLICATION_ID

FK_APPLICATION_ROLE

csm_user_group

csm_group.GROUP_ID = csm_user_group.GROUP_ID

FK_UG_GROUP

csm_user_group_role_pg

csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS

csm_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

csm_pg_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_pg_pe.PROTECTION_ELEMENT_I D

FK_PROTECTION_ELEMENT_PROTECTION_GROUP

_

Table

Join

Title / Name / Description

csm_user_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_user_pe.PROTECTION_ELEMENT_ ID

FK_PROTECTION_ELEMENT_USER

csm_protection_group

csm_protection_group.PROTECTION_ GROUP_ID =
csm_protection_group.PARENT_PROT ECTION_GROUP_ID

FK_PROTECTION_GROUP

csm_pg_pe

csm_protection_group.PROTECTION_ GROUP_ID =
csm_pg_pe.PROTECTION_GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT

csm_user_group_role_pg

csm_protection_group.PROTECTION_ GROUP_ID =
csm_user_group_role_pg.PROTECTIO N_GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP

csm_role_privilege

csm_role.ROLE_ID = csm_role_privilege.ROLE_ID

FK_ROLE

csm_user_group_role_pg

csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE

csm_user_group

csm_user.USER_ID = csm_user_group.USER_ID

FK_USER_GROUP

csm_user_group_role_pg

csm_user.USER_ID = csm_user_group_role_pg.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

csm_user_pe

csm_user.USER_ID = csm_user_pe.USER_ID

FK_PE_USER

query_history

csm_user.USER_ID = query_history.user_id

FK_Q_H_USER_ID

saved_query

csm_user.USER_ID = saved_query.user_id

FK_SAVED_QUERY_USER_ID

custom_series_list_attribute

custom_series_list.CUSTOM_SERIES_LI ST_PK_ID =
custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID

FK_CUSTOM_SERIES_LIST_PK_ID

general_series

general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id

fk_g_equipment_pk_id

ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id

mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID

ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1

general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id

mr_image

general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID

FK_MR_GEN_SERIES_PK_ID

general_image

patient.patient_pk_id = general_image.patient_pk_id

FK_general_image_patient

study

patient.patient_pk_id = study.patient_pk_id

fk_patient_pk_id

query_history_pk_id

bigint(19, 0)

-

-

user_id

bigint(19, 0)

Nullable
References: csm_user

-

query_execute_timestamp

datetime

Nullable

--

query_elapsed_time

bigint(19, 0)

Nullable

-

saved_query_pk_id

bigint(19, 0)

Nullable
References: saved_query

-

tool

varchar(100)

Nullable

query_history

saved_query.saved_query_pk_id = query_history.saved_query_pk_id

fk_s_query_pk_id

saved_query_attribute

saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk
_id

FK_SAVED_QUERY_PK_ID

general_image

study.study_pk_id = general_image.study_pk_id

FK_general_image_study

general_series

study.study_pk_id = general_series.study_pk_id

fk_gs_study_pk_id

patient

trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id

fk_trial_dp_pk_id

site

trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id

fk_tdp_st_pk_id