dbo.clicksendSMSReply

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.clicksendSMSReply.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	SMSMessageID	int	no	identity	Primary key identifying this ClickSend SMS reply record.
2	Sent	datetime	no		Date and time this SMS reply was recorded (set to GETDATE() on insert).
3	FromMobile	nvarchar(50)	no		Mobile number the SMS reply was sent from.
4	ToMobile	nvarchar(50)	no		Mobile number the SMS reply was sent to.
7	OriginalMessageID	uniqueidentifier	yes		ClickSend message ID of the original outbound SMS this reply is responding to.
8	MessageID	uniqueidentifier	yes		ClickSend message ID assigned to this inbound reply message.
9	Body	nvarchar(MAX)	no		Text content of the SMS reply message.
10	CustomString	nvarchar(255)	yes		Custom reference string passed through from ClickSend (echoed from the original outbound message) for correlating replies.
11	ResponseCode	int	no		HTTP-style response code for the reply record; defaulted to 200 on insert by spClickSendInsertSMSReply.
13	Outbound	bit	no		Flag indicating message direction: 0 = inbound reply from customer, 1 = outbound. Set to 0 by default when inserted via spClickSendInsertSMSReply.
14	CreatedAt	datetime	no		Date and time this SMS reply record was created.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__Automati__880DA632CF1F9B52	CLUSTERED	yes	yes	SMSMessageID

Referenced by

Procedures: dbo.spClickSendGetLastMFABody, dbo.spClickSendInsertSMSReply