---
title: "Crisp Data Model"
description: "Crisp is online software for customer experience, including multi-channel chat, CRM, knowledge base and email campaigns."
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/crisp
original: https://documentation.invantive.eu/en/datamodels/crisp
updated: 2026-11-16T20:44:16Z
license: https://documentation.invantive.eu/fr/
---

# Crisp Data Model

Crisp est un logiciel en ligne dédié à l'expérience client, qui comprend un service de chat multicanal, un CRM, une base de connaissances et des campagnes par e-mail.

https://crisp.com/docs

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/crisp

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

## Plate-forme

- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: [https://status.crisp.chat/](https://status.crisp.chat/).

## Chiffres

| Figure | Count |
|---|---:|
| Tables | 135 |
| Columns | 1,162 |
| Tableaux avec insert | 5 |
| Tables avec mise à jour | 0 |
| Tables avec la clause DELETE | 0 |
| Tableaux documentés | 69 |

## Tableaux

### Crisp.Crisp

- [ActiveOperatorsByWebsiteId](Crisp.Crisp.ActiveOperatorsByWebsiteId): Active Operators
- [CampaignTemplatesByWebsiteId](Crisp.Crisp.CampaignTemplatesByWebsiteId): Campaign Templates
- [ConversationByWebsiteIdAndSessionId](Crisp.Crisp.ConversationByWebsiteIdAndSessionId): Conversation Data
- [ConversationDeviceCapabilitiesByWebsiteId](Crisp.Crisp.ConversationDeviceCapabilitiesByWebsiteId): Conversation Device Capabilities
- [ConversationDeviceLocalesByWebsiteId](Crisp.Crisp.ConversationDeviceLocalesByWebsiteId): Conversation Device Locales
- [ConversationEventsByWebsiteIdAndSessionId](Crisp.Crisp.ConversationEventsByWebsiteIdAndSessionId): Conversation Events
- [ConversationFilesByWebsiteIdAndSessionId](Crisp.Crisp.ConversationFilesByWebsiteIdAndSessionId): Conversation Files
- [ConversationMentionsByWebsiteId](Crisp.Crisp.ConversationMentionsByWebsiteId): Conversation Mentions
- [ConversationMessageMentionsByWebsiteIdAndSessionId](Crisp.Crisp.ConversationMessageMentionsByWebsiteIdAndSessionId): Conversation Message Mentions
- [ConversationMessagesByWebsiteIdAndSessionId](Crisp.Crisp.ConversationMessagesByWebsiteIdAndSessionId): Conversation Messages
- [ConversationPagesByWebsiteIdAndSessionId](Crisp.Crisp.ConversationPagesByWebsiteIdAndSessionId): Conversation Pages
- [ConversationParticipantsByWebsiteId](Crisp.Crisp.ConversationParticipantsByWebsiteId): Conversation Participants
- [ConversationRelatedChildrenByWebsiteIdAndSessionId](Crisp.Crisp.ConversationRelatedChildrenByWebsiteIdAndSessionId): Conversation Related Children
- [ConversationRelationsByWebsiteIdAndSessionId](Crisp.Crisp.ConversationRelationsByWebsiteIdAndSessionId): Conversation Relations
- [ConversationSegmentsByWebsiteId](Crisp.Crisp.ConversationSegmentsByWebsiteId): Conversation Segments
- [ConversationSuggestedDataKeysByWebsiteId](Crisp.Crisp.ConversationSuggestedDataKeysByWebsiteId): Conversation Suggested Data Keys
- [ConversationSuggestedSegmentsByWebsiteId](Crisp.Crisp.ConversationSuggestedSegmentsByWebsiteId): Conversation Suggested Segments
- [ConversationVerificationsByWebsiteId](Crisp.Crisp.ConversationVerificationsByWebsiteId): Conversation Verifications
- [ConversationsByWebsiteId](Crisp.Crisp.ConversationsByWebsiteId): Conversations
- [HelpdeskArticleByWebsiteIdAndLocaleAndArticleId](Crisp.Crisp.HelpdeskArticleByWebsiteIdAndLocaleAndArticleId): Helpdesk Article
- [HelpdeskArticlesByWebsiteIdAndLocale](Crisp.Crisp.HelpdeskArticlesByWebsiteIdAndLocale): Helpdesk Articles
- [HelpdeskByWebsiteId](Crisp.Crisp.HelpdeskByWebsiteId): Helpdesk
- [HelpdeskCategoriesByWebsiteIdAndLocale](Crisp.Crisp.HelpdeskCategoriesByWebsiteIdAndLocale): Helpdesk Categories
- [HelpdeskFeedbackRatingsByWebsiteIdAndLocale](Crisp.Crisp.HelpdeskFeedbackRatingsByWebsiteIdAndLocale): Helpdesk Feedback Ratings
- [HelpdeskFeedbacksByWebsiteIdAndLocale](Crisp.Crisp.HelpdeskFeedbacksByWebsiteIdAndLocale): Helpdesk Feedbacks
- [HelpdeskLocalesByWebsiteId](Crisp.Crisp.HelpdeskLocalesByWebsiteId): Helpdesk Locales
- [HelpdeskRedirectionsByWebsiteId](Crisp.Crisp.HelpdeskRedirectionsByWebsiteId): Helpdesk Redirections
- [HelpdeskSectionsByWebsiteIdAndLocaleAndCategoryId](Crisp.Crisp.HelpdeskSectionsByWebsiteIdAndLocaleAndCategoryId): Helpdesk Sections
- [HelpdeskSettingsByWebsiteId](Crisp.Crisp.HelpdeskSettingsByWebsiteId): Helpdesk Settings
- [InboxConditionQueriesByWebsiteId](Crisp.Crisp.InboxConditionQueriesByWebsiteId): Inbox Condition Queries
- [InboxConditionsByWebsiteId](Crisp.Crisp.InboxConditionsByWebsiteId): Inbox Conditions
- [InboxOperatorsByWebsiteId](Crisp.Crisp.InboxOperatorsByWebsiteId): Inbox Operators
- [InboxTeamOperatorsByWebsiteId](Crisp.Crisp.InboxTeamOperatorsByWebsiteId): Inbox Team Operators
- [InboxTeamsByWebsiteId](Crisp.Crisp.InboxTeamsByWebsiteId): Inbox Teams
- [InboxesByWebsiteId](Crisp.Crisp.InboxesByWebsiteId): Inboxes
- [OperatorAvailabilitiesByWebsiteId](Crisp.Crisp.OperatorAvailabilitiesByWebsiteId): Operator Availabilities
- [OperatorByWebsiteIdAndUserId](Crisp.Crisp.OperatorByWebsiteIdAndUserId): Operator
- [OperatorsByWebsiteId](Crisp.Crisp.OperatorsByWebsiteId): Operators
- [PeopleCompanyEmailsByWebsiteId](Crisp.Crisp.PeopleCompanyEmailsByWebsiteId): People Company Emails
- [PeopleCompanyPhonesByWebsiteId](Crisp.Crisp.PeopleCompanyPhonesByWebsiteId): People Company Phones
- [PeopleCompanyTagsByWebsiteId](Crisp.Crisp.PeopleCompanyTagsByWebsiteId): People Company Tags
- [PeopleConversationsByWebsiteIdAndPeopleId](Crisp.Crisp.PeopleConversationsByWebsiteIdAndPeopleId): People Conversations
- [PeopleDataByWebsiteIdAndPeopleId](Crisp.Crisp.PeopleDataByWebsiteIdAndPeopleId): People Data
- [PeopleEventsByWebsiteIdAndPeopleId](Crisp.Crisp.PeopleEventsByWebsiteIdAndPeopleId): People Events
- [PeopleLocalesByWebsiteId](Crisp.Crisp.PeopleLocalesByWebsiteId): People Locales
- [PeopleProfileByWebsiteIdAndPeopleId](Crisp.Crisp.PeopleProfileByWebsiteIdAndPeopleId): People Profile
- [PeopleProfilesByWebsiteId](Crisp.Crisp.PeopleProfilesByWebsiteId): People Profiles
- [PeopleSegmentsByWebsiteId](Crisp.Crisp.PeopleSegmentsByWebsiteId): People Segments
- [PeopleSocialMediaProfilesByWebsiteId](Crisp.Crisp.PeopleSocialMediaProfilesByWebsiteId): People Social Media Profiles
- [PeopleStatisticsByWebsiteId](Crisp.Crisp.PeopleStatisticsByWebsiteId): People Statistics
- [PeopleSubscriptionByWebsiteIdAndPeopleId](Crisp.Crisp.PeopleSubscriptionByWebsiteIdAndPeopleId): People Subscription
- [PeopleSuggestedDataKeysByWebsiteId](Crisp.Crisp.PeopleSuggestedDataKeysByWebsiteId): People Suggested Data Keys
- [PeopleSuggestedEventsByWebsiteId](Crisp.Crisp.PeopleSuggestedEventsByWebsiteId): People Suggested Events
- [PeopleSuggestedSegmentsByWebsiteId](Crisp.Crisp.PeopleSuggestedSegmentsByWebsiteId): People Suggested Segments
- [VerifySettingsByWebsiteId](Crisp.Crisp.VerifySettingsByWebsiteId): Verify Settings
- [VisitorCapabilitiesByWebsiteId](Crisp.Crisp.VisitorCapabilitiesByWebsiteId): Visitor Capabilities
- [VisitorCountsByWebsiteId](Crisp.Crisp.VisitorCountsByWebsiteId): Visitor Counts
- [VisitorLocalesByWebsiteId](Crisp.Crisp.VisitorLocalesByWebsiteId): Visitor Locales
- [VisitorsByWebsiteId](Crisp.Crisp.VisitorsByWebsiteId): Visitors
- [WebsiteAvailabilityStatusById](Crisp.Crisp.WebsiteAvailabilityStatusById): Website Availability Status
- [WebsiteById](Crisp.Crisp.WebsiteById): Website
- [WebsiteSettingsById](Crisp.Crisp.WebsiteSettingsById): Website Settings
- [WebsiteSettingsChatboxAllowedPagesById](Crisp.Crisp.WebsiteSettingsChatboxAllowedPagesById): Website Settings Chatbox Allowed Pages
- [WebsiteSettingsChatboxBlockedCountriesById](Crisp.Crisp.WebsiteSettingsChatboxBlockedCountriesById): Website Settings Chatbox Blocked Countries
- [WebsiteSettingsChatboxBlockedIpAddressesById](Crisp.Crisp.WebsiteSettingsChatboxBlockedIpAddressesById): Website Settings Chatbox Blocked IP Addresses
- [WebsiteSettingsChatboxBlockedLocalesById](Crisp.Crisp.WebsiteSettingsChatboxBlockedLocalesById): Website Settings Chatbox Blocked Locales
- [WebsiteSettingsChatboxBlockedPagesById](Crisp.Crisp.WebsiteSettingsChatboxBlockedPagesById): Website Settings Chatbox Blocked Pages
- [WebsiteSettingsDomainAlternatesById](Crisp.Crisp.WebsiteSettingsDomainAlternatesById): Website Settings Domain Alternates

### Crisp.Native

- [NATIVEPLATFORMSCALARREQUESTS](Crisp.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Crisp.Views

- [ActiveOperators](Crisp.Views.ActiveOperators): Active Operators
- [CampaignTemplates](Crisp.Views.CampaignTemplates): Campaign Templates
- [ConversationDeviceCapabilities](Crisp.Views.ConversationDeviceCapabilities): Conversation Device Capabilities
- [ConversationDeviceLocales](Crisp.Views.ConversationDeviceLocales): Conversation Device Locales
- [ConversationEvents](Crisp.Views.ConversationEvents): Conversation Events
- [ConversationFiles](Crisp.Views.ConversationFiles): Conversation Files
- [ConversationMentions](Crisp.Views.ConversationMentions): Conversation Mentions
- [ConversationMessageMentions](Crisp.Views.ConversationMessageMentions): Conversation Message Mentions
- [ConversationMessages](Crisp.Views.ConversationMessages): Conversation Messages
- [ConversationPages](Crisp.Views.ConversationPages): Conversation Pages
- [ConversationParticipants](Crisp.Views.ConversationParticipants): Conversation Participants
- [ConversationRelatedChildren](Crisp.Views.ConversationRelatedChildren): Conversation Related Children
- [ConversationRelations](Crisp.Views.ConversationRelations): Conversation Relations
- [ConversationSegments](Crisp.Views.ConversationSegments): Conversation Segments
- [ConversationSuggestedDataKeys](Crisp.Views.ConversationSuggestedDataKeys): Conversation Suggested Data Keys
- [ConversationSuggestedSegments](Crisp.Views.ConversationSuggestedSegments): Conversation Suggested Segments
- [ConversationVerifications](Crisp.Views.ConversationVerifications): Conversation Verifications
- [Conversations](Crisp.Views.Conversations): Conversations
- [HelpdeskArticleContents](Crisp.Views.HelpdeskArticleContents): Helpdesk Article Contents
- [HelpdeskArticles](Crisp.Views.HelpdeskArticles): Helpdesk Articles
- [HelpdeskCategories](Crisp.Views.HelpdeskCategories): Helpdesk Categories
- [HelpdeskFeedbackRatings](Crisp.Views.HelpdeskFeedbackRatings): Helpdesk Feedback Ratings
- [HelpdeskFeedbacks](Crisp.Views.HelpdeskFeedbacks): Helpdesk Feedbacks
- [HelpdeskLocales](Crisp.Views.HelpdeskLocales): Helpdesk Locales
- [HelpdeskRedirections](Crisp.Views.HelpdeskRedirections): Helpdesk Redirections
- [HelpdeskSections](Crisp.Views.HelpdeskSections): Helpdesk Sections
- [HelpdeskSettings](Crisp.Views.HelpdeskSettings): Helpdesk Settings
- [Helpdesks](Crisp.Views.Helpdesks): Helpdesks
- [InboxConditionQueries](Crisp.Views.InboxConditionQueries): Inbox Condition Queries
- [InboxConditions](Crisp.Views.InboxConditions): Inbox Conditions
- [InboxOperators](Crisp.Views.InboxOperators): Inbox Operators
- [InboxTeamOperators](Crisp.Views.InboxTeamOperators): Inbox Team Operators
- [InboxTeams](Crisp.Views.InboxTeams): Inbox Teams
- [Inboxes](Crisp.Views.Inboxes): Inboxes
- [OperatorAvailabilities](Crisp.Views.OperatorAvailabilities): Operator Availabilities
- [Operators](Crisp.Views.Operators): Operators
- [PeopleCompanyEmails](Crisp.Views.PeopleCompanyEmails): People Company Emails
- [PeopleCompanyPhones](Crisp.Views.PeopleCompanyPhones): People Company Phones
- [PeopleCompanyTags](Crisp.Views.PeopleCompanyTags): People Company Tags
- [PeopleConversations](Crisp.Views.PeopleConversations): People Conversations
- [PeopleData](Crisp.Views.PeopleData): People Data
- [PeopleEvents](Crisp.Views.PeopleEvents): People Events
- [PeopleLocales](Crisp.Views.PeopleLocales): People Locales
- [PeopleProfiles](Crisp.Views.PeopleProfiles): People Profiles
- [PeopleSegments](Crisp.Views.PeopleSegments): People Segments
- [PeopleSocialMediaProfiles](Crisp.Views.PeopleSocialMediaProfiles): People Social Media Profiles
- [PeopleStatistics](Crisp.Views.PeopleStatistics): People Statistics
- [PeopleSubscriptions](Crisp.Views.PeopleSubscriptions): People Subscriptions
- [PeopleSuggestedDataKeys](Crisp.Views.PeopleSuggestedDataKeys): People Suggested Data Keys
- [PeopleSuggestedEvents](Crisp.Views.PeopleSuggestedEvents): People Suggested Events
- [PeopleSuggestedSegments](Crisp.Views.PeopleSuggestedSegments): People Suggested Segments
- [VerifySettings](Crisp.Views.VerifySettings): Verify Settings
- [VisitorCapabilities](Crisp.Views.VisitorCapabilities): Visitor Capabilities
- [VisitorCounts](Crisp.Views.VisitorCounts): Visitor Counts
- [VisitorLocales](Crisp.Views.VisitorLocales): Visitor Locales
- [Visitors](Crisp.Views.Visitors): Visitors
- [WebsiteAvailabilityStatus](Crisp.Views.WebsiteAvailabilityStatus): Website Availability Status
- [WebsiteIds](Crisp.Views.WebsiteIds): Website IDs
- [WebsiteSettings](Crisp.Views.WebsiteSettings): Website Settings
- [WebsiteSettingsChatboxAllowedPages](Crisp.Views.WebsiteSettingsChatboxAllowedPages): Website Settings Chatbox Allowed Pages
- [WebsiteSettingsChatboxBlockedCountries](Crisp.Views.WebsiteSettingsChatboxBlockedCountries): Website Settings Chatbox Blocked Countries
- [WebsiteSettingsChatboxBlockedIpAddresses](Crisp.Views.WebsiteSettingsChatboxBlockedIpAddresses): Website Settings Chatbox Blocked IP Addresses
- [WebsiteSettingsChatboxBlockedLocales](Crisp.Views.WebsiteSettingsChatboxBlockedLocales): Website Settings Chatbox Blocked Locales
- [WebsiteSettingsChatboxBlockedPages](Crisp.Views.WebsiteSettingsChatboxBlockedPages): Website Settings Chatbox Blocked Pages
- [WebsiteSettingsDomainAlternates](Crisp.Views.WebsiteSettingsDomainAlternates): Website Settings Domain Alternates
- [Websites](Crisp.Views.Websites): Websites

## Exemples de Queries

```sql
--
-- List the people profiles of the website.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/crisp-data-model/webhelp/crisp-connector-crisp-people-profiles.html
--
select *
from   Crisp.Crisp.PeopleProfiles
limit  100
```

## Attributs

The attributes of this platform are on the page [Attributes](attributes).


## Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :

- [Crisp](/fr/release-notes/drivers?driver=crisp)
