Crisp Data Model
Crisp è un software online dedicato all'esperienza del cliente, che include chat multicanale, CRM, knowledge base e campagne e-mail.
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/crisp
I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.
Piattaforma
- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria 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/.
Figure
| Figure | Count |
|---|---|
| Tables | 135 |
| Columns | 1,162 |
| Tabella con inserti | 5 |
| Tabella con aggiornamento | 0 |
| Tabella con la clausola DELETE | 0 |
| Tabella documentata | 69 |
Poster sul modello di dati
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
Croccante
ConversationDeviceCapabilitiesByWebsiteId, ConversationDeviceLocalesByWebsiteId, ConversationMentionsByWebsiteId, ConversationMessageMentionsByWebsiteIdAndSessionId, ConversationMessagesByWebsiteIdAndSessionId, ConversationParticipantsByWebsiteId, ConversationRelatedChildrenByWebsiteIdAndSessionId, ConversationRelationsByWebsiteIdAndSessionId, ConversationSegmentsByWebsiteId, ConversationVerificationsByWebsiteId, ConversationsByWebsiteId, InboxesByWebsiteId, OperatorsByWebsiteId, PeopleConversationsByWebsiteIdAndPeopleId, PeopleLocalesByWebsiteId, PeopleProfilesByWebsiteId, PeopleSegmentsByWebsiteId
Native (senza relazioni)
Visualizzazioni (senza relazioni)
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
Relazioni
- ConversationDeviceCapabilitiesByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationDeviceLocalesByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationMentionsByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationMentionsByWebsiteId → OperatorsByWebsiteId (candidato): 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 (chiave)
- ConversationMessagesByWebsiteIdAndSessionId → ConversationsByWebsiteId (chiave)
- ConversationParticipantsByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationRelatedChildrenByWebsiteIdAndSessionId → ConversationsByWebsiteId (chiave)
- ConversationRelationsByWebsiteIdAndSessionId → ConversationsByWebsiteId (chiave)
- ConversationSegmentsByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationVerificationsByWebsiteId → ConversationsByWebsiteId (chiave)
- ConversationsByWebsiteId → InboxesByWebsiteId (chiave)
- ConversationsByWebsiteId → PeopleProfilesByWebsiteId (descritto a parole): The people profile of the visitor, as long as the profile exists; the conversation stays when the profile is deleted.
- PeopleConversationsByWebsiteIdAndPeopleId → ConversationsByWebsiteId (chiave)
- PeopleLocalesByWebsiteId → PeopleProfilesByWebsiteId (candidato): 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 (candidato): Follows from the name of the column and held in the data of the smoke website on 2026-10-31; not stated by Crisp.
Tabelle
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
Esempi di Query
--
-- 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
Attributi
The attributes of this platform are on the page Attributes.
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: