dbo.ethFormTriage

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key identifying this form triage record.
2	SubmissionID	nvarchar(50)	no		The unique identifier of the incoming form submission being triaged.
3	SharingCodeID	int	no		Foreign key to the ethFormSharingCode record used to submit this form.
4	PrimeJobID	uniqueidentifier	yes		Foreign key to the Prime Ecosystem job this form submission relates to, once matched/resolved.
5	PrimeContactID	uniqueidentifier	yes		Foreign key to the Prime Ecosystem contact this form submission relates to, once matched/resolved.
6	SchemaVersion	nvarchar(20)	no		The version of the form data schema used to structure the FormData payload, for backward-compatible parsing.
7	FormData	nvarchar(MAX)	no		The raw submitted form data, typically stored as a JSON payload, awaiting triage/routing.
8	CreatedAt	datetime	no		The date and time this form submission was received/created.
9	ModifiedAt	datetime	no		The date and time this form triage record was last modified.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethFormTriage	CLUSTERED	yes	yes	ID
IX_ethFormTriage_SubmissionID	NONCLUSTERED	yes		SubmissionID

Relationships (inferred)

From	To	Confidence
dbo.ethFormTriage.PrimeContactID	dbo.primeContacts.id	low
dbo.ethFormTriage.PrimeJobID	dbo.primeJobs.Id	low

Referenced by

Procedures: dbo.spEthFormTriageGet, dbo.spEthFormTriageUpsert