# CollectionItems ## Documentation The staged items of every CMS collection, drafts included, with their field data as JSON. A collection table in the schema Collections has a column per field and can be written. 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 `CollectionItems` 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: kept, but not published. | | `is_draft` | `char` | | ☐ | Whether the item is a draft, left out of the next publication. An item created through this driver is a draft unless is_draft is set to false. | | `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 |