NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Legend

IconDescription

Primary key

Primary key

Primary key disabled

Primary key disabled

User-defined primary key

User-defined primary key

Unique key

Unique key

Unique key disabled

Unique key disabled

User-defined unique key

User-defined unique key

Active trigger

Active trigger

Disabled triggerMany to one relation

Disabled trigger Many to one relation

User-defined many to one relationOne to many relation

User-defined many to one relation One to many relation

User-defined one to many relationOne to one relation

User-defined one to many relation One to one relation

 User-defined one to one relation

Input

Input

Output

Output

Input/Output

Uses dependency

Uses dependency

User-defined uses dependency

User-defined uses dependency

Used by dependency

Used by dependency

User-defined used by dependency

User-defined used by dependency


Tables

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

Columns for Table: csm_application 



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_group

csm_application.APPLICATION_ID = csm_group.APPLICATION_ID

FK_APPLICATION_GROUP


csm_mapping

csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID

FK_PE_APPLICATION


Table

Join

Title / Name / Description



csm_protection_group

csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D

FK_PG_APPLICATION


csm_role

csm_application.APPLICATION_ID = csm_role.APPLICATION_ID

FK_APPLICATION_ROLE

Unique keys


Columns

Name / Description


APPLICATION_ID

PRIMARY


APPLICATION_NAME

UQ_APPLICATION_NAME

Table: csm_configuration_props


Columns



Name

Data type

Description / Attributes



PROPERTY_KEY

varchar(300)




PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys


Columns

Name / Description


PROPERTY_KEY

PRIMARY

Table: csm_filter_clause


Columns



Name

Data type

Description / Attributes



FILTER_CLAUSE_ID

bigint(19, 0)

Identity / Auto increment



CLASS_NAME

varchar(100)




FILTER_CHAIN

varchar(2000)




TARGET_CLASS_NAME

varchar(100)




TARGET_CLASS_ATTRIBUTE_NAME

varchar(100)




TARGET_CLASS_ATTRIBUTE_TYPE

varchar(100)




TARGET_CLASS_ALIAS

varchar(100)

Nullable



TARGET_CLASS_ATTRIBUTE_ALIAS

varchar(100)

Nullable



GENERATED_SQL_USER

varchar(4000)




APPLICATION_ID

bigint(19, 0)




UPDATE_DATE

date




GENERATED_SQL_GROUP

varchar(4000)


Unique keys


Columns

Name / Description


FILTER_CLAUSE_ID

PRIMARY

Table: csm_group

Columns



Name

Data type

Description / Attributes



GROUP_ID

bigint(19, 0)

Identity / Auto increment



GROUP_NAME

varchar(255)




GROUP_DESC

varchar(200)

Nullable



UPDATE_DATE

date

Default: 1950-01-01



APPLICATION_ID

bigint(19, 0)

References: csm_application

Links to


Table

Join

Title / Name / Description


csm_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

Linked from


Table

Join

Title / Name / Description


csm_user_group

csm_group.GROUP_ID = csm_user_group.GROUP_ID

FK_UG_GROUP


csm_user_group_role_pg

csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS

Unique keys


Columns

Name / Description


GROUP_ID

PRIMARY


APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAME

Table: csm_mapping

Columns



Name

Data type

Description / Attributes



MAPPING_ID

bigint(19, 0)

Identity / Auto increment



APPLICATION_ID

bigint(19, 0)

References: csm_application



OBJECT_NAME

varchar(100)




ATTRIBUTE_NAME

varchar(100)




OBJECT_PACKAGE_NAME

varchar(100)

Nullable



TABLE_NAME

varchar(100)

Nullable



TABLE_NAME_GROUP

varchar(100)

Nullable



TABLE_NAME_USER

varchar(100)

Nullable



VIEW_NAME_GROUP

varchar(100)

Nullable



VIEW_NAME_USER

varchar(100)

Nullable



ACTIVE_FLAG

tinyint(3, 0)

Default: 0



MAINTAINED_FLAG

tinyint(3, 0)

Default: 0

Links to


Table

Join

Title / Name / Description


csm_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

Unique keys


Columns

Name / Description


MAPPING_ID

PRIMARY


OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID

UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

Table: csm_password_history

Columns



Name

Data type

Description / Attributes



CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment



LOGIN_NAME

varchar(500)

Nullable



PASSWORD

varchar(255)

Nullable

Unique keys


Columns

Name / Description


CSM_PASSWORD_HISTORY_ID

PRIMARY

Table: csm_pg_pe

Columns



Name

Data type

Description / Attributes



PG_PE_ID

bigint(19, 0)

Identity / Auto increment



PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group



PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element



UPDATE_DATE

date

Default: 1950-01-01

Links to


Table

Join

Title / Name / Description




csm_protection_element

csm_pg_pe.PROTECTION_ELEMENT_I D =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_PROTECTION_GROUP




csm_protection_group

csm_pg_pe.PROTECTION_GROUP_ID
=
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT

Unique keys


Columns

Name / Description


