id | Unique Benchling-prescribed ID for each line item in table | Character Varying | pcr_oPQS40h3 | Primary key for a table |
source_id | The id of the project that the object's permissions comes from | Foreign key for project.id | src_hh9ffHqV | |
schema_id | Unique identifier for schema containing object | Foreign key for schema.id | ts_IOGwR6u4 | |
field_defiintion_id | Unique id of field definition for object in table | Foreign key for field_definition.id | schema_field_42365 | See field_definition Table |
field_name | Display name for field on schema | Text | "Date Sequenced" | |
batch_id | Unique identifier for batch object | Foreign key for batch.id | bat_Gs8PtV0K | What batch is in the container |
box_id | Unique identifier for box object | Foreign key for box.id | box_oz4ZE0MN | |
container_id | Unique identifier for container object | Foreign key for container.id | con_gQMDFBm4 | |
entry_id | Unique identifier for Entry | Foreign key for entry.id | etr_GtcscEZq | See Entry Table for more information |
location_id | Unique identifier for location that contains object | Foreign key for location.id | loc_Y2v8daz0 | |
plate_id | Unique identifier for plate object | Foreign key for plate.id | plt_K9VZG06I | |
registry_entity_id | Unique identifier of any registered entity | Foreign key for registry_entity.id | bfi_cooUBrYb | |
request_id | Unique identifier for the request | Foreign key for request.id | req_qPtu1MSo | |
run_id | Unique identifier for the Run | Foreign key for assay_run.id | multi_a11d82b2-8df3-44ae-bb2e-89086c8b69a4_file | |
display_value | Text value of identified field | Text | "Amp" | |
blob_value | Blob link value in JSON format of identified field | JSON value | {id, name, url} | Attached file can be found in Benchling |
float_value | Floating point value of identified field | Floating Point | 2, 4.56, 4334.6493, etc | |
date_value | Date format value of identified field | Datetime | 1/8/20 | |
datetime_value | Date format with timestamp value of identified field | Timestamp with timezone | 2019-12-05T19:15:00 | |
integer_value | Integer value of identified field | Integer | 2019-12-05T19:15:00 | |
json_value | Integer value of identified field | JSON Value | | |
linked_batch_id | Unique identifier of any batch the field object is linked to | Foreign key for batch.id | bat_Gs8PtV0 | |
linked_box_id | Unique identifier of any box the field object is linked to | Foreign key for box.id | box_oz4ZE0MN | |
linked_container_id | Unique identifier of any container the field object is linked to | Foreign key for container.id | con_gQMDFBm4 | |
linked_entry_id | Unique identifier of any entry the field object is linked to | Foreign key for entry.id | etr_GtcscEZq | |
linked_location_id | Unique identifier of any location the field object is linked to | Foreign key for location.id | loc_Y2v8daz0 | |
linked_plate_id | Unique identifier of any plate the field object is linked to | Foreign key for plate.id | plt_S5ALalNc | |
linked_result_id | Unique identifier of any result the field object is linked to | Foreign key for result.id | 6498dd5a-1b4b-4954-826f-bfcfd1496373 | |
linked_run_id | Unique identifier of any Run the field object is linked to | Foreign key for run.id | 343494f6-e633-4523-9aa6-26898c99f482 | |
linked_registry_entity_id | Unique identifier of any registered entity the field object is linked to | Foreign key for registry_entity.id | bfi_cooUBrYb | |
value_index | The position number of a given value for a field that supports multiple values | Integer(or null) | null, 1, 2, 6, etc | "null" = Not Multiselect. 1,2,3,4, etc = Position of multi-select field. |