# InvantiveTestPosts: Webflow Invantive Test Posts ## Documentation The staged items of the CMS collection Invantive Test Posts, drafts included, with a column per field. A write here does not change the public site until the items are published, with the procedure publish_items of the package webflow or by publishing the site. Primary locale only, unless filtered on cms_locale_id. - Catalog: `Webflow` - Schema: `Collections` - Primary Keys: `id` - Label: Invantive Test Posts Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `InvantiveTestPosts` 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 | |---|:---:|---|:---:|---| | `body` | `varchar2` | Body | ☐ | The field Body (RichText). HTML. | | `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. | | `featured` | `char` | Featured | ☐ | The field Featured (Switch). | | `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` | Name | ☐ | The field Name (PlainText). | | `price` | `int64` | Price | ☐ | The field Price (Number). Whole numbers only. | | `published_at` | `datetime` | Published At | ☐ | The field Published At (DateTime). UTC. | | `site_id` | `varchar2` | | ☑ | The site. | | `slug` | `varchar2` | Slug | ☐ | The field Slug (PlainText). | | `summary` | `varchar2` | Summary | ☐ | The field Summary (PlainText). | | `website` | `varchar2` | Website | ☐ | The field Website (Link). | ## 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 |