Lite Edition
NBIA
Data Dictionary
6/17/2020 12:00:00 AM
Generated with
Table of contents
NBIA 7
- Tables 7
- Table: collection_descriptions 7
- Table: csm_application 7
- Table: csm_configuration_props 8
- Table: csm_filter_clause 8
- Table: csm_group 8
- Table: csm_mapping 9
- Table: csm_password_history 10
- Table: csm_pg_pe 10
- Table: csm_privilege 11
- Table: csm_protection_element 11
- Table: csm_protection_group 12
- Table: csm_role 13
- Table: csm_role_privilege 13
- Table: csm_user 14
- Table: csm_user_group 15
- Table: csm_user_group_role_pg 15
- Table: csm_user_pe 16
- Table: ct_image 17
- Table: custom_series_list 17
- Table: custom_series_list_attribute 18
- Table: databasechangelog 18
- Table: databasechangeloglock 19
- Table: deletion_audit_trail 19
- Table: download_data_history 20
- Table: download_history 20
- Table: general_equipment 20
- Table: general_image 21
- Table: general_series 23
- Table: gui_action_history 24
- Table: hibernate_unique_key 25
- Table: login_history 25
- Table: modality_descriptions 25
- Table: mr_image 25
- Table: patient 26
- Table: qc_status_history 27
- Table: query_history 27
- Table: query_history_attribute 28
- Table: saved_query 29
- Table: saved_query_attribute 29
- Table: site 30
- Table: species 30
- Table: study 30
- Table: submission_history 31
- Table: trial_data_provenance 32
- Table: trial_site 32
- Table: workflow 33
- Views 33
- View: dicom_image 33
- View: dicom_series 35
- View: dicom_study 35
- View: manufacturer 36
- View: manufacturer_model_software 36
- View: number_month 36
- View: saved_query_last_exec 36
- View: software_versions 37
- View: study_series_number 37Legend
Primary key
Primary key disabled
User-defined primary key 
Unique key
Unique key disabled
User-defined unique key 
Active trigger
Disabled trigger Many to one relation
User-defined many to one relation One to many relation
User-defined one to many relation One to one relation
User-defined one to one relation 
Input
Output
Input/Output
Uses dependency
User-defined uses dependency 
Used by dependency
User-defined used by dependency
NBIATables
Table: collection_descriptions
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
collection_descriptions_pk_id |
PRIMARY |
|
collection_descriptions_pk_id |
PK_COLLECTION_DESC_PK_ID |
Table: csm_application
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
APPLICATION_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
csm_application.APPLICATION_ID = csm_group.APPLICATION_ID |
FK_APPLICATION_GROUP |
|
|
csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID |
FK_PE_APPLICATION |
|
|
Table |
Join |
Title / Name / Description |
|
csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D |
FK_PG_APPLICATION |
|
|
csm_application.APPLICATION_ID = csm_role.APPLICATION_ID |
FK_APPLICATION_ROLE |
Unique keys
|
Columns |
Name / Description |
|
APPLICATION_ID |
PRIMARY |
|
APPLICATION_NAME |
UQ_APPLICATION_NAME |
Table: csm_configuration_props
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
PROPERTY_KEY |
varchar(300) |
|
|
|
PROPERTY_VALUE |
varchar(3000) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
PROPERTY_KEY |
PRIMARY |
Table: csm_filter_clause
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
FILTER_CLAUSE_ID |
PRIMARY |
Table: csm_group
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
GROUP_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
GROUP_NAME |
varchar(255) |
|
|
|
GROUP_DESC |
varchar(200) |
Nullable |
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
|
|
APPLICATION_ID |
bigint(19, 0) |
References: csm_application |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_group.APPLICATION_ID = csm_application.APPLICATION_ID |
FK_APPLICATION_GROUP |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_group.GROUP_ID = csm_user_group.GROUP_ID |
FK_UG_GROUP |
|
|
csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS |
Unique keys
|
Columns |
Name / Description |
|
GROUP_ID |
PRIMARY |
|
APPLICATION_ID, GROUP_NAME |
UQ_GROUP_GROUP_NAME |
Table: csm_mapping
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
MAPPING_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
APPLICATION_ID |
bigint(19, 0) |
References: csm_application |
|
|
OBJECT_NAME |
varchar(100) |
|
|
|
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
|
Table |
Join |
Title / Name / Description |
|
csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID |
FK_PE_APPLICATION |
Unique keys
|
Columns |
Name / Description |
|
MAPPING_ID |
PRIMARY |
|
OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID |
UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID |
Table: csm_password_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
CSM_PASSWORD_HISTORY_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
LOGIN_NAME |
varchar(500) |
Nullable |
|
|
PASSWORD |
varchar(255) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
CSM_PASSWORD_HISTORY_ID |
PRIMARY |
Table: csm_pg_pe
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
PG_PE_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
PROTECTION_GROUP_ID |
bigint(19, 0) |
References: csm_protection_group |
|
|
PROTECTION_ELEMENT_ID |
bigint(19, 0) |
References: csm_protection_element |
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_pg_pe.PROTECTION_ELEMENT_I D = |
FK_PROTECTION_ELEMENT_PROTECTION_GROUP |
|
|
csm_pg_pe.PROTECTION_GROUP_ID |
FK_PROTECTION_GROUP_PROTECTION_ELEMENT |
Unique keys
|
Columns |
Name / Description |
|
PG_PE_ID |
PRIMARY |
|
Columns |
Name / Description |
|
PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID |
UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID |
Table: csm_privilege
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
PRIVILEGE_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
PRIVILEGE_NAME |
varchar(100) |
|
|
|
PRIVILEGE_DESCRIPTION |
varchar(200) |
Nullable |
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID |
FK_PRIVILEGE_ROLE |
Unique keys
|
Columns |
Name / Description |
|
PRIVILEGE_ID |
PRIMARY |
|
PRIVILEGE_NAME |
UQ_PRIVILEGE_NAME |
Table: csm_protection_element
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
PROTECTION_ELEMENT_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
PROTECTION_ELEMENT_NAME |
varchar(100) |
|
|
|
PROTECTION_ELEMENT_DESCRIPTI ON |
varchar(200) |
Nullable |
|
|
OBJECT_ID |
varchar(100) |
|
|
|
ATTRIBUTE |
varchar(100) |
Nullable |
|
|
PROTECTION_ELEMENT_TYPE |
varchar(100) |
Nullable |
|
|
APPLICATION_ID |
bigint(19, 0) |
|
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
|
|
ATTRIBUTE_VALUE |
varchar(100) |
Nullable |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_protection_element.PROTECTION |
FK_PROTECTION_ELEMENT_PROTECTION_GROUP |
|
|
Table |
Join |
Title / Name / Description |
|
csm_protection_element.PROTECTION |
FK_PROTECTION_ELEMENT_USER |
Unique keys
|
Columns |
Name / Description |
|
PROTECTION_ELEMENT_ID |
PRIMARY |
|
OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID |
UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID |
Table: csm_protection_group
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
PROTECTION_GROUP_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
PROTECTION_GROUP_NAME |
varchar(100) |
|
|
|
PROTECTION_GROUP_DESCRIPTIO N |
varchar(200) |
Nullable |
|
|
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 |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID |
FK_PG_APPLICATION |
|
|
csm_protection_group.PARENT_PROT ECTION_GROUP_ID = |
FK_PROTECTION_GROUP |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_protection_group.PROTECTION_ GROUP_ID = |
FK_PROTECTION_GROUP |
|
|
csm_protection_group.PROTECTION_ GROUP_ID = |
FK_PROTECTION_GROUP_PROTECTION_ELEMENT |
|
|
csm_protection_group.PROTECTION_ GROUP_ID = |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP |
Unique keys
|
Columns |
Name / Description |
|
PROTECTION_GROUP_ID |
PRIMARY |
|
APPLICATION_ID, PROTECTION_GROUP_NAME |
UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME |
Table: csm_role
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
ROLE_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
ROLE_NAME |
varchar(100) |
|
|
|
ROLE_DESCRIPTION |
varchar(200) |
Nullable |
|
|
APPLICATION_ID |
bigint(19, 0) |
References: csm_application |
|
|
ACTIVE_FLAG |
tinyint(3, 0) |
|
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_role.APPLICATION_ID = csm_application.APPLICATION_ID |
FK_APPLICATION_ROLE |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_role.ROLE_ID = csm_role_privilege.ROLE_ID |
FK_ROLE |
|
|
csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE |
Unique keys
|
Columns |
Name / Description |
|
ROLE_ID |
PRIMARY |
|
APPLICATION_ID, ROLE_NAME |
UQ_ROLE_ROLE_NAME |
Table: csm_role_privilege
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
ROLE_PRIVILEGE_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
ROLE_ID |
bigint(19, 0) |
References: csm_role |
|
|
PRIVILEGE_ID |
bigint(19, 0) |
References: csm_privilege |
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID |
FK_PRIVILEGE_ROLE |
|
|
csm_role_privilege.ROLE_ID = csm_role.ROLE_ID |
FK_ROLE |
Unique keys
|
Columns |
Name / Description |
|
ROLE_PRIVILEGE_ID |
PRIMARY |
|
PRIVILEGE_ID, ROLE_ID |
UQ_ROLE_PRIVILEGE_ROLE_ID |
Table: csm_user
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
Name |
Data type |
Description / Attributes |
|
|
ACTIVE_FLAG |
tinyint(3, 0) |
Nullable Default: 1 |
|
|
PASSWORD_EXPIRY_DATE |
date |
Nullable |
Linked from
|
Table |
Join |
Title / Name / Description |
|
csm_user.USER_ID = csm_user_group.USER_ID |
FK_USER_GROUP |
|
|
csm_user.USER_ID = csm_user_group_role_pg.USER_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER |
|
|
csm_user.USER_ID = csm_user_pe.USER_ID |
FK_PE_USER |
|
|
csm_user.USER_ID = query_history.user_id |
FK_Q_H_USER_ID |
|
|
csm_user.USER_ID = saved_query.user_id |
FK_SAVED_QUERY_USER_ID |
Unique keys
|
Columns |
Name / Description |
|
USER_ID |
PRIMARY |
Table: csm_user_group
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
csm_user_group.GROUP_ID = csm_group.GROUP_ID |
FK_UG_GROUP |
|
|
csm_user_group.USER_ID = csm_user.USER_ID |
FK_USER_GROUP |
Unique keys
|
Columns |
Name / Description |
|
USER_GROUP_ID |
PRIMARY |
Table: csm_user_group_role_pg
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
USER_GROUP_ROLE_PG_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
Name |
Data type |
Description / Attributes |
|
|
USER_ID |
bigint(19, 0) |
Nullable |
|
|
GROUP_ID |
bigint(19, 0) |
Nullable |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS |
|
|
csm_user_group_role_pg.PROTECTIO N_GROUP_ID = |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP |
|
|
csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE |
|
|
csm_user_group_role_pg.USER_ID = csm_user.USER_ID |
FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER |
Unique keys
|
Columns |
Name / Description |
|
USER_GROUP_ROLE_PG_ID |
PRIMARY |
Table: csm_user_pe
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
USER_PROTECTION_ELEMENT_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
PROTECTION_ELEMENT_ID |
bigint(19, 0) |
References: csm_protection_element |
|
|
USER_ID |
bigint(19, 0) |
References: csm_user |
|
|
UPDATE_DATE |
date |
Default: 1950-01-01 |
Links to
|
Table |
Join |
Title / Name / Description |
|
csm_user_pe.PROTECTION_ELEMENT_ ID = |
FK_PROTECTION_ELEMENT_USER |
|
|
csm_user_pe.USER_ID = csm_user.USER_ID |
FK_PE_USER |
Unique keys
|
Columns |
Name / Description |
|
USER_PROTECTION_ELEMENT_ID |
PRIMARY |
|
Columns |
Name / Description |
|
USER_ID, PROTECTION_ELEMENT_ID |
UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID |
Table: ct_image
Columns
|
|
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 |
|
|
ct_image_pk_id |
bigint(19, 0) |
|
|
|
general_series_pk_id |
bigint(19, 0) |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
ct_image.image_pk_id = general_image.image_pk_id |
fk_image_pk_id |
|
|
ct_image.general_series_pk_id = general_series.general_series_pk_id |
ct_image_ibfk_1 |
Unique keys
|
Columns |
Name / Description |
|
ct_image_pk_id |
PRIMARY |
|
ct_image_pk_id |
PK_CT_IMAGE_PK_ID |
Table: custom_series_list
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
custom_series_list.CUSTOM_SERIES_LI ST_PK_ID = |
FK_CUSTOM_SERIES_LIST_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
CUSTOM_SERIES_LIST_PK_ID |
PRIMARY |
|
CUSTOM_SERIES_LIST_PK_ID |
CUSTOM_SERIES_LIST_PK_ID |
Table: custom_series_list_attribute
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID = |
FK_CUSTOM_SERIES_LIST_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
custom_series_list_attribute_p |
PRIMARY |
|
custom_series_list_attribute_p |
CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID |
Table: databasechangelog
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
ID |
varchar(63) |
|
|
|
AUTHOR |
varchar(63) |
|
|
|
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
|
Columns |
Name / Description |
|
ID, AUTHOR, FILENAME |
PRIMARY |
Table: databasechangeloglock
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
ID |
int(10, 0) |
|
|
|
LOCKED |
tinyint(3, 0) |
|
|
|
LOCKGRANTED |
datetime |
Nullable |
|
|
LOCKEDBY |
varchar(255) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
ID |
PRIMARY |
Table: deletion_audit_trail
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
deletion_pk_id |
PRIMARY |
Table: download_data_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
download_data_history_pk_id |
PRIMARY |
Table: download_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
download_history_pk_id |
PRIMARY |
Table: general_equipment
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id |
fk_g_equipment_pk_id |
Unique keys
|
Columns |
Name / Description |
|
general_equipment_pk_id |
PRIMARY |
|
general_equipment_pk_id |
PK_G_EQUIPMENT_ID |
Table: general_image
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 |
|
|
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 |
|
|
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 |
|
|
dx_data_collection_diameter |
decimal(22, 6) |
Nullable |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
general_image.general_series_pk_id = general_series.general_series_pk_id |
fk_g_series_pk_id |
|
|
general_image.patient_pk_id = patient.patient_pk_id |
FK_general_image_patient |
|
|
general_image.study_pk_id = study.study_pk_id |
FK_general_image_study |
Linked from
|
Table |
Join |
Title / Name / Description |
|
general_image.image_pk_id = ct_image.image_pk_id |
fk_image_pk_id |
|
|
general_image.image_pk_id = mr_image.IMAGE_PK_ID |
FK_MR_GEN_IMAGE_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
image_pk_id |
PRIMARY |
|
image_pk_id, submission_date |
Image_Visibility_Submitted_IDX |
|
image_pk_id |
PK_IMAGE_PK_ID |
|
sop_instance_uid |
sop_instance_uid |
Table: general_series
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
general_series_pk_id |
bigint(19, 0) |
|
|
|
modality |
varchar(16) |
|
|
|
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 |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id |
fk_g_equipment_pk_id |
|
|
general_series.study_pk_id = study.study_pk_id |
fk_gs_study_pk_id |
Linked from
|
Table |
Join |
Title / Name / Description |
|
general_series.general_series_pk_id = ct_image.general_series_pk_id |
ct_image_ibfk_1 |
|
|
general_series.general_series_pk_id = general_image.general_series_pk_id |
fk_g_series_pk_id |
|
|
general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID |
FK_MR_GEN_SERIES_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
general_series_pk_id |
PRIMARY |
|
general_series_pk_id |
PK_G_SERIES_PK_ID |
|
series_instance_uid |
series_instance_uid |
Table: gui_action_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
GUI_ACTION_HISTORY_PK_ID |
bigint(19, 0) |
Default: 0 |
|
|
ACTION_TIMESTAMP |
date |
Nullable |
|
|
ACTION |
varchar(255) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
GUI_ACTION_HISTORY_PK_ID |
PRIMARY |
Table: hibernate_unique_key
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
next_hi |
bigint(19, 0) |
|
Table: login_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
login_history_pk_id |
bigint(19, 0) |
|
|
|
login_timestamp |
datetime |
Nullable |
|
|
ip_address |
varchar(15) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
login_history_pk_id |
PRIMARY |
|
login_history_pk_id |
PK_LOGIN_HISTORY_PK_ID |
Table: modality_descriptions
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
modality_descriptions_pk_id |
bigint(19, 0) |
|
|
|
modality_name |
varchar(20) |
Nullable |
|
|
description |
mediumtext |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
modality_descriptions_pk_id |
PRIMARY |
|
modality_descriptions_pk_id |
MD_COLLECTION_DESC_PK_ID |
Table: mr_image
Columns
|
|
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 |
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
MR_IMAGE_PK_ID |
bigint(19, 0) |
Identity / Auto increment |
|
|
GENERAL_SERIES_PK_ID |
bigint(19, 0) |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
mr_image.IMAGE_PK_ID = general_image.image_pk_id |
FK_MR_GEN_IMAGE_PK_ID |
|
|
mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id |
FK_MR_GEN_SERIES_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
MR_IMAGE_PK_ID |
PRIMARY |
Table: patient
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id |
fk_trial_dp_pk_id |
Linked from
|
Table |
Join |
Title / Name / Description |
|
patient.patient_pk_id = general_image.patient_pk_id |
FK_general_image_patient |
|
|
patient.patient_pk_id = study.patient_pk_id |
fk_patient_pk_id |
Unique keys
|
Columns |
Name / Description |
|
patient_pk_id |
PRIMARY |
|
patient_pk_id |
PK_PATINET_PK_ID |
Table: qc_status_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
qc_status_history_pk_id |
PRIMARY |
|
qc_status_history_pk_id |
PK_QC_STATUS_HISTORY_PK_ID |
Table: query_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
query_history_pk_id |
bigint(19, 0) |
|
|
|
user_id |
bigint(19, 0) |
Nullable |
|
|
query_execute_timestamp |
datetime |
Nullable |
|
|
query_elapsed_time |
bigint(19, 0) |
Nullable |
|
|
saved_query_pk_id |
bigint(19, 0) |
Nullable |
|
|
tool |
varchar(100) |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
query_history.user_id = csm_user.USER_ID |
FK_Q_H_USER_ID |
|
|
query_history.saved_query_pk_id = saved_query.saved_query_pk_id |
fk_s_query_pk_id |
Linked from
|
Table |
Join |
Title / Name / Description |
|
query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id |
FK_Q_H_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
query_history_pk_id |
PRIMARY |
|
query_history_pk_id |
PK_QUERY_HISTORY_PK_ID |
Table: query_history_attribute
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
instance_number |
bigint(19, 0) |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
query_history_attribute.query_history_ pk_id = query_history.query_history_pk_id |
FK_Q_H_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
query_history_attribute_pk_id |
PRIMARY |
|
query_history_attribute_pk_id |
PK_Q_H_A_PK_ID |
Table: saved_query
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
saved_query_pk_id |
bigint(19, 0) |
|
|
|
user_id |
bigint(19, 0) |
Nullable |
|
|
query_name |
varchar(200) |
Nullable |
|
|
new_data_flag |
varchar(5) |
Nullable |
|
|
active |
varchar(5) |
Nullable |
|
|
query_execute_timestamp |
datetime |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
saved_query.user_id = csm_user.USER_ID |
FK_SAVED_QUERY_USER_ID |
Linked from
|
Table |
Join |
Title / Name / Description |
|
saved_query.saved_query_pk_id = query_history.saved_query_pk_id |
fk_s_query_pk_id |
|
|
saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk |
FK_SAVED_QUERY_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
saved_query_pk_id |
PRIMARY |
|
saved_query_pk_id |
PK_SAVED_Q_PK_ID |
Table: saved_query_attribute
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
Name |
Data type |
Description / Attributes |
|
|
instance_number |
bigint(19, 0) |
Nullable |
Links to
|
Table |
Join |
Title / Name / Description |
|
saved_query_attribute.saved_query_pk |
FK_SAVED_QUERY_PK_ID |
Unique keys
|
Columns |
Name / Description |
|
saved_query_attribute_pk_id |
PRIMARY |
|
saved_query_attribute_pk_id |
PK_S_Q_A_PK_ID |
Table: site
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id |
fk_tdp_st_pk_id |
Unique keys
|
Columns |
Name / Description |
|
site_pk_id |
PRIMARY |
|
site_pk_id |
SITE_PK_ID |
Table: species
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
species_code |
varchar(64) |
|
|
|
species_description |
varchar(500) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
species_code |
PRIMARY |
Table: study
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
study_pk_id |
bigint(19, 0) |
|
|
|
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
|
Table |
Join |
Title / Name / Description |
|
study.patient_pk_id = patient.patient_pk_id |
fk_patient_pk_id |
Linked from
|
Table |
Join |
Title / Name / Description |
|
study.study_pk_id = general_image.study_pk_id |
FK_general_image_study |
|
|
study.study_pk_id = general_series.study_pk_id |
fk_gs_study_pk_id |
Unique keys
|
Columns |
Name / Description |
|
study_pk_id |
PRIMARY |
|
study_pk_id |
PK_STUDY_PK_ID |
|
study_instance_uid |
study_instance_uid |
Table: submission_history
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
submission_history_pk_id |
submission_history_pk_id |
Table: trial_data_provenance
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Table |
Join |
Title / Name / Description |
|
trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id |
fk_trial_dp_pk_id |
|
|
trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id |
fk_tdp_st_pk_id |
Unique keys
|
Columns |
Name / Description |
|
trial_dp_pk_id |
PRIMARY |
|
trial_dp_pk_id |
PK_TRIAL_DP_PK_ID |
Table: trial_site
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
trial_site_pk_id |
bigint(19, 0) |
|
|
|
trial_site_id |
varchar(64) |
Nullable |
|
|
Name |
Data type |
Description / Attributes |
|
|
trial_site_name |
varchar(64) |
Nullable |
|
|
trial_pk_id |
bigint(19, 0) |
Nullable |
Unique keys
|
Columns |
Name / Description |
|
trial_site_pk_id |
PRIMARY |
|
trial_site_pk_id |
PK_TRIAL_SITE_PK_ID |
Table: workflow
Columns
|
|
Name |
Data type |
Description / Attributes |
|
|
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
|
Columns |
Name / Description |
|
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 |
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
|
|
DX_DATA_COLLECTION_DIAMETER |
decimal(22, 6) |
Nullable |
|
|
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 |
|
|
|
Name |
Data type |
Description / Attributes |
|
|
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 |
