# LiveCollectionItems ## Documentation The published items of every CMS collection, as visitors see them, with their field data as JSON. A collection table in the schema LiveCollections has a column per field instead. Primary locale only, unless filtered on cms_locale_id. - Catalog: `Webflow` - Schema: `Cms` - Primary Keys: `collection_id, id, cms_locale_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 `LiveCollectionItems` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cms_locale_id` | `varchar2` | | ☐ | The locale of this version of the item; see SiteLocales. | | `collection_id` | `varchar2` | | ☑ | The collection. | | `created_on` | `datetime` | | ☐ | When the item was created, UTC. | | `field_data_json` | `varchar2` | | ☐ | Every field of the item as JSON, keyed on the slug of the field. | | `id` | `varchar2` | | ☑ | The id of the item; the same in every locale of the item. | | `is_archived` | `char` | | ☐ | Whether the item is archived. | | `is_draft` | `char` | | ☐ | Whether the item has staged changes not yet published. | | `last_published` | `datetime` | | ☐ | When the item was last published, UTC; null when never. | | `last_updated` | `datetime` | | ☐ | When the item was last changed, UTC. | | `name` | `varchar2` | | ☐ | The name of the item, its field name. | | `site_id` | `varchar2` | | ☑ | The site. | | `slug` | `varchar2` | | ☐ | The slug of the item in its address, its field slug. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `collection_id` | [[Cms-Collections\|Cms.Collections]] | `id` | Declared by the connector, not enforced by the platform |