# Collections ## Documentation The CMS collections of the sites. Each one is also a table of its own in the schemas Collections and LiveCollections. An insert creates an empty collection with its name and slug fields; a delete removes the collection and every item in it. - Catalog: `Webflow` - Schema: `Cms` - Primary Keys: `id` - Retrieve: True - Insert: True - Update: False - Delete: True ## Table Columns The columns of the table `Collections` 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_on` | `datetime` | | ☐ | When the collection was created, UTC. | | `display_name` | `varchar2` | | ☑ | The name of the collection, such as Blog Posts. | | `id` | `varchar2` | | ☑ | The id of the collection. | | `last_updated` | `datetime` | | ☐ | When the collection was last changed, UTC. | | `singular_name` | `varchar2` | | ☐ | The name of one item, such as Blog Post. | | `site_id` | `varchar2` | | ☑ | The site. | | `slug` | `varchar2` | | ☐ | The slug of the collection in the addresses of its items; also the name of its table. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `site_id` | [[Sites-Sites\|Sites.Sites]] | `id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Cms-CollectionFields\|Cms.CollectionFields]] | `collection_id` | Declared by the connector, not enforced by the platform | | [[Cms-CollectionItems\|Cms.CollectionItems]] | `collection_id` | Declared by the connector, not enforced by the platform | | [[Cms-LiveCollectionItems\|Cms.LiveCollectionItems]] | `collection_id` | Declared by the connector, not enforced by the platform | | [[Collections-InvantiveTestPosts\|Collections.InvantiveTestPosts]] | `collection_id` | Declared by the connector, not enforced by the platform | | [[LiveCollections-InvantiveTestPosts\|LiveCollections.InvantiveTestPosts]] | `collection_id` | Declared by the connector, not enforced by the platform | | [[Pages-Pages\|Pages.Pages]] | `collection_id` | Declared by the connector, not enforced by the platform |