dbo.makesafePhoneCallLocation

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	PhoneCallID	int	no		FK to makesafePhoneCall.ID this geolocation reading relates to.
3	Location	geography	yes		Geographic point (lat/long) resolved for the call, e.g. from the property address.
4	updatedAt	datetime2(7)	no		Timestamp the location was last computed/updated.
5	reprocess	bit	no		Flag indicating the location needs to be recalculated (e.g. geocoding failed or address changed).

Indexes

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

Relationships (inferred)

From	To	Confidence
dbo.makesafePhoneCallLocation.PhoneCallID	dbo.makesafePhoneCall.ID	medium

Referenced by

Procedures: dbo.spMakesafeGetPhoneCallbyID, dbo.spMakesafeGetPhonecallLocationQueue, dbo.spMakesafeSearchPhoneCallTrades, dbo.spMakesafeUpdatePhoneCall, dbo.spMakesafeUpsertPhonecallLocation