Skip to navigation

Users, Teams and Projects

Reference for the Benchling warehouse tables covering users, teams, and projects, including the available tables, key fields, and the relationships between them.

Table Overview

Name$raw FiltersDescription
userNoneLists all users
principalNoneLists all users + Apps
teamNoneLists all teams
team_memberNoneLists all members of teams
projectarchived$ column is not TrueLists all projects
folderarchived$ column is not TrueLists all folders

user

Table RowDefinitionValue TypeExample Values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
handleUnique username chosen by individual usersText”ssiegfried”Handle can be changed at any point to any other unique string of text/integers
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
emailUnique email associated with each user accountEmail”user@example.com”
is_suspendedSuspension status for each userBooleanTRUE, FALSETRUE = Suspended user
created_atCreated date for userTimestamp without timezone2019-12-06 23:24:45

principal

Table RowDefinitionValue TypeExample Values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
handleUnique username chosen by individual usersText”ssiegfried”Handle can be changed at any point to any other unique string of text/integers
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
emailUnique email associated with each user accountEmail”user@example.com”
is_suspendedSuspension status for each userBooleanTRUETRUE = Suspended user
created_atCreated date for userTimestamp without timezone2019-12-06 23:24:45

team

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table. Referred to as team_id when used as a foreign key.
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
descriptionDescription given to objectText”Fermentation Workflow”

team_member

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
team_idUnique identifier for the assignee’s teamForeign key for team.idteam_oh5xGqrm
user_idUnique identifier for userForeign key for user.ident_yXrL3BjXSee user table for more information
roleTeam membership status for an individual userADMIN, MEMBERADMIN, MEMBER

project

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object’s permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn’t in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSETRUE = folder is archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = folder is not archived
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
urlURL for each object in BenchlingBrowser URLhttps://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit

folder

Table RowDefinitionValue TypeExample values (if applicable)Notes
idUnique Benchling-prescribed ID for each line item in tableFormat dependent on tableent_yXrL3BjX, etr_GtcscEZq, loc_Y2v8daz0, etcPrimary key for a table
source_idThe project or registry that the object’s permissions comes fromForeign key for project.id or registry IDsrc_hh9ffHqVIf an object isn’t in a project, the permissions will be derived from the Registry
archived$Archival state for object in BenchlingBooleanTRUE, FALSETRUE = folder is archived
archive_purpose$Archival reason for object in BenchlingTextnull, Made in Error, Retired, Other, etcnull = folder is not archived
created_atCreated date for objectTimestamp without timezone2019-12-06T23:24:44.885478
modified_atMost recent modified date for objectTimestamp without timezone2019-12-06T23:24:44.885478
nameName of object in BenchlingCharacter VaryingTransfection Entry, QC Results, Therapeutic Cell Line, etc
parent_folder_idUnique identifier for folder containing objectForeign key for folder.idlib_J3tmt8BP