dbo.ethBookingService

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

Columns

#	Column	Type	Nullable	Flags	Description
1	primeAppointmentTypeID	uniqueidentifier	no
2	ServiceDurationMins	int	yes		NULL is Window Duration
3	SyncToOptimoRoute	bit	no
4	ServiceDurationMethod	int	no		1=Target Window, 2=Unavailable during Window
5	OverrideWindowToAfternoon	bit	no
6	OverrideAddressToEstimator	bit	no
7	OverrideAddressToOffice	bit	no
8	ClearContactMobile	bit	no
9	SkillCode	nvarchar(100)	no
11	Priority	nvarchar(1)	no
12	OverrideWindowWhenOutofBounds	bit	no

Relationships (inferred)

From	To	Confidence
dbo.ethBooking.primeAppointmentTypeID	dbo.ethBookingService.primeAppointmentTypeID	high
dbo.ethBookingService.primeAppointmentTypeID	dbo.primeAppointmentType.id	high
dbo.ethBookingService.SkillCode	dbo.ethBookingEstimatorSkill.SkillCode	medium
dbo.primeAppointments.appointmentTypeId	dbo.ethBookingService.primeAppointmentTypeID	medium

Referenced by

Procedures: dbo.spEthBookingClear, dbo.spEthBookingGetAppointmentTypesByEstimator, dbo.spEthBookingGetAvailability, dbo.spEthBookingGetAvailabilityByEstimator, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingGetByCode, dbo.spEthBookingGetByID, dbo.spEthBookingGetByJobID, dbo.spEthBookingSetDate, dbo.spOptimoRouteGetAllowSpecificTimeBookings, dbo.spOptimoRouteGetAppointmentQueue