Benchling

Warehouse Table Columns

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.

To see all Benchling Tables in diagram format please navigate to https://docs.benchling.com/docs/warehouse-tables-v2

The following information is outlined below for every WH table:

  1. Column Name
  2. Column Definition
  3. Value Type
  4. Example Values
  5. Useful Notes

--{Notebook Tables}--

See below for all tables relating to the Benchling Notebook

entry

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tablePrimary key for a Warehouse tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcFormat dependent on table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
display_idUnique identifier surfaced in the actual Benchling siteprefix-unique entry numberEXP001 or EXP20000416I.E Unique Entry number
folder_idUnique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BPIf object not in folder, then folder_id = project_id. If null, then object not in folder/project
workflow_idUnique identifier for workflow containing objectForeign key for workflow.idwfw_DMcZhu4A
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
review_statusCurrent review status for objectnull, NEEDS_REVIEW, NEEDS_REVISION, REJECTED, ACCEPTEDnull, NEEDS_REVIEW, NEEDS_REVISION, REJECTED, ACCEPTED
review_requested_atDate of most recent review requested for objectTimestamp without timezone2019-12-06T23:24:44.885478Date of most recent review request
review_status_changed_atDate of review status change for objectTimestamp without timezone2019-12-06T23:24:44.885478
urlurlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX

entry_auditor

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee User Table for more information
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqIf entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information

author

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee User Table for more information
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqIf entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information

--{Results Tables}--

assay_run_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_schema_idUnique identifier for schema which object is derived fromForeign key for schema.idts_XDQ0OW6s

assay_result_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_schema_idUnique identifier for schema which object is derived fromForeign key for schema.idts_XDQ0OW6s

EXAMPLE Result table

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
schemaUnique Schema name for objectText"Fermentation Results"
created_at$Date created for objectTimestamp without timezone2019-12-06T23:24:44.885478
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
custom$Any custom created columns will be shown hereJSONB{}Custom Columns are created after a result table has been entered into a Notebook entry
entityThe Entity an object is mapped toForeign key for registry_entity.idbfi_cooUBrYb
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqIf entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
validation_status$Validation status for individual result objectVALID, INVALIDVALID, INVALID
validation_comment$Validation comment for individual result objectText"Standard curve failure"
field_validation$Validation comment for each field of the Result objectJSONB{ "timestamp": { "validation_comment": null, "validation_status": "VALID" }, "fluorescence_rfu": { "validation_comment": null, "validation_status": "VALID" }, "entity": { "validation_comment": null, "validation_status": "VALID" } }
Speed (EXAMPLE)Individual field of Result objectFloating Point48.7Value dependent on field type. See field table for more information
Color (EXAMPLE)Individual field of Result objectText"Green"Value dependent on field type. See field table for more information
Resistance (EXAMPLE)Individual field of Result objectText["Ampicillin", "Streptomycin"]Value dependent on field type. See field table for more information
result_field (EXAMPLE)Individual field of Result objectValue dependent on field typeinteger, floating point, text, blob link, etcValue dependent on field type. See field table for more information

--{Registry Tables}--

entity_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
entity_typeSelected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types. See Schema table for more information
registry_idUnique identifier for an Organization's RegistryForeign Key for reigstry.idsrc_rdw6rOsL1 Registry per Organization
prefixPrefix selected for each schema objectText"p"Prefix will always come before Registry ID for registered objects

entity

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
file_registry_idUnique Benchling Registry ID associated with each registered entityText"p001"
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
folder_idUnique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BPIf object not in folder, then folder_id = project_id. If null, then object not in folder/project
project_idUnique identifier for project containing objectForeign key for project.idsrc_PDSy77zEIf null, then object isn't contained within a project
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
typeSelected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types
validation statusRegistration validation status of objectPASSED, FAILEDPASSED, FAILED
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit
is_registereddenotes whether this object is registeredbooleanTrue

registry_entity

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
file_registry_idUnique Benchling Registry ID associated with each registered entityText"p001"
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
folder_idUnique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BPIf object not in folder, then folder_id = project_id. If null, then object not in folder/project
project_idUnique identifier for project containing objectForeign key for project.idsrc_PDSy77zEIf null, then object isn't contained within a project
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
typeSelected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types
validation statusRegistration validation status of objectPASSED, FAILEDPASSED, FAILED
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit

entity_alias

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
entity_idThe entity for which this is an aliasForeign key for entity.ident_yXrL3BjX
aliasIdentifier serving as the entity aliasTextMy Memorable Alias

EXAMPLE Entity Table

Table RowDefinitionValue TypeExample values (if applicable)Notes
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
schemaUnique Schema name for objectText"Fermentation Results"
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
creator_id$Unique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_at$Date created for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_at$Most recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
name$Name of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
file_registry_id$Unique Benchling Registry ID associated with each registered entityText"p001"
schema_id$Unique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
folder_id$Unique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BPIf object not in folder, then folder_id = project_id. If null, then object not in folder/project
project_id$Unique identifier for project containing objectForeign key for project.idsrc_PDSy77zEIf null, then object isn't contained within a project
url$url for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
type$Selected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types
is_registered$Is entity currently registeredBooleanTrue, FalseTrue = Entity has been registered
Color (EXAMPLE)Individual Schema FieldText"green"Value dependent on field type. See field table for more information
Plasmid (EXAMPLE)Individual Schema Fieldforeign key for plasmid entityseq_HXnZhUkTValue dependent on field type. See field table for more information
Length (EXAMPLE)Individual Schema FieldFloating Point4.567Value dependent on field type. See field table for more information

batch_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
registry_idUnique identifier for an Organization's RegistryForeign Key for reigstry.idsrc_rdw6rOsL1 Registry per Organization
entity_schema_idUnique identifier for schema objectForeign key for schema.idts_XDQ0OW6s

batch

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purposeArchival reason for object in BenchlingMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherAvailable archive purpose options dependent on object
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
entity_idUnique identifier for entity objectForeign key for registry_entity.idbfi_cooUBrYb
concentration_siConcentration value for objectFloating Point6, 6.87, 7799499.2359, etc
concentration_display_unitsConcentration units for objectConcentration Unitsug/mL
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
typeSelected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types

--{Sample Tracking / Inventory Tables}--

location_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purposeArchival reason for object in BenchlingMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherAvailable archive purpose options dependent on object
registry_idUnique identifier for an Organization's RegistryForeign Key for reigstry.idsrc_rdw6rOsL1 Registry per Organization
prefixPrefix selected for each schema objectText"p"Prefix will always come before Registry ID for registered objects

location

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purposeArchival reason for object in BenchlingMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherMade in error, Retired, Expended, Shipped, Contaminated, Expired, Missing, Merged, OtherAvailable archive purpose options dependent on object
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
barcodeDisplays benchling barcode of the objectText15MLFALCON006
location_idUnique ID for location that contains objectForeign key for location.idloc_Y2v8daz0

box

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
barcodeDisplays benchling barcode of the objectText15MLFALCON006
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
location_idUnique ID for location that contains objectForeign key for location.idloc_Y2v8daz0

plate

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etc
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqV
archived$Archival state for object in BenchlingBooleanTRUE, FALSE
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etc
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
barcodeDisplays benchling barcode of the objectText15MLFALCON006
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
location_idUnique ID for location that contains objectForeign key for location.idloc_Y2v8daz0

container

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
creator_idUnique identifier for creator of objectForeign key for user.ident_yXrL3BjX
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
barcodeDisplays benchling barcode of the objectText15MLFALCON006
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
box_idUnique ID for box objectForeign key for box.idbox_oz4ZE0MN
location_idUnique ID for location that contains objectForeign key for location.idloc_Y2v8daz0
plate_idUnique ID for plate objectForeign key for plate.idplt_K9VZG06I
row_indexRow position where container is locatedinteger5, 7, 12, etcContainer specific - must be in box
column_indexColumn position where container is locatedinteger5, 7, 12, etcContainer specific - must be in box
volume_siVolume value for container contentInteger5, 7, 12, etc
volume_display_unitsVolume units for volume_si valueText for volume unitsmL, uL, nL, etc

container_content

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
batch_idUnique identifier for batch objectForeign key for batch.idbat_Gs8PtV0KWhat batch is in the container
container_idUnique ID for container objectForeign key for container.idcon_gQMDFBm4
entity_idUnique identifier for entity objectForeign key for registry_entity.idbfi_cooUBrYb
concentration_siConcentration value for objectFloating Point6, 6.87, 7799499.2359, etc
concentration_display_unitsConcentration units for objectConcentration Unitsug/mL

container_transfer

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
input_batch_idUnique ID for batch to be transferredForeign key for batch.idbat_Gs8PtV0KTransfer Table-related; not workflow related
input_container_idUnique ID for container that has entity/batch to be transferred toForeign key for container.idcon_gQMDFBm4Transfer Table-related; not workflow related
input_entity_idUnique ID for entity to be transferredForeign key for registry_entity.idbfi_cooUBrYbTransfer Table-related; not workflow related
output_container_idUnique ID for newly created containerForeign key for container.idcon_gQMDFBm4Transfer Table-related; not workflow related
volume_siVolume value for container contentInteger5, 7, 12, etc
volume_display_unitsVolume units for volume_si valueText for volume unitsmL, uL, nL, etc

--{Request Tables}--

request_schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_schema_idUnique identifier for schema which object is derived fromForeign key for schema.idts_XDQ0OW6s

request_assignee

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee User Table for more information
team_idUnique identifier for the assignee's teamForeign key for team.idteam_oh5xGqrm

request_fulfillment

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
sample_group_idID of the schemas designated for the requestForeign key for schema.idts_gUQdTwR7ID's can be for containers, entities, or batches
request_task_idUnique identifier for a task within a requestForeign key for task.idreqtsk_2nzie5Io
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqIf entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information
workflow_idUnique identifier for workflow containing objectForeign key for workflow.idwfw_DMcZhu4A
statusStatus for a request (requestor)IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED

request_sample

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
sample_group_idID of the schemas designated for the requestForeign key for schema.idts_gUQdTwR7ID's can be for containers, entities, or batches
batch_idUnique identifier for batch objectForeign key for batch.idbat_Gs8PtV0KWhat batch is in the container
entity_idUnique identifier for entity objectForeign key for registry_entity.idbfi_cooUBrYb
container_idUnique ID for container objectForeign key for container.idcon_gQMDFBm4
field_nameDisplay name for field on schemaText"Date Sequenced"
row_indexRow position where container is locatedinteger5, 7, 12, etcContainer specific - must be in box

EXAMPLE task

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo

EXAMPLE request

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
schemaUnique Schema name for objectText"Fermentation Results"
created_at$Date created for objectTimestamp without timezone2019-12-06T23:24:44.885478
status$Status for a request fulfillmentIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLEDIN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
display_id$Display name for object in Benchlingprefix-unique numberrequest1, request2
url$url for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit
scheduled_on$Date which the request is to be scheduled fordatetime1/8/20

--{Workflow Tables}--

workflow

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

workflow_template

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

workflow_template_version

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

stage_run

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

--{Schema Tables}--

schema

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
schema_typeSchema type selected for schema of objectTextentity, assay_result, assay_run, request, location, box, container, plate, batchSee Schema table for more information
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc

field_definition

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
positionField number in schemaInteger0, 1, 5, etc0 = 1st field. 1 = 2nd field...etc
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
typeSelected type of entities for a schema objectdna_sequence, aa_sequence, custom_entity, entrydna_sequence, aa_sequence, custom_entity, entryOligo schema are listed as dna_sequence types
display_nameDisplay name of schema in BenchlingText"Cell Line"
numeric_minMinimum numeric value given for objectInteger0, 1, 5, etcprecision limited by number of significant figures
numeric_maxMaximum numeric value given for objectInteger0, 1, 5, etcprecision limited by number of significant figures
is_multiSingle or multi option identifierTRUE, FALSETRUE, FALSE
is_requiredIdentifier whether field is required or notTRUE, FALSETRUE, FALSE
dropdown_idunique id of dropdown tableForeign key for dropdown_id in the field definition tablesfs_ZVmOP8Eddropdown_id also found in the URL for the dropdown in the Registry settings page
target_schema_idID of target schema that points to the relationship linkForeign key for entity_schema.idts_XDQ0OW6s

