NIH | National Cancer Institute | NCI Wiki  

WIKI MAINTENANCE NOTICE

Please be advised that NCI Wiki will be will be undergoing maintenance on Monday, June 24th between 1000 ET and 1100 ET.
Wiki will remain available, but users may experience screen refreshes or HTTP 502 errors during the maintenance period. If you encounter these errors, wait 1-2 minutes, then refresh your page.

If you have any questions or concerns, please contact the CBIIT Atlassian Management Team.

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

...