Deprecated Tables

Table Overview

Name$raw FiltersDescription
fieldarchived$ column in the corresponding field_definition table is not True

field

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableCharacter Varyingpcr_oPQS40h3Primary key for a table
source_idThe id of the project that the object's permissions comes fromForeign key for project.idsrc_hh9ffHqV
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_definition.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 identifier for box objectForeign key for box.idbox_oz4ZE0MN
container_idUnique identifier for container objectForeign key for container.idcon_gQMDFBm4
entry_idUnique identifier for EntryForeign key for entry.idetr_GtcscEZqSee Entry Table for more information
location_idUnique identifier for location that contains objectForeign key for location.idloc_Y2v8daz0
plate_idUnique identifier for plate objectForeign key for plate.idplt_K9VZG06I
registry_entity_idUnique identifier 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 fieldInteger2019-12-05T19:15:00
json_valueInteger value of identified fieldJSON Value
linked_batch_idUnique identifier of any batch the field object is linked toForeign key for batch.idbat_Gs8PtV0
linked_box_idUnique identifier of any box the field object is linked toForeign key for box.idbox_oz4ZE0MN
linked_container_idUnique identifier of any container the field object is linked toForeign key for container.idcon_gQMDFBm4
linked_entry_idUnique identifier of any entry the field object is linked toForeign key for entry.idetr_GtcscEZq
linked_location_idUnique identifier of any location the field object is linked toForeign key for location.idloc_Y2v8daz0
linked_plate_idUnique identifier of any plate the field object is linked toForeign key for plate.idplt_S5ALalNc
linked_result_idUnique identifier of any result the field object is linked toForeign key for result.id6498dd5a-1b4b-4954-826f-bfcfd1496373
linked_run_idUnique identifier of any Run the field object is linked toForeign key for run.id343494f6-e633-4523-9aa6-26898c99f482
linked_registry_entity_idUnique identifier of any registered entity the field object is linked toForeign 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.