field

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
schema_idUnique identifier for schema containing objectForeign key for schema.idts_IOGwR6u4
field_defiintion_idUnique id of field definition for object in tableForeign key for field_defition.idschema_field_42365See field_definition Table
field_nameDisplay name for field on schemaText"Date Sequenced"
batch_idUnique identifier for batch objectForeign key for batch.idbat_Gs8PtV0KWhat batch is in the container
box_idUnique ID for box objectForeign key for box.idbox_oz4ZE0MN
container_idUnique ID for container objectForeign key for container.idcon_gQMDFBm4
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqIf entry has multiple authors there will be multiple rows per entry_id. See Entry Table for more information
location_idUnique ID for location that contains objectForeign key for location.idloc_Y2v8daz0
plate_idUnique ID for plate objectForeign key for plate.idplt_K9VZG06I
registry_entity_idunique id of any registered entityForeign key for registry_entity.idbfi_cooUBrYb
request_idUnique identifier for the requestForeign key for request.idreq_qPtu1MSo
run_idUnique identifier for the runForeign key for assay_run.idmulti_a11d82b2-8df3-44ae-bb2e-89086c8b69a4_file
display_valueText value of identified fieldText"Amp"
blob_valueBlob link value in JSON format of identified fieldJSON value{id, name, url}Attached file can be found in Benchling
float_valueFloating point value of identified fieldFloating Point2, 4.56, 4334.6493, etc
date_valueDate format value of identified fielddatetime1/8/20
datetime_valueDate format with timestamp value of identified fieldTimestamp with timezone2019-12-05T19:15:00
integer_valueInteger value of identified fieldInteger1, 2, 54, etc
json_valueJSON value of identified fieldJSON Value
linked_batch_idUnique id of any batch the field object is linked toForeign key for batch.idbat_Gs8PtV0K
linked_box_idUnique id of any box the field object is linked toForeign key for box.idbox_oz4ZE0MN
linked_container_idUnique id of any container the field object is linked toForeign key for container.idcon_gQMDFBm4
linked_entry_idUnique id of any entry the field object is linked toForeign key for entry.idetr_GtcscEZq
linked_location_idUnique id of any location the field object is linked toForeign key for location.idloc_Y2v8daz0
linked_plate_idUnique id of any plate the field object is linked toForeign key for plate.idplt_S5ALalNc
linked_result_idUnique id of any result the field object is linked toForeign key for result.id6498dd5a-1b4b-4954-826f-bfcfd1496373
linked_run_idUnique id of any run the field object is linked toForeign key for run.id343494f6-e633-4523-9aa6-26898c99f482
linked_registry_entity_idUnique id of any registered entity the field object is linked ooForeign key for registry_entity.idbfi_cooUBrYb
value_indexThe position number of a given value for a field that supports multiple valuesInteger (or null)null, 1, 2, 6, etc"null" = Not Multiselect.1,2,3,4, etc = Position of multi-select field

dropdown

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingsfs_jBu9uUnv, etc.Primary key for a table
nameName of dropdown in BenchlingCharacter VaryingColor, Analytes, etc.
archived$Archival state for dropdown in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for dropdown in BenchlingCharacter Varyingnull, Made in Error, Retired, Other, etcnull = object not archived

dropdown_option

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingsfso_2v93jfF9, etc.Primary key for a table
dropdown_idReference to parent dropdown IDCharacter Varyingsfs_jBu9uUnv, etc.Refers to dropdown.id
nameName of dropdown option in BenchlingCharacter VaryingColor, Analytes, etc.
positionRelative position of dropdown option in the dropdownInteger0, 3, etc.Ranges from 0 to (# options in dropdown - 1)
archived$Archival state for dropdown option in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for dropdown option in BenchlingCharacter Varyingnull, Made in Error, Retired, Other, etcnull = object not archived

--{Folder / Project Tables}--

project

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
urlurl for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP\-Entry%20Namet/etr\_gRogHFOb\-untitled/edit

folder

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object's permissions comes fromForeign key for project.id or registry.idsrc_hh9ffHqVIf an object isn't in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSEtrue = object archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = object not archived
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_folder_idUnique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BP

--{User Tables}--

user

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
handleUnique username chosen by individual usersText"ssiegfried"Handle can be changed at any point to any other unique string of text/integers
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
emailUnique email associated with each user accountEmail"[email protected]"
is_suspendedSuspension status for each userFALSE, TRUEFALSE, TRUETRUE = Suspended user

team_member

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
team_idUnique identifier for the assignee's teamForeign key for team.idteam_oh5xGqrm
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee User Table for more information
roleTeam membership status for an individual userADMIN, MEMBERADMIN, MEMBER

team

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
descriptionDescription given to objectText"Fermentation Workflow"

Updated 2 months ago

Warehouse Table Columns


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.