invantive documentation
Invantive Support ForumsLog In / Sign Up

Crisp Data Model

Crisp is online software for customer experience, including multi-channel chat, CRM, knowledge base and email campaigns.

https://crisp.com/docs

Set up this platform in Invantive Cloud: https://cloud.invantive.com/crisp

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its 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/.

Figures

Figure Count
Tables 135
Columns 1,162
Tables with insert 5
Tables with update 0
Tables with delete 0
Tables documented 69

Data Model Poster

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Crisp data model, Sheet 1 of 1Crisp data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026CrispSheet 1 of 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 dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsCrisp1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/crisp
The poster as text: tables per topic and their relations

Crisp

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

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

Views (without 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

Tables

Crisp.Crisp

Crisp.Native

Crisp.Views

Sample 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

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: