dbo.primeAppointmentType

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Primary key / unique identifier for this record
2	type	nvarchar(50)	no		Category/type classification of this record
3	label	nvarchar(255)	no		Display label
4	version	bigint	no		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__Appointm__3213E83FDC243D95	CLUSTERED	yes	yes	id

Relationships (inferred)

From	To	Confidence
dbo.ethBookingAppointmentSkill.primeAppointmentTypeID	dbo.primeAppointmentType.id	low
dbo.ethBooking.primeAppointmentTypeID	dbo.primeAppointmentType.id	high
dbo.ethBookingService.primeAppointmentTypeID	dbo.primeAppointmentType.id	high
dbo.primeAppointments.appointmentTypeId	dbo.primeAppointmentType.id	high

Referenced by

Views: dbo.VPrimeEstimatorstagesEstimatorworkflowdb

Procedures: dbo.spEthBookingGetAppointmentTypesByEstimator, dbo.spEthBookingGetByCode, dbo.spEthBookingGetByID, dbo.spEthBookingGetByJobID, dbo.spEthBookingParseandCreate, dbo.spEthResolveAppointmentContext, dbo.spOptimoRouteGetAppointmentQueue, dbo.spOptimoRouteGetLogs, dbo.spOptimoRouteGetLogsPaged, dbo.spOptimoRouteGetNotScheduledOrders, dbo.spOptimoRouteGetNotScheduledOrdersEmailQueue, dbo.spPrimeGetAppointmentTypes, dbo.spPrimeUpsertAppointmentType, dbo.spRefreshEstimatorStageSummary