chat_session Table (332)
Some tooltip text!
• 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) | ● |
| 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 | ● |
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.