NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

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

Input

Input

Output

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

Icon1

Icon2

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

Icon1

Columns

Name / Description


Primary key

collection_descriptions_pk_id

PRIMARY


collection_descriptions_pk_id

PK_COLLECTION_DESC_PK_ID

Columns for Table: csm_application 



Name

Data type

Description / Attributes



Primary key

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_group

csm_application.APPLICATION_ID = csm_group.APPLICATION_ID

FK_APPLICATION_GROUP


csm_mapping

csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID

FK_PE_APPLICATION


Table

Join

Title / Name / Description



csm_protection_group

csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D

FK_PG_APPLICATION


csm_role

csm_application.APPLICATION_ID = csm_role.APPLICATION_ID

FK_APPLICATION_ROLE

Unique keys


Columns

Name / Description


Primary key

APPLICATION_ID

PRIMARY


APPLICATION_NAME

UQ_APPLICATION_NAME

Table: csm_configuration_props


Columns



Name

Data type

Description / Attributes



Primary key

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



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


Columns

Name / Description


Primary key

FILTER_CLAUSE_ID

PRIMARY

Table: csm_group

Columns



Name

Data type

Description / Attributes



Primary key

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_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

Linked from


Table

Join

Title / Name / Description


csm_user_group

csm_group.GROUP_ID = csm_user_group.GROUP_ID

FK_UG_GROUP


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


Columns

Name / Description


Primary key

GROUP_ID

PRIMARY


APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAME

Table: csm_mapping

Columns



Name

Data type

Description / Attributes



Primary key

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_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

Unique keys


Columns

Name / Description


Primary key

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



Primary key

CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment



LOGIN_NAME

varchar(500)

Nullable



PASSWORD

varchar(255)

Nullable

Unique keys


Columns

Name / Description


Primary key

CSM_PASSWORD_HISTORY_ID

PRIMARY

Table: csm_pg_pe

Columns



Name

Data type

Description / Attributes



Primary key

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_protection_element

csm_pg_pe.PROTECTION_ELEMENT_I D =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_PROTECTION_GROUP




csm_protection_group

csm_pg_pe.PROTECTION_GROUP_ID
=
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT

Unique keys


Columns

Name / Description


Primary key

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



Primary key

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_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

Unique keys


Columns

Name / Description


Primary key

PRIVILEGE_ID

PRIMARY


PRIVILEGE_NAME

UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns



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



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_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




csm_user_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_user_pe.PROTECTION_ELEMENT_ ID

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



Primary key

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
References: csm_protection_group

Links to


Table

Join

Title / Name / Description


csm_application

csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID

FK_PG_APPLICATION




csm_protection_group

csm_protection_group.PARENT_PROT ECTION_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP

Linked from


Table

Join

Title / Name / Description




csm_protection_group

csm_protection_group.PROTECTION_ GROUP_ID =
csm_protection_group.PARENT_PROT ECTION_GROUP_ID

FK_PROTECTION_GROUP



csm_pg_pe

csm_protection_group.PROTECTION_ GROUP_ID =
csm_pg_pe.PROTECTION_GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT




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


Columns

Name / Description


Primary key

PROTECTION_GROUP_ID

PRIMARY


APPLICATION_ID, PROTECTION_GROUP_NAME

UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns



Name

Data type

Description / Attributes



Primary key

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_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

Linked from


Table

Join

Title / Name / Description


csm_role_privilege

csm_role.ROLE_ID = csm_role_privilege.ROLE_ID

FK_ROLE


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


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_privilege

csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE


csm_role

csm_role_privilege.ROLE_ID = csm_role.ROLE_ID

FK_ROLE

Unique keys


Columns

Name / Description


Primary key

ROLE_PRIVILEGE_ID

PRIMARY


PRIVILEGE_ID, ROLE_ID

UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user


Columns



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



Name

Data type

Description / Attributes



ACTIVE_FLAG

tinyint(3, 0)

Nullable Default: 1



PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10


Linked from


Table

Join

Title / Name / Description


csm_user_group

csm_user.USER_ID = csm_user_group.USER_ID

FK_USER_GROUP


csm_user_group_role_pg

csm_user.USER_ID = csm_user_group_role_pg.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER


csm_user_pe

csm_user.USER_ID = csm_user_pe.USER_ID

FK_PE_USER


query_history

csm_user.USER_ID = query_history.user_id

FK_Q_H_USER_ID


saved_query

csm_user.USER_ID = saved_query.user_id

FK_SAVED_QUERY_USER_ID

Unique keys


Columns

Name / Description


Primary key

USER_ID

PRIMARY

Table: csm_user_group

Columns



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


Table

Join

Title / Name / Description


csm_group

csm_user_group.GROUP_ID = csm_group.GROUP_ID

FK_UG_GROUP


csm_user

csm_user_group.USER_ID = csm_user.USER_ID

FK_USER_GROUP

Unique keys


Columns

Name / Description

Primary key

USER_GROUP_ID

PRIMARY

Table: csm_user_group_role_pg


Columns



Name

Data type

Description / Attributes



Primary key

USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto increment



Name

Data type

Description / Attributes



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


Table

Join

Title / Name / Description


csm_group

csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS




csm_protection_group

csm_user_group_role_pg.PROTECTIO N_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP


csm_role

csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE


csm_user

csm_user_group_role_pg.USER_ID = csm_user.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

Unique keys


Columns

Name / Description

Primary key

USER_GROUP_ROLE_PG_ID

