# Workspaces ## Documentation The workspaces: shared areas which hold folders, sheets, reports and dashboards for a team. An insert creates one, an update renames it, a delete removes it with everything in it. - Catalog: `Smartsheet` - Schema: `Workspaces` - Primary Keys: `workspace_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Workspaces` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `access_level` | `varchar2` | | ☐ | What the user may do in the workspace. | | `name` | `varchar2` | | ☑ | The name of the workspace. | | `permalink` | `varchar2` | | ☐ | The link that opens the workspace in Smartsheet. | | `workspace_id` | `int64` | | ☑ | The id of the workspace. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Platform-Favorites\|Platform.Favorites]] | `object_id` | In words only: A workspace when type is workspace. | | [[Workspaces-FolderItems\|Workspaces.FolderItems]] | `workspace_id` | Declared by the connector, not enforced by the platform | | [[Workspaces-Folders\|Workspaces.Folders]] | `workspace_id` | Declared by the connector, not enforced by the platform |