# CollectionFields ## Documentation The fields of the CMS collections, one request per collection. A field is a column of the table of its collection, named after its slug. An insert adds a field of a simple type; a delete removes it with its values. - Catalog: `Webflow` - Schema: `Cms` - Primary Keys: `collection_id, field_id` - Retrieve: True - Insert: True - Update: False - Delete: True ## Table Columns The columns of the table `CollectionFields` 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 | |---|:---:|---|:---:|---| | `collection_id` | `varchar2` | | ☑ | The collection. | | `display_name` | `varchar2` | | ☑ | The name of the field in the Designer. | | `field_id` | `varchar2` | | ☑ | The id of the field. | | `help_text` | `varchar2` | | ☐ | The help text shown to an editor. | | `is_editable` | `char` | | ☐ | Whether the value can be changed. | | `is_required` | `char` | | ☐ | Whether an item needs a value. | | `referenced_collection_id` | `varchar2` | | ☐ | For a Reference or MultiReference field: the collection it refers to. | | `site_id` | `varchar2` | | ☑ | The site. | | `slug` | `varchar2` | | ☑ | The slug of the field: its key in the field data, and the name of its column. | | `type` | `varchar2` | | ☑ | The type, such as PlainText, RichText, Number, Switch, DateTime, Image, Option, Reference or MultiReference. | | `validations_json` | `varchar2` | | ☐ | The validations of the field as JSON, such as the maximum length or the options. | ## 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 | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Cms-CollectionFieldOptions\|Cms.CollectionFieldOptions]] | `collection_id`, `field_id` | Declared by the connector, not enforced by the platform |