NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


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
Default: 2012-10-10

...


Columns

Name / Description


USER_ID

PRIMARY

Anchor
1.15. Table: csm_user_group
1.15. Table: csm_user_group
Anchor
_bookmark16
_bookmark16
Anchor
_bookmark16
_bookmark16
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

...


Columns

Name / Description


USER_GROUP_ROLE_PG_ID

PRIMARY

Anchor
1.17. Table: csm_user_pe
1.17. Table: csm_user_pe
Anchor
_bookmark18
_bookmark18
Anchor
_bookmark18
_bookmark18
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

...


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

...


Columns

Name / Description


ct_image_pk_id

PRIMARY


ct_image_pk_id

PK_CT_IMAGE_PK_ID

Anchor
1.19. Table: custom_series_list
1.19. Table: custom_series_list
Anchor
_bookmark20
_bookmark20
Anchor
_bookmark20
_bookmark20
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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


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

...


Columns

Name / Description


site_pk_id

PRIMARY


site_pk_id

SITE_PK_ID

Anchor
1.41. Table: species
1.41. Table: species
Anchor
_bookmark42
_bookmark42
Anchor
_bookmark42
_bookmark42
Table: species


Columns



Name

Data type

Description / Attributes



species_code

varchar(64)




species_description

varchar(500)

Nullable

...


Columns

Name / Description


study_pk_id

PRIMARY


study_pk_id

PK_STUDY_PK_ID


study_instance_uid

study_instance_uid

Anchor
1.43. Table: submission_history
1.43. Table: submission_history
Anchor
_bookmark44
_bookmark44
Anchor
_bookmark44
_bookmark44
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)


...


Columns

Name / Description


submission_history_pk_id

submission_history_pk_id

Anchor
1.44. Table: trial_data_provenance
1.44. Table: trial_data_provenance
Anchor
_bookmark45
_bookmark45
Anchor
_bookmark45
_bookmark45
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

...


Columns

Name / Description


trial_site_pk_id

PRIMARY


trial_site_pk_id

PK_TRIAL_SITE_PK_ID

Anchor
1.46. Table: workflow
1.46. Table: workflow
Anchor
_bookmark47
_bookmark47
Anchor
_bookmark47
_bookmark47
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

...


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


Anchor
2.4. View: manufacturer
2.4. View: manufacturer
Anchor
_bookmark52
_bookmark52
Anchor
_bookmark52
_bookmark52
View: manufacturer

VIEW
Columns



Name

Data type

Description / Attributes



MANUFACTURER

varchar(64)

Nullable

Anchor
2.5. View: manufacturer_model_software
2.5. View: manufacturer_model_software
Anchor
_bookmark53
_bookmark53
Anchor
_bookmark53
_bookmark53
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

Anchor
2.6. View: number_month
2.6. View: number_month
Anchor
_bookmark54
_bookmark54
Anchor
_bookmark54
_bookmark54
View: number_month

VIEW
Columns



Name

Data type

Description / Attributes



PATIENT_ID

bigint(19, 0)

Nullable



NUMBER_MONTH

bigint(19, 0)

Nullable

Anchor
2.7. View: saved_query_last_exec
2.7. View: saved_query_last_exec
Anchor
_bookmark55
_bookmark55
Anchor
_bookmark55
_bookmark55
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

Anchor
2.8. View: software_versions
2.8. View: software_versions
Anchor
_bookmark56
_bookmark56
Anchor
_bookmark56
_bookmark56
View: software_versions

VIEW
Columns



Name

Data type

Description / Attributes



SOFTWARE_VERSIONS

varchar(64)

Nullable

...