dbo.ethBooking

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity
2	primeJobID	uniqueidentifier	no
3	primeContactID	uniqueidentifier	no
4	SharingCode	nvarchar(50)	no
5	primeAppointmentTypeID	uniqueidentifier	no
6	primeUserID	uniqueidentifier	yes
7	FromDate	datetime	yes
8	ToDate	datetime	yes
9	Timezone	nvarchar(200)	yes
10	CreatedAt	datetime	no
11	UpdatedAt	datetime	no
12	TimezoneOffsetMins	int	yes
13	primeNoteOnCreate	bit	no
14	primeNoteOnBook	bit	no
15	primeNoteOnCancel	bit	yes
16	primeAppointmentID	uniqueidentifier	yes
17	SharingCodeExpiry	datetime	no
18	CancelReasonCode	int	yes
19	CancelReasonText	nvarchar(1024)	yes
20	CancelFromDate	datetime	yes
21	SkipNotifyContact	bit	no
22	primeAppointmentVersion	bigint	yes
23	primeJobStatusUpdatedAt	datetime	yes
24	BookingNotes	nvarchar(MAX)	yes
25	TimeWindow	int	no
26	ShowMoreDatesDialogShownAtUtc	datetime2(7)	yes
27	ShowMoreDatesDialogConfirmedAtUtc	datetime2(7)	yes
28	ShowMoreDatesDialogCancelledAtUtc	datetime2(7)	yes
29	NoneOfTheseWorkClickedAtUtc	datetime2(7)	yes
30	FirstBookedAtUtc	datetime2(7)	yes
31	FirstBookedFromDate	datetime	yes

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethBooking	CLUSTERED	yes	yes	ID
IX_ethBooking_primeJobID_UpdatedAt	NONCLUSTERED			primeJobID, UpdatedAt	BookingNotes

Relationships (inferred)

From	To	Confidence
dbo.ethAIPrimeJobSummary.primeJobID	dbo.ethBooking.primeJobID	medium
dbo.ethBooking.primeAppointmentID	dbo.primeAppointments.id	high
dbo.ethBooking.primeAppointmentTypeID	dbo.primeAppointmentType.id	high
dbo.ethBooking.primeAppointmentTypeID	dbo.ethBookingService.primeAppointmentTypeID	high
dbo.ethBooking.primeContactID	dbo.primeContacts.id	high
dbo.ethBooking.primeJobID	dbo.primeJobs.Id	high
dbo.ethBooking.primeUserID	dbo.primeUsers.id	high
dbo.ethTask.PrimeObjectID	dbo.ethBooking.primeJobID	high
dbo.optimoRouteOrder.bookingID	dbo.ethBooking.ID	high
dbo.primeJobsLocation.jobID	dbo.ethBooking.primeJobID	high

Referenced by

Procedures: dbo.spEthBookingClear, dbo.spEthBookingClear_Deprecated, dbo.spEthBookingCreate, dbo.spEthBookingGet, dbo.spEthBookingGetAvailabilityGeo, dbo.spEthBookingGetByCode, dbo.spEthBookingGetByID, dbo.spEthBookingGetByJobID, dbo.spEthBookingGetChangedAppointments, dbo.spEthBookingGetID, dbo.spEthBookingGetJobID, dbo.spEthBookingGetOnBook, dbo.spEthBookingGetOnCancel, dbo.spEthBookingGetOnCreate, dbo.spEthBookingGetSharingCode, dbo.spEthBookingGetSMSContactDetails, dbo.spEthBookingJobJobDistanceQueue, dbo.spEthBookingParseandCreate, dbo.spEthBookingSetAppointmentID, dbo.spEthBookingSetAppointmentVersionIfMissing, dbo.spEthBookingSetDate, dbo.spEthBookingSetDate_Depcrecated, dbo.spEthBookingSetInteractionTimestamp, dbo.spEthBookingSetOnBook, dbo.spEthBookingSetOnCancel, dbo.spEthBookingSetOnCreate, dbo.spEthBookingSetToExpired, dbo.spEthBookingSMSOnBook, dbo.spEthBookingSMSOnCancel, dbo.spEthBookingSMSOnCreate, dbo.spEthBookingUpsert, dbo.spEthTaskGetNextX, dbo.spMakesafeGetStatsCalls, dbo.spOptimoRouteGetAllowAdvancedBookings, dbo.spPrimeGetJobInformation