NIH | National Cancer Institute | NCI Wiki  

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 relation

 User-defined one to one relation

Input

Input

Output

Output

Input-Output

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


Tables

Columns for Table: collection_descriptions

Key

Name

Data type

Description / Attributes

Primary key

collection_descriptions_pk_id

bigint(19, 0)

-

-

collection_name

varchar(64)

Nullable

-

user_name

varchar(20)

Nullable

-

description

mediumtext

Nullable

-

collection_descriptions_timest

date

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

collection_descriptions_pk_id

PRIMARY

Unique key

collection_descriptions_pk_id

PK_COLLECTION_DESC_PK_ID

Columns for Table: csm_application 

Key

Name

Data type

Description / Attributes

Primary key

APPLICATION_ID

bigint(19, 0)

Identity / Auto increment

Unique key

APPLICATION_NAME

varchar(255)

_

_

APPLICATION_DESCRIPTION

varchar(200)

_

_

DECLARATIVE_FLAG

tinyint(3, 0)

Default: 0

_

ACTIVE_FLAG

tinyint(3, 0)

Default: 0

_

UPDATE_DATE

date

Default: 1950-01-01

_

DATABASE_URL

varchar(100)

Nullable

_

DATABASE_USER_NAME

varchar(100)

Nullable

_

DATABASE_PASSWORD

varchar(100)

Nullable

_

DATABASE_DIALECT

varchar(100)

Nullable

_

DATABASE_DRIVER

varchar(100)

Nullable

_

CSM_VERSION

varchar(20)

Nullable

Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation

csm_group

csm_application.APPLICATION_ID = csm_group.APPLICATION_ID

FK_APPLICATION_GROUP


One to many relation

csm_mapping

csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID

FK_PE_APPLICATION


One to many relation


csm_protection_group

csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D

FK_PG_APPLICATION


One to many relation

csm_role

csm_application.APPLICATION_ID = csm_role.APPLICATION_ID

FK_APPLICATION_ROLE

Unique keys

Key

Columns

Name / Description


Primary key

APPLICATION_ID

PRIMARY


Unique key

APPLICATION_NAME

UQ_APPLICATION_NAME

Table: csm_configuration_props

Columns

Key

Name

Data type

Description / Attributes

Primary key

PROPERTY_KEY

varchar(300)

-

-

PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

PROPERTY_KEY

PRIMARY

Table: csm_filter_clause

Columns

Key

Name

Data type

Description / Attributes

Primary key

FILTER_CLAUSE_ID

bigint(19, 0)

Identity / Auto increment

_

CLASS_NAME

varchar(100)

_

_

FILTER_CHAIN

varchar(2000)

_

_

TARGET_CLASS_NAME

varchar(100)

_

_

TARGET_CLASS_ATTRIBUTE_NAME

varchar(100)

_

_

TARGET_CLASS_ATTRIBUTE_TYPE

varchar(100)

_

_

TARGET_CLASS_ALIAS

varchar(100)

Nullable

_

TARGET_CLASS_ATTRIBUTE_ALIAS

varchar(100)

Nullable

_

GENERATED_SQL_USER

varchar(4000)

_

_

APPLICATION_ID

bigint(19, 0)

_

_

UPDATE_DATE

date

_

_

GENERATED_SQL_GROUP

varchar(4000)

_

Unique keys

Key

Columns

Name / Description

Primary key

FILTER_CLAUSE_ID

PRIMARY

Table: csm_group

Columns

Key

Name

Data type

Description / Attributes


Primary key

GROUP_ID

bigint(19, 0)

Identity / Auto increment


Unique key

GROUP_NAME

varchar(255)

_

_

GROUP_DESC

varchar(200)

Nullable

_

UPDATE_DATE

date

Default: 1950-01-01


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

csm_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

csm_user_group

csm_group.GROUP_ID = csm_user_group.GROUP_ID

FK_UG_GROUP

One to many relation

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

Primary key

GROUP_ID

PRIMARY

Unique key

APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAM_

Table: csm_mapping

Columns

Key

Name

Data type

Description / Attributes


Primary key

MAPPING_ID

bigint(19, 0)

Identity _/ Auto increment


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

_

OBJECT_NAME

varchar(100)

_

Unique key

ATTRIBUTE_NAME

varchar(100)

_

_

OBJECT_PACKAGE_NAME

varchar(100)

Nullable

_

TABLE_NAME

varchar(100)

Nullable

_

TABLE_NAME_GROUP

varchar(100)

Nullable

_

TABLE_NAME_USER

varchar(100)

Nullable

_

VIEW_NAME_GROUP

varchar(100)

Nullable

_

VIEW_NAME_USER

varchar(100)

Nullable

_

ACTIVE_FLAG

tinyint(3, 0)

Default: 0

_

MAINTAINED_FLAG

tinyint(3, 0)

Default: 0

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

csm_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

Unique keys

Key

Columns

Name / Description

Primary key

MAPPING_ID

PRIMARY

Unique key

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


Primary key

CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment

_

LOGIN_NAME

varchar(500)