PG_PE_ID

PRIMARY


Columns

Name / Description


PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID

UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns



Name

Data type

Description / Attributes



PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment



PRIVILEGE_NAME

varchar(100)




PRIVILEGE_DESCRIPTION

varchar(200)

Nullable



UPDATE_DATE

date

Default: 1950-01-01

Linked from


Table

Join

Title / Name / Description


csm_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

Unique keys


Columns

Name / Description


PRIVILEGE_ID

PRIMARY


PRIVILEGE_NAME

UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns



Name

Data type

Description / Attributes



PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment



PROTECTION_ELEMENT_NAME

varchar(100)




PROTECTION_ELEMENT_DESCRIPTI ON

varchar(200)

Nullable



OBJECT_ID

varchar(100)




ATTRIBUTE

varchar(100)

Nullable



PROTECTION_ELEMENT_TYPE

varchar(100)

Nullable



APPLICATION_ID

bigint(19, 0)




UPDATE_DATE

date

Default: 1950-01-01



ATTRIBUTE_VALUE

varchar(100)

Nullable

Linked from


Table

Join

Title / Name / Description




csm_pg_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_pg_pe.PROTECTION_ELEMENT_I D

FK_PROTECTION_ELEMENT_PROTECTION_GROUP


Table

Join

Title / Name / Description




csm_user_pe

csm_protection_element.PROTECTION
_ELEMENT_ID =
csm_user_pe.PROTECTION_ELEMENT_ ID

FK_PROTECTION_ELEMENT_USER


Unique keys


Columns

Name / Description


PROTECTION_ELEMENT_ID

PRIMARY


OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

Table: csm_protection_group

Columns



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

Links to


Table

Join

Title / Name / Description


csm_application

csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID

FK_PG_APPLICATION




csm_protection_group

csm_protection_group.PARENT_PROT ECTION_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_PROTECTION_GROUP

Linked from


Table

Join

Title / Name / Description




csm_protection_group

csm_protection_group.PROTECTION_ GROUP_ID =
csm_protection_group.PARENT_PROT ECTION_GROUP_ID

FK_PROTECTION_GROUP



csm_pg_pe

csm_protection_group.PROTECTION_ GROUP_ID =
csm_pg_pe.PROTECTION_GROUP_ID

FK_PROTECTION_GROUP_PROTECTION_ELEMENT




csm_user_group_role_pg

csm_protection_group.PROTECTION_ GROUP_ID =
csm_user_group_role_pg.PROTECTIO N_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_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

Linked from


Table

Join

Title / Name / Description


csm_role_privilege

csm_role.ROLE_ID = csm_role_privilege.ROLE_ID

FK_ROLE


csm_user_group_role_pg

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_privilege

csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE


csm_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

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


Linked from


Table

Join

Title / Name / Description


csm_user_group

csm_user.USER_ID = csm_user_group.USER_ID

FK_USER_GROUP


csm_user_group_role_pg

csm_user.USER_ID = csm_user_group_role_pg.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER


csm_user_pe

csm_user.USER_ID = csm_user_pe.USER_ID

FK_PE_USER


query_history

csm_user.USER_ID = query_history.user_id

FK_Q_H_USER_ID


saved_query

csm_user.USER_ID = saved_query.user_id

FK_SAVED_QUERY_USER_ID

Unique keys


Columns

Name / Description


USER_ID

PRIMARY

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

Links to


Table

Join

Title / Name / Description


csm_group

csm_user_group.GROUP_ID = csm_group.GROUP_ID

FK_UG_GROUP


csm_user

csm_user_group.USER_ID = csm_user.USER_ID

FK_USER_GROUP

Unique keys


Columns

Name / Description


USER_GROUP_ID

PRIMARY

Table: csm_user_group_role_pg


Columns



Name

Data type

Description / Attributes



USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto increment



Name

Data type

Description / Attributes



USER_ID

bigint(19, 0)

Nullable
References: csm_user



GROUP_ID

bigint(19, 0)

Nullable
References: csm_group



ROLE_ID

bigint(19, 0)

References: csm_role



PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group



UPDATE_DATE

date

Default: 1950-01-01


Links to


Table

Join

Title / Name / Description


csm_group

csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS




csm_protection_group

csm_user_group_role_pg.PROTECTIO N_GROUP_ID =
csm_protection_group.PROTECTION_ GROUP_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP


csm_role

csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE


csm_user

csm_user_group_role_pg.USER_ID = csm_user.USER_ID

FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

Unique keys


Columns

Name / Description


USER_GROUP_ROLE_PG_ID

PRIMARY

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

Links to


Table

Join

Title / Name / Description




csm_protection_element

csm_user_pe.PROTECTION_ELEMENT_ ID =
csm_protection_element.PROTECTION
_ELEMENT_ID

FK_PROTECTION_ELEMENT_USER


csm_user

csm_user_pe.USER_ID = csm_user.USER_ID

FK_PE_USER

Unique keys


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

Links to


Table

Join

Title / Name / Description


general_image

ct_image.image_pk_id = general_image.image_pk_id

fk_image_pk_id


general_series

ct_image.general_series_pk_id = general_series.general_series_pk_id

ct_image_ibfk_1

Unique keys


Columns

Name / Description


ct_image_pk_id

PRIMARY


ct_image_pk_id

PK_CT_IMAGE_PK_ID

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

Linked from


Table

Join

Title / Name / Description




custom_series_list_attribute

custom_series_list.CUSTOM_SERIES_LI ST_PK_ID =
custom_series_list_attribute.CUSTOM_ SERIES_LIST_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

Links to


Table

Join

Title / Name / Description




custom_series_list

custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID =
custom_series_list.CUSTOM_SERIES_LI ST_PK_ID

FK_CUSTOM_SERIES_LIST_PK_ID

Unique keys


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

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

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_series

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


Links to


Table

Join

Title / Name / Description


general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id


patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient


study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

Linked from


Table

Join

Title / Name / Description


ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id


mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID

Unique keys


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


Links to


Table

Join

Title / Name / Description




general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id


study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id

Linked from


Table

Join

Title / Name / Description


ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1


general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id


mr_image

general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID

FK_MR_GEN_SERIES_PK_ID

Unique keys


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

Unique keys


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

Unique keys


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


Links to


Table

Join

Title / Name / Description


general_image

mr_image.IMAGE_PK_ID = general_image.image_pk_id

FK_MR_GEN_IMAGE_PK_ID


general_series

mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id

FK_MR_GEN_SERIES_PK_ID

Unique keys


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

Links to


Table

Join

Title / Name / Description


trial_data_provenance

patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id

fk_trial_dp_pk_id

Linked from


Table

Join

Title / Name / Description


general_image

patient.patient_pk_id = general_image.patient_pk_id

FK_general_image_patient


study

patient.patient_pk_id = study.patient_pk_id

fk_patient_pk_id

Unique keys


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

Unique keys


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

Links to


Table

Join

Title / Name / Description


csm_user

query_history.user_id = csm_user.USER_ID

FK_Q_H_USER_ID


saved_query

query_history.saved_query_pk_id = saved_query.saved_query_pk_id

fk_s_query_pk_id

Linked from


Table

Join

Title / Name / Description



query_history_attribute

query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id

FK_Q_H_PK_ID

Unique keys


Columns

Name / Description


query_history_pk_id

PRIMARY


query_history_pk_id

PK_QUERY_HISTORY_PK_ID

Table: query_history_attribute


Columns



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



instance_number

bigint(19, 0)

Nullable

Links to


Table

Join

Title / Name / Description



query_history

query_history_attribute.query_history_ pk_id = query_history.query_history_pk_id

FK_Q_H_PK_ID

Unique keys


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



query_name

varchar(200)

Nullable



new_data_flag

varchar(5)

Nullable



active

varchar(5)

Nullable



query_execute_timestamp

datetime

Nullable

Links to


Table

Join

Title / Name / Description


csm_user

saved_query.user_id = csm_user.USER_ID

FK_SAVED_QUERY_USER_ID

Linked from


Table

Join

Title / Name / Description


query_history

saved_query.saved_query_pk_id = query_history.saved_query_pk_id

fk_s_query_pk_id



saved_query_attribute

saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk
_id

FK_SAVED_QUERY_PK_ID

Unique keys


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


Links to


Table

Join

Title / Name / Description


saved_query

saved_query_attribute.saved_query_pk
_id = saved_query.saved_query_pk_id

FK_SAVED_QUERY_PK_ID

Unique keys


Columns

Name / Description


saved_query_attribute_pk_id

PRIMARY


saved_query_attribute_pk_id

PK_S_Q_A_PK_ID

Table: site


Columns



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


Table

Join

Title / Name / Description


trial_data_provenance

site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id

fk_tdp_st_pk_id

Unique keys


Columns

Name / Description


site_pk_id

PRIMARY


site_pk_id

SITE_PK_ID

Table: species


Columns



Name

Data type

Description / Attributes



species_code

varchar(64)




species_description

varchar(500)

Nullable

Unique keys


Columns

Name / Description


species_code

PRIMARY

Table: study

Columns



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


Table

Join

Title / Name / Description


patient

study.patient_pk_id = patient.patient_pk_id

fk_patient_pk_id

Linked from


Table

Join

Title / Name / Description


general_image

study.study_pk_id = general_image.study_pk_id

FK_general_image_study


general_series

study.study_pk_id = general_series.study_pk_id

fk_gs_study_pk_id

Unique keys


Columns

Name / Description


study_pk_id

PRIMARY


study_pk_id

PK_STUDY_PK_ID


study_instance_uid

study_instance_uid

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)


Unique keys


Columns

Name / Description


submission_history_pk_id

submission_history_pk_id

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

Linked from


Table

Join

Title / Name / Description


patient

trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id

fk_trial_dp_pk_id


site

trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id

fk_tdp_st_pk_id

Unique keys


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

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


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

  • No labels