invantive documentation
Forum di supporto InvantiveAccedi / Registrati

Crisp Data Model

Crisp è un software online dedicato all'esperienza del cliente, che include chat multicanale, CRM, knowledge base e campagne e-mail.

https://crisp.com/docs

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

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Crisp Modello di dati, Foglio 1 di 1Crisp Modello di datida utilizzare con Invantive UniversalSQLComunicato 27.1.3-BETA+6294 · 01-11-2026CroccanteFoglio 1 di 1 · documentation.invantive.euCroccanteCrisp.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 RequestsNATIVEPLATFORMSCALARREQUESTSVisualizzazioniCrisp.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: WebsitesWebsitesCrispDizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiCroccante1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleGenerato dai metadati di Invantive UniversalSQL 27.1.3-BETA+6294 il 01-11-2026. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/crisp
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)

NATIVEPLATFORMSCALARREQUESTS

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

Tabelle

Crisp.Crisp

Crisp.Native

Crisp.Views

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: