invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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/.

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

Affiche sur le modèle de données

PDF, 1 feuille A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Crisp Modèle de données, Page 1 sur 1Crisp Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 27.1.3-BETA+6294 · 01-11-2026CrispPage 1 sur 1 · documentation.invantive.euCrispCrisp.Crisp.ConversationDeviceCapabilitiesByWebsiteId: Conversation Device CapabilitiesConversationDeviceCapabilitiesByW…Crisp.Crisp.ConversationDeviceLocalesByWebsiteId: Conversation Device LocalesConversationDeviceLocalesByWebsit…Crisp.Crisp.ConversationMentionsByWebsiteId: Conversation MentionsConversationMentionsByWebsiteIdCrisp.Crisp.ConversationMessageMentionsByWebsiteIdAndSessionId: Conversation Message MentionsConversationMessageMentionsByWe…Crisp.Crisp.ConversationMessagesByWebsiteIdAndSessionId: Conversation MessagesConversationMessagesByWebsiteIdA…Crisp.Crisp.ConversationParticipantsByWebsiteId: Conversation ParticipantsConversationParticipantsByWebsiteIdCrisp.Crisp.ConversationRelatedChildrenByWebsiteIdAndSessionId: Conversation Related ChildrenConversationRelatedChildrenByWebs…Crisp.Crisp.ConversationRelationsByWebsiteIdAndSessionId: Conversation RelationsConversationRelationsByWebsiteIdAn…Crisp.Crisp.ConversationSegmentsByWebsiteId: Conversation SegmentsConversationSegmentsByWebsiteIdCrisp.Crisp.ConversationVerificationsByWebsiteId: Conversation VerificationsConversationVerificationsByWebsiteIdCrisp.Crisp.ConversationsByWebsiteId: ConversationsConversationsByWebsiteIdCrisp.Crisp.InboxesByWebsiteId: InboxesInboxesByWebsiteIdCrisp.Crisp.OperatorsByWebsiteId: OperatorsOperatorsByWebsiteIdCrisp.Crisp.PeopleConversationsByWebsiteIdAndPeopleId: People ConversationsPeopleConversationsByWebsiteIdAnd…Crisp.Crisp.PeopleLocalesByWebsiteId: People LocalesPeopleLocalesByWebsiteIdCrisp.Crisp.PeopleProfilesByWebsiteId: People ProfilesPeopleProfilesByWebsiteIdCrisp.Crisp.PeopleSegmentsByWebsiteId: People SegmentsPeopleSegmentsByWebsiteIdNativeCrisp.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSVuesCrisp.Views.ActiveOperators: Active OperatorsActiveOperatorsCrisp.Views.CampaignTemplates: Campaign TemplatesCampaignTemplatesCrisp.Views.ConversationDeviceCapabilities: Conversation Device CapabilitiesConversationDeviceCapabilitiesCrisp.Views.ConversationDeviceLocales: Conversation Device LocalesConversationDeviceLocalesCrisp.Views.ConversationEvents: Conversation EventsConversationEventsCrisp.Views.ConversationFiles: Conversation FilesConversationFilesCrisp.Views.ConversationMentions: Conversation MentionsConversationMentionsCrisp.Views.ConversationMessageMentions: Conversation Message MentionsConversationMessageMentionsCrisp.Views.ConversationMessages: Conversation MessagesConversationMessagesCrisp.Views.ConversationPages: Conversation PagesConversationPagesCrisp.Views.ConversationParticipants: Conversation ParticipantsConversationParticipantsCrisp.Views.ConversationRelatedChildren: Conversation Related ChildrenConversationRelatedChildrenCrisp.Views.ConversationRelations: Conversation RelationsConversationRelationsCrisp.Views.ConversationSegments: Conversation SegmentsConversationSegmentsCrisp.Views.ConversationSuggestedDataKeys: Conversation Suggested Data KeysConversationSuggestedDataKeysCrisp.Views.ConversationSuggestedSegments: Conversation Suggested SegmentsConversationSuggestedSegmentsCrisp.Views.ConversationVerifications: Conversation VerificationsConversationVerificationsCrisp.Views.Conversations: ConversationsConversationsCrisp.Views.HelpdeskArticleContents: Helpdesk Article ContentsHelpdeskArticleContentsCrisp.Views.HelpdeskArticles: Helpdesk ArticlesHelpdeskArticlesCrisp.Views.HelpdeskCategories: Helpdesk CategoriesHelpdeskCategoriesCrisp.Views.HelpdeskFeedbackRatings: Helpdesk Feedback RatingsHelpdeskFeedbackRatingsCrisp.Views.HelpdeskFeedbacks: Helpdesk FeedbacksHelpdeskFeedbacksCrisp.Views.HelpdeskLocales: Helpdesk LocalesHelpdeskLocalesCrisp.Views.HelpdeskRedirections: Helpdesk RedirectionsHelpdeskRedirectionsCrisp.Views.HelpdeskSections: Helpdesk SectionsHelpdeskSectionsCrisp.Views.HelpdeskSettings: Helpdesk SettingsHelpdeskSettingsCrisp.Views.Helpdesks: HelpdesksHelpdesksCrisp.Views.InboxConditionQueries: Inbox Condition QueriesInboxConditionQueriesCrisp.Views.InboxConditions: Inbox ConditionsInboxConditionsCrisp.Views.InboxOperators: Inbox OperatorsInboxOperatorsCrisp.Views.InboxTeamOperators: Inbox Team OperatorsInboxTeamOperatorsCrisp.Views.InboxTeams: Inbox TeamsInboxTeamsCrisp.Views.Inboxes: InboxesInboxesCrisp.Views.OperatorAvailabilities: Operator AvailabilitiesOperatorAvailabilitiesCrisp.Views.Operators: OperatorsOperatorsCrisp.Views.PeopleCompanyEmails: People Company EmailsPeopleCompanyEmailsCrisp.Views.PeopleCompanyPhones: People Company PhonesPeopleCompanyPhonesCrisp.Views.PeopleCompanyTags: People Company TagsPeopleCompanyTagsCrisp.Views.PeopleConversations: People ConversationsPeopleConversationsCrisp.Views.PeopleData: People DataPeopleDataCrisp.Views.PeopleEvents: People EventsPeopleEventsCrisp.Views.PeopleLocales: People LocalesPeopleLocalesCrisp.Views.PeopleProfiles: People ProfilesPeopleProfilesCrisp.Views.PeopleSegments: People SegmentsPeopleSegmentsCrisp.Views.PeopleSocialMediaProfiles: People Social Media ProfilesPeopleSocialMediaProfilesCrisp.Views.PeopleStatistics: People StatisticsPeopleStatisticsCrisp.Views.PeopleSubscriptions: People SubscriptionsPeopleSubscriptionsCrisp.Views.PeopleSuggestedDataKeys: People Suggested Data KeysPeopleSuggestedDataKeysCrisp.Views.PeopleSuggestedEvents: People Suggested EventsPeopleSuggestedEventsCrisp.Views.PeopleSuggestedSegments: People Suggested SegmentsPeopleSuggestedSegmentsCrisp.Views.VerifySettings: Verify SettingsVerifySettingsCrisp.Views.VisitorCapabilities: Visitor CapabilitiesVisitorCapabilitiesCrisp.Views.VisitorCounts: Visitor CountsVisitorCountsCrisp.Views.VisitorLocales: Visitor LocalesVisitorLocalesCrisp.Views.Visitors: VisitorsVisitorsCrisp.Views.WebsiteAvailabilityStatus: Website Availability StatusWebsiteAvailabilityStatusCrisp.Views.WebsiteIds: Website IDsWebsiteIdsCrisp.Views.WebsiteSettings: Website SettingsWebsiteSettingsCrisp.Views.WebsiteSettingsChatboxAllowedPages: Website Settings Chatbox Allowed PagesWebsiteSettingsChatboxAllowedPagesCrisp.Views.WebsiteSettingsChatboxBlockedCountries: Website Settings Chatbox Blocked CountriesWebsiteSettingsChatboxBlockedCountriesCrisp.Views.WebsiteSettingsChatboxBlockedIpAddresses: Website Settings Chatbox Blocked IP AddressesWebsiteSettingsChatboxBlockedIpAddressesCrisp.Views.WebsiteSettingsChatboxBlockedLocales: Website Settings Chatbox Blocked LocalesWebsiteSettingsChatboxBlockedLocalesCrisp.Views.WebsiteSettingsChatboxBlockedPages: Website Settings Chatbox Blocked PagesWebsiteSettingsChatboxBlockedPagesCrisp.Views.WebsiteSettingsDomainAlternates: Website Settings Domain AlternatesWebsiteSettingsDomainAlternatesCrisp.Views.Websites: WebsitesWebsitesCrispDictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsCrisp1Tables sans relations1LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesGénéré à partir des métadonnées d'Invantive UniversalSQL 27.1.3-BETA+6294 le 01-11-2026. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/crisp
L'affiche sous forme de texte : tableaux par thème et leurs relations