Nullable

_

PASSWORD

varchar(255)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

CSM_PASSWORD_HISTORY_ID

PRIMARY

Table: csm_pg_pe

Columns

Key

Name

Data type

Description / Attributes


Primary key

PG_PE_ID

bigint(19, 0)

Identity / Auto increment


Unique key

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group


Unique key

PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element

_

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger


csm_protection_element

csm_pg_pe.PROTECTION_ELEMENT_I D =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_PROTECTION_GROUP

Disabled trigger


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

Primary key

PG_PE_ID

PRIMARY

Unique key

PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID

UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns

Key

Name

Data type

Description / Attributes


Primary key

PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment


Unique key

PRIVILEGE_NAME

varchar(100)

-

_

PRIVILEGE_DESCRIPTION

varchar(200)

Nullable

_

UPDATE_DATE

date

Default: 1950-01-01

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

csm_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

Unique keys

Key

Columns

Name / Description

Primary key

PRIVILEGE_ID

PRIMARY

Unique key

PRIVILEGE_NAME

UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

Key

Name

Data type

Description / Attributes

Primary key

PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment

_

PROTECTION_ELEMENT_NAME

varchar(100)


_

PROTECTION_ELEMENT_DESCRIPTI ON

varchar(200)

Nullable


Unique key

OBJECT_ID

varchar(100)



Unique key

ATTRIBUTE

varchar(100)

Nullable

_

PROTECTION_ELEMENT_TYPE

varchar(100)

Nullable


Unique key

APPLICATION_ID

bigint(19, 0)


_

UPDATE_DATE

date

Default: 1950-01-01


Unique key

ATTRIBUTE_VALUE

varchar(100)

Nullable

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

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 relation

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

Primary key

PROTECTION_ELEMENT_ID

PRIMARY


Unique key

OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

Table: csm_protection_group

Columns

Key

Name

Data type

Description / Attributes


Primary key

PROTECTION_GROUP_ID

bigint(19, 0)

Identity / Auto increment


Unique key

PROTECTION_GROUP_NAME

varchar(100)


_

PROTECTION_GROUP_DESCRIPTIO N

varchar(200)

Nullable


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

_

LARGE_ELEMENT_COUNT_FLAG

tinyint(3, 0)


_

UPDATE_DATE

date

Default: 1950-01-01

_

PARENT_PROTECTION_GROUP_ID

bigint(19, 0)

Nullable
References: csm_protection_group

Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger

csm_application

csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID

FK_PG_APPLICATION



Disabled trigger


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



One to many relation


csm_protection_group

csm_protection_group.PROTECTION_ GROUP_ID =
csm_protection_group.PARENT_PROT ECTION_GROUP_ID

FK_PROTECTION_GROUP


One to many relation


csm_pg_pe

csm_protection_group.PROTECTION_ GROUP_ID =
csm_pg_pe.PROTECTION_GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT



One to many relation


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


Primary key

PROTECTION_GROUP_ID

PRIMARY


Unique key

APPLICATION_ID, PROTECTION_GROUP_NAME

UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns

Key

Name

Data type

Description / Attributes

Primary key

ROLE_ID

bigint(19, 0)

Identity / Auto increment


Unique key

ROLE_NAME

varchar(100)


_

ROLE_DESCRIPTION

varchar(200)

Nullable


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

_

ACTIVE_FLAG

tinyint(3, 0)


_

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

csm_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation

csm_role_privilege

csm_role.ROLE_ID = csm_role_privilege.ROLE_ID

FK_ROLE


One to many relation

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

Primary key

ROLE_ID

PRIMARY


Unique key

APPLICATION_ID, ROLE_NAME

UQ_ROLE_ROLE_NAME

Table: csm_role_privilege


Columns

Key

Name

Data type

Description / Attributes

Primary key

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

Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger

csm_privilege

csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE


Disabled trigger

csm_role

csm_role_privilege.ROLE_ID = csm_role.ROLE_ID

FK_ROLE

Unique keys

Key

Columns

Name / Description


Primary key

ROLE_PRIVILEGE_ID

PRIMARY


Unique key

PRIVILEGE_ID, ROLE_ID

UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user


Columns

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


Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation

csm_user_group

csm_user.USER_ID = csm_user_group.USER_ID

FK_USER_GROUP


One to many relation

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 relation

csm_user_pe

csm_user.USER_ID = csm_user_pe.USER_ID

FK_PE_USER


One to many relation

query_history

csm_user.USER_ID = query_history.user_id

FK_Q_H_USER_ID


One to many relation

saved_query

csm_user.USER_ID = saved_query.user_id

FK_SAVED_QUERY_USER_ID

Unique keys

Key

Columns

Name / Description


Primary key

USER_ID

PRIMARY

Table: csm_user_group

Columns

Key

Name

Data type

Description / Attributes


Primary key

USER_GROUP_ID

bigint(19, 0)

Identity / Auto increment

_

USER_ID

bigint(19, 0)

References: csm_user

_

GROUP_ID

bigint(19, 0)

References: csm_group

Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger

csm_group

csm_user_group.GROUP_ID = csm_group.GROUP_ID

FK_UG_GROUP


Disabled trigger

csm_user

csm_user_group.USER_ID = csm_user.USER_ID

FK_USER_GROUP

Unique keys

Key

Columns

Name / Description

Primary key

USER_GROUP_ID

PRIMARY

Table: csm_user_group_role_pg


Columns

Key

Name

Data type

Description / Attributes


Primary key

USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto increment

_

USER_ID

bigint(19, 0)

Nullable
References: csm_user

_

GROUP_ID

bigint(19, 0)

Nullable
References: csm_group

_

ROLE_ID

bigint(19, 0)

References: csm_role

_

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group

_

UPDATE_DATE

date

Default: 1950-01-01


Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger

csm_group

csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS



Disabled trigger


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 trigger

csm_role

csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE


Disabled trigger

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

Primary key

USER_GROUP_ROLE_PG_ID

PRIMARY

Table: csm_user_pe


Columns

Key

Name

Data type

Description / Attributes


Primary key

USER_PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment


Unique key

PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element


Unique key

USER_ID

bigint(19, 0)

References: csm_user

_

UPDATE_DATE

date

Default: 1950-01-01

Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger


csm_protection_element

csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_USER


Disabled trigger

csm_user

csm_user_pe.USER_ID = csm_user.USER_ID

FK_PE_USER

Unique keys

Key

Columns

Name / Description


Primary key

USER_PROTECTION_ELEMENT_ID

PRIMARY


Unique key

USER_ID, PROTECTION_ELEMENT_ID

UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

Key

Name

Data type

Description / Attributes

_

kvp

decimal(22, 6)

Nullable

_

scan_options

varchar(16)

Nullable

_

data_collection_diameter

decimal(22, 6)

Nullable

_

reconstruction_diameter

decimal(22, 6)

Nullable

_

gantry_detector_tilt

decimal(22, 6)

Nullable

_

exposure_time

decimal(22, 6)

Nullable

_

x_ray_tube_current

decimal(22, 6)

Nullable

_

exposure

decimal(22, 6)

Nullable

_

exposure_in_microas

decimal(22, 6)

Nullable

_

convolution_kernel

varchar(16)

Nullable

_

revolution_time

decimal(22, 6)

Nullable

_

single_collimation_width

decimal(22, 6)

Nullable

_

total_collimation_width

decimal(22, 6)

Nullable

_

table_speed

decimal(22, 6)

Nullable

_

table_feed_per_rotation

decimal(22, 6)

Nullable

_

ct_pitch_factor

decimal(22, 6)

Nullable

_

anatomic_region_seq

varchar(500)

Nullable

_

image_pk_id

bigint(19, 0)

References: general_image

Primary key

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


Disabled trigger

general_image

ct_image.image_pk_id = general_image.image_pk_id

fk_image_pk_id


Disabled trigger

general_series

ct_image.general_series_pk_id = general_series.general_series_pk_id

ct_image_ibfk_1

Unique keys

Key

Columns

Name / Description


Primary key

ct_image_pk_id

PRIMARY


Unique key

ct_image_pk_id

PK_CT_IMAGE_PK_ID

Table: custom_series_list

Columns

Key

Name

Data type

Description / Attributes

Primary key

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)


_

NAME

varchar(200)

Nullable

_

comment_

varchar(200)

Nullable

_

HYPERLINK

varchar(200)

Nullable

_

CUSTOM_SERIES_LIST_TIMESTAMP

date

Nullable

_

USER_NAME

varchar(20)

Nullable

_

usage_count

unsigned int(10, 0)

Nullable Default: 0

Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation


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


Primary key

CUSTOM_SERIES_LIST_PK_ID

PRIMARY


Unique key

CUSTOM_SERIES_LIST_PK_ID

CUSTOM_SERIES_LIST_PK_ID

Table: custom_series_list_attribute


Columns

Key

Name

Data type

Description / Attributes

Primary key

custom_series_list_attribute_p

bigint(19, 0)

_

_

SERIES_INSTANCE_UID

varchar(200)

Nullable

_

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger


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

Primary key

custom_series_list_attribute_p

PRIMARY


Unique key

custom_series_list_attribute_p

CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Key

Name

Data type

Description / Attributes

Primary key

ID

varchar(63)

_

Primary key

AUTHOR

varchar(63)

_

Primary key

FILENAME

varchar(200)

_

_

DATEEXECUTED

datetime

_

_

MD5SUM

varchar(32)

Nullable

_

DESCRIPTION

varchar(255)

Nullable

_

COMMENTS

varchar(255)

Nullable

-

TAG

varchar(255)

Nullable

-

LIQUIBASE

varchar(10)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

ID, AUTHOR, FILENAME

PRIMARY

Table: databasechangeloglock

Columns

Key

Name

Data type

Description / Attributes

Primary key

ID

int(10, 0)

-

-

LOCKED

tinyint(3, 0)

-

-

LOCKGRANTED

datetime

Nullable

-

LOCKEDBY

