> 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 Entry Tables ## Notebook Entry Tables ### `entry` | 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 | | archive\_purpose\$ | Archival reason for object in Benchling | Text | null, Made in Error, Retired, Other, etc | null = object not archived | | archived\$ | Archival state for object in Benchling | Boolean | TRUE, FALSE | true = object 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 | Name of object in Benchling | Character Varying | Transfection Entry, QC Results, Therapeutic Cell Line, etc | | | 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 | | workflow\_id | Unique identifier for workflow containing object | Foreign key for workflow\.id | wfw\_DMcZhu4A | | | schema\_id | Unique identifier for schema containing object | Foreign key for [schema](/docs/wh-registry#entity_schema).id | ts\_IOGwR6u4 | | | entry\_template\_id | Unique identifier for entry template containing object | Foreign key for entry\_template.id | tmpl\_RlsGq4ng | | | entry\_template\_version\_id | Unique identifier for entry template version containing object | Foreign key for entry\_template\_version.id | tmplver\_LKfYYNbv | | | review\_status | Current review status for object | null, NEEDS\_REVIEW, REJECTED, RETRACTED, ACCEPTED, ACCEPTANCE\_SNAPSHOT\_IN\_PROGRESS, REVIEW\_SNAPSHOT\_IN\_PROGRESS | null, NEEDS\_REVIEW, REJECTED, RETRACTED, ACCEPTED, ACCEPTANCE\_SNAPSHOT\_IN\_PROGRESS, REVIEW\_SNAPSHOT\_IN\_PROGRESS | null = entry not sent for review; REJECTED includes entries requiring revision; snapshot statuses are transient (only visible when blocking snapshot feature flags are enabled) | | review\_requested\_at | Date of most recent review requested for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | NOTE: we prefer using `requested_at` on the [review](/docs/wh-notebook-review-tables#bnchreviewalpha) warehouse table | | review\_completed\_at | Date when the review was completed | Timestamp without timezone | 2019-12-06T23:24:44.885478 | NOTE: we prefer using `completed_at` on the [review](/docs/wh-notebook-review-tables#bnchreviewalpha) warehouse table | | review\_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. NOTE: we prefer using `initial_requested_at` on the [review](/docs/wh-notebook-review-tables#bnchreviewalpha) warehouse table | | review\_status\_changed\_at | Date of review status change for object | Timestamp without timezone | 2019-12-06T23:24:44.885478 | NOTE: we prefer using `review_status_changed_at` on the [review](/docs/wh-notebook-review-tables#bnchreviewalpha) warehouse table | | 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 | | | url | URL for each object in Benchling | Browser URL | [https://demo.benchling.com/#biotech-org/f/lib\_J3tmt8BP-Entry%20Namet/etr\_gRogHFOb-untitled/edit](https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit) | | ### `entry_auditor` \[#entry\_auditor] | 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 | | user\_id | Unique identifier for user | Foreign key for [user](/docs/wh-users-teams-projects#user).id | ent\_yXrL3BjX | See User Table for more information | | entry\_id | Unique identifier for Entry | Foreign key for [entry](/docs/wh-notebook-entries#entry).id | etr\_GtcscEZq | See Entry Table for more information | | review\_process\_stage\_id | Unique identifier for review process stage | Foreign key for [review\_process\_stage](/docs/wh-notebook-review-tables#review_process_stage).id | rlcstg\_ZjNgNXks | | | review\_status | The status for the review | String status | ACCEPTED, NEEDS\_REVIEW, REJECTED, RETRACTED, etc. | | | 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 | ### `entry_template` \[#entry\_template] | 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 | tmpl\_RlsGq4ng, 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 | Template permissions are derived from the template collection's ownership | | archive\_purpose\$ | Archival reason for object in Benchling | Text | null, Made in Error, Retired, Other, etc | null = object not archived | | archived\$ | Archival state for object in Benchling | Boolean | TRUE, FALSE | true = object 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 | Name of the entry template | Character Varying | Western Blot Template, PCR Protocol | | | schema\_id | Unique identifier for schema | Foreign key for [schema](/docs/wh-registry#entity_schema).id | ts\_IOGwR6u4 | Can be null if template is not schema-based | ### `author` | 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 | | user\_id | Unique identifier for user | Foreign key for [principal](/docs/wh-users-teams-projects#principal).id | ent\_yXrL3BjX | See User Table for more information | | entry\_id | Unique identifier for Entry | Foreign key for [entry](/docs/wh-notebook-entries#entry).id | etr\_GtcscEZq | If entry has multiple authors there will be multiple rows per entry\_id. See Entry Table for more information |