dbo.ethBookingEstimatorSkill

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

Columns

#	Column	Type	Nullable	Flags	Description
1	EstimatorSkillID	int	no	identity
2	primeEstimatorID	uniqueidentifier	no
3	SkillCode	nvarchar(100)	no
4	State	nvarchar(50)	yes
5	Enabled	bit	no

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethBookingEstimatorSkill	CLUSTERED	yes	yes	EstimatorSkillID

Relationships (inferred)

From	To	Confidence
dbo.ethBookingEstimatorJobDistance.primeEstimatorUserID	dbo.ethBookingEstimatorSkill.primeEstimatorID	high
dbo.ethBookingEstimatorSkill.primeEstimatorID	dbo.primeUsers.id	high
dbo.ethBookingEstimatorSkill.State	dbo.ethBookingDaySlot.State	high
dbo.ethBookingService.SkillCode	dbo.ethBookingEstimatorSkill.SkillCode	medium
dbo.optimoRouteDriverDay.EstimatorID	dbo.ethBookingEstimatorSkill.primeEstimatorID	high
dbo.optimoRouteOrder.ScheduledEstimatorID	dbo.ethBookingEstimatorSkill.primeEstimatorID	medium
dbo.primeJobs.State	dbo.ethBookingEstimatorSkill.State	medium

Referenced by

Procedures: dbo.spBookingUpsertEstimatorSkill, dbo.spEthBookingDaySlotPopulate, dbo.spEthBookingDeleteEstimatorSkill, dbo.spEthBookingEstimatorJobDistanceQueue, dbo.spEthBookingGetAppointmentTypesByEstimator, dbo.spEthBookingGetAvailability, dbo.spEthBookingGetAvailabilityByEstimator, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingGetEstimators, dbo.spEthBookingGetEstimatorsSkills, dbo.spEthBookingGetMissingEstimatorLocations, dbo.spEthBookingUpsertEstimatorSkill, dbo.spEthGetBookingEstimatorLocations, dbo.spOptimoRouteDriverDayUpsert, dbo.spOptimoRouteGetAllowSpecificTimeBookings, dbo.spOptimoRouteGetAppointmentQueue, dbo.spOptimoRouteGetWorkOrderQueue, dbo.spOptimoRouteUpsertStop, dbo.spPrimeGetContactLocationQueue, dbo.spPrimeGetEstimatorIDFromName