dbo.ethBookingDaySlot

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Date	date	no
2	State	nvarchar(10)	no
4	FromTime	time(7)	no
5	ToTime	time(7)	no
6	IsPublicHoliday	bit	no
11	UnvalidatedDurationMins	int	no

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_ethBookingDaySlot_StateDay	NONCLUSTERED			State, Date

Relationships (inferred)

From	To	Confidence
dbo.ethBookingEstimatorSkill.State	dbo.ethBookingDaySlot.State	high
dbo.optimoRouteDriverDay.PlanDate	dbo.ethBookingDaySlot.Date	high

Referenced by

Procedures: dbo.spEthBookingClear, dbo.spEthBookingClear_Deprecated, dbo.spEthBookingDaySlotPopulate, dbo.spEthBookingDaySlotUpsert_deprecated, dbo.spEthBookingGetAvailability, dbo.spEthBookingGetAvailabilityByEstimator, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingSetDate, dbo.spEthBookingSetDate_Depcrecated, dbo.spOptimoRouteGetAllowSpecificTimeBookings