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.
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
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.
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)
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
- ConversationDeviceCapabilitiesByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationDeviceLocalesByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationMentionsByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationMentionsByWebsiteId → OperatorsByWebsiteId (candidat): 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 (clé)
- ConversationMessagesByWebsiteIdAndSessionId → ConversationsByWebsiteId (clé)
- ConversationParticipantsByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationRelatedChildrenByWebsiteIdAndSessionId → ConversationsByWebsiteId (clé)
- ConversationRelationsByWebsiteIdAndSessionId → ConversationsByWebsiteId (clé)
- ConversationSegmentsByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationVerificationsByWebsiteId → ConversationsByWebsiteId (clé)
- ConversationsByWebsiteId → InboxesByWebsiteId (clé)
- ConversationsByWebsiteId → PeopleProfilesByWebsiteId (décrit avec des mots): The people profile of the visitor, as long as the profile exists; the conversation stays when the profile is deleted.
- PeopleConversationsByWebsiteIdAndPeopleId → ConversationsByWebsiteId (clé)
- PeopleLocalesByWebsiteId → PeopleProfilesByWebsiteId (candidat): 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 (candidat): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
Tableaux
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
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 :