Page History

Versions Compared

Key

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

Panel

Table of Contents

Legend

...

NBIA

...

Icon	Description
Image Added	Primary key
Image Added	Primary key disabled
Image Added	User-defined primary key
Image Added	Unique key
Image Added	Unique key disabled
Image Added	User-defined unique key
Image Added	Active trigger
Image AddedImage Added

Disabled trigger Many to one relation
Image ModifiedImage Modified	User-defined many to one relation One to many relation
Image ModifiedImage Modified	User-defined one to many

...

relation One to one relation

Image Modified

...

	User-defined one to one relation
Image Modified	Input
Image Modified	Output
Image Modified	Input/Output
Image Modified	Uses dependency
Image Modified	User-defined uses dependency
Image Modified	Used by dependency
Image Modified	User-defined used by dependency

...

Tables

...

Columns for

...

Table: collection_descriptions

...

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

collection_descriptions_pk_id

bigint(19, 0)

Image Removed

collection_name

varchar(64)

Nullable

Image Removed

user_name

varchar(20)

Nullable

Image Removed

description

mediumtext

Nullable

Image Removed

collection_descriptions_timest

date

Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	collection_descriptions_pk_id	PRIMARY
Image Modified	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

...

Columns for Table: csm_

...

application

...

Key

Image Removed

Name	Data type	Description / Attributes

Image Removed

Image Added

APPLICATION_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

Image Removed

APPLICATION_NAME

varchar(255)

Image Removed

APPLICATION_DESCRIPTION

varchar(200)

Image Removed

DECLARATIVE_FLAG

tinyint(3, 0)

Default: 0

Image Removed

ACTIVE_FLAG

tinyint(3, 0)

Default: 0

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

DATABASE_URL

varchar(100)

Nullable

Image Removed

DATABASE_USER_NAME

varchar(100)

Nullable

Image Removed

DATABASE_PASSWORD

varchar(100)

Nullable

Image Removed

DATABASE_DIALECT

varchar(100)

Nullable

Image Removed

DATABASE_DRIVER

varchar(100)

Nullable

Image Removed

CSM_VERSION

varchar(20)

Nullable

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_application.APPLICATION_ID = csm_group.APPLICATION_ID	FK_APPLICATION_GROUP
Image Modified	csm_mapping	csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID	FK_PE_APPLICATION

Table

Join

Title / Name / Description

Image Modified	csm_protection_group	csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D	FK_PG_APPLICATION
Image Modified	csm_role	csm_application.APPLICATION_ID = csm_role.APPLICATION_ID	FK_APPLICATION_ROLE

Unique keys

...

Key	Columns	Name / Description
Image Modified	APPLICATION_ID	PRIMARY
Image Modified	APPLICATION_NAME	UQ_APPLICATION_NAME

...

Table: csm_configuration_props

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

PROPERTY_KEY

varchar(300)

Image Removed

PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys

Key	Columns	Name

/ Description

Image Removed

PROPERTY_KEY

PRIMARY

...

/ Description
Image Added	PROPERTY_KEY	PRIMARY

...

Table: csm_filter_clause

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

FILTER_CLAUSE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

CLASS_NAME

varchar(100)

Image Removed

FILTER_CHAIN

varchar(2000)

Image Removed

TARGET_CLASS_NAME

varchar(100)

Image Removed

TARGET_CLASS_ATTRIBUTE_NAME

varchar(100)

Image Removed

TARGET_CLASS_ATTRIBUTE_TYPE

varchar(100)

Image Removed

TARGET_CLASS_ALIAS

varchar(100)

Nullable

Image Removed

TARGET_CLASS_ATTRIBUTE_ALIAS

varchar(100)

Nullable

Image Removed

GENERATED_SQL_USER

varchar(4000)

Image Removed

APPLICATION_ID

bigint(19, 0)

Image Removed

UPDATE_DATE

date

Image Removed

GENERATED_SQL_GROUP

varchar(4000)

Unique keys

...

Key	Columns	Name / Description
Image Modified	FILTER_CLAUSE_ID	PRIMARY

...

Table: csm_group

...

...
Columns
...

Image Removed
Key
Name
Data type
Description / Attributes
Image Removed

Image Added
GROUP_ID
bigint(19, 0)
Identity / Auto increment
Image Removed Image Removed

Image Added
GROUP_NAME
varchar(255)

_
Image Removed
_
GROUP_DESC
varchar(200)
Nullable
Image Removed Image Removed
_
UPDATE_DATE
date
Default: 1950-01-01
Image Removed

Image Added
APPLICATION_ID
bigint(19, 0)
References: csm_application
Links to

Relationship
Table
Join
Title / Name / Description
Image Modified
csm_application
csm_group.APPLICATION_ID = csm_application.APPLICATION_ID
FK_APPLICATION_GROUP
Linked from

Relationship
Table
Join
Title / Name / Description
Image Modified
csm_user_group
csm_group.GROUP_ID = csm_user_group.GROUP_ID
FK_UG_GROUP
Image Modified
csm_user_group_role_pg
csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID
FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
Unique keys
...

Key
Columns
Name / Description
Image Modified
GROUP_ID
PRIMARY
Image Modified
APPLICATION_ID, GROUP_NAME
UQ_GROUP_GROUP_
NAME
...
NAM_

Table: csm_mapping

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

MAPPING_ID

bigint(19, 0)

Identity _/ Auto increment

Image Removed

Image Added

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed

OBJECT_NAME

varchar(100)

Image Removed

Image Added

Image Removed

ATTRIBUTE_NAME

varchar(100)

Image Removed

OBJECT_PACKAGE_NAME

varchar(100)

Nullable

Image Removed

TABLE_NAME

varchar(100)

Nullable

Image Removed

TABLE_NAME_GROUP

varchar(100)

Nullable

Image Removed

TABLE_NAME_USER

varchar(100)

Nullable

Image Removed

VIEW_NAME_GROUP

varchar(100)

Nullable

Image Removed

VIEW_NAME_USER

varchar(100)

Nullable

Image Removed

ACTIVE_FLAG

tinyint(3, 0)

Default: 0

Image Removed

MAINTAINED_FLAG

tinyint(3, 0)

Default: 0

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID	FK_PE_APPLICATION

Unique keys

...

Key	Columns	Name / Description
Image Modified	MAPPING_ID	PRIMARY
Image Modified	OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID	UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

...

Table: csm_password_history

Columns

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

LOGIN_NAME

varchar(500)

Nullable

Image Removed

PASSWORD

varchar(255)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	CSM_PASSWORD_HISTORY_ID	PRIMARY

...

Table: csm_pg_pe

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

PG_PE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group

Image Removed

Image Added

PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_protection_element	csm_pg_pe.PROTECTION_ELEMENT_I D = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_PROTECTION_GROUP
Image Modified	csm_protection_group	csm_pg_pe.PROTECTION_GROUP_ID = csm_protection_group.PROTECTION_ GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT

Unique keys

...

Key	Columns	Name / Description
Image Modified	PG_PE_ID	PRIMARY

Columns

Name / Description


Image Modified	PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID	UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

...

Table: csm_privilege

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

PRIVILEGE_NAME

varchar(100)

Image Removed

PRIVILEGE_DESCRIPTION

varchar(200)

Nullable

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_role_privilege	csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID	FK_PRIVILEGE_ROLE

Unique keys

...

Columns

...

Name / Description

Key	Columns	Name / Description
Image Added	PRIVILEGE_ID	PRIMARY
Image Added	PRIVILEGE_NAME	UQ_PRIVILEGE_NAME

...

PRIVILEGE_ID

...

PRIMARY

...

PRIVILEGE_NAME

...

UQ_PRIVILEGE_NAME

...

Table: csm_protection_element

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

PROTECTION_ELEMENT_NAME

varchar(100)

Image Removed

PROTECTION_ELEMENT_DESCRIPTI ON

varchar(200)

Nullable

Image Removed

Image Added

OBJECT_ID

varchar(100)

Image Removed

Image Added

Image Removed

ATTRIBUTE

varchar(100)

Nullable

Image Removed

PROTECTION_ELEMENT_TYPE

varchar(100)

Nullable

Image Removed

Image Added

APPLICATION_ID

bigint(19, 0)

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

Image Added

ATTRIBUTE_VALUE

varchar(100)

Nullable

Linked from

Relationship	Table	Join	Title / Name / Description
Image 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
Image Modified	csm_user_pe	csm_protection_element.PROTECTION _ELEMENT_ID = csm_user_pe.PROTECTION_ELEMENT_ ID	FK_PROTECTION_ELEMENT_USER

Unique keys

Key	Columns	Name / Description
Image Modified	PROTECTION_ELEMENT_ID	PRIMARY
Image Modified	OBJECT_ID

, ATTRIBUTE

_VALUE

APPLICATION_IDUQ_PE_PE_NAME_

ATTRIBUTE

_VALUE_APP_ID

...

_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

...

Table: csm_protection_group

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

PROTECTION_GROUP_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

PROTECTION_GROUP_NAME

varchar(100)

Image Removed

PROTECTION_GROUP_DESCRIPTIO N

varchar(200)

Nullable

Image Removed

Image Added

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed

LARGE_ELEMENT_COUNT_FLAG

tinyint(3, 0)

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

PARENT_PROTECTION_GROUP_ID

bigint(19, 0)

Nullable
References: csm_protection_group

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID	FK_PG_APPLICATION
Image Modified	csm_protection_group	csm_protection_group.PARENT_PROT ECTION_GROUP_ID = csm_protection_group.PROTECTION_ GROUP_ID	FK_PROTECTION_GROUP

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_protection_group	csm_protection_group.PROTECTION_ GROUP_ID = csm_protection_group.PARENT_PROT ECTION_GROUP_ID	FK_PROTECTION_GROUP
Image Modified	csm_pg_pe	csm_protection_group.PROTECTION_ GROUP_ID = csm_pg_pe.PROTECTION_GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT
Image 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

Unique keys

...

Key	Columns	Name / Description
Image Modified	PROTECTION_GROUP_ID	PRIMARY
Image Modified	APPLICATION_ID, PROTECTION_GROUP_NAME	UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

...

Table: csm_role

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

ROLE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

ROLE_NAME

varchar(100)

Image Removed


_	ROLE_DESCRIPTION	varchar(200)	Nullable

Image Removed

Image Added

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed

ACTIVE_FLAG

tinyint(3, 0)

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_role.APPLICATION_ID = csm_application.APPLICATION_ID	FK_APPLICATION_ROLE

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_role_privilege	csm_role.ROLE_ID = csm_role_privilege.ROLE_ID	FK_ROLE
Image Modified	csm_user_group_role_pg	csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE

Unique keys

...

Key	Columns	Name / Description
Image Modified	ROLE_ID	PRIMARY
Image Modified	APPLICATION_ID, ROLE_NAME	UQ_ROLE_ROLE_NAME

...

Table: csm_role_privilege

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

ROLE_PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

Image Added

ROLE_ID

bigint(19, 0)

References: csm_role

Image Removed

Image Added

Image Removed

PRIVILEGE_ID

bigint(19, 0)

References: csm_privilege

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_privilege	csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID	FK_PRIVILEGE_ROLE
Image Modified	csm_role	csm_role_privilege.ROLE_ID = csm_role.ROLE_ID	FK_ROLE

Unique keys

...

Key	Columns	Name / Description
Image Modified	ROLE_PRIVILEGE_ID	PRIMARY
Image Modified	PRIVILEGE_ID, ROLE_ID	UQ_ROLE_PRIVILEGE

_ROLE_ID

...

_ROLE_ID

Table: csm_user

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

USER_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

LOGIN_NAME

varchar(500)

Nullable

Image Removed

FIRST_NAME

varchar(100)

Image Removed

LAST_NAME

varchar(100)

ORGANIZATION

varchar(500)

Nullable

Image Removed

DEPARTMENT

varchar(100)

Nullable

Image Removed

TITLE

varchar(100)

Nullable

Image Removed

PHONE_NUMBER

varchar(100)

Nullable

Image Removed

PASSWORD

varchar(100)

Nullable

Image Removed

EMAIL_ID

varchar(100)

Nullable

Image Removed

START_DATE

date

Nullable

Image Removed

END_DATE

date

Nullable

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

MIDDLE_NAME

varchar(100)

Nullable

Image Removed

FAX

varchar(20)

Nullable

Image Removed

ADDRESS

varchar(200)

Nullable

Image Removed

CITY

varchar(100)

Nullable

Image Removed

STATE

varchar(100)

Nullable

Image Removed

COUNTRY

varchar(100)

Nullable

Image Removed

POSTAL_CODE

varchar(10)

Nullable

Image Removed

MIGRATED_FLAG

tinyint(3, 0)

Default: 0

Image Removed

PREMGRT_LOGIN_NAME

varchar(100)

Nullable

Image Removed

PASSWORD_EXPIRED

tinyint(3, 0)

Nullable Default: 0

Image Removed

FIRST_TIME_LOGIN

tinyint(3, 0)

Nullable Default:

Name

Data type

Description / Attributes

Image Removed

ACTIVE_FLAG

tinyint(3, 0)

Nullable Default: 1

Image Removed

PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user_group	csm_user.USER_ID = csm_user_group.USER_ID	FK_USER_GROUP
Image Modified	csm_user_group_role_pg	csm_user.USER_ID = csm_user_group_role_pg.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER
Image Modified	csm_user_pe	csm_user.USER_ID = csm_user_pe.USER_ID	FK_PE_USER
Image Modified	query_history	csm_user.USER_ID = query_history.user_id	FK_Q_H_USER_ID
Image Modified	saved_query	csm_user.USER_ID = saved_query.user_id	FK_SAVED_QUERY_USER_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	USER_ID	PRIMARY

...

Table: csm_user_group

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

USER_GROUP_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

USER_ID

bigint(19, 0)

References: csm_user

Image Removed

GROUP_ID

bigint(19, 0)

References: csm_group

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_user_group.GROUP_ID = csm_group.GROUP_ID	FK_UG_GROUP
Image Modified	csm_user	csm_user_group.USER_ID = csm_user.USER_ID	FK_USER_GROUP

Unique keys

Key	Columns	Name / Description
Image Modified	USER_GROUP

_ID

PRIMARY

...

_ID

PRIMARY

...

Table: csm_user_group_role_pg

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto increment

Name

Data type

Description / Attributes

Image Removed

USER_ID

bigint(19, 0)

Nullable
References: csm_user

Image Removed

GROUP_ID

bigint(19, 0)

Nullable
References: csm_group

Image Removed

ROLE_ID

bigint(19, 0)

References: csm_role

Image Removed

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group

Image Removed

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
Image 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
Image Modified	csm_role	csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE
Image Modified	csm_user	csm_user_group_role_pg.USER_ID = csm_user.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

Unique keys

...

Key	Columns	Name / Description
Image Modified	USER_GROUP_ROLE_PG_ID	PRIMARY

...

Table: csm_user_pe

...

...

Columns

Image Removed
Key
Name
Data type
Description / Attributes
Image Removed

Image Added
USER_PROTECTION_ELEMENT_ID
bigint(19, 0)
Identity / Auto increment
Image Removed Image Removed Image Removed

Image Added
PROTECTION_ELEMENT_ID
bigint(19, 0)
References: csm_protection_element
Image Removed

Image Added
USER_ID
bigint(19, 0)
References: csm_user
Image Removed
_
UPDATE_DATE
date
Default: 1950-01-01
Links to

Relationship
Table
Join
Title / Name / Description

Image Modified

csm_protection_element
csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID
FK_PROTECTION_ELEMENT_USER

Image Modified
csm_user
csm_user_pe.USER_ID = csm_user.USER_ID
FK_PE_USER
Unique keys
...

Key
Columns
Name / Description

Image Modified
USER_PROTECTION_ELEMENT_ID
PRIMARY

Columns
Name / Description

Image Modified
USER_ID, PROTECTION_ELEMENT_ID
UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID
...

Table: ct_image

Columns

Key	Name	Data type	Description / Attributes

Image Removed

kvp

decimal(22, 6)

Nullable

Image Removed

scan_options

varchar(16)

Nullable

Image Removed

data_collection_diameter

decimal(22, 6)

Nullable

Image Removed

reconstruction_diameter

decimal(22, 6)

Nullable

Image Removed

gantry_detector_tilt

decimal(22, 6)

Nullable

Image Removed

exposure_time

decimal(22, 6)

Nullable

Image Removed

x_ray_tube_current

decimal(22, 6)

Nullable

Image Removed

exposure

decimal(22, 6)

Nullable

Image Removed

exposure_in_microas

decimal(22, 6)

Nullable

Image Removed

convolution_kernel

varchar(16)

Nullable

Image Removed

revolution_time

decimal(22, 6)

Nullable

Image Removed

single_collimation_width

decimal(22, 6)

Nullable

Image Removed

total_collimation_width

decimal(22, 6)

Nullable

Image Removed

table_speed

decimal(22, 6)

Nullable

Image Removed

table_feed_per_rotation

decimal(22, 6)

Nullable

Image Removed

ct_pitch_factor

decimal(22, 6)

Nullable

Image Removed

anatomic_region_seq

varchar(500)

Nullable

Image Removed

image_pk_id

bigint(19, 0)

References: general_image

Image Removed

Image Added

Image Removed

ct_image_pk_id

bigint(19, 0)

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	general_image	ct_image.image_pk_id = general_image.image_pk_id	fk_image_pk_id
Image Modified	general_series	ct_image.general_series_pk_id = general_series.general_series_pk_id	ct_image_ibfk_1

Unique keys

...

Key	Columns	Name / Description
Image Modified	ct_image_pk_id	PRIMARY
Image Modified	ct_image_pk_id	PK_CT_IMAGE_PK_ID

...

Table: custom_series_list

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

Image Removed

NAME

varchar(200)

Nullable

Image Removed

comment_

varchar(200)

Nullable

Image Removed

HYPERLINK

varchar(200)

Nullable

Image Removed

CUSTOM_SERIES_LIST_TIMESTAMP

date

Nullable

Image Removed

USER_NAME

varchar(20)

Nullable

Image Removed

usage_count

unsigned int(10, 0)

Nullable Default: 0

Linked from

Relationship	Table	Join	Title / Name / Description
Image 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

Unique keys

Key	Columns	Name / Description
Image Modified	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
Image Modified

CUSTOM_SERIES_LIST_PK_ID

...

CUSTOM_SERIES_LIST_PK_ID

...

Table: custom_series_list_attribute

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

custom_series_list_attribute_p

bigint(19, 0)

Image Removed

SERIES_INSTANCE_UID

varchar(200)

Nullable

Image Removed

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

Relationship	Table	Join	Title / Name / Description
Image 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

Unique keys

...

Key	Columns	Name / Description
Image Modified	custom_series_list_attribute_p	PRIMARY
Image Modified	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

...

Table: databasechangelog

Columns

Key

Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

ID	varchar(63)

Image Removed

Image Added

AUTHOR

varchar(63)

Image Removed

Image Added

FILENAME

varchar(200)

Image Removed

DATEEXECUTED

datetime

Image Removed

MD5SUM

varchar(32)

Nullable

Image Removed

DESCRIPTION

varchar(255)

Nullable

Image Removed

COMMENTS

varchar(255)

Nullable

Image Removed

TAG

varchar(255)

Nullable

Image Removed

LIQUIBASE

varchar(10)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	ID, AUTHOR, FILENAME	PRIMARY

...

Table: databasechangeloglock

Columns

Key

Image Removed

Name	Data type	Description / Attributes

Image Removed

Image Added

int(10, 0)

Image Removed

LOCKED

tinyint(3, 0)

Image Removed

LOCKGRANTED

datetime

Nullable

Image Removed

LOCKEDBY

varchar(255)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	ID	PRIMARY

...

Table: deletion_audit_trail

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

deletion_pk_id

bigint(19, 0)

Image Removed

data_id

varchar(64)

Nullable

Image Removed

data_type

varchar(50)

Nullable

Image Removed

total_image

bigint(19, 0)

Nullable

Image Removed

user_name

varchar(50)

Nullable

Image Removed

time_stamp

datetime

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	deletion_pk_id	PRIMARY

...

Table: download_data_history

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

download_data_history_pk_id

bigint(19, 0)

Image Removed

series_instance_uid

varchar(64)

Nullable

Image Removed

login_name

varchar(100)

Nullable

Image Removed

download_timestamp

date

Nullable

Image Removed

download_type

varchar(20)

Nullable

Image Removed

size_

decimal(22, 2)

Nullable

Unique keys

Key	Columns	Name / Description
Image Modified

download_data_history_pk_id

PRIMARY

...

download_data_history_pk_id

PRIMARY

...

Table: download_history

Columns

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

download_history_pk_id

bigint(19, 0)

Image Removed

user_id

bigint(19, 0)

Nullable

Image Removed

timestamp

datetime

Nullable

Image Removed

total_file_size

decimal(22, 2)

Nullable

Image Removed

download_file_name

varchar(300)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	download_history_pk_id	PRIMARY

...

Table: general_equipment

Columns

Key

Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

general_equipment_pk_id

bigint(19, 0)

Image Removed

manufacturer

varchar(64)

Nullable

Image Removed

institution_name

varchar(64)

Nullable

Image Removed

manufacturer_model_name

varchar(64)

Nullable

Image Removed

software_versions

varchar(64)

Nullable

Image Removed

institution_address

varchar(1024)

Nullable

Image Removed

station_name

varchar(16)

Nullable

Image Removed

device_serial_number

varchar(64)

Nullable

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	general_series	general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id	fk_g_equipment_pk_id

Unique keys

...

Key	Columns	Name / Description
Image Modified	general_equipment_pk_id	PRIMARY
Image Modified	general_equipment_pk_id	PK_G_EQUIPMENT_ID

...

Table: general_image

Columns

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

image_pk_id

bigint(19, 0)

Image Removed

instance_number

bigint(19, 0)

Nullable

Image Removed

content_date

date

Nullable

Image Removed

content_time

varchar(16)

Nullable

Image Removed

image_type

varchar(16)

Nullable

Image Removed

acquisition_date

date

Nullable

Image Removed

acquisition_time

varchar(16)

Nullable

Image Removed

acquisition_number

decimal(22, 6)

Nullable

Image Removed

lossy_image_compression

varchar(16)

Nullable

Image Removed

pixel_spacing

decimal(22, 6)

Nullable

Image Removed

image_orientation_patient

varchar(200)

Nullable

Image Removed

image_position_patient

varchar(200)

Nullable

Image Removed

slice_thickness

decimal(22, 6)

Nullable

Image Removed

slice_location

decimal(22, 6)

Nullable

Image Removed

i_rows

decimal(22, 6)

Nullable

Image Removed

i_columns

decimal(22, 6)

Nullable

Image Removed

contrast_bolus_agent

varchar(64)

Nullable

Image Removed

contrast_bolus_route

varchar(64)

Nullable

Image Removed

sop_class_uid

varchar(64)

Nullable

Image Removed

Image Added

sop_instance_uid

varchar(64)

Nullable

Image Removed

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Image Removed

patient_position

varchar(16)

Nullable

Image Removed

source_to_detector_distance

decimal(22, 6)

Nullable

Image Removed

source_subject_distance

decimal(22, 6)

Nullable

Image Removed

focal_spot_size

decimal(22, 6)

Nullable

Name

Data type

Description / Attributes

Image Removed

storage_media_file_set_uid

varchar(64)

Nullable

Image Removed

dicom_file_uri

varchar(2000)

Nullable

Image Removed

acquisition_datetime

varchar(50)

Nullable

Image Removed

image_comments

varchar(4000)

Nullable

Image Removed

image_receiving_timestamp

datetime

Nullable

Image Removed

curation_timestamp

datetime

Nullable

Image Removed

annotation

varchar(20)

Nullable

Image Removed

Image Added

submission_date

date

Nullable

Image Removed

dicom_size

decimal(22, 6)

Nullable

Image Removed

image_laterality

varchar(16)

Nullable

Image Removed

trial_dp_pk_id

bigint(19, 0)

Nullable

Image Removed

patient_id

varchar(64)

Nullable

Image Removed

study_instance_uid

varchar(500)

Nullable

Image Removed

series_instance_uid

varchar(64)

Nullable

Image Removed

patient_pk_id

bigint(19, 0)

Nullable References: patient

Image Removed

study_pk_id

bigint(19, 0)

Nullable References: study

Image Removed

project

varchar(200)

Nullable

Image Removed

acquisition_matrix

decimal(22, 6)

Nullable
Default: 0.000000

Image Removed

dx_data_collection_diameter

decimal(22, 6)

Nullable
Default: 0.000000

Image Removed

md5_digest

varchar(50)

Nullable

Image Removed

US_FRAME_NUMBER

varchar(50)

Nullable

Image Removed

US_COLOR_DATA_PRESENT

varchar(50)

Nullable

Image Removed

US_MULTI_MODALITY

varchar(50)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	general_series	general_image.general_series_pk_id = general_series.general_series_pk_id	fk_g_series_pk_id
Image Modified	patient	general_image.patient_pk_id = patient.patient_pk_id	FK_general_image_patient
Image Modified	study	general_image.study_pk_id = study.study_pk_id	FK_general_image_study

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	ct_image	general_image.image_pk_id = ct_image.image_pk_id	fk_image_pk_id
Image Modified	mr_image	general_image.image_pk_id = mr_image.IMAGE_PK_ID	FK_MR_GEN_IMAGE_PK_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	image_pk_id	PRIMARY
Image Modified	image_pk_id, submission_date	Image_Visibility_Submitted_IDX
Image Modified	image_pk_id	PK_IMAGE_PK_ID
Image Modified	sop_instance_uid	sop_instance_uid

...

Table: general_series

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

general_series_pk_id

bigint(19, 0)

Image Removed

modality

varchar(16)

Image Removed

Image Added

series_instance_uid

varchar(64)

Nullable

Image Removed

series_laterality

varchar(16)

Nullable

Image Removed

series_date

date

Nullable

Image Removed

protocol_name

varchar(64)

Nullable

Image Removed

series_desc

varchar(64)

Nullable

Image Removed

body_part_examined

varchar(16)

Nullable

Image Removed

study_pk_id

bigint(19, 0)

Nullable References: study

Image Removed

general_equipment_pk_id