PRIMARY

Table: csm_user_pe


Columns



Name

Data type

Description / Attributes



Primary key

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_protection_element

csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_USER


csm_user

csm_user_pe.USER_ID = csm_user.USER_ID

FK_PE_USER

Unique keys


Columns

Name / Description


Primary key

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



Primary key

ct_image_pk_id

bigint(19, 0)




general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Links to


Table

Join

Title / Name / Description


general_image

ct_image.image_pk_id = general_image.image_pk_id

fk_image_pk_id


general_series

ct_image.general_series_pk_id = general_series.general_series_pk_id

ct_image_ibfk_1

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

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


Table

Join

Title / Name / Description




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


Columns

Name / Description


Primary key

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



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


Table

Join

Title / Name / Description




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


Columns

Name / Description

Primary key

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



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


Columns

Name / Description

Primary key

ID, AUTHOR, FILENAME

PRIMARY

Table: databasechangeloglock

Columns



Name

Data type

Description / Attributes

Primary key

ID

int(10, 0)




LOCKED

tinyint(3, 0)




LOCKGRANTED

datetime

Nullable



LOCKEDBY

varchar(255)

Nullable

Unique keys


Columns

Name / Description

Primary key

ID

PRIMARY

Table: deletion_audit_trail

Columns



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


Columns

Name / Description

Primary key

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

Primary key

download_data_history_pk_id

PRIMARY

Table: download_history

Columns



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


Columns

Name / Description

Primary key

download_history_pk_id

PRIMARY

Table: general_equipment

Columns



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


Table

Join

Title / Name / Description


general_series

general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id

fk_g_equipment_pk_id

Unique keys


Columns

Name / Description

Primary key

general_equipment_pk_id

PRIMARY


general_equipment_pk_id

PK_G_EQUIPMENT_ID

Table: general_image

Columns



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



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



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


Table

Join

Title / Name / Description


general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id


patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient


study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

Linked from


Table

Join

Title / Name / Description


ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id


mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID

Unique keys


Columns

Name / Description


Primary key

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



Primary key

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
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


Table

Join

Title / Name / Description




general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id


study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id

Linked from


Table

Join

Title / Name / Description


ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1


general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id


mr_image

general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID

FK_MR_GEN_SERIES_PK_ID

Unique keys


Columns

Name / Description

Primary key

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



Primary key

GUI_ACTION_HISTORY_PK_ID

bigint(19, 0)

Default: 0



ACTION_TIMESTAMP

date

Nullable



ACTION

varchar(255)

Nullable

Unique keys


Columns

Name / Description

Primary key

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



Primary key

login_history_pk_id

bigint(19, 0)




login_timestamp

datetime

Nullable



ip_address

varchar(15)

Nullable

Unique keys


Columns

Name / Description

Primary key

login_history_pk_id

PRIMARY


login_history_pk_id

PK_LOGIN_HISTORY_PK_ID

Table: modality_descriptions


Columns



Name

Data type

Description / Attributes

Primary key

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
References: general_series


Links to


Table

Join

Title / Name / Description


general_image

mr_image.IMAGE_PK_ID = general_image.image_pk_id

FK_MR_GEN_IMAGE_PK_ID


general_series

mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id

FK_MR_GEN_SERIES_PK_ID

Unique keys


Columns

Name / Description

Primary key

MR_IMAGE_PK_ID

PRIMARY

Table: patient


Columns



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


Table

Join

Title / Name / Description

trial_data_provenance

patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id

fk_trial_dp_pk_id

Linked from


Table

Join

Title / Name / Description

general_image

patient.patient_pk_id = general_image.patient_pk_id

FK_general_image_patient


study

patient.patient_pk_id = study.patient_pk_id

fk_patient_pk_id

Unique keys


Columns

Name / Description

Primary key

patient_pk_id

PRIMARY


patient_pk_id

PK_PATINET_PK_ID

Table: qc_status_history


Columns



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


Columns

Name / Description

Primary key

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

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


Table

Join

Title / Name / Description

csm_user

query_history.user_id = csm_user.USER_ID

FK_Q_H_USER_ID


saved_query

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_attribute

query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id

FK_Q_H_PK_ID

Unique keys


Columns

Name / Description

Primary key

query_history_pk_id

PRIMARY


query_history_pk_id

PK_QUERY_HISTORY_PK_ID

Table: query_history_attribute

CKK
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
References: query_history



instance_number

bigint(19, 0)

Nullable

Links to


Table

Join

Title / Name / Description



query_history

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
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


Table

Join

Title / Name / Description


csm_user

saved_query.user_id = csm_user.USER_ID

FK_SAVED_QUERY_USER_ID

Linked from


Table

Join

Title / Name / Description


query_history

saved_query.saved_query_pk_id = query_history.saved_query_pk_id

fk_s_query_pk_id



saved_query_attribute

saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk
_id

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
References: saved_query



Name

Data type

Description / Attributes



instance_number

bigint(19, 0)

Nullable


Links to


Table

Join

Title / Name / Description


saved_query

saved_query_attribute.saved_query_pk
_id = saved_query.saved_query_pk_id

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


trial_data_provenance

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


patient

study.patient_pk_id = patient.patient_pk_id

fk_patient_pk_id

Linked from


Table

Join

Title / Name / Description


general_image

study.study_pk_id = general_image.study_pk_id

FK_general_image_study


general_series

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


patient

trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id

fk_trial_dp_pk_id


site

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
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




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

  • No labels