dbo.primeMilestoneItem

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	uniqueidentifier	no		Primary key / unique identifier for this record
2	jobId	uniqueidentifier	yes		Foreign key to primeJobs
3	milestoneId	uniqueidentifier	yes		Foreign key to primeMilestone
4	value	nvarchar(255)	yes		Value of the field/attribute
5	notes	nvarchar(MAX)	yes		Free-text internal notes
6	createdAt	datetime2(0)	yes		Timestamp the record was created
7	createdBy	nvarchar(100)	yes		User/system that created the record
8	updatedAt	datetime2(0)	yes		Timestamp the record was last updated
9	updatedBy	nvarchar(100)	yes		User/system that last updated the record
10	version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeMilestoneItem	CLUSTERED	yes	yes	id
IX_primeMilestoneItem_jobId	NONCLUSTERED			jobId
IX_primeMilestoneItem_milestoneId	NONCLUSTERED			milestoneId

Relationships (inferred)

From	To	Confidence
dbo.primeMilestoneItem.jobId	dbo.primeJobs.Id	high

Referenced by

Procedures: dbo.spEthRepairlineJobDatesQueueTasks, dbo.spEthSedgwickJobDatesqueueTasks, dbo.spPrimeGetJobDates, dbo.spPrimeUpsertMilestoneItems