> This page is for Developer Documentation.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.benchling.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.benchling.com/_mcp/server.

# Notebook Worksheet Tables

## Notebook Worksheet Tables

### `bnch$creation_context$beta` \[#bnchcreation\_contextbeta]

| 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](/docs/wh-users-teams-projects#project).id or registry ID                                       | src\_hh9ffHqV                                    | If an object isn't in a project, the permissions will be derived from the Registry |
| created\_object\_id                | Unique identifier for the created object                                                                                         | Foreign key for any type of object that can have a creation context                                                      | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| entry\_id                          | Unique identifier for the notebook entry that the object was created in                                                          | Foreign key for [entry](/docs/wh-notebook-entries#entry).id                                                              | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| worksheet\_id                      | Unique identifier for the worksheet that the object was created in                                                               | Foreign key for worksheet.id                                                                                             | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| procedure\_step\_execution\_id     | Unique identifier for the the associated procedure step execution instance for the worksheet step that the object was created in | Foreign key for [procedure\_step\_execution\_instance](/docs/wh-procedures#bnchprocedure_step_execution_instancebeta).id | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| parameter\_measured\_value\_id     | Unique identifier for the created procedure parameter measured value                                                             | Foreign key for [parameter\_measured\_value](/docs/wh-procedures#bnchparameter_measured_valuebeta).id                    | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| parameter\_confirmation\_value\_id | Unique identifier for the created procedure parameter confirmation value                                                         | Foreign key for [parameter\_confirmation\_value](/docs/wh-procedures#bnchparameter_confirmation_valuebeta).id            | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| parameter\_planned\_value\_id      | Unique identifier for the created procedure parameter planned value                                                              | Foreign key for [parameter\_planned\_value](/docs/wh-procedures#bnchparameter_planned_valuebeta).id                      | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| run\_id                            | Unique identifier for the created Connect Run                                                                                    | Character varying                                                                                                        | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| result\_id                         | Unique identifier for the created result                                                                                         | Foreign key for [result](/docs/wh-results-runs#result).id                                                                | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| entity\_id                         | Unique identifier for the created entity                                                                                         | Foreign key for [entity](/docs/wh-registry#entity).id                                                                    | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| box\_id                            | Unique identifier for the created box                                                                                            | Foreign key for [box](/docs/wh-inventory#box).id                                                                         | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| plate\_id                          | Unique identifier for the created plate                                                                                          | Foreign key for [plate](/docs/wh-inventory#plate).id                                                                     | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |
| container\_id                      | Unique identifier for the created container                                                                                      | Foreign key for [container](/docs/wh-inventory#container).id                                                             | ent\_yXrL3BjX, etr\_GtcscEZq, loc\_Y2v8daz0, etc |                                                                                    |

### `bnch$worksheet$alpha`

| 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                                                          | wks\_gLZqJzcl, etc                                                | Primary key for a table                                                                           |
| source\_id         | The project or registry that the object's permissions comes from | Foreign key for [project](/docs/wh-users-teams-projects#project).id or registry ID | src\_hh9ffHqV                                                     | If an object isn't in a project, the permissions will be derived from the Registry                |
| archived\$         | Archival state for object in Benchling                           | Boolean                                                                            | TRUE, FALSE                                                       | true = object archived                                                                            |
| archive\_purpose\$ | Archival reason for object in Benchling                          | Text                                                                               | null, Made in Error, Retired, Other, etc                          | null = object not archived                                                                        |
| creator\_id        | Unique identifier for creator of object                          | Foreign key for [principal](/docs/wh-users-teams-projects#principal).id            | ent\_yXrL3BjX                                                     |                                                                                                   |
| created\_at        | Created date for object                                          | Timestamp without timezone                                                         | 2019-12-06T23:24:44.885478                                        |                                                                                                   |
| modified\_at       | Most recent modified date for object                             | Timestamp without timezone                                                         | 2019-12-06T23:24:44.885478                                        |                                                                                                   |
| name               | String name of the worksheet                                     | String                                                                             | Condition 1 - Replicate 1 - my method 433130470 - Worksheet Study |                                                                                                   |
| display\_id        | Unique identifier surfaced in the actual Benchling site          | Prefix-unique entry number                                                         | EXP001 or EXP20000416                                             | Unique Entry number                                                                               |
| folder\_id         | Unique identifier for folder containing object                   | Foreign key for [folder](/docs/wh-users-teams-projects#folder).id                  | lib\_J3tmt8BP                                                     | If object not in folder, then folder\_id = project\_id.If null, then object not in folder/project |

**Note on Worksheet Review Data:**

Unlike the `entry` table, the `bnch$worksheet$alpha` table does **not** contain embedded review fields. To access worksheet review information, you must join with the `bnch$review$alpha` table:

```sql
SELECT
    w.id,
    w.name,
    w.display_id,
    r.review_status,
    r.initiator_id,
    r.requested_at,
    r.completed_at,
    r.initial_requested_at,
    r.review_status_changed_at,
    r.review_process_id
FROM bnch$worksheet$alpha w
LEFT JOIN bnch$review$alpha r ON r.reviewable_id = w.id
WHERE w.archived$ = FALSE
```

## Example Queries

For some example queries using notebook warehouse tables, see [Joins](/docs/warehouse-tables#joins).