catissue_coll_prot_event

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
catissue_cp_req_specimen.COLLECTION_PROTOCOL_EVENT_ID FK111110456906F39R
catissue_specimen_coll_group.COLLECTION_PROTOCOL_EVENT_ID FKDEBAF16753B01F66R
os_supply_items.CPE_ID FK_SUPPLY_ITEM_EVENT_IDR
os_task_instance_out_items.CPE_ID FK_TASK_OUT_ITEM_CPE_IDR
os_workflow_instance_in_items.CPE_ID FK_WF_IN_ITEM_CPE_IDR
os_workflow_task_deviations.CPE_ID FK_TASK_DEV_CPE_IDR
CLINICAL_STATUS VARCHAR 50 √ null
COLLECTION_POINT_LABEL VARCHAR 255 √ null
STUDY_CALENDAR_EVENT_POINT DOUBLE 22 √ null
COLLECTION_PROTOCOL_ID BIGINT 19 √ null
catissue_collection_protocol.IDENTIFIER FK7AE7715948304401R
LABELFORMAT VARCHAR 255 √ null
DEFAULT_SITE_ID BIGINT 19 √ null
CLINICAL_DIAGNOSIS VARCHAR 255 √ null
ACTIVITY_STATUS VARCHAR 50 √ null
SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK_SITE_ID_CPER
CODE VARCHAR 32 √ null
VISIT_NAME_PRINT_MODE VARCHAR 32 √ null
VISIT_NAME_PRINT_COPIES BIGINT 19 √ null
EVENT_POINT_UNIT VARCHAR 16 √ DAYS
CLINICAL_STATUS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_CPE_CLINICAL_STATUSR
CLINICAL_DIAGNOSIS_ID BIGINT 19 √ null
catissue_permissible_value.identifier FK_CPE_CLINICAL_DIAGNOSISR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
COLLECTION_PROTOCOL_ID Must be unique Asc/Asc COLLECTION_PROTOCOL_ID + COLLECTION_POINT_LABEL
FK_CPE_CLINICAL_DIAGNOSIS Performance Asc CLINICAL_DIAGNOSIS_ID
FK_CPE_CLINICAL_STATUS Performance Asc CLINICAL_STATUS_ID
FK_SITE_ID_CPE Performance Asc SITE_ID
INDX_COLPROTO_EVNT_CAL Performance Asc STUDY_CALENDAR_EVENT_POINT

Relationships

Close relationships within degrees of separation