Page History

collection_descriptions_pk_id

PRIMARY

collection_descriptions_pk_id

PK_COLLECTION_DESC_PK_ID

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

APPLICATION_ID

PRIMARY

APPLICATION_NAME

UQ_APPLICATION_NAME

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

GROUP_ID

PRIMARY

APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAME

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

MAPPING_ID

PRIMARY

OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID

UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

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

PG_PE_ID

PRIMARY

PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID

UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment

PRIVILEGE_NAME

varchar(100)

PRIVILEGE_DESCRIPTION

varchar(200)

Nullable

UPDATE_DATE

date

Default: 1950-01-01

PRIVILEGE_ID

PRIMARY

PRIVILEGE_NAME

UQ_PRIVILEGE_NAME

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

PROTECTION_ELEMENT_ID

PRIMARY

OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

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

PROTECTION_GROUP_ID

PRIMARY

APPLICATION_ID, PROTECTION_GROUP_NAME

UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

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

ROLE_ID

PRIMARY

APPLICATION_ID, ROLE_NAME

UQ_ROLE_ROLE_NAME

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

ROLE_PRIVILEGE_ID

PRIMARY

PRIVILEGE_ID, ROLE_ID

UQ_ROLE_PRIVILEGE_ROLE_ID

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

USER_PROTECTION_ELEMENT_ID

PRIMARY

USER_ID, PROTECTION_ELEMENT_ID

UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

ct_image_pk_id

PRIMARY

ct_image_pk_id

PK_CT_IMAGE_PK_ID

CUSTOM_SERIES_LIST_PK_ID

PRIMARY

CUSTOM_SERIES_LIST_PK_ID

CUSTOM_SERIES_LIST_PK_ID

custom_series_list_attribute_p

PRIMARY

custom_series_list_attribute_p

CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

general_equipment_pk_id

PRIMARY

general_equipment_pk_id

PK_G_EQUIPMENT_ID

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

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

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

general_series_pk_id

PRIMARY

general_series_pk_id

PK_G_SERIES_PK_ID

series_instance_uid

series_instance_uid

login_history_pk_id

PRIMARY

login_history_pk_id

PK_LOGIN_HISTORY_PK_ID

modality_descriptions_pk_id

PRIMARY

modality_descriptions_pk_id

MD_COLLECTION_DESC_PK_ID

patient_pk_id

PRIMARY

patient_pk_id

PK_PATINET_PK_ID

qc_status_history_pk_id

PRIMARY

qc_status_history_pk_id

PK_QC_STATUS_HISTORY_PK_ID

query_history_pk_id

PRIMARY

query_history_pk_id

PK_QUERY_HISTORY_PK_ID

query_history_attribute_pk_id

PRIMARY

query_history_attribute_pk_id

PK_Q_H_A_PK_ID

saved_query_pk_id

PRIMARY

saved_query_pk_id

PK_SAVED_Q_PK_ID

saved_query_attribute_pk_id

PRIMARY

saved_query_attribute_pk_id

PK_S_Q_A_PK_ID

site_pk_id

PRIMARY

site_pk_id

SITE_PK_ID

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

study_pk_id

PRIMARY

study_pk_id

PK_STUDY_PK_ID

study_instance_uid

study_instance_uid

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)

submission_history_pk_id

submission_history_pk_id

trial_dp_pk_id

PRIMARY

trial_dp_pk_id

PK_TRIAL_DP_PK_ID

trial_site_pk_id

PRIMARY

trial_site_pk_id

PK_TRIAL_SITE_PK_ID