Page History

csm_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

csm_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

csm_protection_element

csm_pg_pe.PROTECTION_ELEMENT_I D =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_PROTECTION_GROUP

csm_protection_group

csm_pg_pe.PROTECTION_GROUP_ID
=
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT

csm_application

csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID

FK_PG_APPLICATION

csm_protection_group

csm_protection_group.PARENT_PROT ECTION_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP

csm_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

csm_privilege

csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

csm_role

csm_role_privilege.ROLE_ID = csm_role.ROLE_ID

FK_ROLE

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

csm_group

csm_user_group.GROUP_ID = csm_group.GROUP_ID

FK_UG_GROUP

csm_user

csm_user_group.USER_ID = csm_user.USER_ID

FK_USER_GROUP

csm_group

csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS

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

csm_role

csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE

csm_user

csm_user_group_role_pg.USER_ID = csm_user.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

csm_protection_element

csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_USER

csm_user

csm_user_pe.USER_ID = csm_user.USER_ID

FK_PE_USER

general_image

ct_image.image_pk_id = general_image.image_pk_id

fk_image_pk_id

general_series

ct_image.general_series_pk_id = general_series.general_series_pk_id

ct_image_ibfk_1

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

general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id

patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient

study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id

study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id