dbo.primeSchedule

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ScheduleId	uniqueidentifier	no		Foreign key to primeSchedule
2	Type	nvarchar(50)	no		Category/type classification of this record
3	JobId	uniqueidentifier	yes		Foreign key to primeJobs
4	Label	nvarchar(255)	yes		Display label
5	Description	nvarchar(MAX)	yes		Free-text description
6	ScheduleType	nvarchar(100)	yes		Type of schedule item (e.g. task, milestone)
7	AttachmentId	uniqueidentifier	yes		Foreign key to primeAttachment
8	EncodedLinkToken	nvarchar(MAX)	yes		Encoded token used to build a secure link to this record
9	CreatedAt	datetime2(0)	yes		Timestamp the record was created
10	CreatedBy	nvarchar(255)	yes		User/system that created the record
11	UpdatedAt	datetime2(0)	yes		Timestamp the record was last updated
12	UpdatedBy	nvarchar(255)	yes		User/system that last updated the record
13	Version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeSch__9C8A5B49AAF28166	CLUSTERED	yes	yes	ScheduleId
IX_primeSchedule_JobId	NONCLUSTERED			JobId

Relationships (inferred)

From	To	Confidence
dbo.primeSchedule.JobId	dbo.primeJobs.Id	high
dbo.primeSchedule.ScheduleId	dbo.primeScheduleItem.ScheduleId	high

Referenced by

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