Note that this page doesn't display tables as well as we'd hope. Please zoom in your browser with CTRL-+ or CMD-+.
The Benchling Warehouse Columns Descriptions
Each Benchling Warehouse (WH) table has many columns that represent the data contained in each table. Use the following information help understand how each table can be used to directly query the data you have stored in Benchling.
The following information is outlined below for every WH table:
Column Name
Column Definition
Value Type
Example Values
Useful Notes
📘
Tables vs. $raw tables
As discussed in Warehouse Tables, these tables are Postgres views that represent a "cleaned up" version of the raw data. For applicable tables, we've specified the filter(s) being applied to the raw data in order to produce the cleaned table. These filters are described here:
Filter key
Filter description
IS_NOT_ARCHIVED
Filters away rows where the archived$ column is True
LINKED_FIELD_IS_NOT_ARCHIVED
Filters away rows in the field table where the corresponding row in the field_definition table's archived$ column is True. This look up is an outer join on field.field_definition_id = field_definition.id
STATIC_IS_REVIEWED
Performs a join between the entry$raw table and the result table (result.entry_id = entry.id). Filters away rows whose corresponding entry IS NOT accepted (entry$raw.review_status != ACCEPTED)
STATIC_IS_VALID
Filters away result rows where validation_status IS NOT NULL AND the value is not VALID or PARTIALLY_VALID.
--{Notebook Tables}--
See below for all tables relating to the Benchling Notebook
entry
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Primary key for a Warehouse table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Format dependent on table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
id
</td>
<td>
Unique identifier surfaced in the actual Benchling site
</td>
<td>
prefix
\-
unique entry number
</td>
<td>
EXP001 or EXP20000416
</td>
<td>
I
\.
E Unique Entry number
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
If object not in folder, then folder
\_
id = project
\_
id
\.
If null, then object not in folder/project
</td>
</tr>
<tr>
<td>
workflow
\_
id
</td>
<td>
Unique identifier for workflow containing object
</td>
<td>
Foreign key for workflow
\.
id
</td>
<td>
wfw
\_
DMcZhu4A
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
review
\_
status
</td>
<td>
Current review status for object
</td>
<td>
null, NEEDS
\_
REVIEW, NEEDS
\_
REVISION, REJECTED, ACCEPTED
</td>
<td>
null, NEEDS
\_
REVIEW, NEEDS
\_
REVISION, REJECTED, ACCEPTED
</td>
<td>
</td>
</tr>
<tr>
<td>
review
\_
requested
\_
at
</td>
<td>
Date of most recent review requested for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
Date of most recent review request
</td>
</tr>
<tr>
<td>
review
\_
status
\_
changed
\_
at
</td>
<td>
Date of review status change for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP-Entry%20Namet/etr\_gRogHFOb-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
Table Row
id
entry_auditor
Table Row
Definition
Value Type
Example values (if applicable)
Notes
id
Unique Benchling-prescribed ID for each line item in table
Format dependent on table
ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc
Primary key for a table
source_id
The project or registry that the object's permissions comes from
Foreign key for project.id or registry.id
src_hh9ffHqV
If an object isn't in a project, the permissions will be derived from the Registry
user_id
Unique identifier for user
Foreign key for user.id
ent_yXrL3BjX
See User Table for more information
entry_id
Unique identifier for Entry
Foreign key for entry.id
etr_GtcscEZq
See Entry Table for more information
author
Table Row
Definition
Value Type
Example values (if applicable)
Notes
id
Unique Benchling-prescribed ID for each line item in table
Format dependent on table
ent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc
Primary key for a table
source_id
The project or registry that the object's permissions comes from
Foreign key for project.id or registry.id
src_hh9ffHqV
If an object isn't in a project, the permissions will be derived from the Registry
user_id
Unique identifier for user
Foreign key for user.id
ent_yXrL3BjX
See User Table for more information
entry_id
Unique identifier for Entry
Foreign key for entry.id
etr_GtcscEZq
If entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information
--{Lab Automation Tables}--
EXAMPLE Lab Auto table
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
identifier of the run
</td>
<td>
Character varying
</td>
<td>
ee6da040-fa64-4e47-9a5e-98892fa32580
</td>
<td>
</td>
</tr>
<tr>
<td>
source\_id
</td>
<td>
project that the run is in
</td>
<td>
Character varying
</td>
<td>
src\_RWL0Oekn
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
</td>
<td>
lab auto schema this run is part of
</td>
<td>
Character varying
</td>
<td>
transfection\_v1\_schema
</td>
<td>
</td>
</tr>
<tr>
<td>
created\_at$
</td>
<td>
when the run was created
</td>
<td>
timestamp without time zone
</td>
<td>
2020-06-04T00:11:56.132400
</td>
<td>
</td>
</tr>
<tr>
<td>
creator\_id$
</td>
<td>
who created it
</td>
<td>
Character varying
</td>
<td>
ent\_naLWig4C
</td>
<td>
</td>
</tr>
<tr>
<td>
entry\_id$
</td>
<td>
which entry it was created in
</td>
<td>
Character varying
</td>
<td>
etr\_nLrUvmPx
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
whether the run was archived
</td>
<td>
boolean
</td>
<td>
false
</td>
<td>
</td>
</tr>
<tr>
<td>
archive\_purpose$
</td>
<td>
reason for why the run was archived, if archived
</td>
<td>
Character varying
</td>
<td>
null
</td>
<td>
</td>
</tr>
<tr>
<td>
validation\_status$
</td>
<td>
validation status
</td>
<td>
Character varying
</td>
<td>
VALID
</td>
<td>
</td>
</tr>
<tr>
<td>
validation\_comment$
</td>
<td>
validation information
</td>
<td>
Character varying
</td>
<td>
null
</td>
<td>
</td>
</tr>
<tr>
<td>
plate
</td>
<td>
custom created columns as part of the run configuration
</td>
<td>
Character varying
</td>
<td>
"plt\_2Q09VfYn"
</td>
<td>
</td>
</tr>
Table Row
id
--{Results Tables}--
assay_run_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
parent
\_
schema
\_
id
</td>
<td>
Unique identifier for schema which object is derived from
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
XDQ0OW6s
</td>
<td>
</td>
</tr>
Table Row
id
assay_result_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
parent
\_
schema
\_
id
</td>
<td>
Unique identifier for schema which object is derived from
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
XDQ0OW6s
</td>
<td>
</td>
</tr>
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
schema
</td>
<td>
Unique Schema name for object
</td>
<td>
Text
</td>
<td>
"Fermentation Results"
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at$
</td>
<td>
Date created for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
custom$
</td>
<td>
Any custom created columns will be shown here
</td>
<td>
JSONB
</td>
<td>
\{
\}
</td>
<td>
Custom Columns are created after a result table has been entered into a Notebook entry
</td>
</tr>
<tr>
<td>
entity
</td>
<td>
The Entity an object is mapped to
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
entry
\_
id$
</td>
<td>
Unique identifier for Entry
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
See Entry Table for more information
</td>
</tr>
<tr>
<td>
run
\_
id$
</td>
<td>
Unique identifier for Entry
</td>
<td>
Foreign key for run
\.
id
</td>
<td>
a11d82b2
\-
8df3
\-
44ae
\-
bb2e
\-
89086c8b69a4
</td>
<td>
See Entry Table for more information
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
validation
\_
status$
</td>
<td>
Validation status for individual result object
</td>
<td>
VALID, INVALID
</td>
<td>
VALID, INVALID
</td>
<td>
</td>
</tr>
<tr>
<td>
validation
\_
comment$
</td>
<td>
Validation comment for individual result object
</td>
<td>
Text
</td>
<td>
"Standard curve failure"
</td>
<td>
</td>
</tr>
<tr>
<td>
field
\_
validation$
</td>
<td>
Validation comment for each field of the Result object
</td>
<td>
JSONB
</td>
<td>
\{
"timestamp":
\{
"validation
\_
comment": null, "validation
\_
status": "VALID"
\}
, "fluorescence
\_
rfu":
\{
"validation
\_
comment": null, "validation
\_
status": "VALID"
\}
, "entity":
\{
"validation
\_
comment": null, "validation
\_
status": "VALID"
\}
\}
</td>
<td>
</td>
</tr>
<tr>
<td>
Speed
\(
EXAMPLE
\)
</td>
<td>
Individual field of Result object
</td>
<td>
Floating Point
</td>
<td>
48
\.
7
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
<tr>
<td>
Color
\(
EXAMPLE
\)
</td>
<td>
Individual field of Result object
</td>
<td>
Text
</td>
<td>
"Green"
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
<tr>
<td>
Resistance
\(
EXAMPLE
\)
</td>
<td>
Individual field of Result object
</td>
<td>
Text
</td>
<td>
\[
"Ampicillin", "Streptomycin"
\]
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
<tr>
<td>
result
\_
field
\(
EXAMPLE
\)
</td>
<td>
Individual field of Result object
</td>
<td>
Value dependent on field type
</td>
<td>
integer, floating point, text, blob link, etc
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
Table Row
id
--{Registry Tables}--
entity_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
entity
\_
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
\.
See Schema table for more information
</td>
</tr>
<tr>
<td>
registry
\_
id
</td>
<td>
Unique identifier for an Organization's Registry
</td>
<td>
Foreign Key for reigstry
\.
id
</td>
<td>
src
\_
rdw6rOsL
</td>
<td>
1 Registry per Organization
</td>
</tr>
<tr>
<td>
prefix
</td>
<td>
Prefix selected for each schema object
</td>
<td>
Text
</td>
<td>
"p"
</td>
<td>
Prefix will always come before Registry ID for registered objects
</td>
</tr>
Table Row
id
entity
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
file
\_
registry
\_
id
</td>
<td>
Unique Benchling Registry ID associated with each registered entity
</td>
<td>
Text
</td>
<td>
"p001"
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object (when the entity was originally created)
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
If object not in folder, then folder
\_
id = project
\_
id
\.
If null, then object not in folder/project
</td>
</tr>
<tr>
<td>
project
\_
id
</td>
<td>
Unique identifier for project containing object
</td>
<td>
Foreign key for project
\.
id
</td>
<td>
src
\_
PDSy77zE
</td>
<td>
If null, then object isn't contained within a project
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
<tr>
<td>
validation status
</td>
<td>
Registration validation status of object
</td>
<td>
PASSED, FAILED
</td>
<td>
PASSED, FAILED
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP-Entry%20Namet/etr\_gRogHFOb-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
is\_registered
</td>
<td>
denotes whether this object is registered
</td>
<td>
boolean
</td>
<td>
True
</td>
<td>
</td>
</tr>
Table Row
id
registry_entity
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
file
\_
registry
\_
id
</td>
<td>
Unique Benchling Registry ID associated with each registered entity
</td>
<td>
Text
</td>
<td>
"p001"
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object (when the entity was originally created)
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
If object not in folder, then folder
\_
id = project
\_
id
\.
If null, then object not in folder/project
</td>
</tr>
<tr>
<td>
project
\_
id
</td>
<td>
Unique identifier for project containing object
</td>
<td>
Foreign key for project
\.
id
</td>
<td>
src
\_
PDSy77zE
</td>
<td>
If null, then object isn't contained within a project
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry, rna_oligo
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
<tr>
<td>
validation status
</td>
<td>
Registration validation status of object
</td>
<td>
PASSED, FAILED
</td>
<td>
PASSED, FAILED
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP-Entry%20Namet/etr\_gRogHFOb-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit)
</td>
<td>
</td>
</tr>
Table Row
id
entity_alias
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
entity
\_
id
</td>
<td>
The entity for which this is an alias
</td>
<td>
Foreign key for entity
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
alias
</td>
<td>
Identifier serving as the entity alias
</td>
<td>
Text
</td>
<td>
My Memorable Alias
</td>
<td>
</td>
</tr>
Table Row
id
mixture_ingredient
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
created
\_
at$
</td>
<td>
Created date for object (when the entity was originally created)
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at$
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
mixture
\_
id
</td>
<td>
Unique ID for mixture object
</td>
<td>
Foreign key for mixture
\.
id
</td>
<td>
bfi
\_
gQMDFBm4
</td>
<td>
</td>
</tr>
<tr>
<td>
component
\_
entity
\_
id
</td>
<td>
Unique identifier for entity object
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
amount
</td>
<td>
Amount of content
</td>
<td>
Floating Point
</td>
<td>
6, 6
\.
87, 7799499
\.
2359, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
amount
\_
text
</td>
<td>
Amount as text
</td>
<td>
Character Varying
</td>
<td>
100 grams
</td>
<td>
</td>
</tr>
Table Row
id
mixture
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
file
\_
registry
\_
id
</td>
<td>
Unique Benchling Registry ID associated with each registered entity
</td>
<td>
Text
</td>
<td>
"p001"
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object (when the entity was originally created)
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
If object not in folder, then folder
\_
id = project
\_
id
\.
If null, then object not in folder/project
</td>
</tr>
<tr>
<td>
project
\_
id
</td>
<td>
Unique identifier for project containing object
</td>
<td>
Foreign key for project
\.
id
</td>
<td>
src
\_
PDSy77zE
</td>
<td>
If null, then object isn't contained within a project
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry, rna_oligo
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
<tr>
<td>
validation status
</td>
<td>
Registration validation status of object
</td>
<td>
PASSED, FAILED
</td>
<td>
PASSED, FAILED
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP-Entry%20Namet/etr\_gRogHFOb-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
is\_registered
</td>
<td>
denotes whether this object is registered
</td>
<td>
boolean
</td>
<td>
True
</td>
<td>
</td>
</tr>
<tr>
<td>
amount
</td>
<td>
how much of the mixture
</td>
<td>
double
</td>
<td>
100
</td>
<td>
</td>
</tr>
<tr>
<td>
units
</td>
<td>
units
</td>
<td>
Character Varying
</td>
<td>
grams
</td>
<td>
</td>
</tr>
<tr>
<td>
allows\_measured\_ingredients
</td>
<td>
whether you can have measured ingredients in this mixture
</td>
<td>
boolean
</td>
<td>
true
</td>
<td>
</td>
</tr>
Table Row
id
EXAMPLE Entity Table
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
Table Row
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
schema
</td>
<td>
Unique Schema name for object
</td>
<td>
Text
</td>
<td>
"Fermentation Results"
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
creator
\_
id$
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at$
</td>
<td>
Created date for object (when the entity was originally created)
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at$
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
name$
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
file
\_
registry
\_
id$
</td>
<td>
Unique Benchling Registry ID associated with each registered entity
</td>
<td>
Text
</td>
<td>
"p001"
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id$
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id$
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
If object not in folder, then folder
\_
id = project
\_
id
\.
If null, then object not in folder/project
</td>
</tr>
<tr>
<td>
project
\_
id$
</td>
<td>
Unique identifier for project containing object
</td>
<td>
Foreign key for project
\.
id
</td>
<td>
src
\_
PDSy77zE
</td>
<td>
If null, then object isn't contained within a project
</td>
</tr>
<tr>
<td>
url$
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
type$
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry, rna_oligo
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
<tr>
<td>
is
\_
registered$
</td>
<td>
Is entity currently registered
</td>
<td>
Boolean
</td>
<td>
True, False
</td>
<td>
True = Entity has been registered
</td>
</tr>
<tr>
<td>
Color
\(
EXAMPLE
\)
</td>
<td>
Individual Schema Field
</td>
<td>
Text
</td>
<td>
"green"
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
<tr>
<td>
Plasmid
\(
EXAMPLE
\)
</td>
<td>
Individual Schema Field
</td>
<td>
foreign key for plasmid entity
</td>
<td>
seq
\_
HXnZhUkT
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
<tr>
<td>
Length
\(
EXAMPLE
\)
</td>
<td>
Individual Schema Field
</td>
<td>
Floating Point
</td>
<td>
4
\.
567
</td>
<td>
Value dependent on field type
\.
See field table for more information
</td>
</tr>
batch_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
registry
\_
id
</td>
<td>
Unique identifier for an Organization's Registry
</td>
<td>
Foreign Key for reigstry
\.
id
</td>
<td>
src
\_
rdw6rOsL
</td>
<td>
1 Registry per Organization
</td>
</tr>
<tr>
<td>
entity
\_
schema
\_
id
</td>
<td>
Unique identifier for schema object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
XDQ0OW6s
</td>
<td>
</td>
</tr>
Table Row
id
batch
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Available archive purpose options dependent on object
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
entity
\_
id
</td>
<td>
Unique identifier for entity object
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
concentration
\_
si
</td>
<td>
Concentration value for content - note that this is in SI units, not the original units created in the application.
</td>
<td>
Floating Point
</td>
<td>
6, 6
\.
87, 7799499
\.
2359, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
concentration
\_
display
\_
units
</td>
<td>
Original concentration units for concentration
\_
si value. For example, 5 g / L will have 0.005 in the concentration
\_
si column and "g / L" in the concentration
\_
display
\_
units column.
</td>
<td>
Concentration Units
</td>
<td>
ug/mL
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
Table Row
id
--{Sample Tracking / Inventory Tables}--
location_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Available archive purpose options dependent on object
</td>
</tr>
<tr>
<td>
registry
\_
id
</td>
<td>
Unique identifier for an Organization's Registry
</td>
<td>
Foreign Key for reigstry
\.
id
</td>
<td>
src
\_
rdw6rOsL
</td>
<td>
1 Registry per Organization
</td>
</tr>
<tr>
<td>
prefix
</td>
<td>
Prefix selected for each schema object
</td>
<td>
Text
</td>
<td>
"p"
</td>
<td>
Prefix will always come before Registry ID for registered objects
</td>
</tr>
Table Row
id
location
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Made in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, Other
</td>
<td>
Available archive purpose options dependent on object
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
barcode
</td>
<td>
Displays benchling barcode of the object
</td>
<td>
Text
</td>
<td>
15MLFALCON006
</td>
<td>
</td>
</tr>
<tr>
<td>
location
\_
id
</td>
<td>
Unique ID for location that contains object
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
Table Row
id
box
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
barcode
</td>
<td>
Displays benchling barcode of the object
</td>
<td>
Text
</td>
<td>
15MLFALCON006
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
location
\_
id
</td>
<td>
Unique ID for location that contains object
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
Table Row
id
plate
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
barcode
</td>
<td>
Displays benchling barcode of the object
</td>
<td>
Text
</td>
<td>
15MLFALCON006
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
location
\_
id
</td>
<td>
Unique ID for location that contains object
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
Table Row
id
container
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
barcode
</td>
<td>
Displays benchling barcode of the object
</td>
<td>
Text
</td>
<td>
15MLFALCON006
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
box
\_
id
</td>
<td>
Unique ID for box object
</td>
<td>
Foreign key for box
\.
id
</td>
<td>
box
\_
oz4ZE0MN
</td>
<td>
</td>
</tr>
<tr>
<td>
location
\_
id
</td>
<td>
Unique ID for location that contains object
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
<tr>
<td>
plate
\_
id
</td>
<td>
Unique ID for plate object
</td>
<td>
Foreign key for plate
\.
id
</td>
<td>
plt
\_
K9VZG06I
</td>
<td>
</td>
</tr>
<tr>
<td>
row
\_
index
</td>
<td>
Row position where container is located
</td>
<td>
integer
</td>
<td>
5, 7, 12, etc
</td>
<td>
Container specific
\-
must be in box
</td>
</tr>
<tr>
<td>
column
\_
index
</td>
<td>
Column position where container is located
</td>
<td>
integer
</td>
<td>
5, 7, 12, etc
</td>
<td>
Container specific
\-
must be in box
</td>
</tr>
<tr>
<td>
volume
\_
si
</td>
<td>
Volume value for container content - note that this is in SI units, not the original units created in the application.
</td>
<td>
Floating Point
</td>
<td>
5, 7, 12, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
volume
\_
display
\_
units
</td>
<td>
Original volume units for volume
\_
si value. For example, 5 mL will have 0.005 in the volume
\_
si column and "mL" in the volume
\_
display
\_
units column.
</td>
<td>
Text for volume units
</td>
<td>
mL, uL, nL, etc
</td>
<td>
</td>
</tr>
Table Row
id
container_content
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
batch
\_
id
</td>
<td>
Unique identifier for batch object
</td>
<td>
Foreign key for batch
\.
id
</td>
<td>
bat
\_
Gs8PtV0K
</td>
<td>
What batch is in the container
</td>
</tr>
<tr>
<td>
container
\_
id
</td>
<td>
Unique ID for container object
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
</td>
</tr>
<tr>
<td>
entity
\_
id
</td>
<td>
Unique identifier for entity object
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
concentration
\_
si
</td>
<td>
Concentration value for content - note that this is in SI units, not the original units created in the application.
</td>
<td>
Floating Point
</td>
<td>
6, 6
\.
87, 7799499
\.
2359, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
concentration
\_
display
\_
units
</td>
<td>
Original concentration units for concentration
\_
si value. For example, 5 g / L will have 0.005 in the concentration
\_
si column and "g / L" in the concentration
\_
display
\_
units column.
</td>
<td>
Concentration Units
</td>
<td>
ug/mL
</td>
<td>
</td>
</tr>
Table Row
id
container_transfer
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
input
\_
batch
\_
id
</td>
<td>
Unique ID for batch to be transferred
</td>
<td>
Foreign key for batch
\.
id
</td>
<td>
bat
\_
Gs8PtV0K
</td>
<td>
Transfer Table
\-
related; not workflow related
</td>
</tr>
<tr>
<td>
input
\_
container
\_
id
</td>
<td>
Unique ID for container that has entity/batch to be transferred to
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
Transfer Table
\-
related; not workflow related
</td>
</tr>
<tr>
<td>
input
\_
entity
\_
id
</td>
<td>
Unique ID for entity to be transferred
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
Transfer Table
\-
related; not workflow related
</td>
</tr>
<tr>
<td>
output
\_
container
\_
id
</td>
<td>
Unique ID for newly created container
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
Transfer Table
\-
related; not workflow related
</td>
</tr>
<tr>
<td>
volume
\_
si
</td>
<td>
Volume value for container content - note that this is in SI units, not the original units created in the application.
</td>
<td>
Floating Point
</td>
<td>
5, 7, 12, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
volume
\_
display
\_
units
</td>
<td>
Original volume units for volume
\_
si value. For example, 5 mL will have 0.005 in the volume
\_
si column and "mL" in the volume
\_
display
\_
units column.
</td>
<td>
Text for volume units
</td>
<td>
mL, uL, nL, etc
</td>
<td>
</td>
</tr>
Table Row
id
--{Request Tables}--
request_schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
parent
\_
schema
\_
id
</td>
<td>
Unique identifier for schema which object is derived from
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
XDQ0OW6s
</td>
<td>
</td>
</tr>
Table Row
id
request_assignee
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
request
\_
id
</td>
<td>
Unique identifier for the request
</td>
<td>
Foreign key for request
\.
id
</td>
<td>
req
\_
qPtu1MSo
</td>
<td>
</td>
</tr>
<tr>
<td>
user
\_
id
</td>
<td>
Unique identifier for user
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
See User Table for more information
</td>
</tr>
<tr>
<td>
team
\_
id
</td>
<td>
Unique identifier for the assignee's team
</td>
<td>
Foreign key for team
\.
id
</td>
<td>
team
\_
oh5xGqrm
</td>
<td>
</td>
</tr>
Table Row
id
request_fulfillment
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
request
\_
id
</td>
<td>
Unique identifier for the request
</td>
<td>
Foreign key for request
\.
id
</td>
<td>
req
\_
qPtu1MSo
</td>
<td>
</td>
</tr>
<tr>
<td>
sample
\_
group
\_
id
</td>
<td>
ID of the schemas designated for the request
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
gUQdTwR7
</td>
<td>
ID's can be for containers, entities, or batches
</td>
</tr>
<tr>
<td>
request
\_
task
\_
id
</td>
<td>
Unique identifier for a task within a request
</td>
<td>
Foreign key for task
\.
id
</td>
<td>
reqtsk
\_
2nzie5Io
</td>
<td>
</td>
</tr>
<tr>
<td>
entry
\_
id
</td>
<td>
Unique identifier for Entry
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
See Entry Table for more information
</td>
</tr>
<tr>
<td>
workflow
\_
id
</td>
<td>
Unique identifier for workflow containing object
</td>
<td>
Foreign key for workflow
\.
id
</td>
<td>
wfw
\_
DMcZhu4A
</td>
<td>
</td>
</tr>
<tr>
<td>
status
</td>
<td>
Status for a request
\(
requestor
\)
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
</td>
</tr>
Table Row
id
request_sample
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
request
\_
id
</td>
<td>
Unique identifier for the request
</td>
<td>
Foreign key for request
\.
id
</td>
<td>
req
\_
qPtu1MSo
</td>
<td>
</td>
</tr>
<tr>
<td>
sample
\_
group
\_
id
</td>
<td>
ID of the schemas designated for the request
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
gUQdTwR7
</td>
<td>
ID's can be for containers, entities, or batches
</td>
</tr>
<tr>
<td>
batch
\_
id
</td>
<td>
Unique identifier for batch object
</td>
<td>
Foreign key for batch
\.
id
</td>
<td>
bat
\_
Gs8PtV0K
</td>
<td>
What batch is in the container
</td>
</tr>
<tr>
<td>
entity
\_
id
</td>
<td>
Unique identifier for entity object
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
container
\_
id
</td>
<td>
Unique ID for container object
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
</td>
</tr>
<tr>
<td>
field
\_
name
</td>
<td>
Display name for field on schema
</td>
<td>
Text
</td>
<td>
"Date Sequenced"
</td>
<td>
</td>
</tr>
<tr>
<td>
row
\_
index
</td>
<td>
Row position where container is located
</td>
<td>
integer
</td>
<td>
5, 7, 12, etc
</td>
<td>
Container specific
\-
must be in box
</td>
</tr>
Table Row
id
EXAMPLE task
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
request
\_
id
</td>
<td>
Unique identifier for the request
</td>
<td>
Foreign key for request
\.
id
</td>
<td>
req
\_
qPtu1MSo
</td>
<td>
</td>
</tr>
Table Row
id
EXAMPLE request
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
schema
</td>
<td>
Unique Schema name for object
</td>
<td>
Text
</td>
<td>
"Fermentation Results"
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at$
</td>
<td>
Date created for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
status$
</td>
<td>
Status for a request fulfillment
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
id$
</td>
<td>
Display name for object in Benchling
</td>
<td>
prefix
\-
unique number
</td>
<td>
request1, request2
</td>
<td>
</td>
</tr>
<tr>
<td>
url$
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
<tr>
<td>
scheduled
\_
on$
</td>
<td>
Date which the request is to be scheduled for
</td>
<td>
datetime
</td>
<td>
1/8/20
</td>
<td>
</td>
</tr>
Table Row
id
--{Workflow Tables}--
workflow
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
alias
</td>
<td>
Unique identifier for the workflow, based on prefix and sequential number
</td>
<td>
prefix
\-
unique number
</td>
<td>
WF020
</td>
<td>
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
description
</td>
<td>
Description given to object
</td>
<td>
Text
</td>
<td>
"Fermentation Workflow"
</td>
<td>
</td>
</tr>
<tr>
<td>
status
</td>
<td>
Status for a request
\(
requestor
\)
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
</td>
</tr>
<tr>
<td>
last
\_
stage
\_
completed
</td>
<td>
Name of last stage entry marked as complete
</td>
<td>
Text
</td>
<td>
"Transformation"
</td>
<td>
</td>
</tr>
<tr>
<td>
last
\_
stage
\_
completed
\_
at
</td>
<td>
Timestamp of when status of last stage entry was marked as complete
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
template
\_
version
\_
id
</td>
<td>
API ID of workflow template used to generate this workflow
</td>
<td>
Foreign key for workflow
\_
template
\_
version
\.
id
</td>
<td>
wfwtmplv
\_
0MjnYgSk
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
Table Row
id
workflow_template
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
Table Row
id
workflow_template_version
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
version
</td>
<td>
Version
\#
for workflow template
</td>
<td>
Integer
</td>
<td>
1,3 65, etc
</td>
<td>
Auto
\-
incremental when new workflow version is completed
</td>
</tr>
<tr>
<td>
workflow
\_
template
\_
id
</td>
<td>
Unique ID for workflow TEMPLATE
</td>
<td>
Foreign key for workflow
\_
template
\.
id
</td>
<td>
wfwtmpl
\_
w6d11hNb
</td>
<td>
</td>
</tr>
Table Row
id
stage_run
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
stage
\_
name
</td>
<td>
Stage name in Benchling
</td>
<td>
Text
</td>
<td>
"Transfection"
</td>
<td>
</td>
</tr>
<tr>
<td>
entry
\_
id
</td>
<td>
Unique identifier for Entry
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
See Entry Table for more information
</td>
</tr>
<tr>
<td>
workflow
\_
id
</td>
<td>
Unique identifier for workflow containing object
</td>
<td>
Foreign key for workflow
\.
id
</td>
<td>
wfw
\_
DMcZhu4A
</td>
<td>
</td>
</tr>
<tr>
<td>
status
</td>
<td>
Status for a request
\(
requestor
\)
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
IN
\_
PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
</td>
<td>
</td>
</tr>
<tr>
<td>
exp
\_
condition
\_
values
</td>
<td>
Values available for Stage Experimental Conditions
</td>
<td>
Text
</td>
<td>
"Condition": "2"
</td>
<td>
</td>
</tr>
Table Row
id
--{Schema Tables}--
schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
entity, assay
\_
result, assay
\_
run, request, location, box, container, plate, batch
</td>
<td>
See Schema table for more information
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
Table Row
id
field_definition
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
position
</td>
<td>
Field number in schema
</td>
<td>
Integer
</td>
<td>
0, 1, 5, etc
</td>
<td>
0 = 1st field
\.
1 = 2nd field
\.
\.
\.
etc
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
type
</td>
<td>
Selected type of entities for a schema object
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
dna
\_
sequence, aa
\_
sequence, custom
\_
entity, entry
</td>
<td>
Oligo schema are listed as dna
\_
sequence types
</td>
</tr>
<tr>
<td>
display
\_
name
</td>
<td>
Display name of schema in Benchling
</td>
<td>
Text
</td>
<td>
"Cell Line"
</td>
<td>
</td>
</tr>
<tr>
<td>
numeric
\_
min
</td>
<td>
Minimum numeric value given for object
</td>
<td>
Integer
</td>
<td>
0, 1, 5, etc
</td>
<td>
precision limited by number of significant figures
</td>
</tr>
<tr>
<td>
numeric
\_
max
</td>
<td>
Maximum numeric value given for object
</td>
<td>
Integer
</td>
<td>
0, 1, 5, etc
</td>
<td>
precision limited by number of significant figures
</td>
</tr>
<tr>
<td>
is
\_
multi
</td>
<td>
Single or multi option identifier
</td>
<td>
TRUE, FALSE
</td>
<td>
TRUE, FALSE
</td>
<td>
</td>
</tr>
<tr>
<td>
is
\_
required
</td>
<td>
Identifier whether field is required or not
</td>
<td>
TRUE, FALSE
</td>
<td>
TRUE, FALSE
</td>
<td>
</td>
</tr>
<tr>
<td>
dropdown
\_
id
</td>
<td>
unique id of dropdown table
</td>
<td>
Foreign key for dropdown
\_
id in the field definition table
</td>
<td>
sfs
\_
ZVmOP8Ed
</td>
<td>
dropdown
\_
id also found in the URL for the dropdown in the Registry settings page
</td>
</tr>
<tr>
<td>
target
\_
schema
\_
id
</td>
<td>
ID of target schema that points to the relationship link
</td>
<td>
Foreign key for entity
\_
schema
\.
id
</td>
<td>
ts
\_
XDQ0OW6s
</td>
<td>
</td>
</tr>
Table Row
id
[DEPRECATED] field
Applied filter(s): LINKED_FIELD_IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
schema
\_
id
</td>
<td>
Unique identifier for schema containing object
</td>
<td>
Foreign key for schema
\.
id
</td>
<td>
ts
\_
IOGwR6u4
</td>
<td>
</td>
</tr>
<tr>
<td>
field
\_
defiintion
\_
id
</td>
<td>
Unique id of field definition for object in table
</td>
<td>
Foreign key for field
\_
defition
\.
id
</td>
<td>
schema
\_
field
\_
42365
</td>
<td>
See field
\_
definition Table
</td>
</tr>
<tr>
<td>
field
\_
name
</td>
<td>
Display name for field on schema
</td>
<td>
Text
</td>
<td>
"Date Sequenced"
</td>
<td>
</td>
</tr>
<tr>
<td>
batch
\_
id
</td>
<td>
Unique identifier for batch object
</td>
<td>
Foreign key for batch
\.
id
</td>
<td>
bat
\_
Gs8PtV0K
</td>
<td>
What batch is in the container
</td>
</tr>
<tr>
<td>
box
\_
id
</td>
<td>
Unique ID for box object
</td>
<td>
Foreign key for box
\.
id
</td>
<td>
box
\_
oz4ZE0MN
</td>
<td>
</td>
</tr>
<tr>
<td>
container
\_
id
</td>
<td>
Unique ID for container object
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
</td>
</tr>
<tr>
<td>
entry
\_
id
</td>
<td>
Unique identifier for Entry
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
See Entry Table for more information
</td>
</tr>
<tr>
<td>
location
\_
id
</td>
<td>
Unique ID for location that contains object
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
<tr>
<td>
plate
\_
id
</td>
<td>
Unique ID for plate object
</td>
<td>
Foreign key for plate
\.
id
</td>
<td>
plt
\_
K9VZG06I
</td>
<td>
</td>
</tr>
<tr>
<td>
registry
\_
entity
\_
id
</td>
<td>
unique id of any registered entity
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
request
\_
id
</td>
<td>
Unique identifier for the request
</td>
<td>
Foreign key for request
\.
id
</td>
<td>
req
\_
qPtu1MSo
</td>
<td>
</td>
</tr>
<tr>
<td>
run
\_
id
</td>
<td>
Unique identifier for the run
</td>
<td>
Foreign key for assay
\_
run
\.
id
</td>
<td>
multi
\_
a11d82b2
\-
8df3
\-
44ae
\-
bb2e
\-
89086c8b69a4
\_
file
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
value
</td>
<td>
Text value of identified field
</td>
<td>
Text
</td>
<td>
"Amp"
</td>
<td>
</td>
</tr>
<tr>
<td>
blob
\_
value
</td>
<td>
Blob link value in JSON format of identified field
</td>
<td>
JSON value
</td>
<td>
\{
id, name, url
\}
</td>
<td>
Attached file can be found in Benchling
</td>
</tr>
<tr>
<td>
float
\_
value
</td>
<td>
Floating point value of identified field
</td>
<td>
Floating Point
</td>
<td>
2, 4
\.
56, 4334
\.
6493, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
date
\_
value
</td>
<td>
Date format value of identified field
</td>
<td>
datetime
</td>
<td>
1/8/20
</td>
<td>
</td>
</tr>
<tr>
<td>
datetime
\_
value
</td>
<td>
Date format with timestamp value of identified field
</td>
<td>
Timestamp with timezone
</td>
<td>
2019
\-
12
\-
05T19:15:00
</td>
<td>
</td>
</tr>
<tr>
<td>
integer
\_
value
</td>
<td>
Integer value of identified field
</td>
<td>
Integer
</td>
<td>
1, 2, 54, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
json
\_
value
</td>
<td>
JSON value of identified field
</td>
<td>
JSON Value
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
batch
\_
id
</td>
<td>
Unique id of any batch the field object is linked to
</td>
<td>
Foreign key for batch
\.
id
</td>
<td>
bat
\_
Gs8PtV0K
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
box
\_
id
</td>
<td>
Unique id of any box the field object is linked to
</td>
<td>
Foreign key for box
\.
id
</td>
<td>
box
\_
oz4ZE0MN
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
container
\_
id
</td>
<td>
Unique id of any container the field object is linked to
</td>
<td>
Foreign key for container
\.
id
</td>
<td>
con
\_
gQMDFBm4
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
entry
\_
id
</td>
<td>
Unique id of any entry the field object is linked to
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
location
\_
id
</td>
<td>
Unique id of any location the field object is linked to
</td>
<td>
Foreign key for location
\.
id
</td>
<td>
loc
\_
Y2v8daz0
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
plate
\_
id
</td>
<td>
Unique id of any plate the field object is linked to
</td>
<td>
Foreign key for plate
\.
id
</td>
<td>
plt
\_
S5ALalNc
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
result
\_
id
</td>
<td>
Unique id of any result the field object is linked to
</td>
<td>
Foreign key for result
\.
id
</td>
<td>
6498dd5a
\-
1b4b
\-
4954
\-
826f
\-
bfcfd1496373
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
run
\_
id
</td>
<td>
Unique id of any run the field object is linked to
</td>
<td>
Foreign key for run
\.
id
</td>
<td>
343494f6
\-
e633
\-
4523
\-
9aa6
\-
26898c99f482
</td>
<td>
</td>
</tr>
<tr>
<td>
linked
\_
registry
\_
entity
\_
id
</td>
<td>
Unique id of any registered entity the field object is linked oo
</td>
<td>
Foreign key for registry
\_
entity
\.
id
</td>
<td>
bfi
\_
cooUBrYb
</td>
<td>
</td>
</tr>
<tr>
<td>
value
\_
index
</td>
<td>
The position number of a given value for a field that supports multiple values
</td>
<td>
Integer
\(
or null
\)
</td>
<td>
null, 1, 2, 6, etc
</td>
<td>
"null" = Not Multiselect
\.
1,2,3,4, etc = Position of multi
\-
select field
</td>
</tr>
Table Row
id
dropdown
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Character Varying
</td>
<td>
sfs\_jBu9uUnv, etc.
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of dropdown in Benchling
</td>
<td>
Character Varying
</td>
<td>
Color, Analytes, etc.
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for dropdown in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for dropdown in Benchling
</td>
<td>
Character Varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
Table Row
id
dropdown_option
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Character Varying
</td>
<td>
sfso\_2v93jfF9, etc.
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
dropdown\_id
</td>
<td>
Reference to parent dropdown ID
</td>
<td>
Character Varying
</td>
<td>
sfs\_jBu9uUnv, etc.
</td>
<td>
Refers to dropdown.id
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of dropdown option in Benchling
</td>
<td>
Character Varying
</td>
<td>
Color, Analytes, etc.
</td>
<td>
</td>
</tr>
<tr>
<td>
position
</td>
<td>
Relative position of dropdown option in the dropdown
</td>
<td>
Integer
</td>
<td>
0, 3, etc.
</td>
<td>
Ranges from 0 to (# options in dropdown - 1)
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for dropdown option in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for dropdown option in Benchling
</td>
<td>
Character Varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
Table Row
id
--{Folder / Project Tables}--
project
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
url for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
[https://demo.benchling.com/#biotech-org/f/lib\\\_J3tmt8BP\\-Entry%20Namet/etr\\\_gRogHFOb\\-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib\\_J3tmt8BP\\-Entry%20Namet/etr\\_gRogHFOb\\-untitled/edit)
</td>
<td>
</td>
</tr>
Table Row
id
folder
Applied filter(s): IS_NOT_ARCHIVED
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
true = object archived
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Text
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
null = object not archived
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
parent
\_
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
J3tmt8BP
</td>
<td>
</td>
</tr>
Table Row
id
--{User Tables}--
principal
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
handle
</td>
<td>
Unique username chosen by individual users or username defined for a Benchling Apps
</td>
<td>
Text
</td>
<td>
"ssiegfried"
</td>
<td>
Handle can be changed at any point to any other unique string of text/integers
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
email
</td>
<td>
Unique email associated with each user account , column will be null for Benchling App accounts
</td>
<td>
Email
</td>
<td>
"benchlingsupport@benchling
\.
com"
</td>
<td>
</td>
</tr>
<tr>
<td>
is
\_
suspended
</td>
<td>
Suspension status for each user or app
</td>
<td>
FALSE, TRUE
</td>
<td>
FALSE, TRUE
</td>
<td>
TRUE = Suspended user
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for user or app
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
Table Row
id
user
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
handle
</td>
<td>
Unique username chosen by individual users
</td>
<td>
Text
</td>
<td>
"ssiegfried"
</td>
<td>
Handle can be changed at any point to any other unique string of text/integers
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
email
</td>
<td>
Unique email associated with each user account
</td>
<td>
Email
</td>
<td>
"benchlingsupport@benchling
\.
com"
</td>
<td>
</td>
</tr>
<tr>
<td>
is
\_
suspended
</td>
<td>
Suspension status for each user
</td>
<td>
FALSE, TRUE
</td>
<td>
FALSE, TRUE
</td>
<td>
TRUE = Suspended user
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for user
</td>
<td>
Timestamp without timezone
</td>
<td>
2019
\-
12
\-
06T23:24:44
\.
885478
</td>
<td>
</td>
</tr>
Table Row
id
team_member
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
team
\_
id
</td>
<td>
Unique identifier for the assignee's team
</td>
<td>
Foreign key for team
\.
id
</td>
<td>
team
\_
oh5xGqrm
</td>
<td>
</td>
</tr>
<tr>
<td>
user
\_
id
</td>
<td>
Unique identifier for user
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
See User Table for more information
</td>
</tr>
<tr>
<td>
role
</td>
<td>
Team membership status for an individual user
</td>
<td>
ADMIN, MEMBER
</td>
<td>
ADMIN, MEMBER
</td>
<td>
</td>
</tr>
Table Row
id
team
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, QC Results, Therapeutic Cell Line, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
description
</td>
<td>
Description given to object
</td>
<td>
Text
</td>
<td>
"Fermentation Workflow"
</td>
<td>
</td>
</tr>
Table Row
id
--{Molecular Biology Tables}--
Note: These tables exist only in their $raw form; consider performing a JOIN on the relevant schema table.
DNA Sequnce$raw
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Unique identifier for the request
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, Therapeutic Cell Line
</td>
<td>
</td>
</tr>
<tr>
<td>
bases
</td>
<td>
A string representing the bases that make up the DNA Sequence
</td>
<td>
Character Varying
</td>
<td>
agtctgttgggatggccacttaccacatcgtaccccta
\[...]
</td>
<td>
</td>
</tr>
<tr>
<td>
bases\_length\_exceeds\_limit
</td>
<td>
Whether or not the length of the
`bases`
field exceeds the limit
</td>
<td>
Boolean
</td>
<td>
false
</td>
<td>
</td>
</tr>
Table Row
id
DNA Oligo$raw
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
ent
\_
yXrL3BjX, etr
\_
GtcscEZq, loc
\_
Y2v8daz0, etc
</td>
<td>
Primary key for a table
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
If an object isn't in a project, the permissions will be derived from the Registry
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Unique identifier for the request
</td>
<td>
Character Varying
</td>
<td>
Transfection Entry, Therapeutic Cell Line
</td>
<td>
</td>
</tr>
<tr>
<td>
bases
</td>
<td>
A string representing the bases that make up the DNA Oligo
</td>
<td>
Character Varying
</td>
<td>
agtctgttgggatggccacttaccacatcgtaccccta
\[...]
</td>
<td>
</td>
</tr>
Table Row
id
--{Workflow Tables}--
Workflow Task Group
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
prs
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character varying
</td>
<td>
Analytical SEC 26
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
id
</td>
<td>
Unique identifier surfaced in the actual Benchling site
</td>
<td>
Prefix
\-
unique number
</td>
<td>
SEC26
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
URL for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
https://demo
\.
benchling
\.
com/demo/f/lib
\_
LDMZLtYM
\-
media
\-
prep/prs
\_
hVI52tJk
\-
\-
analytical
\-
sec
\-
26/edit
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
LDMZLtYM
</td>
<td>
</td>
</tr>
<tr>
<td>
execution
\_
type
</td>
<td>
Selected type for how tasks are executed
</td>
<td>
ENTRY, DIRECT
</td>
<td>
ENTRY, DIRECT
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
boolean
</td>
<td>
FALSE, TRUE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Character varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_node\_config\_id
</td>
<td>
Unique identifier for workflow\_flowchart\_node\_config
</td>
<td>
Foreign key for workflow\_flowchart\_node\_config.id
</td>
<td>
wffcnc\_giVNQcTL
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_config\_version\_id
</td>
<td>
Unique identifier for workflow\_flowchart\_config\_version
</td>
<td>
Foreign key for workflow\_flowchart\_config\_version.id
</td>
<td>
wffccv\_giVNQcAF
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Task Schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
prstsch
\_
0JAxhOhS
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
workflow
\_
task
</td>
<td>
Always workflow
\_
task for this table
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character varying
</td>
<td>
Analytical SEC
</td>
<td>
</td>
</tr>
<tr>
<td>
system
\_
name
</td>
<td>
Name of warehouse table for this schema
</td>
<td>
Character varying
</td>
<td>
analytical
\_
sec
</td>
<td>
</td>
</tr>
<tr>
<td>
execution
\_
type
</td>
<td>
Selected type for how tasks are executed
</td>
<td>
ENTRY, DIRECT
</td>
<td>
ENTRY, DIRECT
</td>
<td>
</td>
</tr>
<tr>
<td>
prefix
</td>
<td>
Prefix used when creating workflow tasks from this schema
</td>
<td>
Character varying
</td>
<td>
SEC
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
group
\_
prefix
</td>
<td>
Prefix used when creating workflow task groups from this schema
</td>
<td>
Character varying
</td>
<td>
SEC
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
url
</td>
<td>
URL for each object in Benchling
</td>
<td>
Browser URL
</td>
<td>
https://demo
\.
benchling
\.
com/demo/f/lib
\_
LDMZLtYM
\-
media
\-
prep/prs
\_
hVI52tJk
\-
\-
analytical
\-
sec
\-
26/edit
</td>
<td>
</td>
</tr>
<tr>
<td>
can
\_
set
\_
assignee
\_
on
\_
task
\_
creation
</td>
<td>
Determines if assignees can be set when a task is created
</td>
<td>
Boolean
</td>
<td>
TRUE, FALSE
</td>
<td>
</td>
</tr>
<tr>
<td>
folder
\_
id
</td>
<td>
Unique identifier for folder containing object
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
LDMZLtYM
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
status
\_
lifecycle
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
\_
lifecycle
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\_
lifecycle
\.
id
</td>
<td>
prstswf
\_
J8s40D7l
</td>
<td>
</td>
</tr>
<tr>
<td>
default
\_
responsible
\_
team
\_
id
</td>
<td>
Unique identifier for team
</td>
<td>
Foreign key for team
\.
id
</td>
<td>
team
\_
oh5xGqrm
</td>
<td>
</td>
</tr>
<tr>
<td>
default
\_
creation
\_
folder
\_
id
</td>
<td>
Unique identifier for default folder where tasks of this schema are created
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
LDMZLtYM
</td>
<td>
</td>
</tr>
<tr>
<td>
default
\_
entry
\_
execution
\_
folder
\_
id
</td>
<td>
Unique identifier for default folder where tasks of this schema are executed
</td>
<td>
Foreign key for folder
\.
id
</td>
<td>
lib
\_
LDMZLtYM
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
boolean
</td>
<td>
FALSE, TRUE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Character varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Task
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wftask
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
id
</td>
<td>
Unique identifier surfaced in the actual Benchling site
</td>
<td>
Prefix
\-
unique number
</td>
<td>
SEC26
\-
T5
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
scheduled
\_
on
\_
date
</td>
<td>
Date the task is scheduled to be performed
</td>
<td>
Date
</td>
<td>
2020
\-
06
\-
04
</td>
<td>
</td>
</tr>
<tr>
<td>
assignee
\_
id
</td>
<td>
Unique identifier for assigned user
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
group
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
group
</td>
<td>
Foreign key for workflow
\_
task
\_
group
\.
id
</td>
<td>
prs
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
schema
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
schema
</td>
<td>
Foreign key for workflow
\_
task
\_
schema
\.
id
</td>
<td>
prstsch
\_
0JAxhOhS
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
status
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\.
id
</td>
<td>
wfts
\_
A6CmVrOp
</td>
<td>
</td>
</tr>
<tr>
<td>
execution
\_
entry
\_
id
</td>
<td>
Unique identifier for entry
</td>
<td>
Foreign key for entry
\.
id
</td>
<td>
etr
\_
GtcscEZq
</td>
<td>
</td>
</tr>
<tr>
<td>
execution
\_
user
\_
id
</td>
<td>
Unique identifier for user
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
executed
\_
on
</td>
<td>
Date the task was executed
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
Boolean
</td>
<td>
FALSE, TRUE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Character varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_id
</td>
<td>
Unique identifier for workflow\_flowchart
</td>
<td>
Foreign key for workflow\_flowchart.id
</td>
<td>
wffc\_giVNQcAF
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_task\_id
</td>
<td>
Unique identifier for a flowchart workflow\_task
</td>
<td>
Foreign key for workflow\_task.id
</td>
<td>
wftask\_OnnsW08k
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Output Schema
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
prsosch
\_
kz6y7T4o
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
type
</td>
<td>
Schema type selected for schema of object
</td>
<td>
Text
</td>
<td>
workflow
\_
output
</td>
<td>
Always workflow
\_
output for this table
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character varying
</td>
<td>
Analytical SEC
</td>
<td>
</td>
</tr>
<tr>
<td>
system
\_
name
</td>
<td>
Name of warehouse table for this schema
</td>
<td>
Character varying
</td>
<td>
analytical
\_
sec
</td>
<td>
</td>
</tr>
<tr>
<td>
prefix
</td>
<td>
Prefix used when creating workflow tasks from this schema
</td>
<td>
Character varying
</td>
<td>
SEC
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
boolean
</td>
<td>
FALSE, TRUE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Character varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Output
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wftask
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
source
\_
id
</td>
<td>
The project or registry that the object's permissions comes from
</td>
<td>
Foreign key for project
\.
id or registry
\.
id
</td>
<td>
src
\_
hh9ffHqV
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
id
</td>
<td>
Unique identifier surfaced in the actual Benchling site
</td>
<td>
Prefix
\-
unique number
</td>
<td>
SEC26
\-
T5
</td>
<td>
</td>
</tr>
<tr>
<td>
creator
\_
id
</td>
<td>
Unique identifier for creator of object
</td>
<td>
Foreign key for user
\.
id
</td>
<td>
ent
\_
yXrL3BjX
</td>
<td>
</td>
</tr>
<tr>
<td>
created
\_
at
</td>
<td>
Created date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
modified
\_
at
</td>
<td>
Most recent modified date for object
</td>
<td>
Timestamp without time zone
</td>
<td>
2020
\-
06
\-
04T00:11:56
\.
132400
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
group
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
group
</td>
<td>
Foreign key for workflow
\_
task
\_
group
\.
id
</td>
<td>
prs
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
id
</td>
<td>
Unique identifier for workflow
\_
task that output is for
</td>
<td>
Foreign key for workflow
\_
task
\.
id
</td>
<td>
wftask
\_
hVI52tJk
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
status
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\.
id
</td>
<td>
wfts
\_
A6CmVrOp
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
output
\_
schema
\_
id
</td>
<td>
Unique identifier for workflow
\_
output
\_
schema
</td>
<td>
Foreign key for workflow
\_
output
\_
schema
\.
id
</td>
<td>
prsosch
\_
kz6y7T4o
</td>
<td>
</td>
</tr>
<tr>
<td>
archived$
</td>
<td>
Archival state for object in Benchling
</td>
<td>
boolean
</td>
<td>
FALSE, TRUE
</td>
<td>
</td>
</tr>
<tr>
<td>
archive
\_
purpose$
</td>
<td>
Archival reason for object in Benchling
</td>
<td>
Character varying
</td>
<td>
null, Made in Error, Retired, Other, etc
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Task Status
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wfts
\_
A6CmVrOp
</td>
<td>
</td>
</tr>
<tr>
<td>
display
\_
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character varying
</td>
<td>
Completed
</td>
<td>
</td>
</tr>
<tr>
<td>
status
\_
type
</td>
<td>
Type of status
</td>
<td>
PENDING, IN
\_
PROGRESS, COMPLETED, CANCELLED, FAILED, INVALID
</td>
<td>
PENDING, IN
\_
PROGRESS, COMPLETED, CANCELLED, FAILED, INVALID
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Task Status Lifecycle
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
prstswf
\_
J8s40D7l
</td>
<td>
</td>
</tr>
<tr>
<td>
name
</td>
<td>
Name of object in Benchling
</td>
<td>
Character varying
</td>
<td>
Entry Review
</td>
<td>
</td>
</tr>
<tr>
<td>
schema
\_
execution
\_
type
</td>
<td>
Type of execution for task schemas using this lifecycle
</td>
<td>
DIRECT, ENTRY
</td>
<td>
DIRECT, ENTRY
</td>
<td>
</td>
</tr>
<tr>
<td>
initial
\_
workflow
\_
task
\_
status
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\.
id
</td>
<td>
wfts
\_
A6CmVrOp
</td>
<td>
The first status of the lifecycle
\.
lifecycle edges determine the rest of the status order
\.
</td>
</tr>
Table Row
id
Workflow Task Status Lifecycle Edge
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling
\-
prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
prstswfe
\_
aziohrUt
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow
\_
task
\_
status
\_
lifecycle
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
\_
lifecycle
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\_
lifecycle
\.
id
</td>
<td>
prstswf
\_
J8s40D7l
</td>
<td>
Lifecycle that the edge is for
</td>
</tr>
<tr>
<td>
from
\_
workflow
\_
task
\_
status
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\.
id
</td>
<td>
wfts
\_
A6CmVrOp
</td>
<td>
The starting status of the edge
</td>
</tr>
<tr>
<td>
to
\_
workflow
\_
task
\_
status
\_
id
</td>
<td>
Unique identifier for workflow
\_
task
\_
status
</td>
<td>
Foreign key for workflow
\_
task
\_
status
\.
id
</td>
<td>
wfts
\_
Td7q3eiM
</td>
<td>
The ending status of the edge
</td>
</tr>
Table Row
id
Workflow Flowchart
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wffc\_giVNQcAF
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Flowchart Node Config
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wffcnc\_giVNQWcXS
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_task\_schema\_id
</td>
<td>
Unique identifier for workflow\_task\_schema
</td>
<td>
Foreign key for workflow\_task\_schema.id
</td>
<td>
prstsch\_OnnsV06w
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Flowchart Edge Config
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wffcec\_poVNQcQE
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_id
</td>
<td>
Unique identifier for workflow\_flowchart
</td>
<td>
Foreign key for workflow\_flowchart.id
</td>
<td>
wffc\_giVNQcAF
</td>
<td>
</td>
</tr>
<tr>
<td>
from\_flowchart\_node\_config\_id
</td>
<td>
Unique identifier for workflow\_flowchart\_node\_config
</td>
<td>
Foreign key for workflow\_flowchart\_node\_config.id
</td>
<td>
wffcnc\_mcMKcXS
</td>
<td>
</td>
</tr>
<tr>
<td>
to\_node\_config\_id
</td>
<td>
Unique identifier for workflow\_flowchart\_node\_config
</td>
<td>
Foreign key for workflow\_flowchart\_node\_config.id
</td>
<td>
wffcnc\_nwICpoe
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Lineage Edge
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wfle\_kmQWplX
</td>
<td>
</td>
</tr>
<tr>
<td>
to\_workflow\_task\_id
</td>
<td>
Unique identifier for workflow\_task
</td>
<td>
Foreign key for workflow\_task.id
</td>
<td>
wftask\_OnnsW08k
</td>
<td>
</td>
</tr>
<tr>
<td>
from\_workflow\_task\_id
</td>
<td>
Unique identifier for workflow\_task
</td>
<td>
Foreign key for workflow\_task.id
</td>
<td>
wftask\_OnnsW08k
</td>
<td>
</td>
</tr>
<tr>
<td>
to\_workflow\_output\_id
</td>
<td>
Unique identifier for workflow\_output
</td>
<td>
Foreign key for workflow\_output
</td>
<td>
wfout\_5cJLQKVF
</td>
<td>
</td>
</tr>
<tr>
<td>
from\_workflow\_output\_id
</td>
<td>
Unique identifier for workflow\_output
</td>
<td>
Foreign key for workflow\_output.id
</td>
<td>
wfout\_5cJLQKVF
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Flowchart Config Version
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wffccv\_giVNQcAF
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_config\_id
</td>
<td>
Unique identifier for workflow\_flowchart\_config
</td>
<td>
Foreign key for workflow\_flowchart\_config.id
</td>
<td>
wffcc\_wcIJAPL
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_flowchart\_id
</td>
<td>
Unique identifier for workflow\_flowchart
</td>
<td>
Foreign key for workflow\_flowchart.id
</td>
<td>
wffc\_giVNQcAF
</td>
<td>
</td>
</tr>
Table Row
id
Workflow Chart Config
<th>
Definition
</th>
<th>
Value Type
</th>
<th>
Example values
\(
if applicable
\)
</th>
<th>
Notes
</th>
</tr>
<td>
Unique Benchling-prescribed ID for each line item in table
</td>
<td>
Format dependent on table
</td>
<td>
wffcc\_wcIJAPL
</td>
<td>
</td>
</tr>
<tr>
<td>
workflow\_task\_schema\_id
</td>
<td>
Unique identifier for workflow\_task\_schema
</td>
<td>
Foreign key for workflow\_task\_schema.id
</td>
<td>
prstsch\_OnnsV06w
</td>
<td>
</td>
</tr>
