Skip to content

dbo.ethBookingEstimatorJobDistance ​

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

Columns ​

#ColumnTypeNullableFlagsDescription
1primeEstimatorUserIDuniqueidentifierno
2primeJobIDuniqueidentifierno
3Distanceintno
4Durationintno

Relationships (inferred) ​

FromToConfidence
dbo.ethBookingEstimatorJobDistance.primeEstimatorUserIDdbo.ethBookingEstimatorSkill.primeEstimatorIDhigh
dbo.ethBookingEstimatorJobDistance.primeJobIDdbo.primeJobsLocation.jobIDmedium
dbo.ethBookingEstimatorJobDistance.primeJobIDdbo.primeJobs.Idlow

Referenced by ​

Procedures: dbo.spEthBookingClear, dbo.spEthBookingClear_Deprecated, dbo.spEthBookingEstimatorJobDistanceQueue, dbo.spEthBookingGetAvailability, dbo.spEthBookingGetAvailabilityByEstimator, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingGetMissingEstimatorLocations, dbo.spEthBookingSetDate, dbo.spEthBookingSetDate_Depcrecated, dbo.spEthUpsertBookingEstimatorJobDistance, dbo.spOptimoRouteGetAllowSpecificTimeBookings