Skip to main content

Live Chat - Key Tables

Full column listings for the 2 key tables in this category.

LIVECHATHEADER (34 columns)

# Column Type Length Nullable Default
1 LCHid int NO
2 LCHname nvarchar 255 YES
3 LCHsectionid int YES
4 LCHistech bit YES
5 LCHisclosed bit YES ((0))
6 LCHisassigned bit YES ((0))
7 LCHlastmessageid int YES ((0))
8 LCHlastupdatedate datetime YES ((0))
9 LCHparticipantcount int YES ((0))
10 LCHfaultid int YES ((0))
11 lchicon nvarchar -1 YES
12 LCHChatProfileId nvarchar 50 YES
13 LCHlivechatstarted bit YES ((1))
14 lCHflowstep int YES
15 LCHTeamsActivity nvarchar -1 YES ('')
16 LCHTeamsConversationId nvarchar 1000 YES
17 LCHtimetolaunch float YES
18 LCHpageurl nvarchar -1 YES
19 lchlanguageid int YES
20 LCHaiThreadId nvarchar 255 YES
21 LCHvirtualAgentId nvarchar 50 YES
22 LCHaiThreadLastMessageId int YES
23 lchuserchaturl nvarchar 500 YES
24 LCHSlackAppId nvarchar 20 YES
25 LCHSlackChannelId nvarchar 20 YES
26 LCHSlackUserId nvarchar 20 YES
27 LCHisabandoned bit YES
28 LCHlastcwmid int YES
29 LCHdatetimequeued datetime YES ((0))
30 lchfeedbacksubmitted bit YES
31 LCHcurrentAutomationId int YES
32 LCHlastIntegrationRequestID int YES
33 LCHdatetimeagentjoined datetime YES ((0))
34 LCHqueuetime float YES

LIVECHATMSG (21 columns)

# Column Type Length Nullable Default
1 LCMid int NO
2 LCMchatid int NO
3 LCMsender int YES
4 LCMtext ntext 1073741823 YES
5 LCMtimestamp datetime YES
6 LCMsystemid int YES ((0))
7 LCMfaultid int YES ((0))
8 LCMnextInputFieldId int YES ((0))
9 LCMinputFieldId int YES
10 LCMvalueInt int YES
11 lcmchatimagetype int YES ((0))
12 lcmattachmentid int YES ((0))
13 LCMvalueBool bit YES
14 LCMvalueDate datetime YES ((0))
15 LCMvalueMulti nvarchar 1000 YES
16 LCMchatProfileId nvarchar 36 YES
17 LCMflowStepId int YES
18 lcmtextissafe bit YES
19 lcmtextplain nvarchar 4000 YES
20 LCMmodifiedbyunum int YES
21 LCMdolocalstoragefetch bit YES
Back to top