 |
Page History
...
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
CKK
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 |
...
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 |
