dbo.primeJobsLocation

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key / unique identifier for this record
2	jobID	uniqueidentifier	no		Foreign key to primeJobs
3	Location	geography	yes		Geographic coordinates of the site address
4	updatedAt	datetime2(7)	no		Timestamp the record was last updated
5	reprocess	bit	no		Flag indicating this record should be reprocessed
6	Hash	varbinary(32)	yes		Hash of the file content, used to detect duplicates/changes

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeJobsLocation	CLUSTERED	yes	yes	ID
nci_msft_1_primeJobsLocation_564F54C3718169007C94915031942581	NONCLUSTERED			jobID	Location

Relationships (inferred)

From	To	Confidence
dbo.ethBookingEstimatorJobDistance.primeJobID	dbo.primeJobsLocation.jobID	medium
dbo.primeJobsLocation.jobID	dbo.ethKpiResultsActive.JobId	high
dbo.primeJobsLocation.jobID	dbo.ethBooking.primeJobID	high
dbo.primeJobsLocation.jobID	dbo.primeJobs.Id	high
dbo.primeJobsLocation.jobID	dbo.optimoRouteOrder.primeJobID	high

Referenced by

Views: dbo.vEthActiveJobsLocation, dbo.vEthActiveJobsLocationVIC

Procedures: dbo.spEthBookingEstimatorJobDistanceQueue, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingJobJobDistanceQueue, dbo.spMCPSearchTrades, dbo.spOptimoRouteGetNearbyJobs, dbo.spPrimeGetJobLocation, dbo.spPrimeGetJobsLocationQueue, dbo.spPrimeGetJobsLocationTaskQueue, dbo.spPrimeReprocessJobsLocation, dbo.spPrimeUpsertJob, dbo.spPrimeUpsertJobsLocation