dbo.makesafePhoneCallTrade

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	PhoneCallID	int	no		FK to makesafePhoneCall.ID this trade contractor was notified/dispatched for.
3	PrimeContactID	uniqueidentifier	no		FK to primeContacts identifying the trade contractor notified for the make-safe call.
4	Status	tinyint	no		Status code tracking whether/how the trade contact responded to the notification.
5	CreatedAt	datetime	no		Timestamp the trade notification record was created.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_makesafePhoneCallTrade	CLUSTERED	yes	yes	ID

Relationships (inferred)

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

Referenced by

Procedures: dbo.spMakesafeGetPhoneCallTradeByCode, dbo.spMakesafeGetPhoneCallTrades, dbo.spMakesafeInsertPhoneCallTrade, dbo.spMakesafeSearchPhoneCallTrades, dbo.spMakesafeUpdatePhoneCallTradeStatus