bigint(19, 0)

Nullable
References: general_equipment

Image Removed

trial_protocol_id

varchar(64)

Nullable

Image Removed

trial_protocol_name

varchar(64)

Nullable

Image Removed

trial_site_name

varchar(64)

Nullable

Image Removed

study_date

date

Nullable

Image Removed

study_desc

varchar(64)

Nullable

Image Removed

admitting_diagnoses_desc

varchar(64)

Nullable

Image Removed

patient_age

varchar(4)

Nullable

Image Removed

patient_sex

varchar(16)

Nullable

Image Removed

patient_weight

decimal(22, 6)

Nullable

Image Removed

age_group

varchar(10)

Nullable

Image Removed

patient_pk_id

bigint(19, 0)

Nullable

Image Removed

series_number

decimal(22, 6)

Nullable

Image Removed

sync_frame_of_ref_uid

varchar(64)

Nullable

Image Removed

patient_id

varchar(64)

Nullable

Image Removed

frame_of_reference_uid

varchar(64)

Nullable

Image Removed

visibility

varchar(5)

Nullable

Image Removed

security_group

varchar(50)

Nullable

Image Removed

annotations_flag

varchar(5)

Nullable

Name

Data type

Description / Attributes

Image Removed

project

varchar(200)

Nullable

Image Removed

site

varchar(40)

Nullable

Image Removed

study_instance_uid

varchar(500)

Nullable

Image Removed

max_submission_timestamp

datetime

Nullable

Image Removed

batchNum

int(10, 0)

Nullable

Image Removed

submission_type

varchar(100)

Nullable

Image Removed

released_status

varchar(50)

Nullable

Image Removed

third_party_analysis

varchar(4)

Nullable

Image Removed

description_uri

varchar(500)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	general_equipment	general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id	fk_g_equipment_pk_id
Image Modified	study	general_series.study_pk_id = study.study_pk_id	fk_gs_study_pk_id

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	ct_image	general_series.general_series_pk_id = ct_image.general_series_pk_id	ct_image_ibfk_1
Image Modified	general_image	general_series.general_series_pk_id = general_image.general_series_pk_id	fk_g_series_pk_id
Image Modified	mr_image	general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID	FK_MR_GEN_SERIES_PK_ID

Unique keys

Key	Columns	Name / Description
Image Modified	general_series_pk_id	PRIMARY
Image Modified	general_series_pk_id	PK_G_SERIES_PK_ID
Image Modified	series_instance_uid	series_instance_uid

...

Table: gui_action_history

...

...

Columns
...

Image Removed
Key
Name
Data type
Description / Attributes
Image Removed

Image Added
GUI_ACTION_HISTORY_PK_ID
bigint(19, 0)
Default: 0
Image Removed
-
ACTION_TIMESTAMP
date
Nullable
Image Removed
-
ACTION
varchar(255)
Nullable
Unique keys
...

Key
Columns
Name / Description
Image Modified
GUI_ACTION_HISTORY_PK_ID
PRIMARY
...
...

Table: hibernate_unique_key

Columns

...

Key	Name	Data type	Description / Attributes

Image Removed

next_hi

bigint(19, 0)

...

Table: login_history

Columns

Key

Image Removed

Name	Data type	Description / Attributes

Image Removed

Image Added

login_history_pk_id

bigint(19, 0)

Image Removed

login_timestamp

datetime

Nullable

Image Removed

ip_address

varchar(15)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	login_history_pk_id	PRIMARY
Image Modified	login_history_pk_id	PK_LOGIN_HISTORY_PK_ID

...

Table: modality_descriptions

Columns

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

modality_descriptions_pk_id

bigint(19, 0)

Image Removed

modality_name

varchar(20)

Nullable

Image Removed

description

mediumtext

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	modality_descriptions_pk_id	PRIMARY
Image Modified	modality_descriptions_pk_id	MD_COLLECTION_DESC_PK_ID

...

Table: mr_image

Columns

Key	Name	Data type	Description / Attributes

Image Removed

IMAGE_TYPE_VALUE_3

varchar(16)

Image Removed

SCANNING_SEQUENCE

varchar(126)

Image Removed

SEQUENCE_VARIANT

varchar(126)

Image Removed

REPETITION_TIME

decimal(22, 10)

Nullable

Image Removed

ECHO_TIME

decimal(22, 10)

Nullable

Image Removed

INVERSION_TIME

decimal(22, 10)

Nullable

Image Removed

SEQUENCE_NAME

varchar(64)

Nullable

Name

Data type

Description / Attributes

Image Removed

IMAGED_NUCLEUS

varchar(64)

Nullable

Image Removed

MAGNETIC_FIELD_STRENGTH

decimal(22, 10)

Nullable

Image Removed

SAR

decimal(22, 10)

Nullable

Image Removed

DB_DT

decimal(22, 10)

Nullable

Image Removed

TRIGGER_TIME

decimal(22, 10)

Nullable

Image Removed

ANGIO_FLAG

varchar(1)

Nullable

Image Removed

IMAGE_PK_ID

bigint(19, 0)

References: general_image

Image Removed

Image Added

Image Removed

MR_IMAGE_PK_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable
References: general_series

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	general_image	mr_image.IMAGE_PK_ID = general_image.image_pk_id	FK_MR_GEN_IMAGE_PK_ID
Image Modified	general_series	mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id	FK_MR_GEN_SERIES_PK_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	MR_IMAGE_PK_ID	PRIMARY

...

Table: patient

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

patient_pk_id

bigint(19, 0)

Image Removed

patient_id

varchar(64)

Nullable

Image Removed

patient_name

varchar(250)

Nullable

Image Removed

patient_birth_date

date

Nullable

Image Removed

patient_sex

varchar(16)

Nullable

Image Removed

ethnic_group

varchar(16)

Nullable

Image Removed

trial_dp_pk_id

bigint(19, 0)

Nullable
References: trial_data_provenance

Image Removed

trial_subject_id

varchar(64)

Nullable

Image Removed

trial_subject_reading_id

varchar(255)

Nullable

Image Removed

trial_site_pk_id

bigint(19, 0)

Nullable

Image Removed

species_code

varchar(100)

Nullable

Image Removed

species_description

varchar(100)

Nullable

Image Removed

qc_subject

varchar(4)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	trial_data_provenance	patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id	fk_trial_dp_pk_id

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	general_image	patient.patient_pk_id = general_image.patient_pk_id	FK_general_image_patient
Image Modified	study	patient.patient_pk_id = study.patient_pk_id	fk_patient_pk_id

Unique keys

...

Key	Columns	Name / Description
Image Modified	patient_pk_id	PRIMARY
Image Modified	patient_pk_id	PK_PATINET_PK_ID

...

Table: qc_status_history

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

qc_status_history_pk_id

bigint(19, 0)

Image Removed

series_instance_uid

varchar(64)

Image Removed

user_id

varchar(100)

Nullable

Image Removed

comment_

varchar(4000)

Nullable

Image Removed

history_timestamp

datetime

Nullable

Image Removed

new_value

varchar(100)

Nullable

Image Removed

old_value

varchar(100)

Nullable

Image Removed

oldBatch

varchar(20)

Nullable

Image Removed

newBatch

varchar(20)

Nullable

Image Removed

oldSubmissionType

varchar(100)

Nullable

Image Removed

newSubmissionType

varchar(100)

Nullable

Image Removed

oldReleasedStatus

varchar(50)

Nullable

Image Removed

newReleasedStatus

varchar(50)

Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	qc_status_history_pk_id	PRIMARY
Image Modified	qc_status_history_pk_id	PK_QC_STATUS_HISTORY_PK_ID

...

Table: query_history

...

...
Columns

Key

Image Removed
Name
Data type
Description / Attributes
Image Removed
Image Added
query_history_pk_id
bigint(19, 0)

-
Image Removed
-
user_id
bigint(19, 0)
Nullable
References: csm_user
Image Removed
-
query_execute_timestamp
datetime
Nullable
Image Removed
-

query_elapsed_time
bigint(19, 0)
Nullable
Image Removed
-
saved_query_pk_id
bigint(19, 0)
Nullable
References: saved_query
Image Removed
-

tool
varchar(100)
Nullable
Links to

Relationship
Table
Join
Title / Name / Description
Image Modified
csm_user
query_history.user_id = csm_user.USER_ID
FK_Q_H_USER_ID

Image Modified
saved_query
query_history.saved_query_pk_id = saved_query.saved_query_pk_id
fk_s_query_pk_id
Linked from

Relationship
Table
Join
Title / Name / Description
Image Modified
query_history_attribute
query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id
FK_Q_H_PK_ID
Unique keys

Key
Columns
Name / Description
Image Modified
query_history_pk_id
PRIMARY

Image Modified
query_history_pk_id
PK_QUERY_HISTORY_PK_ID
...
...
query_history_pk_
...
id
...
PK_
...
QUERY_HISTORY_PK_ID

Table: query_history_attribute

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

query_history_attribute_pk_id

bigint(19, 0)

Image Removed

attribute_name

varchar(300)

Nullable

Image Removed

subattribute_name

varchar(300)

Nullable

Image Removed

attribute_value

varchar(300)

Nullable

Image Removed

query_history_pk_id

bigint(19, 0)

Nullable
References: query_history

Image Removed

instance_number

bigint(19, 0)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	query_history	query_history_attribute.query_history_ pk_id = query_history.query_history_pk_id	FK_Q_H_PK_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	query_history_attribute_pk_id	PRIMARY
Image Modified	query_history_attribute_pk_id	PK_Q_H_A_PK_ID

...

Table: saved_query

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

saved_query_pk_id

bigint(19, 0)

Image Removed

user_id

bigint(19, 0)

Nullable
References: csm_user

Image Removed

query_name

varchar(200)

Nullable

Image Removed

new_data_flag

varchar(5)

Nullable

Image Removed

active

varchar(5)

Nullable

Image Removed

query_execute_timestamp

datetime

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user	saved_query.user_id = csm_user.USER_ID	FK_SAVED_QUERY_USER_ID

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	query_history	saved_query.saved_query_pk_id = query_history.saved_query_pk_id	fk_s_query_pk_id
Image Modified	saved_query_attribute	saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk _id	FK_SAVED_QUERY_PK_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	saved_query_pk_id	PRIMARY
Image Modified	saved_query_pk_id	PK_SAVED_Q_PK_ID

...

Table: saved_query_attribute

Columns

Key

Name	Data type	Description / Attributes

Image Removed

Image Added

Image Removed

saved_query_attribute_pk_id

bigint(19, 0)

Image Removed

attribute_name

varchar(300)

Nullable

Image Removed

subattribute_name

varchar(300)

Nullable

Image Removed

attribute_value

varchar(300)

Nullable

Image Removed

saved_query_pk_id

bigint(19, 0)

Nullable
References: saved_query

Name

Data type

Description / Attributes

Image Removed

instance_number

bigint(19, 0)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	saved_query	saved_query_attribute.saved_query_pk _id = saved_query.saved_query_pk_id	FK_SAVED_QUERY_PK_ID

Unique keys

...

Key	Columns	Name / Description
Image Modified	saved_query_attribute_pk_id	PRIMARY
Image Modified	saved_query_attribute_pk_id	PK_S_Q_A_PK

_ID

...

_ID

Table: site

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

site_pk_id

bigint(19, 0)

Image Removed

dp_site_name

varchar(40)

Nullable

Image Removed

dp_site_id

varchar(64)

Nullable

Image Removed

trial_dp_pk_id

bigint(19, 0)

References: trial_data_provenance

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	trial_data_provenance	site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id	fk_tdp_st_pk_id

Unique keys

...

Key	Columns	Name / Description
Image Modified	site_pk_id	PRIMARY
Image Modified	site_pk_id	SITE_PK_ID

...

Table: species

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

species_code

varchar(64)

Image Removed

species_description

varchar(500)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	species_code	PRIMARY

...

Table: study

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

study_pk_id

bigint(19, 0)

Image Removed


Image Added	study_instance_uid	varchar(500)	Nullable

Image Removed

study_date

date

Image Removed

study_time

varchar(16)

Nullable

Image Removed

study_desc

varchar(64)

Nullable

Image Removed

admitting_diagnoses_desc

varchar(64)

Nullable

Image Removed

admitting_diagnoses_code_seq

varchar(500)

Nullable

Image Removed

patient_pk_id

bigint(19, 0)

Nullable References: patient

Image Removed

study_id

varchar(16)

Nullable

Image Removed

trial_time_point_id

varchar(64)

Nullable

Image Removed

trial_time_point_desc

varchar(1024)

Nullable

Image Removed

patient_age

varchar(4)

Nullable

Image Removed

age_group

varchar(10)

Nullable

Image Removed

patient_size

decimal(22, 6)

Nullable

Image Removed

patient_weight

decimal(22, 6)

Nullable

Image Removed

occupation

varchar(16)

Nullable

Image Removed

additional_patient_history

varchar(4000)

Nullable

Links to

Relationship	Table	Join	Title / Name / Description
Image Modified	patient	study.patient_pk_id = patient.patient_pk_id	fk_patient_pk_id

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	general_image	study.study_pk_id = general_image.study_pk_id	FK_general_image_study
Image Modified	general_series	study.study_pk_id = general_series.study_pk_id	fk_gs_study_pk_id

Unique keys

Key	Columns	Name / Description
Image Modified

study_pk_id

PRIMARY

Image Removed

study_pk_id

PK_STUDY_PK_ID

Image Removed

study_instance_uid

...

	study_pk_id	PRIMARY
Image Added	study_pk_id	PK_STUDY_PK_ID
Image Added	study_instance_uid	study_instance_uid

...

Table: submission_history

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

submission_history_pk_id

bigint(19, 0)

Identity / Auto increment

Image Removed

patient_id

varchar(64)

Nullable

Image Removed

study_instance_uid

varchar(500)

Nullable

Image Removed

series_instance_uid

varchar(64)

Nullable

Image Removed

sop_instance_uid

varchar(64)

Nullable

Image Removed

submission_timestamp

datetime

Nullable

Image Removed

project

varchar(200)

Nullable

Image Removed

site

varchar(40)

Nullable

Image Removed

operation_type

smallint(5, 0)

Unique keys

...

Columns

...

Name / Description

...

submission_history_pk_id

...

submission_history_pk_id

...

Key	Columns	Name / Description
Image Added	submission_history_pk_id	submission_history_pk_id

...

Table: trial_data_provenance

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

trial_dp_pk_id

bigint(19, 0)

Image Removed

dp_site_name

varchar(40)

Nullable

Image Removed

dp_site_id

varchar(64)

Nullable

Image Removed

project

varchar(50)

Nullable

Linked from

Relationship	Table	Join	Title / Name / Description
Image Modified	patient	trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id	fk_trial_dp_pk_id
Image Modified	site	trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id	fk_tdp_st_pk_id

Unique keys

...

Key	Columns	Name / Description
Image Modified	trial_dp_pk_id	PRIMARY
Image Modified	trial_dp_pk_id	PK_TRIAL_DP_PK_ID

...

Table: trial_site

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

trial_site_pk_id

bigint(19, 0)

Image Removed

trial_site_id

varchar(64

)

Nullable

Name

Data type

Description / Attributes

Image Removed

)	Nullable
-

trial_site_name

varchar(64)

Nullable

Image Removed

trial_pk_id

bigint(19, 0)

Nullable

Unique keys

...

Key	Columns	Name / Description
Image Modified	trial_site_pk_id	PRIMARY
Image Modified	trial_site_pk_id	PK_TRIAL_SITE_PK_ID

...

Table: workflow

Columns

Image Removed

Key	Name	Data type	Description / Attributes

Image Removed

Image Added

WORKFLOW_ID

bigint(19, 0)

Image Removed

NAME

varchar(50)

Nullable

Image Removed

COLLECTION

varchar(200)

Nullable

Image Removed

SITE

varchar(200)

Nullable

Image Removed

URL

varchar(255)

Nullable

Image Removed

WORKFLOW_TYPE

varchar(

50)

Nullable

Unique keys

...

Columns

...

Name / Description

...

WORKFLOW_ID

...

PRIMARY

...

50)	Nullable

Unique keys

Key	Columns	Name / Description
Image Added	WORKFLOW_ID	PRIMARY

Views

...

View: dicom_image

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


IMAGE_PK_ID	bigint(19, 0)

INSTANCE_NUMBER

bigint(19, 0)

Nullable

Image Removed


CONTENT_DATE	date	Nullable

Image Removed


CONTENT_TIME	varchar(16)	Nullable

Image Removed


IMAGE_TYPE	varchar(16)	Nullable

Image Removed


ACQUISITION_DATE	date	Nullable

Image Removed

ACQUISITION_TIME

varchar(16)

Nullable

Image Removed


ACQUISITION_NUMBER	decimal(22, 6)	Nullable

Image Removed

LOSSY_IMAGE_COMPRESSION

varchar(16)

Nullable

Image Removed

PIXEL_SPACING

decimal(22, 6)

Nullable

Image Removed


IMAGE_ORIENTATION_PATIENT	varchar(200)	Nullable

Image Removed


IMAGE_POSITION_PATIENT	varchar(200)	Nullable

Name

Data type

Description / Attributes

Image Removed

SLICE_THICKNESS

decimal(22, 6)

Nullable

Image Removed

SLICE_LOCATION

decimal(22, 6)

Nullable

Image Removed


I_ROWS	decimal(22, 6)	Nullable

Image Removed


I_COLUMNS	decimal(22, 6)	Nullable

Image Removed


CONTRAST_BOLUS_AGENT	varchar(64)	Nullable

Image Removed


CONTRAST_BOLUS_ROUTE	varchar(64)	Nullable

Image Removed

SOP_CLASS_UID

varchar(64)

Nullable

Image Removed


SOP_INSTANCE_UID	varchar(64)	Nullable

Image Removed

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable

Image Removed

PATIENT_POSITION

varchar(16)

Nullable

Image Removed


SOURCE_TO_DETECTOR_DISTANCE	decimal(22, 6)	Nullable

Image Removed


SOURCE_SUBJECT_DISTANCE	decimal(22, 6)	Nullable

Image Removed


FOCAL_SPOT_SIZE	decimal(22, 6)	Nullable

Image Removed


STORAGE_MEDIA_FILE_SET_UID	varchar(64)	Nullable

Image Removed

DICOM_FILE_URI

varchar(2000)

Nullable

Image Removed


ACQUISITION_DATETIME	varchar(50)	Nullable

Image Removed

IMAGE_COMMENTS

varchar(4000)

Nullable

Image Removed

IMAGE_RECEIVING_TIMESTAMP

datetime

Nullable

Image Removed


CURATION_TIMESTAMP	datetime	Nullable

Image Removed


ANNOTATION	varchar(20)	Nullable

Image Removed


SUBMISSION_DATE	date	Nullable

Image Removed


DICOM_SIZE	decimal(22, 6)	Nullable

Image Removed

IMAGE_LATERALITY

varchar(16)

Nullable

Image Removed


TRIAL_DP_PK_ID	bigint(19, 0)	Nullable

Image Removed

PATIENT_ID

varchar(64)

Nullable

Image Removed


STUDY_INSTANCE_UID	varchar(500)	Nullable

Image Removed


SERIES_INSTANCE_UID	varchar(64)	Nullable

Image Removed


PATIENT_PK_ID	bigint(19, 0)	Nullable

Image Removed


STUDY_PK_ID	bigint(19, 0)	Nullable

Image Removed


PROJECT	varchar(200)	Nullable

Image Removed

ACQUISITION_MATRIX

decimal(22, 6)

Nullable
Default: 0.000000

Image Removed


DX_DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Default: 0.000000

Image Removed

KVP

decimal(22, 6)

Nullable

Image Removed


SCAN_OPTIONS	varchar(16)	Nullable

Image Removed


DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable

Image Removed


RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable

Image Removed


GANTRY_DETECTOR_TILT	decimal(22, 6)	Nullable

Name

Data type

Description / Attributes

Image Removed


EXPOSURE_TIME	decimal(22, 6)	Nullable

Image Removed

X_RAY_TUBE_CURRENT

decimal(22, 6)

Nullable

Image Removed

EXPOSURE

decimal(22, 6)

Nullable

Image Removed


EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable

Image Removed


CONVOLUTION_KERNEL	varchar(16)	Nullable

Image Removed


REVOLUTION_TIME	decimal(22, 6)	Nullable

Image Removed


SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable

Image Removed

TOTAL_COLLIMATION_WIDTH

decimal(22, 6)

Nullable

Image Removed


TABLE_SPEED	decimal(22, 6)	Nullable

Image Removed

TABLE_FEED_PER_ROTATION

decimal(22, 6)

Nullable

Image Removed

CT_PITCH_FACTOR

decimal(22, 6)

Nullable

Image Removed


ANATOMIC_REGION_SEQ	varchar(500)	Nullable

...

View: dicom_series

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed

GENERAL_SERIES_PK_ID

bigint(19, 0)

Image Removed

-
BODY_PART_EXAMINED	varchar(16)	Nullable

Image Removed

FRAME_OF_REFERENCE_UID

varchar(64)

Nullable

Image Removed

Nullable
SERIES_LATERALITY	varchar(16)	Nullable

Image Removed


MODALITY	varchar(16)

-
PROTOCOL_NAME	varchar(64)	Nullable

Image Removed

SERIES_DATE

date

Nullable

Image Removed


SERIES_DESC	varchar(64)	Nullable

Image Removed

SERIES_INSTANCE_UID

varchar(64)

Nullable

Image Removed

SERIES_NUMBER

decimal(22, 6)

Nullable

Image Removed


SYNC_FRAME_OF_REF_UID	varchar(64)	Nullable

Image Removed


STUDY_PK_ID	bigint(19, 0)	Nullable

Image Removed


GENERAL_EQUIPMENT_PK_ID	bigint(19, 0)	Nullable

...

View: dicom_study

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed

STUDY_PK_ID

bigint(19, 0)

Image Removed

-
STUDY_INSTANCE_UID	varchar(500)	Nullable

Image Removed


ADDITIONAL_PATIENT_HISTORY	varchar(4000)	Nullable

Image Removed

Name

Data type

Description / Attributes

Image Removed


STUDY_DATE	date

STUDY_DESC

varchar(64)

Nullable

Image Removed

Nullable
ADMITTING_DIAGNOSES_DESC	varchar(64)	Nullable

Image Removed


ADMITTING_DIAGNOSES_CODE_S EQ	varchar(500)	Nullable

Image Removed


OCCUPATION	varchar(16)	Nullable

Image Removed


PATIENT_AGE	varchar(4)	Nullable

Image Removed

PATIENT_SIZE

decimal(22, 6)

Nullable

Image Removed


PATIENT_WEIGHT	decimal(22, 6)	Nullable

Image Removed

STUDY_ID

varchar(16)

Nullable

Image Removed

STUDY_TIME

varchar(16)

Nullable

Image Removed


TRIAL_TIME_POINT_ID	varchar(64)	Nullable

Image Removed


TRIAL_TIME_POINT_DESC	varchar(1024)	Nullable

Image Removed


PATIENT_PK_ID	bigint(19, 0)	Nullable

...

View: manufacturer

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


MANUFACTURER	varchar(64

)

Nullable

...

)	Nullable

...

View: manufacturer_model_software

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


ID	bigint(19, 0)

Image Removed

MANUFACTURER

varchar(64)

Nullable

Image Removed


MODEL	varchar(64)	Nullable

Image Removed

SOFTWARE

varchar(64)

Nullable

...

View: number_month

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


PATIENT_ID	bigint(19, 0)	Nullable

Image Removed


NUMBER_MONTH	bigint(19, 0)	Nullable

...

View: saved_query_last_exec

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


SAVED_QUERY_PK_ID	bigint(19, 0)	Nullable

Image Removed


LAST_EXECUTE_DATE	datetime	Nullable

...

View: software_versions

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed

SOFTWARE_VERSIONS

varchar(64)

Nullable

...

View: study_series_number

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed


PATIENT_PK_ID	bigint(19, 0)	Nullable

Image Removed

PATIENT_ID

varchar(64)

Nullable

Image Removed


PROJECT	varchar(50)	Nullable

Image Removed

STUDY_NUMBER

bigint(19, 0)

Default: 0

Image Removed


SERIES_NUMBER	bigint(19, 0)	Default: 0

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user_group	csm_group.GROUP_ID = csm_user_group.GROUP_ID	FK_UG_GROUP
Image 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
Image Modified	csm_protection_element	csm_user_pe.PROTECTION_ELEMENT_ ID = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_USER
Image Modified	csm_user	csm_user_pe.USER_ID = csm_user.USER_ID	FK_PE_USER


Image Modified	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user	query_history.user_id = csm_user.USER_ID	FK_Q_H_USER_ID
Image Modified	saved_query	query_history.saved_query_pk_id = saved_query.saved_query_pk_id	fk_s_query_pk_id

Content

Space Tools

Page History

Versions Compared

Old Version 2

New Version Current

Key

Legend

NBIA

Tables

Columns for

Table: collection_descriptions

Columns for Table: csm_

application

Table: csm_configuration_props

Table: csm_filter_clause

Table: csm_group

Table: csm_mapping

Table: csm_password_history

Table: csm_pg_pe

Table: csm_privilege

Table: csm_protection_element

Table: csm_protection_group

Table: csm_role

Table: csm_role_privilege

Table: csm_user

Table: csm_user_group

Table: csm_user_group_role_pg

Table: csm_user_pe

Table: ct_image

Table: custom_series_list

Table: custom_series_list_attribute

Table: databasechangelog

Table: databasechangeloglock

Table: deletion_audit_trail

Table: download_data_history

Table: download_history

Table: general_equipment

Table: general_image

Table: general_series

Table: gui_action_history

Table: hibernate_unique_key

Table: login_history

Table: modality_descriptions

Table: mr_image

Table: patient

Table: qc_status_history

Table: query_history

Table: query_history_attribute

Table: saved_query

Table: saved_query_attribute

Table: site

Table: species

Table: study

Table: submission_history

Table: trial_data_provenance

Table: trial_site

Table: workflow

Views

View: dicom_image

View: dicom_series

View: dicom_study

View: manufacturer

View: manufacturer_model_software

View: number_month

View: saved_query_last_exec

View: software_versions

View: study_series_number