dbo.elevenLabsConversations

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key identifying this ElevenLabs AI voice conversation record.
2	JSON	nvarchar(MAX)	no		Raw JSON payload received from the ElevenLabs webhook containing conversation initiation data.
3	DateModified	datetime	no		Date and time this conversation record was last modified.
4	PhoneCallID	int	yes		Foreign key to makesafePhoneCall linking this AI voice conversation to the associated phone call, if applicable.
5	MessageID	int	yes		Foreign key to makesafeSMSMessage linking this AI voice conversation to an associated SMS message, if applicable.
6	ConversationID	nvarchar(100)	yes		ElevenLabs system conversation ID, extracted from the JSON payload's conversation_initiation_client_data.dynamic_variables.system__conversation_id.
7	ConversationStatus	nvarchar(50)	yes		Processing status of the AI voice conversation, e.g. 'PendingUpload' initially, updated via spElevenLabsConversationSetStatus.
8	ConversationUploadedAt	datetime	yes		Date and time the conversation status was last updated/uploaded, set by spElevenLabsConversationSetStatus.

Indexes

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

Relationships (inferred)

From	To	Confidence
dbo.elevenLabsConversations.MessageID	dbo.makesafeMessage.ID	high
dbo.elevenLabsConversations.PhoneCallID	dbo.makesafePhoneCall.ID	high

Referenced by

Views: dbo.vMakeSafePhonecalls, dbo.vMakeSafePhonecallsNoAlerts

Procedures: dbo.spElevenLabsConversationGetAudioQueue, dbo.spElevenLabsConversationSetStatus, dbo.spElevenLabsInsertConversation, dbo.spMakesafeGetAllMessages, dbo.spMakesafeGetAllPhoneCalls, dbo.spMakesafeGetElevenLabsConversationbyID, dbo.spMakesafeGetGeoLocationPhoneCalls, dbo.spMakesafeGetMessagesPaged, dbo.spMakesafeGetPhoneCallbyID, dbo.spMakesafeGetPhoneCallConversationbyID, dbo.spMakesafeGetPhoneCallJSON, dbo.spMakesafeGetPhoneCalls, dbo.spMakesafeGetPhoneCallsPaged, dbo.spMakesafeGetPhoneCallStatusbyID