> 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 Review Tables ## Notebook Review Tables ### `review_process` \[#review\_process] | 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 | | current\_version | Version id of the current (i.e. most up-to-date) review process version | Foreign key for [review\_process\_version](/docs/wh-notebook-review-tables#review_process_version).id | rlc\_6x2onGXv | | ### `review_process_version` \[#review\_process\_version] | 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 | | review\_process\_id | Unique identifier for review process | Foreign key for [review\_process](/docs/wh-notebook-review-tables#review_process).id | rlc\_fSmNiu8i | | | created\_at | Created date for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | | | name | Name of the review processes version | Character Varying | Self Review, Lab Sequential | | | lifecycle\_type | Review process type | Enumeration | `SELF_REVIEW`,`SEQUENTIAL`,`PARALLEL` | | | completion\_stage | Status of a completed review using review process | Character Varying | `ACCEPTED` | | ### `review_process_stage` \[#review\_process\_stage] | 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 | | name | Name of the review process stage | Character Varying | Self review, Stage 1 | | | action | Text appearing in the user-facing label when completing stage | Character Varying | `ACCEPT` | | | review\_process\_version\_id | Unique identifier for version id of review process | Foreign key for [review\_process\_version](/docs/wh-notebook-review-tables#review_process_version).id | rlc\_SN0IwfBx | | ### `project_review_process` \[#project\_review\_process] | 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 | | project\_id | Unique identifier for project | Foreign key for [project](/docs/wh-users-teams-projects#project).id | src\_D44xhOol | | | review\_process\_id | Unique identifier for review process | Foreign key for [review\_process](/docs/wh-notebook-review-tables#review_process).id | rlc\_fSmNiu8i | | ### `bnch$review$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 | rvw\_JkYbw7mj, 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\_at | Created date for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | | | review\_status | The status for the review | String status | null, ACCEPTED, NEEDS\_REVIEW, REJECTED, RETRACTED, ACCEPTANCE\_SNAPSHOT\_IN\_PROGRESS, REVIEW\_SNAPSHOT\_IN\_PROGRESS | null = reviewable not sent for review; REJECTED includes items requiring revision; snapshot statuses are transient (only visible when blocking snapshot feature flags like ELN\_REVIEW\_REQUIRES\_SUCCESSFUL\_SNAPSHOT are enabled) | | review\_process\_id | Unique identifier for review process | Foreign key for [review\_process](/docs/wh-notebook-review-tables#review_process).id | rlc\_fSmNiu8i | | | reviewable\_id | Unique identifier for the reviewable object the review is associated with | Foreign key for [entry](/docs/wh-notebook-entries#entry).id, worksheet.id, study\_design.id | etr\_GtcscEZq, wks\_gLZqJzcl, stdydsgn\_DfDd5D1w | See respective reviewable's Table for more information | | initiator\_id | Unique identifier for userThis represents the User who **initiated** the review (sent for review, self-approved) | Foreign key for [user](/docs/wh-users-teams-projects#user).id | ent\_yXrL3BjX | See User Table for more information | | requested\_at | Date when the review was most recently sent for review | Timestamp without timezone | 2019-12-06T23:24:44.885478 | | | completed\_at | Date when the review was completed | Timestamp without timezone | 2019-12-06T23:24:44.885478 | | | initial\_requested\_at | Date when the review was first sent for review | Timestamp without timezone | 2019-12-06T23:24:44.885478 | Compared to `requested_at`, this captures the first time any reviewable was sent for review | | review\_status\_changed\_at | Date when the review status last changed | Timestamp without timezone | 2019-12-06T23:24:44.885478 | | ### `bnch$reviewer$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 | reviewer\_66, 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 | | user\_id | Unique identifier for user tied to the review/review stage | Foreign key for [user](/docs/wh-users-teams-projects#user).id | ent\_yXrL3BjX | See User Table for more information | | reviewable\_id | Unique identifier for the reviewable object the review is associated with | Foreign key for [entry](/docs/wh-notebook-entries#entry).id, worksheet.id, study\_design.id | etr\_GtcscEZq, wks\_gLZqJzcl, stdydsgn\_DfDd5D1w | See respective reviewable's Table for more information | | reviewer\_status | The status of the reviewer's review | String status | PENDING, FINISHED, REJECTED, BLOCKED | | | review\_process\_stage\_id | Unique identifier for review process stage the reviewer is associated with | Foreign key for [review\_process\_stage](/docs/wh-notebook-review-tables#review_process_stage).id | rlcstg\_ZjNgNXks | | | review\_id | Unique identifier for review | Foreign key for [review](/docs/wh-notebook-review-tables#bnchreviewalpha).id | rvw\_JkYbw7mj | See Review Table for more information |