dbo.PredefinedEstimateItems

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

Columns

#	Column	Type	Nullable	Flags	Description
1	predefined_item_id	uniqueidentifier	no		Primary key identifying this predefined estimate line item.
2	item_type	nvarchar(50)	yes		Category/classification of the estimate item (e.g. material, labour, trade type).
3	reference_code	nvarchar(50)	no		External reference/code used to look up this line item in the estimating system.
4	estimate_template_category	nvarchar(255)	yes		Category grouping within the estimate template that this item belongs to.
5	estimate_item_type	nvarchar(100)	yes		Type/sub-category of the estimate item within its template category.
6	description	nvarchar(MAX)	no		Plain-English description of the estimate line item shown to estimators.
7	trade	nvarchar(255)	yes		Trade this estimate item applies to (e.g. carpentry, plumbing, electrical).
8	material_unit	nvarchar(50)	yes		Unit of measure for materials on this item (e.g. "m2", "each", "lm").
9	notes	nvarchar(MAX)	yes		Free-text notes about the predefined estimate item.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__Predefin__66E4D654A0B0A142	CLUSTERED	yes	yes	predefined_item_id