dbo.primeScheduleItem

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ScheduleItemId	uniqueidentifier	no		Foreign key to primeScheduleItem
2	ScheduleId	uniqueidentifier	no		Foreign key to primeSchedule
3	Label	nvarchar(255)	yes		Display label
4	Description	nvarchar(MAX)	yes		Free-text description
5	ObjectType	nvarchar(100)	yes		Type of the related object this record applies to (e.g. Job, Contact)
6	ObjectId	uniqueidentifier	yes		Identifier of the related object this record applies to
7	StartDate	date	yes		Start date of this record/job
8	EndDate	date	yes		End date of this record/job
9	StartTime	time(0)	yes		Start time of the appointment/slot
10	EndTime	time(0)	yes		End time of the appointment/slot
11	AssignedId	uniqueidentifier	yes		Foreign key to primeUsers - the user this record is assigned to
12	Visible	bit	no		Flag indicating whether this record is visible
13	Version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeSch__DBAE6C8399187F02	CLUSTERED	yes	yes	ScheduleItemId
IX_primeScheduleItem_ScheduleId	NONCLUSTERED			ScheduleId
IX_primeScheduleItem_ObjectId	NONCLUSTERED			ObjectId
IX_primeScheduleItem_AssignedId	NONCLUSTERED			AssignedId
IX_primeScheduleItem_StartDate_EndDate	NONCLUSTERED			StartDate, EndDate

Relationships (inferred)

From	To	Confidence
dbo.primeScheduleItem.ObjectId	dbo.primeWorkOrders.id	high
dbo.primeSchedule.ScheduleId	dbo.primeScheduleItem.ScheduleId	high
dbo.primeWorkOrderItems.workorderid	dbo.primeScheduleItem.ObjectId	high

Referenced by

Procedures: dbo.spPrimeGetWIPUpdatesWorksCompleted, dbo.spPrimeGetWIPUpdatesWorksInProgress, dbo.spPrimeGetWIPUpdatesWorksUpcoming, dbo.spPrimeUpsertScheduleItem