Page History
...
Columns for Table: collection_descriptions
Icon1 | Icon2 | Name | Data type | Description / Attributes |
---|---|---|---|---|
collection_descriptions_pk_id | bigint(19, 0) | |||
collection_name | varchar(64) | Nullable | ||
user_name | varchar(20) | Nullable | ||
description | mediumtext | Nullable | ||
collection_descriptions_timest | date | Nullable |
Unique keys
Icon1 | Columns | Name / Description |
---|---|---|
collection_descriptions_pk_id | PRIMARY | |
collection_descriptions_pk_id | PK_COLLECTION_DESC_PK_ID |
...
Name | Data type | Description / Attributes | ||
---|---|---|---|---|
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 |
Linked from
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_application.APPLICATION_ID = csm_group.APPLICATION_ID | FK_APPLICATION_GROUP | ||
csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID | FK_PE_APPLICATION | ||
Table | Join | Title / Name / Description | |
csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D | FK_PG_APPLICATION | ||
csm_application.APPLICATION_ID = csm_role.APPLICATION_ID | FK_APPLICATION_ROLE |
Unique keys
Columns | Name / Description | |
---|---|---|
APPLICATION_ID | PRIMARY | |
APPLICATION_NAME | UQ_APPLICATION_NAME |
...
Name | Data type | Description / Attributes | ||
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 |
Links to
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID | FK_PG_APPLICATION | ||
csm_protection_group.PARENT_PROT ECTION_GROUP_ID = | FK_PROTECTION_GROUP |
Linked from
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_protection_group.PROTECTION_ GROUP_ID = | FK_PROTECTION_GROUP | ||
csm_protection_group.PROTECTION_ GROUP_ID = | FK_PROTECTION_GROUP_PROTECTION_ELEMENT | ||
csm_protection_group.PROTECTION_ GROUP_ID = | FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP |
Unique keys
Columns | Name / Description | |
---|---|---|
PROTECTION_GROUP_ID | PRIMARY | |
APPLICATION_ID, PROTECTION_GROUP_NAME | UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME |
...
...
Table: csm_role
...
Columns
Name | Data type | Description / Attributes | ||
---|---|---|---|---|
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 |
Links to
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_role.APPLICATION_ID = csm_application.APPLICATION_ID | FK_APPLICATION_ROLE |
Linked from
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_role.ROLE_ID = csm_role_privilege.ROLE_ID | FK_ROLE | ||
csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID | FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE |
Unique keys
Columns | Name / Description | |
---|---|---|
ROLE_ID | PRIMARY | |
APPLICATION_ID, ROLE_NAME | UQ_ROLE_ROLE_NAME |
...
...
Table: csm_role_privilege
...
...
Columns
Name | Data type | Description / Attributes | ||
---|---|---|---|---|
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 |
Links to
Table | Join | Title / Name / Description | |
---|---|---|---|
csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID | FK_PRIVILEGE_ROLE | ||
csm_role_privilege.ROLE_ID = csm_role.ROLE_ID | FK_ROLE |
Unique keys
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 |
...
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 |
...
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 |
...
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 |
Linked from
Table | Join | Title / Name / Description | |
---|---|---|---|
custom_series_list.CUSTOM_SERIES_LI ST_PK_ID = | FK_CUSTOM_SERIES_LIST_PK_ID |
Unique keys
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 |
---|
...
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 |
Unique keys
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 |
Unique keys
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 |
Unique keys
Columns | Name / Description | |
---|---|---|
deletion_pk_id | PRIMARY |
...
...
Table: download_data_history
...
Columns
Name | Data type |
---|
...
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 |
Unique keys
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 |
Unique keys
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 |
Linked from
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
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 | ||
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 | ||
dx_data_collection_diameter | decimal(22, 6) | Nullable | ||
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 | ||
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 |
...
Columns | Name / Description | |
modality_descriptions_pk_id | PRIMARY | |
modality_descriptions_pk_id | MD_COLLECTION_DESC_PK_ID |
...
_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 |
...
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 | ||
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 |
...
_ID |
Table: query_history
Columns
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 |
...
Columns | Name / Description | |
query_history_attribute_pk_id | PRIMARY | |
query_history_attribute_pk_id | PK_Q_H_A_PK_ID |
...
...
Table: saved_query
...
Columns
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 |
...
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 | ||
Name | Data type | Description / Attributes | ||
instance_number | bigint(19, 0) | Nullable |
...
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 |
...