invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Crisp Data Model

Crisp is online software voor customer experience, inclusief multi-channel chat, CRM, kennisbank en e-mailcampagnes.

https://crisp.com/docs

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/crisp

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.crisp.chat/.

Cijfers

Figure Count
Tables 135
Columns 1,162
Tabeller med invoegsel 5
Tabeller med update 0
Tabellen met de functie 'verwijderen' 0
Tabeller gedocumenteerd 69

Poster met datamodel

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Crisp Datamodel, Pagina 1 van 1Crisp Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.3-BETA+6294 · 01-11-2026CrispPagina 1 van 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 RequestsNATIVEPLATFORMSCALARREQUESTSViewsCrisp.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: WebsitesWebsitesCrispData DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenCrisp1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/crisp
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Crisp

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

Native (zonder relaties)

NATIVEPLATFORMSCALARREQUESTS

Views (zonder relaties)

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

Relaties

Tabellen

Crisp.Crisp

Crisp.Native

Crisp.Views

Voorbeeldqueries

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

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: