dbo.ethWIPJobHistoryContacts

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

Columns

#	Column	Type	Nullable	Flags	Description
1	WIPJobHistoryID	int	no		Foreign key to the parent ethWIPJobHistory record (WIP update) this contact entry belongs to.
2	jobId	uniqueidentifier	no		Prime Ecosystem job (primeJobs.id) this contact entry relates to.
3	type	nvarchar(50)	no		Category of contact for this WIP update (e.g. 'Email' recipient vs 'ClientNote' recipient); used to group and replace contact sets for the same history record and type.
4	contactId	uniqueidentifier	yes		Prime Ecosystem contact identifier this row represents.
5	email	nvarchar(200)	yes		Email address of the contact used to send/queue the WIP update email or note.
6	UpdatedAt	datetime	no		Date and time this contact entry was last modified.
7	ID	int	no	identity	Identity primary key of the WIP job history contact record.
8	EmailSentAt	datetime	yes		Date and time the WIP update email was sent to this contact; null if not yet sent.
9	EmailCancelledAt	datetime	yes		Date and time the queued email to this contact was cancelled instead of being sent.
10	EmailQueueFor	datetime	yes		Date and time at which the WIP update email to this contact becomes eligible to be sent.

Relationships (inferred)

From	To	Confidence
dbo.ethWIPJobHistoryContacts.contactId	dbo.primeContacts.id	high
dbo.ethWIPJobHistoryContacts.WIPJobHistoryID	dbo.ethWIPJobHistory.ID	high

Referenced by

Procedures: dbo.spEthWIPGetJobHistoryContactIds, dbo.spEthWIPGetJobHistoryEmails, dbo.spEthWIPJobClientNoteQueue, dbo.spEthWIPJobEmailGet, dbo.spEthWIPJobEmailMarkSent, dbo.spEthWIPJobEmailMarkSentByWIPID, dbo.spEthWIPJobEmailQueue, dbo.spEthWIPJobEmailQueueAggregated, dbo.spEthWIPUpsertJobHistoryContacts