 |
Page History
...
| Icon | Description |
|---|---|
| Primary key |
| Primary key disabled |
| User-defined primary key |
| Unique key |
| Unique key disabled |
| User-defined unique key |
| Active trigger |
| Disabled trigger Many to one relation |
| User-defined many to one relation One to many relation |
| User-defined one to many relation One to one relation |
| User-defined one to one relation |
| Input |
| Output |
| Input/Output |
| Uses dependency |
| User-defined uses dependency |
| Used by dependency |
| User-defined used by dependency |
...
Key | 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 |
...
Key | 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 |
...
Key | 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 |
- | 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 |
...
Relationship | Table | Join | Title / Name / Description |
|---|---|---|---|
| mr_image.IMAGE_PK_ID = general_image.image_pk_id | FK_MR_GEN_IMAGE_PK_ID | |
| mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id | FK_MR_GEN_SERIES_PK_ID |
...
Relationship | Table | Join | Title / Name / Description |
|---|---|---|---|
| patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id | fk_trial_dp_pk_id |
...
Relationship | Table | Join | Title / Name / Description |
|---|---|---|---|
| query_history.user_id = csm_user.USER_ID | FK_Q_H_USER_ID | |
| query_history.saved_query_pk_id = saved_query.saved_query_pk_id | fk_s_query_pk_id |
...
Relationship | Table | Join | Title / Name / Description |
|---|---|---|---|
| query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id | FK_Q_H_PK_ID |
...
