invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Crisp Data Model

Crisp es un software en línea dedicado a la experiencia del cliente, que incluye chat multicanal, CRM, base de conocimientos y campañas de correo electrónico.

https://crisp.com/docs

Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/crisp

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su 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/.

Cifras

Figure Count
Tables 135
Columns 1,162
Tablas con inserciones 5
Tablas con actualización 0
Tablas con la instrucción «DELETE» 0
Tablas documentadas 69

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Crisp Modelo de Datos, Hoja 1 de 1Crisp Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026CrujienteHoja 1 de 1 · documentation.invantive.euCrujienteCrisp.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 RequestsNATIVEPLATFORMSCALARREQUESTSVistasCrisp.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: WebsitesWebsitesCrispDiccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasCrujiente1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/crisp
El póster en forma de texto: tablas por tema y sus relaciones

Crujiente

ConversationDeviceCapabilitiesByWebsiteId, ConversationDeviceLocalesByWebsiteId, ConversationMentionsByWebsiteId, ConversationMessageMentionsByWebsiteIdAndSessionId, ConversationMessagesByWebsiteIdAndSessionId, ConversationParticipantsByWebsiteId, ConversationRelatedChildrenByWebsiteIdAndSessionId, ConversationRelationsByWebsiteIdAndSessionId, ConversationSegmentsByWebsiteId, ConversationVerificationsByWebsiteId, ConversationsByWebsiteId, InboxesByWebsiteId, OperatorsByWebsiteId, PeopleConversationsByWebsiteIdAndPeopleId, PeopleLocalesByWebsiteId, PeopleProfilesByWebsiteId, PeopleSegmentsByWebsiteId

Native (sin relaciones)

NATIVEPLATFORMSCALARREQUESTS

Vistas (sin relaciones)

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

Relaciones

Tablas

Crisp.Crisp

Crisp.Native

Crisp.Views

Ejemplos 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

Atributos

The attributes of this platform are on the page Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: