dbo.primeNotifications

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

Columns

#	Column	Type	Nullable	Flags	Description
1	Id	uniqueidentifier	no		Primary key / unique identifier for this record
2	JobId	uniqueidentifier	no		Foreign key to primeJobs
3	NotificationChannel	nvarchar(50)	no		Channel the notification was sent through (e.g. Email, SMS)
4	NotificationType	nvarchar(100)	no		Type/category of notification
5	NotificationTemplateId	uniqueidentifier	yes		Foreign key to primeNotificationTemplates
6	NotificationTemplate	nvarchar(255)	yes		Name of the notification template
7	EmailFrom	nvarchar(255)	yes		Sender email address
8	EmailFromName	nvarchar(255)	yes		Display name of the email sender
9	EmailTo	nvarchar(MAX)	yes		Recipient email address
10	EmailToString	nvarchar(500)	yes		Recipient email address(es) as a display string
11	EmailCc	nvarchar(MAX)	yes		CC email address(es)
12	EmailBcc	nvarchar(MAX)	yes		BCC email address(es)
13	EmailSubject	nvarchar(1000)	yes		Subject line of the email
14	EmailBody	nvarchar(MAX)	yes		Body content of the email
15	Attachments	nvarchar(MAX)	yes		List/count of attachments associated with this record
16	NoteText	nvarchar(MAX)	yes		Free-text content of the note
17	NotePublic	bit	yes		Flag indicating whether the note is visible to the client/customer
18	CreatedAt	datetime2(0)	no		Timestamp the record was created
19	CreatedBy	nvarchar(255)	yes		User/system that created the record
20	UpdatedAt	datetime2(0)	no		Timestamp the record was last updated
21	UpdatedBy	nvarchar(255)	yes		User/system that last updated the record

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_primeNotifications	CLUSTERED	yes	yes	Id
IX_primeNotifications_JobId	NONCLUSTERED			JobId	EmailFromName, EmailSubject, EmailToString, NotificationChannel, NotificationTemplate, NotificationType

Referenced by

Procedures: dbo.spPrimeGetJobNotifications, dbo.spPrimeUpsertNotification