Page History

Columns

Name / Description

USER_GROUP_ID

PRIMARY

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

Columns

Name / Description

query_history_pk_id

PRIMARY

query_history_pk_id

PK_QUERY_HISTORY_PK_ID

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

Columns

Name / Description

saved_query_attribute_pk_id

PRIMARY

saved_query_attribute_pk_id

PK_S_Q_A_PK_ID

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

Columns

Name / Description

species_code

PRIMARY

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

Columns

Name / Description

trial_dp_pk_id

PRIMARY

trial_dp_pk_id

PK_TRIAL_DP_PK_ID

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