dbo.primeLockedEstimateCategories

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

Columns

#	Column	Type	Nullable	Flags	Description
1	CategoryID	uniqueidentifier	no		Foreign key to the related estimate category
2	EstimateID	uniqueidentifier	no		Foreign key to the related estimate
3	type	nvarchar(50)	yes		Category/type classification of this record
4	label	nvarchar(255)	yes		Display label
5	description	nvarchar(MAX)	yes		Free-text description
6	materialMargin	decimal(10,6)	yes		Margin percentage applied to material cost
7	labourMargin	decimal(10,6)	yes		Margin percentage applied to labour cost

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__primeLoc__19093A2B041C5BCC	CLUSTERED	yes	yes	CategoryID
nci_msft_1_primeLockedEstimateCategories_79D1F169E6DA1292EF71686B3589B8C6	NONCLUSTERED			EstimateID
IX_primeLockedEstimateCategories_EstimateID	NONCLUSTERED			EstimateID	CategoryID

Relationships (inferred)

From	To	Confidence
dbo.primeLockedEstimateCategories.CategoryID	dbo.primeLockedEstimateCategoryItems.CategoryID	high
dbo.primeLockedEstimates.EstimateID	dbo.primeLockedEstimateCategories.EstimateID	high

Referenced by

Procedures: dbo.spEndataEstimateUploads, dbo.spPrimeBuildLockedEstimatesThisYear, dbo.spPrimeUpsertLockedEstimate, dbo.spPrimeUpsertLockedEstimateCategory