Crisp Data Model
Crisp is online software for customer experience, including multi-channel chat, CRM, knowledge base and email campaigns.
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
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
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)
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
- ConversationDeviceCapabilitiesByWebsiteId → ConversationsByWebsiteId (key)
- ConversationDeviceLocalesByWebsiteId → ConversationsByWebsiteId (key)
- ConversationMentionsByWebsiteId → ConversationsByWebsiteId (key)
- ConversationMentionsByWebsiteId → OperatorsByWebsiteId (candidate): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
- ConversationMessageMentionsByWebsiteIdAndSessionId → ConversationsByWebsiteId (key)
- ConversationMessagesByWebsiteIdAndSessionId → ConversationsByWebsiteId (key)
- ConversationParticipantsByWebsiteId → ConversationsByWebsiteId (key)
- ConversationRelatedChildrenByWebsiteIdAndSessionId → ConversationsByWebsiteId (key)
- ConversationRelationsByWebsiteIdAndSessionId → ConversationsByWebsiteId (key)
- ConversationSegmentsByWebsiteId → ConversationsByWebsiteId (key)
- ConversationVerificationsByWebsiteId → ConversationsByWebsiteId (key)
- ConversationsByWebsiteId → InboxesByWebsiteId (key)
- ConversationsByWebsiteId → PeopleProfilesByWebsiteId (described in words): The people profile of the visitor, as long as the profile exists; the conversation stays when the profile is deleted.
- PeopleConversationsByWebsiteIdAndPeopleId → ConversationsByWebsiteId (key)
- PeopleLocalesByWebsiteId → PeopleProfilesByWebsiteId (candidate): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
- PeopleSegmentsByWebsiteId → PeopleProfilesByWebsiteId (candidate): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
Tables
Crisp.Crisp
- ActiveOperatorsByWebsiteId: Active Operators
- CampaignTemplatesByWebsiteId: Campaign Templates
- ConversationByWebsiteIdAndSessionId: Conversation Data
- ConversationDeviceCapabilitiesByWebsiteId: Conversation Device Capabilities
- ConversationDeviceLocalesByWebsiteId: Conversation Device Locales
- ConversationEventsByWebsiteIdAndSessionId: Conversation Events
- ConversationFilesByWebsiteIdAndSessionId: Conversation Files
- ConversationMentionsByWebsiteId: Conversation Mentions
- ConversationMessageMentionsByWebsiteIdAndSessionId: Conversation Message Mentions
- ConversationMessagesByWebsiteIdAndSessionId: Conversation Messages
- ConversationPagesByWebsiteIdAndSessionId: Conversation Pages
- ConversationParticipantsByWebsiteId: Conversation Participants
- ConversationRelatedChildrenByWebsiteIdAndSessionId: Conversation Related Children
- ConversationRelationsByWebsiteIdAndSessionId: Conversation Relations
- ConversationSegmentsByWebsiteId: Conversation Segments
- ConversationSuggestedDataKeysByWebsiteId: Conversation Suggested Data Keys
- ConversationSuggestedSegmentsByWebsiteId: Conversation Suggested Segments
- ConversationVerificationsByWebsiteId: Conversation Verifications
- ConversationsByWebsiteId: Conversations
- HelpdeskArticleByWebsiteIdAndLocaleAndArticleId: Helpdesk Article
- HelpdeskArticlesByWebsiteIdAndLocale: Helpdesk Articles
- HelpdeskByWebsiteId: Helpdesk
- HelpdeskCategoriesByWebsiteIdAndLocale: Helpdesk Categories
- HelpdeskFeedbackRatingsByWebsiteIdAndLocale: Helpdesk Feedback Ratings
- HelpdeskFeedbacksByWebsiteIdAndLocale: Helpdesk Feedbacks
- HelpdeskLocalesByWebsiteId: Helpdesk Locales
- HelpdeskRedirectionsByWebsiteId: Helpdesk Redirections
- HelpdeskSectionsByWebsiteIdAndLocaleAndCategoryId: Helpdesk Sections
- HelpdeskSettingsByWebsiteId: Helpdesk Settings
- InboxConditionQueriesByWebsiteId: Inbox Condition Queries
- InboxConditionsByWebsiteId: Inbox Conditions
- InboxOperatorsByWebsiteId: Inbox Operators
- InboxTeamOperatorsByWebsiteId: Inbox Team Operators
- InboxTeamsByWebsiteId: Inbox Teams
- InboxesByWebsiteId: Inboxes
- OperatorAvailabilitiesByWebsiteId: Operator Availabilities
- OperatorByWebsiteIdAndUserId: Operator
- OperatorsByWebsiteId: Operators
- PeopleCompanyEmailsByWebsiteId: People Company Emails
- PeopleCompanyPhonesByWebsiteId: People Company Phones
- PeopleCompanyTagsByWebsiteId: People Company Tags
- PeopleConversationsByWebsiteIdAndPeopleId: People Conversations
- PeopleDataByWebsiteIdAndPeopleId: People Data
- PeopleEventsByWebsiteIdAndPeopleId: People Events
- PeopleLocalesByWebsiteId: People Locales
- PeopleProfileByWebsiteIdAndPeopleId: People Profile
- PeopleProfilesByWebsiteId: People Profiles
- PeopleSegmentsByWebsiteId: People Segments
- PeopleSocialMediaProfilesByWebsiteId: People Social Media Profiles
- PeopleStatisticsByWebsiteId: People Statistics
- PeopleSubscriptionByWebsiteIdAndPeopleId: People Subscription
- PeopleSuggestedDataKeysByWebsiteId: People Suggested Data Keys
- PeopleSuggestedEventsByWebsiteId: People Suggested Events
- PeopleSuggestedSegmentsByWebsiteId: People Suggested Segments
- VerifySettingsByWebsiteId: Verify Settings
- VisitorCapabilitiesByWebsiteId: Visitor Capabilities
- VisitorCountsByWebsiteId: Visitor Counts
- VisitorLocalesByWebsiteId: Visitor Locales
- VisitorsByWebsiteId: Visitors
- WebsiteAvailabilityStatusById: Website Availability Status
- WebsiteById: Website
- WebsiteSettingsById: Website Settings
- WebsiteSettingsChatboxAllowedPagesById: Website Settings Chatbox Allowed Pages
- WebsiteSettingsChatboxBlockedCountriesById: Website Settings Chatbox Blocked Countries
- WebsiteSettingsChatboxBlockedIpAddressesById: Website Settings Chatbox Blocked IP Addresses
- WebsiteSettingsChatboxBlockedLocalesById: Website Settings Chatbox Blocked Locales
- WebsiteSettingsChatboxBlockedPagesById: Website Settings Chatbox Blocked Pages
- WebsiteSettingsDomainAlternatesById: Website Settings Domain Alternates
Crisp.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Crisp.Views
- ActiveOperators: Active Operators
- CampaignTemplates: Campaign Templates
- ConversationDeviceCapabilities: Conversation Device Capabilities
- ConversationDeviceLocales: Conversation Device Locales
- ConversationEvents: Conversation Events
- ConversationFiles: Conversation Files
- ConversationMentions: Conversation Mentions
- ConversationMessageMentions: Conversation Message Mentions
- ConversationMessages: Conversation Messages
- ConversationPages: Conversation Pages
- ConversationParticipants: Conversation Participants
- ConversationRelatedChildren: Conversation Related Children
- ConversationRelations: Conversation Relations
- ConversationSegments: Conversation Segments
- ConversationSuggestedDataKeys: Conversation Suggested Data Keys
- ConversationSuggestedSegments: Conversation Suggested Segments
- ConversationVerifications: Conversation Verifications
- Conversations: Conversations
- HelpdeskArticleContents: Helpdesk Article Contents
- HelpdeskArticles: Helpdesk Articles
- HelpdeskCategories: Helpdesk Categories
- HelpdeskFeedbackRatings: Helpdesk Feedback Ratings
- HelpdeskFeedbacks: Helpdesk Feedbacks
- HelpdeskLocales: Helpdesk Locales
- HelpdeskRedirections: Helpdesk Redirections
- HelpdeskSections: Helpdesk Sections
- HelpdeskSettings: Helpdesk Settings
- Helpdesks: Helpdesks
- InboxConditionQueries: Inbox Condition Queries
- InboxConditions: Inbox Conditions
- InboxOperators: Inbox Operators
- InboxTeamOperators: Inbox Team Operators
- InboxTeams: Inbox Teams
- Inboxes: Inboxes
- OperatorAvailabilities: Operator Availabilities
- Operators: Operators
- PeopleCompanyEmails: People Company Emails
- PeopleCompanyPhones: People Company Phones
- PeopleCompanyTags: People Company Tags
- PeopleConversations: People Conversations
- PeopleData: People Data
- PeopleEvents: People Events
- PeopleLocales: People Locales
- PeopleProfiles: People Profiles
- PeopleSegments: People Segments
- PeopleSocialMediaProfiles: People Social Media Profiles
- PeopleStatistics: People Statistics
- PeopleSubscriptions: People Subscriptions
- PeopleSuggestedDataKeys: People Suggested Data Keys
- PeopleSuggestedEvents: People Suggested Events
- PeopleSuggestedSegments: People Suggested Segments
- VerifySettings: Verify Settings
- VisitorCapabilities: Visitor Capabilities
- VisitorCounts: Visitor Counts
- VisitorLocales: Visitor Locales
- Visitors: Visitors
- WebsiteAvailabilityStatus: Website Availability Status
- WebsiteIds: Website IDs
- WebsiteSettings: Website Settings
- WebsiteSettingsChatboxAllowedPages: Website Settings Chatbox Allowed Pages
- WebsiteSettingsChatboxBlockedCountries: Website Settings Chatbox Blocked Countries
- WebsiteSettingsChatboxBlockedIpAddresses: Website Settings Chatbox Blocked IP Addresses
- WebsiteSettingsChatboxBlockedLocales: Website Settings Chatbox Blocked Locales
- WebsiteSettingsChatboxBlockedPages: Website Settings Chatbox Blocked Pages
- WebsiteSettingsDomainAlternates: Website Settings Domain Alternates
- Websites: Websites
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: