# Favorites ## Documentation The items the user marked as favourite. - Catalog: `Smartsheet` - Schema: `Platform` - Primary Keys: `type, object_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `Favorites` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `object_id` | `int64` | | ☑ | The id of the item. | | `type` | `varchar2` | | ☑ | What the favourite is: folder, report, sheet, sight, template or workspace. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `object_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | In words only: A sheet when type is sheet. | | `object_id` | [[Reports-Reports\|Reports.Reports]] | `report_id` | In words only: A report when type is report. | | `object_id` | [[Reports-Dashboards\|Reports.Dashboards]] | `dashboard_id` | In words only: A dashboard when type is sight. | | `object_id` | [[Workspaces-Folders\|Workspaces.Folders]] | `folder_id` | In words only: A folder when type is folder. | | `object_id` | [[Workspaces-Workspaces\|Workspaces.Workspaces]] | `workspace_id` | In words only: A workspace when type is workspace. | | `object_id` | [[Platform-Templates\|Platform.Templates]] | `template_id` | In words only: A template when type is template. |