Appearance
dbo.ethBookingEstimatorJobDistance
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.ethBookingEstimatorJobDistance.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | primeEstimatorUserID | uniqueidentifier | no | ||
| 2 | primeJobID | uniqueidentifier | no | ||
| 3 | Distance | int | no | ||
| 4 | Duration | int | no |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.ethBookingEstimatorJobDistance.primeEstimatorUserID | dbo.ethBookingEstimatorSkill.primeEstimatorID | high |
| dbo.ethBookingEstimatorJobDistance.primeJobID | dbo.primeJobsLocation.jobID | medium |
| dbo.ethBookingEstimatorJobDistance.primeJobID | dbo.primeJobs.Id | low |
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

