Crisp Data Model
Crisp is online software voor customer experience, inclusief multi-channel chat, CRM, kennisbank en e-mailcampagnes.
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
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
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)
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
- ConversationDeviceCapabilitiesByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationDeviceLocalesByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationMentionsByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationMentionsByWebsiteId → OperatorsByWebsiteId (kandidaat): 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 (sleutel)
- ConversationMessagesByWebsiteIdAndSessionId → ConversationsByWebsiteId (sleutel)
- ConversationParticipantsByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationRelatedChildrenByWebsiteIdAndSessionId → ConversationsByWebsiteId (sleutel)
- ConversationRelationsByWebsiteIdAndSessionId → ConversationsByWebsiteId (sleutel)
- ConversationSegmentsByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationVerificationsByWebsiteId → ConversationsByWebsiteId (sleutel)
- ConversationsByWebsiteId → InboxesByWebsiteId (sleutel)
- ConversationsByWebsiteId → PeopleProfilesByWebsiteId (in woorden beschreven): The people profile of the visitor, as long as the profile exists; the conversation stays when the profile is deleted.
- PeopleConversationsByWebsiteIdAndPeopleId → ConversationsByWebsiteId (sleutel)
- PeopleLocalesByWebsiteId → PeopleProfilesByWebsiteId (kandidaat): 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 (kandidaat): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
Tabellen
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
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: