dbo.ethFormSharingCode

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key identifying this form sharing code.
2	Code	nvarchar(100)	no		The shareable code/token issued to allow external access to a specific online form (e.g. via a shareable link).
3	FormType	nvarchar(100)	no		Identifies which type/template of form this sharing code grants access to.
4	CreatedAt	datetime	no		The date and time this sharing code was created.
5	ModifiedAt	datetime	no		The date and time this sharing code record was last modified.
6	ExpiresAt	datetime	no		The date and time after which this sharing code is no longer valid for use.
7	UsedAt	datetime	yes		The date and time this sharing code was consumed/used to submit a form, or null if not yet used.
8	PrimeContactID	uniqueidentifier	yes		Foreign key to the Prime Ecosystem contact this sharing code was issued for or associated with.
9	PrimeJobID	uniqueidentifier	yes		Foreign key to the Prime Ecosystem job this sharing code was issued for or associated with.
10	CreatedBy	nvarchar(100)	yes		The user or system identifier that created this sharing code.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethFormSharingCode	CLUSTERED	yes	yes	ID
IX_ethFormSharingCode_Code	NONCLUSTERED	yes		Code

Relationships (inferred)

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

Referenced by

Procedures: dbo.spEthFormGetSharingCode, dbo.spEthFormSharingCodeInsert, dbo.spEthFormSharingCodeMarkUsed