dbo.makesafeMessage

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	Message	nvarchar(MAX)	yes		Text of the 'leave a message' recorded via the make-safe AI answering system.
3	CallerReturnPhone	nvarchar(50)	yes		Phone number the caller provided for a callback.
4	DateModified	datetime	no		Timestamp the message was recorded/left (also used as its date/time in message list views).
5	Status	tinyint	no		Processing/read status code of the message.
6	ClaimNumber	nvarchar(100)	yes		Insurance claim number quoted by the caller, matched against primeJobs.clientreference/jobnumber.
7	CallerFromPhone	nvarchar(50)	yes		Phone number the call originated from.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_makesafeMessage_DateModified	NONCLUSTERED			DateModified

Relationships (inferred)

From	To	Confidence
dbo.elevenLabsConversations.MessageID	dbo.makesafeMessage.ID	high
dbo.makesafeMessage.ClaimNumber	dbo.primeJobs.ClientReference	high
dbo.makesafeMessage.ClaimNumber	dbo.primeJobs.JobNumber	high

Referenced by

Procedures: dbo.spMakesafeGetAllMessages, dbo.spMakesafeGetMessageFormatted, dbo.spMakesafeGetMessagesPaged, dbo.spMakesafeGetStatsCalls, dbo.spMakesafeInsertMessage, dbo.spMakesafeQueueMessageSMSMessages, dbo.spMakesafeUpdateMessageStatus