Appearance
dbo.primeEstimateCategories
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeEstimateCategories.jsonand 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 | categoryType | nvarchar(50) | no | Type/classification of the estimate category | |
| 4 | label | nvarchar(255) | no | Display label | |
| 5 | description | nvarchar(MAX) | yes | Free-text description | |
| 6 | materialMargin | decimal(9,6) | no | Margin percentage applied to material cost | |
| 7 | labourMargin | decimal(9,6) | no | Margin percentage applied to labour cost |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_primeEstimateCategories | CLUSTERED | yes | yes | categoryId | ||
| IX_primeEstimateCategories_estimateId | NONCLUSTERED | estimateId | ||||
| IX_primeEstimateCategories_label | NONCLUSTERED | label |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.primeEstimateCategories.categoryId | dbo.primeEstimateCategoryItems.categoryId | high |
| dbo.primeEstimates.estimateId | dbo.primeEstimateCategories.estimateId | high |
Referenced by
Procedures: dbo.spPrimeDeleteEstimatesForJob, dbo.spPrimePeerReviewEstimatedetails, dbo.spPrimeUpsertEstimateCategory