dbo.primeSiteForms

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

Columns

#	Column	Type	Nullable	Flags	Description
1	siteFormId	uniqueidentifier	no		Foreign key to primeSiteForms
2	number	nvarchar(50)	no		Sequential number/reference of the site form
3	label	nvarchar(255)	yes		Display label
4	jobId	uniqueidentifier	yes		Foreign key to primeJobs
5	objectId	uniqueidentifier	no		Identifier of the related object this record applies to
6	objectType	nvarchar(50)	no		Type of the related object this record applies to (e.g. Job, Contact)
7	template	nvarchar(255)	yes		Template used
8	siteFormTemplateId	uniqueidentifier	yes		Foreign key to primeSiteFormTemplates
9	status	nvarchar(50)	no		Current status of this record
10	attachmentId	uniqueidentifier	yes		Foreign key to primeAttachment
11	notes	nvarchar(MAX)	yes		Free-text internal notes
12	assignedContact	nvarchar(200)	yes		Display name of the assigned contact
13	assignedUser	nvarchar(200)	yes		Display name of the assigned user
14	approvedBy	nvarchar(200)	yes		User who approved this record
15	approvedAt	datetimeoffset(0)	yes		Timestamp this record was approved
16	version	bigint	no		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeSiteForms	CLUSTERED	yes	yes	siteFormId
IX_primeSiteForms_jobId	NONCLUSTERED			jobId
IX_primeSiteForms_status	NONCLUSTERED			status
IX_primeSiteForms_number	NONCLUSTERED			number
IX_primeSiteForms_label	NONCLUSTERED			label	jobId, objectId, objectType, siteFormId, status

Relationships (inferred)

From	To	Confidence
dbo.primeSiteForms.jobId	dbo.primeJobs.Id	high
dbo.primeSiteForms.siteFormId	dbo.primeSiteFormItems.siteFormId	high

Referenced by

Views: dbo.PrimeValidations, dbo.VPrimeValidations

Procedures: dbo.spEthAIPrimeGetJobHash, dbo.spEthAIPrimeUpsertJobSummaryQueue, dbo.spPrimeGetTriageSiteForms, dbo.spPrimePeerReviewformdetails, dbo.spPrimeUpsertSiteForm