Page History

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

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

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)

_

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

GROUP_ID

PRIMARY

APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAM_NAME

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

CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment

_

LOGIN_NAME

varchar(500)

Nullable

_

PASSWORD

varchar(255)

Nullable

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

PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment

PRIVILEGE_NAME

varchar(100)

_

PRIVILEGE_DESCRIPTION

varchar(200)

Nullable

_

UPDATE_DATE

date

Default: 1950-01-01

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

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

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

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

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

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: 0Name

Data type

Description / Attributes

_

Image Removed

ACTIVE_FLAG

tinyint(3, 0)

Nullable Default: 1

_

PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10

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

USER_GROUP_ROLE_PG_ID

bigint(19, 0)

Identity / Auto incrementName

Data type

Description / Attributes

_

Image Removed

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

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

USER_PROTECTION_ELEMENT_ID

PRIMARY

USER_ID, PROTECTION_ELEMENT_ID

UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

_

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

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

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

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