varchar(255)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

ID

PRIMARY

Table: deletion_audit_trail

Columns

Key

Name

Data type

Description / Attributes

Primary key

deletion_pk_id

bigint(19, 0)

-

-

data_id

varchar(64)

Nullable

-

data_type

varchar(50)

Nullable

-

total_image

bigint(19, 0)

Nullable

-

user_name

varchar(50)

Nullable

-

time_stamp

datetime

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

deletion_pk_id

PRIMARY

Table: download_data_history

Columns

Key

Name

Data type

Description / Attributes

Primary key

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

Unique keys

Key

Columns

Name / Description

Primary key

download_data_history_pk_id

PRIMARY

Table: download_history

Columns

Key

Name

Data type

Description / Attributes

Primary key

download_history_pk_id

bigint(19, 0)

-

-

user_id

bigint(19, 0)

Nullable

-

timestamp

datetime

Nullable

-

total_file_size

decimal(22, 2)

Nullable

-

download_file_name

varchar(300)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

download_history_pk_id

PRIMARY

Table: general_equipment

Columns

Key

Name

Data type

Description / Attributes

Primary key

general_equipment_pk_id

bigint(19, 0)

-

-

manufacturer

varchar(64)

Nullable

-

institution_name

varchar(64)

Nullable

-

manufacturer_model_name

varchar(64)

Nullable

-

software_versions

varchar(64)

Nullable

-

institution_address

varchar(1024)

Nullable

-

station_name

varchar(16)

Nullable

-

device_serial_number

varchar(64)

Nullable

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation


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

Primary key

general_equipment_pk_id

PRIMARY


Unique key

general_equipment_pk_id

PK_G_EQUIPMENT_ID

Table: general_image

Columns

Key

Name

Data type

Description / Attributes

Primary key

image_pk_id

bigint(19, 0)

-

-

instance_number

bigint(19, 0)

Nullable

-

content_date

date

Nullable

-

content_time

varchar(16)

Nullable

-

image_type

varchar(16)

Nullable

-

acquisition_date

date

Nullable

-

acquisition_time

varchar(16)

Nullable

-

acquisition_number

decimal(22, 6)

Nullable

-

lossy_image_compression

varchar(16)

Nullable

-

pixel_spacing

decimal(22, 6)

Nullable

-

image_orientation_patient

varchar(200)

Nullable

-

image_position_patient

varchar(200)

Nullable

-

slice_thickness

decimal(22, 6)

Nullable

-

slice_location

decimal(22, 6)

Nullable

-

i_rows

decimal(22, 6)

Nullable

-

i_columns

decimal(22, 6)

Nullable

-

contrast_bolus_agent

varchar(64)

Nullable

-

contrast_bolus_route

varchar(64)

Nullable

-

sop_class_uid

varchar(64)

Nullable


Unique key

sop_instance_uid

varchar(64)

Nullable

-

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

-

patient_position

varchar(16)

Nullable

-

source_to_detector_distance

decimal(22, 6)

Nullable

-

source_subject_distance

decimal(22, 6)

Nullable

-

focal_spot_size

decimal(22, 6)

Nullable

-

Name

Data type

Description / Attributes

-

storage_media_file_set_uid

varchar(64)

Nullable

-

dicom_file_uri

varchar(2000)

Nullable

-

acquisition_datetime

varchar(50)

Nullable

-

image_comments

varchar(4000)

Nullable

-

image_receiving_timestamp

datetime

Nullable

-

curation_timestamp

datetime

Nullable

-

annotation

varchar(20)

Nullable


Unique key

submission_date

date

Nullable

-

dicom_size

decimal(22, 6)

Nullable

-

image_laterality

varchar(16)

Nullable

-

trial_dp_pk_id

bigint(19, 0)

Nullable

-

patient_id

varchar(64)

Nullable

-

study_instance_uid

varchar(500)

Nullable

-

series_instance_uid

varchar(64)

Nullable

-

patient_pk_id

bigint(19, 0)

Nullable References: patient

-

study_pk_id

bigint(19, 0)

Nullable References: study

-

project

varchar(200)

Nullable

-

acquisition_matrix

decimal(22, 6)

Nullable
Default: 0.000000

-

dx_data_collection_diameter

decimal(22, 6)

Nullable
Default: 0.000000

-

md5_digest

varchar(50)

Nullable

-

US_FRAME_NUMBER

varchar(50)

Nullable

-

US_COLOR_DATA_PRESENT

varchar(50)

Nullable

-

US_MULTI_MODALITY

varchar(50)

Nullable


Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id


Disabled trigger

patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient


Disabled trigger

study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id


One to many relation

mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID

Unique keys

Key

Columns

Name / Description


Primary key

image_pk_id

PRIMARY


Unique key

image_pk_id, submission_date

Image_Visibility_Submitted_IDX


Unique key

image_pk_id

PK_IMAGE_PK_ID


Unique key

sop_instance_uid

sop_instance_uid

Table: general_series


Columns

Key

Name

Data type

Description / Attributes

Primary key

general_series_pk_id

bigint(19, 0)

