NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 26

changes.mady.by.user Klinger, Carolyn (NIH/NCI) [C]

Saved on

compared with

New Version Current

changes.mady.by.user Klinger, Carolyn (NIH/NCI) [C]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel

Table of Contents

Legend

IconDescription

Primary key

Primary key

Primary key disabled

Primary key disabled

User-defined primary key

User-defined primary key

Unique key

Unique key

Unique key disabled

Unique key disabled

User-defined unique key

User-defined unique key

Active trigger

Active trigger

Disabled triggerMany to one relation

Disabled trigger Many to one relation

User-defined many to one relationOne to many relation

User-defined many to one relation One to many relation

User-defined one to many relationOne to one relation

User-defined one to many relation One to one relation

User-defined one to one relationImage Modified

 User-defined one to one relation

Input

Input

Output

Output

Input-OutputImage Modified

Input/Output

Uses dependency

Uses dependency

User-defined uses dependency

User-defined uses dependency

Used by dependency

Used by dependency

User-defined used by dependency

User-defined used by dependency

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified

csm_group

csm_application.APPLICATION_ID = csm_group.APPLICATION_ID

FK_APPLICATION_GROUP


One to many relationImage Modified

csm_mapping

csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID

FK_PE_APPLICATION


One to many relationImage Modified


csm_protection_group

csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D

FK_PG_APPLICATION


One to many relationImage Modified

csm_role

csm_application.APPLICATION_ID = csm_role.APPLICATION_ID

FK_APPLICATION_ROLE

...

Key

Columns

Name / Description

Primary keyImage Modified

PROPERTY_KEY

PRIMARY

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

csm_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

csm_user_group

csm_group.GROUP_ID = csm_user_group.GROUP_ID

FK_UG_GROUP

One to many relationImage Modified

csm_user_group_role_pg

csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

csm_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified


csm_protection_element

csm_pg_pe.PROTECTION_ELEMENT_I D =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_PROTECTION_GROUP

Disabled triggerImage Modified


csm_protection_group

csm_pg_pe.PROTECTION_GROUP_ID
=
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

csm_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

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

One to many relationImage Modified

csm_user_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_user_pe.PROTECTION_ELEMENT_ ID

FK_PROTECTION_ELEMENT_USER

...

Key

Columns

Name / Description

Primary keyImage Modified

PROTECTION_ELEMENT_ID

PRIMARY


Unique key

OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

csm_application

csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID

FK_PG_APPLICATION



Disabled triggerImage Modified


csm_protection_group

csm_protection_group.PARENT_PROT ECTION_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP

...

Relationship

Table

Join

Title / Name / Description



One to many relationImage Modified


csm_protection_group

csm_protection_group.PROTECTION_ GROUP_ID =
csm_protection_group.PARENT_PROT ECTION_GROUP_ID

FK_PROTECTION_GROUP


One to many relationImage Modified


csm_pg_pe

csm_protection_group.PROTECTION_ GROUP_ID =
csm_pg_pe.PROTECTION_GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT



One to many relationImage Modified


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

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

csm_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified

csm_role_privilege

csm_role.ROLE_ID = csm_role_privilege.ROLE_ID

FK_ROLE


One to many relationImage Modified

csm_user_group_role_pg

csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE

...

Key

Columns

Name / Description

Primary keyImage Modified

ROLE_ID

PRIMARY


Unique key

APPLICATION_ID, ROLE_NAME

UQ_ROLE_ROLE_NAME

...

Key

Name

Data type

Description / Attributes

Image RemovedPrimary keyImage Added

ROLE_PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment


Unique key

ROLE_ID

bigint(19, 0)

References: csm_role


Unique key

PRIVILEGE_ID

bigint(19, 0)

References: csm_privilege

_

UPDATE_DATE

date

Default: 1950-01-01

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

csm_privilege

csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE


Disabled triggerImage Modified

csm_role

csm_role_privilege.ROLE_ID = csm_role.ROLE_ID

FK_ROLE

...

Key

Name

Data type

Description / Attributes


Primary key

USER_ID

bigint(19, 0)

Identity / Auto increment

_

LOGIN_NAME

varchar(500)

Nullable

__