Crisp

ConversationDeviceCapabilitiesByWebsiteId, ConversationDeviceLocalesByWebsiteId, ConversationMentionsByWebsiteId, ConversationMessageMentionsByWebsiteIdAndSessionId, ConversationMessagesByWebsiteIdAndSessionId, ConversationParticipantsByWebsiteId, ConversationRelatedChildrenByWebsiteIdAndSessionId, ConversationRelationsByWebsiteIdAndSessionId, ConversationSegmentsByWebsiteId, ConversationVerificationsByWebsiteId, ConversationsByWebsiteId, InboxesByWebsiteId, OperatorsByWebsiteId, PeopleConversationsByWebsiteIdAndPeopleId, PeopleLocalesByWebsiteId, PeopleProfilesByWebsiteId, PeopleSegmentsByWebsiteId

Native (sans relations)

NATIVEPLATFORMSCALARREQUESTS

Vues (sans relations)

ActiveOperators, CampaignTemplates, ConversationDeviceCapabilities, ConversationDeviceLocales, ConversationEvents, ConversationFiles, ConversationMentions, ConversationMessageMentions, ConversationMessages, ConversationPages, ConversationParticipants, ConversationRelatedChildren, ConversationRelations, ConversationSegments, ConversationSuggestedDataKeys, ConversationSuggestedSegments, ConversationVerifications, Conversations, HelpdeskArticleContents, HelpdeskArticles, HelpdeskCategories, HelpdeskFeedbackRatings, HelpdeskFeedbacks, HelpdeskLocales, HelpdeskRedirections, HelpdeskSections, HelpdeskSettings, Helpdesks, InboxConditionQueries, InboxConditions, InboxOperators, InboxTeamOperators, InboxTeams, Inboxes, OperatorAvailabilities, Operators, PeopleCompanyEmails, PeopleCompanyPhones, PeopleCompanyTags, PeopleConversations, PeopleData, PeopleEvents, PeopleLocales, PeopleProfiles, PeopleSegments, PeopleSocialMediaProfiles, PeopleStatistics, PeopleSubscriptions, PeopleSuggestedDataKeys, PeopleSuggestedEvents, PeopleSuggestedSegments, VerifySettings, VisitorCapabilities, VisitorCounts, VisitorLocales, Visitors, WebsiteAvailabilityStatus, WebsiteIds, WebsiteSettings, WebsiteSettingsChatboxAllowedPages, WebsiteSettingsChatboxBlockedCountries, WebsiteSettingsChatboxBlockedIpAddresses, WebsiteSettingsChatboxBlockedLocales, WebsiteSettingsChatboxBlockedPages, WebsiteSettingsDomainAlternates, Websites

Relations

Tableaux

Crisp.Crisp

Crisp.Native

Crisp.Views

Exemples de Queries

--
-- 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.

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 :