-

-

modality

varchar(16)

-

Unique key

series_instance_uid

varchar(64)

Nullable

-

series_laterality

varchar(16)

Nullable

-

series_date

date

Nullable

-

protocol_name

varchar(64)

Nullable

-

series_desc

varchar(64)

Nullable

-

body_part_examined

varchar(16)

Nullable

-

study_pk_id

bigint(19, 0)

Nullable References: study

-

general_equipment_pk_id

bigint(19, 0)

Nullable
References: general_equipment

-

trial_protocol_id

varchar(64)

Nullable

-

trial_protocol_name

varchar(64)

Nullable

-

trial_site_name

varchar(64)

Nullable

-

study_date

date

Nullable

-

study_desc

varchar(64)

Nullable

-

admitting_diagnoses_desc

varchar(64)

Nullable

-

patient_age

varchar(4)

Nullable

-

patient_sex

varchar(16)

Nullable

-

patient_weight

decimal(22, 6)

Nullable

-

age_group

varchar(10)

Nullable

-

patient_pk_id

bigint(19, 0)

Nullable

-

series_number

decimal(22, 6)

Nullable

-

sync_frame_of_ref_uid

varchar(64)

Nullable

-

patient_id

varchar(64)

Nullable

-

frame_of_reference_uid

varchar(64)

Nullable

-

visibility

varchar(5)

Nullable

-

security_group

varchar(50)

Nullable

-

annotations_flag

varchar(5)

Nullable

-

Name

Data type

Description / Attributes

-

project

varchar(200)

Nullable

-

site

varchar(40)

Nullable

-

study_instance_uid

varchar(500)

Nullable

-

max_submission_timestamp

datetime

Nullable

-

batchNum

int(10, 0)

Nullable

-

submission_type

varchar(100)

Nullable

-

released_status

varchar(50)

Nullable

-

third_party_analysis

varchar(4)

Nullable

-

description_uri

varchar(500)

Nullable


Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id


Disabled trigger

study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id

Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation

ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1


One to many relation

general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id


One to many relation

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

Primary key

general_series_pk_id

PRIMARY


Unique key

general_series_pk_id

PK_G_SERIES_PK_ID


Unique key

series_instance_uid

series_instance_uid

Table: gui_action_history


Columns

Key

Name

Data type

Description / Attributes


Primary key

GUI_ACTION_HISTORY_PK_ID

bigint(19, 0)

Default: 0

-

ACTION_TIMESTAMP

date

Nullable

-

ACTION

varchar(255)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

GUI_ACTION_HISTORY_PK_ID

PRIMARY

Table: hibernate_unique_key


Columns

Key

Name

Data type

Description / Attributes

-

next_hi

bigint(19, 0)

-

Table: login_history


Columns

Key

Name

Data type

Description / Attributes


Primary key

login_history_pk_id

bigint(19, 0)

-

-

login_timestamp

datetime

Nullable

-

ip_address

varchar(15)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

login_history_pk_id

PRIMARY


Unique key

login_history_pk_id

PK_LOGIN_HISTORY_PK_ID

Table: modality_descriptions


Columns

Key

Name

Data type

Description / Attributes

Primary key

modality_descriptions_pk_id

bigint(19, 0)

-

-

modality_name

varchar(20)

Nullable

-

description

mediumtext

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

modality_descriptions_pk_id

PRIMARY


Unique key

modality_descriptions_pk_id

MD_COLLECTION_DESC_PK_ID

Table: mr_image


Columns

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

Primary key

MR_IMAGE_PK_ID

bigint(19, 0)

Identity / Auto increment

-

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable
References: general_series


Links to

Relationship

Table

Join

Title / Name / Description


Disabled trigger

general_image

mr_image.IMAGE_PK_ID = general_image.image_pk_id

FK_MR_GEN_IMAGE_PK_ID


Disabled trigger

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

Primary key

MR_IMAGE_PK_ID

PRIMARY

Table: patient

Columns

Key

Name

Data type

Description / Attributes

Primary key

patient_pk_id

bigint(19, 0)

-

-

patient_id

varchar(64)

Nullable

-

patient_name

varchar(250)

Nullable

-

patient_birth_date

date

Nullable

-

patient_sex

varchar(16)

Nullable

-

ethnic_group

varchar(16)

Nullable

-

trial_dp_pk_id

bigint(19, 0)

Nullable
References: trial_data_provenance

-

trial_subject_id

varchar(64)

Nullable

-

trial_subject_reading_id

varchar(255)

Nullable

-

trial_site_pk_id

bigint(19, 0)

Nullable

-

species_code

varchar(100)

Nullable

-

species_description

varchar(100)

Nullable

-

qc_subject

varchar(4)

Nullable

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

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

One to many relation

general_image

patient.patient_pk_id = general_image.patient_pk_id

FK_general_image_patient


One to many relation

study

patient.patient_pk_id = study.patient_pk_id

fk_patient_pk_id

Unique keys

Key

Columns

Name / Description

Primary key

patient_pk_id

PRIMARY


Unique key

patient_pk_id