FIRST_NAME

varchar(100)


_

LAST_NAME

varchar(100)


__

ORGANIZATION

varchar(500)

Nullable

__

DEPARTMENT

varchar(100)

Nullable

_

TITLE

varchar(100)

Nullable

_

PHONE_NUMBER

varchar(100)

Nullable

_

PASSWORD

varchar(100)

Nullable

_

EMAIL_ID

varchar(100)

Nullable

_

START_DATE

date

Nullable

_

END_DATE

date

Nullable

_

UPDATE_DATE

date

Default: 1950-01-01

_

MIDDLE_NAME

varchar(100)

Nullable

_

FAX

varchar(20)

Nullable

_

ADDRESS

varchar(200)

Nullable

_

CITY

varchar(100)

Nullable

_

STATE

varchar(100)

Nullable

_

COUNTRY

varchar(100)

Nullable

_

POSTAL_CODE

varchar(10)

Nullable

_

MIGRATED_FLAG

tinyint(3, 0)

Default: 0

_

PREMGRT_LOGIN_NAME

varchar(100)

Nullable

_

PASSWORD_EXPIRED

tinyint(3, 0)

Nullable Default: 0

_

FIRST_TIME_LOGIN

tinyint(3, 0)

Nullable Default: 0

_

ACTIVE_FLAG

tinyint(3, 0)

Nullable Default: 1

_

PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified

csm_user_group

csm_user.USER_ID = csm_user_group.USER_ID

FK_USER_GROUP


One to many relationImage Modified

csm_user_group_role_pg

csm_user.USER_ID = csm_user_group_role_pg.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER


One to many relationImage Modified

csm_user_pe

csm_user.USER_ID = csm_user_pe.USER_ID

FK_PE_USER


One to many relationImage Modified

query_history

csm_user.USER_ID = query_history.user_id

FK_Q_H_USER_ID


One to many relationImage Modified

saved_query

csm_user.USER_ID = saved_query.user_id

FK_SAVED_QUERY_USER_ID

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

csm_group

csm_user_group.GROUP_ID = csm_group.GROUP_ID

FK_UG_GROUP


Disabled triggerImage Modified

csm_user

csm_user_group.USER_ID = csm_user.USER_ID

FK_USER_GROUP

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

csm_group

csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS



Disabled triggerImage Modified


csm_protection_group

csm_user_group_role_pg.PROTECTIO N_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP


Disabled triggerImage Modified

csm_role

csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE


Disabled triggerImage Modified

csm_user

csm_user_group_role_pg.USER_ID = csm_user.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified


csm_protection_element

csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_USER


Disabled triggerImage Modified

csm_user

csm_user_pe.USER_ID = csm_user.USER_ID

FK_PE_USER

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

general_image

ct_image.image_pk_id = general_image.image_pk_id

fk_image_pk_id


Disabled triggerImage Modified

general_series

ct_image.general_series_pk_id = general_series.general_series_pk_id

ct_image_ibfk_1

...

Key

Columns

Name / Description


Primary keyImage Modified

ct_image_pk_id

PRIMARY


Unique key

ct_image_pk_id

PK_CT_IMAGE_PK_ID

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified


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

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified


custom_series_list

custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID =
custom_series_list.CUSTOM_SERIES_LI ST_PK_ID

FK_CUSTOM_SERIES_LIST_PK_ID

...

Key

Name

Data type

Description / Attributes

Image RemovedPrimary keyImage Added

download_data_history_pk_id

bigint(19, 0)

-

-

series_instance_uid

varchar(64)

Nullable

-

login_name

varchar(100)

Nullable

-

download_timestamp

date

Nullable

-

download_type

varchar(20)

Nullable

-

size_

decimal(22, 2)

Nullable

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified


general_series

general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id

fk_g_equipment_pk_id

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id


Disabled triggerImage Modified

patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient


Disabled triggerImage Modified

study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id


One to many relationImage Modified

mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id


Disabled triggerImage Modified

study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified

ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1


One to many relationImage Modified

general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id


One to many relationImage Modified

mr_image

general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID

FK_MR_GEN_SERIES_PK_ID

...

Key

Columns

Name / Description

Primary keyImage Modified

