dbo.EthTasks

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

Columns

#	Column	Type	Nullable	Flags	Description
1	TaskId	uniqueidentifier	no		Unique identifier of the background/queued task.
2	JobId	uniqueidentifier	yes		Identifier of the Prime Ecosystem job the task relates to, if applicable.
3	UserId	uniqueidentifier	no		Identifier of the user the task was created for or by.
4	TaskType	nvarchar(50)	no		Type of the task, determining what background process handles it.
5	Description	nvarchar(MAX)	yes		Free-text description of the task.
6	Status	nvarchar(20)	no		Current processing status of the task (e.g. pending, completed, failed).
7	ScheduledAt	datetime2(7)	yes		Date/time (UTC) the task is scheduled to run; pending tasks are only picked up once this time has passed.
8	CompletedAt	datetime2(7)	yes		Date/time the task finished processing.
9	Retries	int	no		Number of times processing of the task has been retried.
10	Payload	nvarchar(MAX)	yes		JSON payload containing the data needed to process the task.
11	CreatedAt	datetime2(7)	no		Date/time the task was created.
12	UpdatedAt	datetime2(7)	no		Date/time the task record was last updated.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK__EthTasks__7C6949B149E8045E	CLUSTERED	yes	yes	TaskId

Referenced by

Procedures: dbo.spEthCreateAppointment, dbo.spEthGetPendingTasks, dbo.spEthUpdateTaskStatus