PK_PATINET_PK_ID

Table: qc_status_history


Columns

Key

Name

Data type

Description / Attributes

Primary key

qc_status_history_pk_id

bigint(19, 0)

-

-

series_instance_uid

varchar(64)

-

-

user_id

varchar(100)

Nullable

-

comment_

varchar(4000)

Nullable

-

history_timestamp

datetime

Nullable

-

new_value

varchar(100)

Nullable

-

old_value

varchar(100)

Nullable

-

oldBatch

varchar(20)

Nullable

-

newBatch

varchar(20)

Nullable

-

oldSubmissionType

varchar(100)

Nullable

-

newSubmissionType

varchar(100)

Nullable

-

oldReleasedStatus

varchar(50)

Nullable

-

newReleasedStatus

varchar(50)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

qc_status_history_pk_id

PRIMARY


Unique key

qc_status_history_pk_id

PK_QC_STATUS_HISTORY_PK_ID

Table: query_history

Columns

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

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

csm_user

query_history.user_id = csm_user.USER_ID

FK_Q_H_USER_ID


Disabled trigger

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

One to many relation

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

Primary key

query_history_pk_id

PRIMARY


Unique key

query_history_pk_id

PK_QUERY_HISTORY_PK_ID

Table: query_history_attribute

Columns

Key

Name

Data type

Description / Attributes

Primary key

query_history_attribute_pk_id

bigint(19, 0)

-

-

attribute_name

varchar(300)

Nullable

-

subattribute_name

varchar(300)

Nullable

-

attribute_value

varchar(300)

Nullable

-

query_history_pk_id

bigint(19, 0)

Nullable
References: query_history

-

instance_number

bigint(19, 0)

Nullable

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

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

Primary key

query_history_attribute_pk_id

PRIMARY


Unique key

query_history_attribute_pk_id

PK_Q_H_A_PK_ID

Table: saved_query

Columns

Key

Name

Data type

Description / Attributes

Primary key

saved_query_pk_id

bigint(19, 0)

-

-

user_id

bigint(19, 0)

Nullable
References: csm_user

-

query_name

varchar(200)

Nullable

-

new_data_flag

varchar(5)

Nullable

-

active

varchar(5)

Nullable

-

query_execute_timestamp

datetime

Nullable

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

csm_user

saved_query.user_id = csm_user.USER_ID

FK_SAVED_QUERY_USER_ID

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

query_history

saved_query.saved_query_pk_id = query_history.saved_query_pk_id

fk_s_query_pk_id


One to many relation


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

Primary key

saved_query_pk_id

PRIMARY


Unique key

saved_query_pk_id

PK_SAVED_Q_PK_ID

Table: saved_query_attribute


Columns

Key

Name

Data type

Description / Attributes

Primary key

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


Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

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

Primary key

saved_query_attribute_pk_id

PRIMARY


Unique key

saved_query_attribute_pk_id

PK_S_Q_A_PK_ID

Table: site

Columns

Key

Name

Data type

Description / Attributes

Primary key

site_pk_id

bigint(19, 0)

-

-

dp_site_name

varchar(40)

Nullable

-

dp_site_id

varchar(64)

Nullable

-

trial_dp_pk_id

bigint(19, 0)

References: trial_data_provenance

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

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

Primary key

site_pk_id

PRIMARY


Unique key

site_pk_id

SITE_PK_ID

Table: species

Columns

Key

Name

Data type

Description / Attributes

Primary key

species_code

varchar(64)

-

-

species_description

varchar(500)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

species_code

PRIMARY

Table: study

Columns

Key

Name

Data type

Description / Attributes

Primary key

study_pk_id

bigint(19, 0)



Unique key

study_instance_uid

varchar(500)

Nullable

-

study_date

date

-

-

study_time

varchar(16)

Nullable

-

study_desc

varchar(64)

Nullable

-

admitting_diagnoses_desc

varchar(64)

Nullable

-

admitting_diagnoses_code_seq

varchar(500)

Nullable

-

patient_pk_id

bigint(19, 0)

Nullable References: patient

-

study_id

varchar(16)

Nullable

-

trial_time_point_id

varchar(64)

Nullable

-

trial_time_point_desc

varchar(1024)

Nullable

-

patient_age

varchar(4)

Nullable

-

age_group

varchar(10)

Nullable

-

patient_size

decimal(22, 6)

Nullable

-

patient_weight

decimal(22, 6)

Nullable

-

occupation

varchar(16)

Nullable

-

additional_patient_history

varchar(4000)

Nullable

Links to

Relationship

Table

Join

Title / Name / Description

Disabled trigger

patient

study.patient_pk_id = patient.patient_pk_id

fk_patient_pk_id

Linked from

Relationship

Table

Join

Title / Name / Description

One to many relation

general_image

study.study_pk_id = general_image.study_pk_id

FK_general_image_study


One to many relation

general_series

study.study_pk_id = general_series.study_pk_id

fk_gs_study_pk_id

Unique keys

Key

Columns

Name / Description

Primary key

study_pk_id

PRIMARY


Unique key

study_pk_id

