# PeopleSubscriptions: Crisp People Subscriptions - Catalog: `Crisp` - Schema: `Views` - Label: People Subscriptions This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleSubscriptions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `email_subscribed` | `char` | | ☑ | Whether the people profile is subscribed to emails or not. | | `email_subscribed` | `char` | | ☑ | Whether the people profile is subscribed to emails or not. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. |# PeopleSubscriptions: Crisp People Subscriptions - Catalog: `Crisp` - Schema: `Views` - Label: People Subscriptions This is a read-only view. The Crisp API may not support changing the data or the Invantive UniversalSQL driver for Crisp does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Crisp API. ## View Columns The columns of the view `PeopleSubscriptions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `email_subscribed` | `char` | | ☑ | Whether the people profile is subscribed to emails or not. | | `email_subscribed` | `char` | | ☑ | Whether the people profile is subscribed to emails or not. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `email` | `varchar2` | | ☑ | Email for people profile. | | `people_id` | `varchar2` | | ☑ | People identifier. | | `people_id` | `varchar2` | | ☑ | People identifier. |