modality_descriptions_pk_id

PRIMARY


Unique key

modality_descriptions_pk_id

MD_COLLECTION_DESC_PK_ID

...

Key

Name

Data type

Description / Attributes

-

IMAGE_TYPE_VALUE_3

varchar(16)

-

-

SCANNING_SEQUENCE

varchar(126)

-

-

SEQUENCE_VARIANT

varchar(126)

-

-

REPETITION_TIME

decimal(22, 10)

Nullable

-

ECHO_TIME

decimal(22, 10)

Nullable

-

INVERSION_TIME

decimal(22, 10)

Nullable

-

SEQUENCE_NAME

varchar(64)

Nullable

-

IMAGED_NUCLEUS

varchar(64)

Nullable

-

MAGNETIC_FIELD_STRENGTH

decimal(22, 10)

Nullable

-

SAR

decimal(22, 10)

Nullable

-

DB_DT

decimal(22, 10)

Nullable

-

TRIGGER_TIME

decimal(22, 10)

Nullable

-

ANGIO_FLAG

varchar(1)

Nullable

-

IMAGE_PK_ID

bigint(19, 0)

References: general_image

Image RemovedPrimary keyImage Added

MR_IMAGE_PK_ID

bigint(19, 0)

Identity / Auto increment

-

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable
References: general_series

...

Relationship

Table

Join

Title / Name / Description


Disabled triggerImage Modified

general_image

mr_image.IMAGE_PK_ID = general_image.image_pk_id

FK_MR_GEN_IMAGE_PK_ID


Disabled triggerImage Modified

general_series

mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id

FK_MR_GEN_SERIES_PK_ID

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

trial_data_provenance

patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id

fk_trial_dp_pk_id

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

general_image

patient.patient_pk_id = general_image.patient_pk_id

FK_general_image_patient


One to many relationImage Modified

study

patient.patient_pk_id = study.patient_pk_id

fk_patient_pk_id

...

Key

Name

Data type

Description / Attributes

Primary key

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

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

csm_user

query_history.user_id = csm_user.USER_ID

FK_Q_H_USER_ID


Disabled triggerImage Modified

saved_query

query_history.saved_query_pk_id = saved_query.saved_query_pk_id

fk_s_query_pk_id

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

query_history_attribute

query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id

FK_Q_H_PK_ID

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

query_history

query_history_attribute.query_history_ pk_id = query_history.query_history_pk_id

FK_Q_H_PK_ID

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

csm_user

saved_query.user_id = csm_user.USER_ID

FK_SAVED_QUERY_USER_ID

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

query_history

saved_query.saved_query_pk_id = query_history.saved_query_pk_id

fk_s_query_pk_id


One to many relationImage Modified


saved_query_attribute

saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk
_id

FK_SAVED_QUERY_PK_ID

...

Key

Name

Data type

Description / Attributes

Image RemovedPrimary keyImage Added

saved_query_attribute_pk_id

bigint(19, 0)

-

-

attribute_name

varchar(300)

Nullable

-

subattribute_name

varchar(300)

Nullable

-

attribute_value

varchar(300)

Nullable

-

saved_query_pk_id

bigint(19, 0)

Nullable
References: saved_query

-

Name

Data type

Description / Attributes

-

instance_number

bigint(19, 0)

Nullable

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

saved_query

saved_query_attribute.saved_query_pk
_id = saved_query.saved_query_pk_id

FK_SAVED_QUERY_PK_ID

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

trial_data_provenance

site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id

fk_tdp_st_pk_id

...

Relationship

Table

Join

Title / Name / Description

Disabled triggerImage Modified

patient

study.patient_pk_id = patient.patient_pk_id

fk_patient_pk_id

...

Relationship

Table

Join

Title / Name / Description

One to many relationImage Modified

general_image

study.study_pk_id = general_image.study_pk_id

FK_general_image_study


One to many relationImage Modified

general_series

study.study_pk_id = general_series.study_pk_id

fk_gs_study_pk_id

...

Relationship

Table

Join

Title / Name / Description


One to many relationImage Modified

patient

trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id

fk_trial_dp_pk_id


One to many relationImage Modified

site

trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id

fk_tdp_st_pk_id

...