PK_STUDY_PK_ID


Unique key

study_instance_uid

study_instance_uid

Table: submission_history

Columns

Key

Name

Data type

Description / Attributes

Unique key

submission_history_pk_id

bigint(19, 0)

Identity / Auto increment

-

patient_id

varchar(64)

Nullable

-

study_instance_uid

varchar(500)

Nullable

-

series_instance_uid

varchar(64)

Nullable

-

sop_instance_uid

varchar(64)

Nullable

-

submission_timestamp

datetime

Nullable

-

project

varchar(200)

Nullable

-

site

varchar(40)

Nullable

-

operation_type

smallint(5, 0)

-

Unique keys

Key

Columns

Name / Description

Unique key

submission_history_pk_id

submission_history_pk_id

Table: trial_data_provenance

Columns

Key

Name

Data type

Description / Attributes

Primary key

trial_dp_pk_id

bigint(19, 0)

-

-

dp_site_name

varchar(40)

Nullable

-

dp_site_id

varchar(64)

Nullable

-

project

varchar(50)

Nullable

Linked from

Relationship

Table

Join

Title / Name / Description


One to many relation

patient

trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id

fk_trial_dp_pk_id


One to many relation

site

trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id

fk_tdp_st_pk_id

Unique keys

Key

Columns

Name / Description

Primary key

trial_dp_pk_id

PRIMARY


Unique key

trial_dp_pk_id

PK_TRIAL_DP_PK_ID

Table: trial_site

Columns

Key

Name

Data type

Description / Attributes

Primary key

trial_site_pk_id

bigint(19, 0)

-

-

trial_site_id

varchar(64)

Nullable

-

trial_site_name

varchar(64)

Nullable

-

trial_pk_id

bigint(19, 0)

Nullable


Unique keys

Key

Columns

Name / Description

Primary key

trial_site_pk_id

PRIMARY


Unique key

trial_site_pk_id

PK_TRIAL_SITE_PK_ID

Table: workflow


Columns

Key

Name

Data type

Description / Attributes

Primary key

WORKFLOW_ID

bigint(19, 0)

-

-

NAME

varchar(50)

Nullable

-

COLLECTION

varchar(200)

Nullable

-

SITE

varchar(200)

Nullable

-

URL

varchar(255)

Nullable

-

WORKFLOW_TYPE

varchar(50)

Nullable

Unique keys

Key

Columns

Name / Description

Primary key

WORKFLOW_ID

PRIMARY

Views

View: dicom_image

VIEW
Columns

Name

Data type

Description / Attributes

IMAGE_PK_ID

bigint(19, 0)


INSTANCE_NUMBER

bigint(19, 0)

Nullable

CONTENT_DATE

date

Nullable

CONTENT_TIME

varchar(16)

Nullable

IMAGE_TYPE

varchar(16)

Nullable

ACQUISITION_DATE

date

Nullable

ACQUISITION_TIME

varchar(16)

Nullable

ACQUISITION_NUMBER

decimal(22, 6)

Nullable

LOSSY_IMAGE_COMPRESSION

varchar(16)

Nullable

PIXEL_SPACING

decimal(22, 6)

Nullable

IMAGE_ORIENTATION_PATIENT

varchar(200)

Nullable

IMAGE_POSITION_PATIENT

varchar(200)

Nullable

SLICE_THICKNESS

decimal(22, 6)

Nullable

SLICE_LOCATION

decimal(22, 6)

Nullable

I_ROWS

decimal(22, 6)

Nullable

I_COLUMNS

decimal(22, 6)

Nullable

CONTRAST_BOLUS_AGENT

varchar(64)

Nullable

CONTRAST_BOLUS_ROUTE

varchar(64)

Nullable

SOP_CLASS_UID

varchar(64)

Nullable

SOP_INSTANCE_UID

varchar(64)

Nullable

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable

PATIENT_POSITION

varchar(16)

Nullable

SOURCE_TO_DETECTOR_DISTANCE

decimal(22, 6)

Nullable

SOURCE_SUBJECT_DISTANCE

decimal(22, 6)

Nullable

FOCAL_SPOT_SIZE

decimal(22, 6)

Nullable

STORAGE_MEDIA_FILE_SET_UID

varchar(64)

Nullable

DICOM_FILE_URI

varchar(2000)

Nullable

ACQUISITION_DATETIME

varchar(50)

Nullable

IMAGE_COMMENTS

varchar(4000)

Nullable

IMAGE_RECEIVING_TIMESTAMP

datetime

Nullable

CURATION_TIMESTAMP

datetime

Nullable

ANNOTATION

varchar(20)

Nullable

SUBMISSION_DATE

date

Nullable

DICOM_SIZE

decimal(22, 6)

Nullable

IMAGE_LATERALITY

varchar(16)

Nullable

TRIAL_DP_PK_ID

bigint(19, 0)

Nullable

PATIENT_ID

varchar(64)

Nullable

STUDY_INSTANCE_UID

varchar(500)

Nullable

SERIES_INSTANCE_UID

varchar(64)

Nullable

