os_workflow_instance_in_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_WF_INPUT_ITEM_INSTANCE_IDR
SPECIMEN_ID BIGINT 19 √ null
catissue_specimen.IDENTIFIER FK_WF_INPUT_ITEM_SPECIMEN_IDR
CPR_ID BIGINT 19 √ null
catissue_coll_prot_reg.IDENTIFIER FK_WF_IN_ITEM_CPR_IDR
CPE_ID BIGINT 19 √ null
catissue_coll_prot_event.IDENTIFIER FK_WF_IN_ITEM_CPE_IDR
VISIT_ID BIGINT 19 √ null
catissue_specimen_coll_group.IDENTIFIER FK_WF_IN_ITEM_VISIT_IDR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_WF_IN_ITEM_CPE_ID Performance Asc CPE_ID
FK_WF_IN_ITEM_CPR_ID Performance Asc CPR_ID
FK_WF_IN_ITEM_VISIT_ID Performance Asc VISIT_ID
FK_WF_INPUT_ITEM_INSTANCE_ID Performance Asc WORKFLOW_INSTANCE_ID
FK_WF_INPUT_ITEM_SPECIMEN_ID Performance Asc SPECIMEN_ID

Relationships

Close relationships within degrees of separation