Legacy Workflows

Table Overview

Name$raw FiltersDescription
workflowLists all Legacy Workflows
workflow_templateLists all Legacy Workflow Templates
workflow_template_versionLists all versions of Legacy Workflow Templates
stage_runLists all stages for Legacy Workflows

workflow

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfw_DMcZhu4APrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
aliasUnique identifier for the workflow, based on prefix and sequential numberPrefix-unique numberWF020
nameName of object in BenchlingCharacter varyingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without time zone2020-06-04T00:11:56.132400
descriptionDescription given to objectText"Fermentation Workflow"
statusStatus for a request(requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
last_stage_completedName of last stage entry marked as completeText"Transformation"
last_stage_completed_atTimestamp of when status of last stage entry was marked as completeTimestamp without timezone2019-12-06T23:24:44.885478
workflow_template_version_idAPI ID of workflow template used to generate this workflowForeign key for workflow_template_version.idwfwtmplv_0MjnYgSk
urlURL for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit

workflow_template

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfwtmpl_w6d11hNbPrimary key for a table
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc

workflow_template_version

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablewfwtmplv_0MjnYgSkPrimary key for a table
versionVersion number for templateInteger1, 3, 65, etcAuto-incremental when new workflow version is completed
workflow_template_idUnique ID for workflow TEMPLATEForeign key for workflow_template.idwfwtmpl_w6d11hNb

stage_run

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tablestgr_OvHALbNC
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
stage_nameStage name in BenchlingText"Transfection"
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZq
workflow_idUnique identifier for workflow containing objectForeign key for workflow.idwfw_DMcZhu4A
statusStatus for a request(requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
exp_condition_valuesValues available for Stage Experimental ConditionsText"Condition": "2"