PATIENT_PK_ID

bigint(19, 0)

Nullable

STUDY_PK_ID

bigint(19, 0)

Nullable

PROJECT

varchar(200)

Nullable

ACQUISITION_MATRIX

decimal(22, 6)

Nullable
Default: 0.000000

DX_DATA_COLLECTION_DIAMETER

decimal(22, 6)

Nullable
Default: 0.000000

KVP

decimal(22, 6)

Nullable

SCAN_OPTIONS

varchar(16)

Nullable

DATA_COLLECTION_DIAMETER

decimal(22, 6)

Nullable

RECONSTRUCTION_DIAMETER

decimal(22, 6)

Nullable

GANTRY_DETECTOR_TILT

decimal(22, 6)

Nullable

Name

Data type

Description / Attributes

EXPOSURE_TIME

decimal(22, 6)

Nullable

X_RAY_TUBE_CURRENT

decimal(22, 6)

Nullable

EXPOSURE

decimal(22, 6)

Nullable

EXPOSURE_IN_MICROAS

decimal(22, 6)

Nullable

CONVOLUTION_KERNEL

varchar(16)

Nullable

REVOLUTION_TIME

decimal(22, 6)

Nullable

SINGLE_COLLIMATION_WIDTH

decimal(22, 6)

Nullable

TOTAL_COLLIMATION_WIDTH

decimal(22, 6)

Nullable

TABLE_SPEED

decimal(22, 6)

Nullable

TABLE_FEED_PER_ROTATION

decimal(22, 6)

Nullable

CT_PITCH_FACTOR

decimal(22, 6)

Nullable

ANATOMIC_REGION_SEQ

varchar(500)

Nullable

View: dicom_series

VIEW
Columns

Name

Data type

Description / Attributes

GENERAL_SERIES_PK_ID

bigint(19, 0)

-

BODY_PART_EXAMINED

varchar(16)

Nullable

FRAME_OF_REFERENCE_UID

varchar(64)

Nullable

SERIES_LATERALITY

varchar(16)

Nullable

MODALITY

varchar(16)

-

PROTOCOL_NAME

varchar(64)

Nullable

SERIES_DATE

date

Nullable

SERIES_DESC

varchar(64)

Nullable

SERIES_INSTANCE_UID

varchar(64)

Nullable

SERIES_NUMBER

decimal(22, 6)

Nullable

SYNC_FRAME_OF_REF_UID

varchar(64)

Nullable

STUDY_PK_ID

bigint(19, 0)

Nullable

GENERAL_EQUIPMENT_PK_ID

bigint(19, 0)

Nullable

View: dicom_study

VIEW
Columns

Name

Data type

Description / Attributes

STUDY_PK_ID

bigint(19, 0)

-

STUDY_INSTANCE_UID

varchar(500)

Nullable

ADDITIONAL_PATIENT_HISTORY

varchar(4000)

Nullable

STUDY_DATE

date

-

STUDY_DESC

varchar(64)

Nullable

ADMITTING_DIAGNOSES_DESC

varchar(64)

Nullable

ADMITTING_DIAGNOSES_CODE_S EQ

varchar(500)

Nullable

OCCUPATION

varchar(16)

Nullable

PATIENT_AGE

varchar(4)

Nullable

PATIENT_SIZE

decimal(22, 6)

Nullable

PATIENT_WEIGHT

decimal(22, 6)

Nullable

STUDY_ID

varchar(16)

Nullable

STUDY_TIME

varchar(16)

Nullable

TRIAL_TIME_POINT_ID

varchar(64)

Nullable

TRIAL_TIME_POINT_DESC

varchar(1024)

Nullable

PATIENT_PK_ID

bigint(19, 0)

Nullable

View: manufacturer

VIEW
Columns

Name

Data type

Description / Attributes

MANUFACTURER

varchar(64)

Nullable

View: manufacturer_model_software

VIEW
Columns

Name

Data type

Description / Attributes

ID

bigint(19, 0)

-

MANUFACTURER

varchar(64)

Nullable

MODEL

varchar(64)

Nullable

SOFTWARE

varchar(64)

Nullable

View: number_month

VIEW
Columns

Name

Data type

Description / Attributes

PATIENT_ID

bigint(19, 0)

Nullable

NUMBER_MONTH

bigint(19, 0)

Nullable

View: saved_query_last_exec

VIEW
Columns

Name

Data type

Description / Attributes

SAVED_QUERY_PK_ID

bigint(19, 0)

Nullable

LAST_EXECUTE_DATE

datetime

Nullable

View: software_versions

VIEW
Columns

Name

Data type

Description / Attributes

SOFTWARE_VERSIONS

varchar(64)

Nullable

View: study_series_number

VIEW
Columns

Name

Data type

Description / Attributes

PATIENT_PK_ID

bigint(19, 0)

Nullable

PATIENT_ID

varchar(64)

Nullable

PROJECT

varchar(50)

Nullable

STUDY_NUMBER

bigint(19, 0)

Default: 0

SERIES_NUMBER

bigint(19, 0)

Default: 0

  • No labels