# Folders ## Documentation The folders in the workspaces, at every depth. An insert creates one in a workspace or a folder, an update renames it, a delete removes it with everything in it. - Catalog: `Smartsheet` - Schema: `Workspaces` - Primary Keys: `folder_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Folders` 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 | |---|:---:|---|:---:|---| | `depth` | `int32` | | ☐ | 0 at the top of the workspace. | | `folder_id` | `int64` | | ☑ | The id of the folder. | | `name` | `varchar2` | | ☑ | The name of the folder. | | `parent_folder_id` | `int64` | | ☐ | The folder this folder is in; null at the top of the workspace. | | `permalink` | `varchar2` | | ☐ | The link that opens the folder in Smartsheet. | | `workspace_id` | `int64` | | ☐ | The workspace the folder is in. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `parent_folder_id` | [[Workspaces-Folders\|Workspaces.Folders]] | `folder_id` | Declared by the connector, not enforced by the platform | | `workspace_id` | [[Workspaces-Workspaces\|Workspaces.Workspaces]] | `workspace_id` | Declared by the connector, not enforced by the platform | ## 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 folder when type is folder. | | [[Workspaces-FolderItems\|Workspaces.FolderItems]] | `id` | In words only: A folder when resource_type is folder. | | [[Workspaces-FolderItems\|Workspaces.FolderItems]] | `parent_folder_id` | Declared by the connector, not enforced by the platform | | [[Workspaces-Folders\|Workspaces.Folders]] | `parent_folder_id` | Declared by the connector, not enforced by the platform |