chat_session Table (332)

•
Environment: onsite, online
• 4 minutes to read
 • 4 minutes to read

This table contains chat sessions.

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
topic_id The reference to the associated chat topic. FK chat_topic
user_id The reference to the associated user. FK ejuser
customer_id The reference to the associated customer. May be NULL or -1. FK person
customer_alias The alias for the customer. String(64) ●
status Enum indicating the status for the session (pending, active, closed, etc). Enum ChatSessionStatus ●
when_requested When the session was requested by the customer. DateTime ●
when_started When the session was accepted by a user. DateTime ●
when_ended When the session was ended. DateTime ●
idle The last time anyone sent a message for this session. DateTime ●
customer_fetch The last time the customer's client refetched the data. Used to detect 'dead' session. DateTime ●
session_key Key used to authenticate the session. String(255) ●
initial_queue_pos The initial queue pos (i.e. the number of pending sessions + 1) when the session was requested. Int ●
customer_host The hostname or IP address for the customer. String(255) ●
alert_level The alert level for this chat session. Int ●
rank Lowest possible unique number for active sessions for user. User for color index. Starting at 1. Int ●
name The name of customer, if provided String(255) ●
company_name The name of the customers company, if provided String(255) ●
email The email address of the customer, if provided String(255) ●
phone The phone number of the customer, if provided String(32) ●
first_message A copy of the first message in the chat session String(1024) ●
last_message A copy of the last message in the chat session String(1024) ●
flags Various flags for the chat session Enum ChatSessionFlags ●
project_id The project that this chat session is connected to FK project ●
sale_id The sale that this chat session is connected to FK sale ●
ticket_id The ticket that this chat session is connected to FK ticket ●
contact_id The contact that this chat session is connected to FK contact ●
transfer_to The ejuser that has a pending transfer of the chat session FK ejuser ●
consented The customer consented when starting the session Bool ●
chatbot_isactive Indicates that a chatbot is active on the session. This will cause bot triggers to fire. Set to 0 when bot hands off to user. Bool ●
country The country that the chat customer selected. Int ●
rating Rating of this chat conversation given by the customer Int ●

chat_session table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
topic_id FK Index
user_id FK Index
customer_id FK Index
status, topic_id, id Enum, FK, PK Index

Relationships

Table Description
chat_message This table contains messages in a chat session.
chat_topic This table contains chat topics.
contact Companies and Organizations. This table features a special record containing information about the contact that owns the database.
ejuser This table contains entries for the users of the system.
person Persons in a company or an organizations. All associates have a corresponding person record
project Projects
sale Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.
ticket This table contains the tickets (requests) of the system. Its purpose should be evident.

Replication Flags

  • None

Security Flags

  • No access control via user's Role.