# Sites
## Documentation
The sites the token may see: one for a site token, the sites chosen at authorisation for OAuth. Every site is a partition.
- Catalog: `Webflow`
- Schema: `Sites`
- Primary Keys: `id`
This is a read-only table. The Webflow API may not support changing the data or the Invantive UniversalSQL driver for Webflow does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Webflow API.
## Table Columns
The columns of the table `Sites` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `created_on` | `datetime` | | ☐ | When the site was created, UTC. |
| `data_collection_enabled` | `char` | | ☐ | Whether Webflow collects visitor data for analytics on the site. |
| `data_collection_type` | `varchar2` | | ☐ | always, optOut or disabled. |
| `display_name` | `varchar2` | | ☑ | The name of the site. |
| `full_site_compiled_at` | `datetime` | | ☐ | When the whole site was last compiled, UTC. |
| `id` | `varchar2` | | ☑ | The id of the site. |
| `last_published` | `datetime` | | ☐ | When the site was last published, UTC; null when never. |
| `last_updated` | `datetime` | | ☐ | When the site was last changed, UTC. |
| `parent_folder_id` | `varchar2` | | ☐ | The folder of the workspace the site is in; null at the top. |
| `preview_url` | `varchar2` | | ☐ | The URL of a preview image of the site. |
| `short_name` | `varchar2` | | ☐ | The name of the site as used in its webflow.io address. |
| `time_zone` | `varchar2` | | ☐ | The time zone of the site, as an IANA name such as Europe/Amsterdam. |
| `workspace_id` | `varchar2` | | ☐ | The workspace the site belongs to. |
## Referenced By
The columns of these tables refer to a row of this table.
| Table | Columns | Guarantee |
|---|---|---|
| [[Assets-AssetFolders\|Assets.AssetFolders]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Assets-Assets\|Assets.Assets]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Cms-Collections\|Cms.Collections]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Forms-FormSubmissions\|Forms.FormSubmissions]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Forms-Forms\|Forms.Forms]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Pages-Pages\|Pages.Pages]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Sites-CustomDomains\|Sites.CustomDomains]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Sites-SiteLocales\|Sites.SiteLocales]] | `site_id` | Declared by the connector, not enforced by the platform |
| [[Sites-Webhooks\|Sites.Webhooks]] | `site_id` | Declared by the connector, not enforced by the platform |