Appearance
dbo.primeSiteFormItems
Info Generated by
scripts/Generate-DataDictionary.ps1- do not edit by hand. Edit descriptions inschemas/tables/dbo.primeSiteFormItems.jsonand regenerate.
Columns
| # | Column | Type | Nullable | Flags | Description |
|---|---|---|---|---|---|
| 1 | itemId | uniqueidentifier | no | Foreign key to the related line item | |
| 2 | siteFormId | uniqueidentifier | no | Foreign key to primeSiteForms | |
| 3 | customFieldId | uniqueidentifier | no | Foreign key to primeJobCustomField definition | |
| 4 | customFieldType | nvarchar(50) | no | Data type of the custom field (e.g. text, number, date) | |
| 5 | customFieldLabel | nvarchar(500) | no | Display label of the custom field | |
| 6 | value | nvarchar(MAX) | yes | Value of the field/attribute | |
| 7 | timezone | nvarchar(100) | yes | Time zone associated with this record |
Indexes
| Name | Type | Unique | PK | Key columns | Included | Filter |
|---|---|---|---|---|---|---|
| PK_primeSiteFormItems | CLUSTERED | yes | yes | itemId | ||
| IX_primeSiteFormItems_siteFormId | NONCLUSTERED | siteFormId | customFieldLabel, customFieldType |
Relationships (inferred)
| From | To | Confidence |
|---|---|---|
| dbo.primeSiteForms.siteFormId | dbo.primeSiteFormItems.siteFormId | high |
Referenced by
Procedures: dbo.spPrimeGetTriageSiteFormItems, dbo.spPrimePeerReviewformdetails, dbo.spPrimeUpsertSiteFormItem