dbo.makesafeSharingCode

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	Code	nvarchar(100)	no		Unique code shared with an external party (e.g. via link) to grant access to a make-safe form.
3	DateModified	datetime	no		Timestamp the sharing code record was created or last modified.
4	DateExpiry	datetime	no		Date/time after which the sharing code is no longer valid.
5	PhoneCallID	int	yes		FK to makesafePhoneCall.ID this sharing code grants access to, if any.
6	PrimeContactID	uniqueidentifier	yes		FK to primeContacts identifying the contact the sharing code was issued to, if any.
7	FormType	nvarchar(100)	yes		Type of form the shared link grants access to.

Relationships (inferred)

From	To	Confidence
dbo.makesafeSharingCode.PhoneCallID	dbo.makesafePhoneCall.ID	high
dbo.makesafeSharingCode.PhoneCallID	dbo.makesafePhoneCallTrade.PhoneCallID	medium
dbo.makesafeSharingCode.PrimeContactID	dbo.primeContacts.id	high
dbo.makesafeSharingCode.PrimeContactID	dbo.makesafePhoneCallTrade.PrimeContactID	medium

Referenced by

Procedures: dbo.spMakesafeGetAllSharingCodes, dbo.spMakesafeGetPhoneCallbyCode, dbo.spMakesafeGetPhoneCallTradeByCode, dbo.spMakesafeGetSharingCode, dbo.spMakesafeInsertFormSharingCode, dbo.spMakesafeInsertPhoneCallSharingCode, dbo.spMakesafeValidateFormSharingCode