Crisp Data Model
Crisp ist eine Online-Software für das Customer Experience, einschließlich Multi-Channel-Chat, CRM, Wissensdatenbank und E-Mail-Kampagnen.
Richten Sie diese Plattform in der Invantive Cloud ein: https://cloud.invantive.com/crisp
Bei Textvergleichen auf dieser Plattform wird zwischen Groß- und Kleinschreibung unterschieden.
Plattform
- Verwendung über: Invantive Cloud und die Invantive-Produkte auf Ihrem eigenen Computer oder Server.
- Art: Eine Anwendung, auf die über ihre API zugegriffen wird.
- Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: https://status.crisp.chat/.
Angaben
| Figure | Count |
|---|---|
| Tables | 135 |
| Columns | 1,162 |
| Tabellen mit Einfügung | 5 |
| Tabellen mit Aktualisierung | 0 |
| Tabellen mit Löschfunktion | 0 |
| Tabellen dokumentiert | 69 |
Poster zum Daten Muster
Auf einer Tabelle des Posters: Zoom-Vergrößerung und Zoom-Verkleinung, mit den Pfeiltasten bewegen, 0 passt.
Das Poster als Text: Tabellen nach Themen und deren Zusammenhänge
Crisp
ConversationDeviceCapabilitiesByWebsiteId, ConversationDeviceLocalesByWebsiteId, ConversationMentionsByWebsiteId, ConversationMessageMentionsByWebsiteIdAndSessionId, ConversationMessagesByWebsiteIdAndSessionId, ConversationParticipantsByWebsiteId, ConversationRelatedChildrenByWebsiteIdAndSessionId, ConversationRelationsByWebsiteIdAndSessionId, ConversationSegmentsByWebsiteId, ConversationVerificationsByWebsiteId, ConversationsByWebsiteId, InboxesByWebsiteId, OperatorsByWebsiteId, PeopleConversationsByWebsiteIdAndPeopleId, PeopleLocalesByWebsiteId, PeopleProfilesByWebsiteId, PeopleSegmentsByWebsiteId
Native (ohne Beziehungen)
Views (ohne Beziehungen)
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
Beziehungen
- ConversationDeviceCapabilitiesByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationDeviceLocalesByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationMentionsByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationMentionsByWebsiteId → OperatorsByWebsiteId (Kandidat): 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 (Schlüssel)
- ConversationMessagesByWebsiteIdAndSessionId → ConversationsByWebsiteId (Schlüssel)
- ConversationParticipantsByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationRelatedChildrenByWebsiteIdAndSessionId → ConversationsByWebsiteId (Schlüssel)
- ConversationRelationsByWebsiteIdAndSessionId → ConversationsByWebsiteId (Schlüssel)
- ConversationSegmentsByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationVerificationsByWebsiteId → ConversationsByWebsiteId (Schlüssel)
- ConversationsByWebsiteId → InboxesByWebsiteId (Schlüssel)
- ConversationsByWebsiteId → PeopleProfilesByWebsiteId (in Worten beschrieben): The people profile of the visitor, as long as the profile exists; the conversation stays when the profile is deleted.
- PeopleConversationsByWebsiteIdAndPeopleId → ConversationsByWebsiteId (Schlüssel)
- PeopleLocalesByWebsiteId → PeopleProfilesByWebsiteId (Kandidat): 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 (Kandidat): 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
Beispiel-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
Attribute
The attributes of this platform are on the page Attributes.
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: