![]() |
Page History
...
Table: csm_user_group
Columns
Icon1 | Icon2Key | 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 |
...
Table: csm_user_group_role_pg
Columns
Icon1Key | Icon2 | Name | Data type | Description / Attributes |
---|---|---|---|---|
USER_GROUP_ROLE_PG_ID | bigint(19, 0) | Identity / Auto increment | ||
_ | USER_ID | bigint(19, 0) | Nullable | |
_ | GROUP_ID | bigint(19, 0) | Nullable | |
_ | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID | FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS | ||
csm_user_group_role_pg.PROTECTIO N_GROUP_ID = | FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP | ||
csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID | FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE | ||
csm_user_group_role_pg.USER_ID = csm_user.USER_ID | FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
USER_GROUP_ROLE_PG_ID | PRIMARY |
Table: csm_user_pe
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
csm_user_pe.PROTECTION_ELEMENT_ ID = | FK_PROTECTION_ELEMENT_USER | ||
csm_user_pe.USER_ID = csm_user.USER_ID | FK_PE_USER |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
USER_PROTECTION_ELEMENT_ID | PRIMARY | |
USER_ID, PROTECTION_ELEMENT_ID | UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID |
Table: ct_image
Columns
Icon1Key | Icon2 | 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 |
Links to
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
ct_image.image_pk_id = general_image.image_pk_id | fk_image_pk_id | ||
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 | |
ct_image_pk_id | PK_CT_IMAGE_PK_ID |
Table: custom_series_list
Columns
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
custom_series_list.CUSTOM_SERIES_LI ST_PK_ID = | FK_CUSTOM_SERIES_LIST_PK_ID |
Unique keys
IconKey | 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
Icon1 | Icon2Key | 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
IconRelationship | Table | Join | Title / Name / Description |
---|---|---|---|
custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID = | FK_CUSTOM_SERIES_LIST_PK_ID |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
custom_series_list_attribute_p | PRIMARY | |
custom_series_list_attribute_p | CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID |
Table: databasechangelog
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
ID, AUTHOR, FILENAME | PRIMARY |
Table: databasechangeloglock
Columns
Icon1Key | Icon2 | Name | Data type | Description / Attributes |
---|---|---|---|---|
ID | int(10, 0) | - | ||
- | LOCKED | tinyint(3, 0) | - | |
- | LOCKGRANTED | datetime | Nullable | |
- | LOCKEDBY | varchar(255) | Nullable |
Unique keys
IconKey | Columns | Name / Description |
---|---|---|
ID | PRIMARY |
Table: deletion_audit_trail
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
deletion_pk_id | PRIMARY |
Table: download_data_history
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
download_data_history_pk_id | PRIMARY |
Table: download_history
Columns
Icon1 | Icon2Key | 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
IconKey | Columns | Name / Description |
---|---|---|
download_history_pk_id | PRIMARY |
...