dbo.clicksendConversations

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key identifying this ClickSend conversation record.
2	JSON	nvarchar(MAX)	no		Raw JSON payload received from the ClickSend webhook/API for this conversation.
3	DateModified	datetime	no		Date and time this conversation record was last modified.
4	PhoneCallID	int	yes		Foreign key to makesafePhoneCall linking this conversation to the phone call that triggered it, if applicable.
5	SMSMessageID	int	yes		Foreign key to makesafeSMSMessage linking this conversation to the originating SMS message, if applicable.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_clicksendConversations	CLUSTERED	yes	yes	ID

Referenced by

Procedures: dbo.spClickSendInsertConversation