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.

...

Table: csm_user_group

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

USER_GROUP_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

USER_ID

bigint(19, 0)

References: csm_user

Image Removed

_

GROUP_ID

bigint(19, 0)

References: csm_group

...

Table: csm_user_group_role_pg


Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes


Image RemovedPrimary key

USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

USER_ID

bigint(19, 0)

Nullable
References: csm_user

Image Removed

_

GROUP_ID

bigint(19, 0)

Nullable
References: csm_group

Image Removed

_

ROLE_ID

bigint(19, 0)

References: csm_role

Image Removed

_

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01


Links to

IconRelationship

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

IconKey

Columns

Name / Description

Primary key

USER_GROUP_ROLE_PG_ID

PRIMARY

Table: csm_user_pe


Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

USER_PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment


Image RemovedUnique key

PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element

Image Removed


Unique key

USER_ID

bigint(19, 0)

References: csm_user

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Links to

IconRelationship

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

IconKey

Columns

Name / Description


Primary key

USER_PROTECTION_ELEMENT_ID

PRIMARY


Unique key

USER_ID, PROTECTION_ELEMENT_ID

UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

Image Removed

Icon1Key

Icon2

Name

Data type

Description / Attributes

_

kvp

decimal(22, 6)

Nullable

Image Removed

_

scan_options

varchar(16)

Nullable

Image Removed

_

data_collection_diameter

decimal(22, 6)

Nullable

Image Removed

_

reconstruction_diameter

decimal(22, 6)

Nullable

Image Removed

_

gantry_detector_tilt

decimal(22, 6)

Nullable

Image Removed

_

exposure_time

decimal(22, 6)

Nullable

Image Removed

_

x_ray_tube_current

decimal(22, 6)

Nullable

Image Removed

_

exposure

decimal(22, 6)

Nullable

Image Removed

_

exposure_in_microas

decimal(22, 6)

Nullable

Image Removed

_

convolution_kernel

varchar(16)

Nullable

Image Removed

_

revolution_time

decimal(22, 6)

Nullable

Image Removed

_

single_collimation_width

decimal(22, 6)

Nullable

Image Removed

_

total_collimation_width

decimal(22, 6)

Nullable

Image Removed

_

table_speed

decimal(22, 6)

Nullable

Image Removed

_

table_feed_per_rotation

decimal(22, 6)

Nullable

Image Removed

_

ct_pitch_factor

decimal(22, 6)

Nullable

Image Removed

_

anatomic_region_seq

varchar(500)

Nullable

Image Removed

_

image_pk_id

bigint(19, 0)

References: general_image


Image RemovedPrimary key

ct_image_pk_id

bigint(19, 0)

Image Removed


_

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Links to

IconRelationship

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

IconKey

Columns

Name / Description


ct_image_pk_id

PRIMARY


Unique key

ct_image_pk_id

PK_CT_IMAGE_PK_ID

Table: custom_series_list

Columns

Icon1

Icon2Key

Name

Data type

Description / Attributes

Image Removed

Primary key

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

Image Removed


_

NAME

varchar(200)

Nullable

Image Removed

_

comment_

varchar(200)

Nullable

Image Removed

_

HYPERLINK

varchar(200)

Nullable

Image Removed

_

CUSTOM_SERIES_LIST_TIMESTAMP

date

Nullable

Image Removed

_

USER_NAME

varchar(20)

Nullable

Image Removed

_

usage_count

unsigned int(10, 0)

Nullable Default: 0

Linked from

IconRelationship

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

IconKey

Columns

Name / Description


Primary key

CUSTOM_SERIES_LIST_PK_ID

PRIMARY


Unique key

CUSTOM_SERIES_LIST_PK_ID

CUSTOM_SERIES_LIST_PK_ID

Table: custom_series_list_attribute


Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

custom_series_list_attribute_p

bigint(19, 0)

_

Image Removed

_

SERIES_INSTANCE_UID

varchar(200)

Nullable

Image Removed

_

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

IconRelationship

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

IconKey

Columns

Name / Description

Primary key

custom_series_list_attribute_p

PRIMARY


Unique key

custom_series_list_attribute_p

CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Icon1

Icon2Key

Name

Data type

Description / Attributes


Image RemovedPrimary key

ID

varchar(63)

_

Image Removed


Primary key

AUTHOR

varchar(63)

_

Image Removed


Primary key

FILENAME

varchar(200)

_

Image Removed

_

DATEEXECUTED

datetime

_

Image Removed

_

MD5SUM

varchar(32)

Nullable

Image Removed

_

DESCRIPTION

varchar(255)

Nullable

Image Removed

_

COMMENTS

varchar(255)

Nullable

Image Removed

-

TAG

varchar(255)

Nullable

Image Removed

-

LIQUIBASE

varchar(10)

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

ID, AUTHOR, FILENAME

PRIMARY

Table: databasechangeloglock

Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes

Image Removed

Primary key

ID

int(10, 0)

-

Image Removed

-

LOCKED

tinyint(3, 0)

-

Image Removed

-

LOCKGRANTED

datetime

Nullable

Image Removed

-

LOCKEDBY

varchar(255)

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

ID

PRIMARY

Table: deletion_audit_trail

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

deletion_pk_id

bigint(19, 0)

-

Image Removed

-

data_id

varchar(64)

Nullable

Image Removed

-

data_type

varchar(50)

Nullable

Image Removed

-

total_image

bigint(19, 0)

Nullable

Image Removed

-

user_name

varchar(50)

Nullable

Image Removed

-

time_stamp

datetime

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

deletion_pk_id

PRIMARY

Table: download_data_history

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


download_data_history_pk_id

bigint(19, 0)

-

-

Image Removed

series_instance_uid

varchar(64)

Nullable

Image Removed

-

login_name

varchar(100)

Nullable

Image Removed

-

download_timestamp

date

Nullable

Image Removed

-

download_type

varchar(20)

Nullable

Image Removed

-

size_

decimal(22, 2)

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

download_data_history_pk_id

PRIMARY

Table: download_history

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes

Primary key

download_history_pk_id

bigint(19, 0)

-

Image Removed

-

user_id

bigint(19, 0)

Nullable

Image Removed

-

timestamp

datetime

Nullable

Image Removed

-

total_file_size

decimal(22, 2)

Nullable

Image Removed

-

download_file_name

varchar(300)

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

download_history_pk_id

PRIMARY

...