![]() |
Page History
...
Key | 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
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
USER_GROUP_ID | PRIMARY |
...
Relationship | 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
IconKey | Columns | Name / Description |
---|---|---|
general_equipment_pk_id | PRIMARY | |
general_equipment_pk_id | PK_G_EQUIPMENT_ID |
...
Relationship | 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
IconKey | Columns | Name / Description |
---|---|---|
MR_IMAGE_PK_ID | PRIMARY |
Table: patient
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id | fk_trial_dp_pk_id |
Linked from
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
patient_pk_id | PRIMARY | |
patient_pk_id | PK_PATINET_PK_ID |
Table: qc_status_history
Columns
Icon1Key | Icon2 | 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
IconKey | Columns | Name / Description |
---|---|---|
qc_status_history_pk_id | PRIMARY | |
qc_status_history_pk_id | PK_QC_STATUS_HISTORY_PK_ID |
Table: query_history
Columns
Icon1Key | Icon2 | 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
IconRelationship | 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
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
query_history_pk_id | PRIMARY | |
query_history_pk_id | PK_QUERY_HISTORY_PK_ID |
Table: query_history_attribute
Columns
Icon1 | Icon2Key | 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
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
query_history_attribute_pk_id | PRIMARY | |
query_history_attribute_pk_id | PK_Q_H_A_PK_ID |
Table: saved_query
Columns
Icon1Key | Icon2 | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
saved_query.user_id = csm_user.USER_ID | FK_SAVED_QUERY_USER_ID |
Linked from
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
saved_query_pk_id | PRIMARY | |
saved_query_pk_id | PK_SAVED_Q_PK_ID |
Table: saved_query_attribute
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
saved_query_attribute.saved_query_pk | FK_SAVED_QUERY_PK_ID |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
saved_query_attribute_pk_id | PRIMARY | |
saved_query_attribute_pk_id | PK_S_Q_A_PK_ID |
Table: site
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id | fk_tdp_st_pk_id |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
site_pk_id | PRIMARY | |
site_pk_id | SITE_PK_ID |
Table: species
Columns
Icon1 | Icon2Key | Name | Data type | Description / Attributes |
---|---|---|---|---|
species_code | varchar(64) | - | ||
- | species_description | varchar(500) | Nullable |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
species_code | PRIMARY |
Table: study
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
study.patient_pk_id = patient.patient_pk_id | fk_patient_pk_id |
Linked from
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
study_pk_id | PRIMARY | |
study_pk_id | PK_STUDY_PK_ID | |
study_instance_uid | study_instance_uid |
Table: submission_history
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
submission_history_pk_id | submission_history_pk_id |
Table: trial_data_provenance
Columns
Icon1 | Icon2Key | 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
IconRelationship | 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
IconKey | Columns | Name / Description |
---|---|---|
trial_dp_pk_id | PRIMARY | |
trial_dp_pk_id | PK_TRIAL_DP_PK_ID |
Table: trial_site
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
trial_site_pk_id | PRIMARY | |
trial_site_pk_id | PK_TRIAL_SITE_PK_ID |
Table: workflow
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
WORKFLOW_ID | PRIMARY |
...
View: dicom_image
VIEW
Columns
...
Icon2 | Name | Data type | Description / Attributes |
---|---|---|---|
IMAGE_PK_ID | bigint(19, 0) | ||
INSTANCE_NUMBER | bigint(19, 0) | Nullable | |
CONTENT_DATE | date | Nullable | |
CONTENT_TIME | varchar(16) | Nullable | |
IMAGE_TYPE | varchar(16) | Nullable | |
ACQUISITION_DATE | date | Nullable | |
ACQUISITION_TIME | varchar(16) | Nullable | |
ACQUISITION_NUMBER | decimal(22, 6) | Nullable | |
LOSSY_IMAGE_COMPRESSION | varchar(16) | Nullable | |
PIXEL_SPACING | decimal(22, 6) | Nullable | |
IMAGE_ORIENTATION_PATIENT | varchar(200) | Nullable | |
IMAGE_POSITION_PATIENT | varchar(200) | Nullable | |
SLICE_THICKNESS | decimal(22, 6) | Nullable | |
SLICE_LOCATION | decimal(22, 6) | Nullable | |
I_ROWS | decimal(22, 6) | Nullable | |
I_COLUMNS | decimal(22, 6) | Nullable | |
CONTRAST_BOLUS_AGENT | varchar(64) | Nullable | |
CONTRAST_BOLUS_ROUTE | varchar(64) | Nullable | |
SOP_CLASS_UID | varchar(64) | Nullable | |
SOP_INSTANCE_UID | varchar(64) | Nullable | |
GENERAL_SERIES_PK_ID | bigint(19, 0) | Nullable | |
PATIENT_POSITION | varchar(16) | Nullable | |
SOURCE_TO_DETECTOR_DISTANCE | decimal(22, 6) | Nullable | |
SOURCE_SUBJECT_DISTANCE | decimal(22, 6) | Nullable | |
FOCAL_SPOT_SIZE | decimal(22, 6) | Nullable | |
STORAGE_MEDIA_FILE_SET_UID | varchar(64) | Nullable | |
DICOM_FILE_URI | varchar(2000) | Nullable | |
ACQUISITION_DATETIME | varchar(50) | Nullable | |
IMAGE_COMMENTS | varchar(4000) | Nullable | |
IMAGE_RECEIVING_TIMESTAMP | datetime | Nullable | |
CURATION_TIMESTAMP | datetime | Nullable | |
ANNOTATION | varchar(20) | Nullable | |
SUBMISSION_DATE | date | Nullable | |
DICOM_SIZE | decimal(22, 6) | Nullable | |
IMAGE_LATERALITY | varchar(16) | Nullable | |
TRIAL_DP_PK_ID | bigint(19, 0) | Nullable | |
PATIENT_ID | varchar(64) | Nullable | |
STUDY_INSTANCE_UID | varchar(500) | Nullable | |
SERIES_INSTANCE_UID | varchar(64) | Nullable | |
PATIENT_PK_ID | bigint(19, 0) | Nullable | |
STUDY_PK_ID | bigint(19, 0) | Nullable | |
PROJECT | varchar(200) | Nullable | |
ACQUISITION_MATRIX | decimal(22, 6) | Nullable | |
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
...
Icon1
...
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
...
Icon1
...
Name | Data type | Description / Attributes | |
---|---|---|---|
STUDY_PK_ID | bigint(19, 0) | - | |
STUDY_INSTANCE_UID | varchar(500) | Nullable | |
ADDITIONAL_PATIENT_HISTORY | varchar(4000) | Nullable | |
STUDY_DATE | date | - | |
STUDY_DESC | varchar(64) | Nullable | |
ADMITTING_DIAGNOSES_DESC | varchar(64) | Nullable | |
ADMITTING_DIAGNOSES_CODE_S EQ | varchar(500) | Nullable | |
OCCUPATION | varchar(16) | Nullable | |
PATIENT_AGE | varchar(4) | Nullable | |
PATIENT_SIZE | decimal(22, 6) | Nullable | |
PATIENT_WEIGHT | decimal(22, 6) | Nullable | |
STUDY_ID | varchar(16) | Nullable | |
STUDY_TIME | varchar(16) | Nullable | |
TRIAL_TIME_POINT_ID | varchar(64) | Nullable | |
TRIAL_TIME_POINT_DESC | varchar(1024) | Nullable | |
PATIENT_PK_ID | bigint(19, 0) | Nullable |
View: manufacturer
VIEW
Columns
...
Icon1
...
Name | Data type | Description / Attributes | |
---|---|---|---|
MANUFACTURER | varchar(64) | Nullable |
View: manufacturer_model_software
VIEW
Columns
...
Icon2 | 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
...
Icon2 | Name | Data type | Description / Attributes | |
---|---|---|---|---|
PATIENT_ID | bigint(19, 0) | Nullable | ||
NUMBER_MONTH | bigint(19, 0) | Nullable |
View: saved_query_last_exec
VIEW
Columns
...
Icon1
...
Name | Data type | Description / Attributes | |
---|---|---|---|
SAVED_QUERY_PK_ID | bigint(19, 0) | Nullable | |
LAST_EXECUTE_DATE | datetime | Nullable |
View: software_versions
VIEW
Columns
...
Icon1
...
Name | Data type | Description / Attributes | |
---|---|---|---|
SOFTWARE_VERSIONS | varchar(64) | Nullable |
View: study_series_number
VIEW
Columns
...
Icon1
...
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 |