os_task_instance_out_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
WORKFLOW_INSTANCE_ID BIGINT 19 null
os_workflow_instances.IDENTIFIER FK_TASK_INST_OUT_ITEM_WI_IDR
TASK_INSTANCE_ID BIGINT 19 null
os_workflow_task_instances.IDENTIFIER FK_TASK_INST_OUT_ITEM_TI_IDR
OUT_KEY VARCHAR 512 √ null
SPECIMEN_ID BIGINT 19 √ null
catissue_specimen.IDENTIFIER FK_TASK_INST_OUT_ITEM_SPMNR
VISIT_ID BIGINT 19 √ null
catissue_specimen_coll_group.IDENTIFIER FK_TASK_OUT_ITEM_VISIT_IDR
CPR_ID BIGINT 19 √ null
catissue_coll_prot_reg.IDENTIFIER FK_TASK_OUT_ITEM_CPR_IDR
CPE_ID BIGINT 19 √ null
catissue_coll_prot_event.IDENTIFIER FK_TASK_OUT_ITEM_CPE_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_TASK_INST_OUT_ITEM_SPMN Performance Asc SPECIMEN_ID
FK_TASK_INST_OUT_ITEM_TI_ID Performance Asc TASK_INSTANCE_ID
FK_TASK_INST_OUT_ITEM_WI_ID Performance Asc WORKFLOW_INSTANCE_ID
FK_TASK_OUT_ITEM_CPE_ID Performance Asc CPE_ID
FK_TASK_OUT_ITEM_CPR_ID Performance Asc CPR_ID
FK_TASK_OUT_ITEM_VISIT_ID Performance Asc VISIT_ID

Relationships

Close relationships within degrees of separation