JobType

6 rows


Description

Reference table defining available job types for background processing

Columns

Column Type Size Nulls Auto Default Children Parents Comments
JobTypeId int identity 4 null
JobExecution.JobTypeId FK_JobExecution_JobType R
JobName nvarchar 200 null
ContainerAppJobName nvarchar 200 null
Description nvarchar 1000 null
Category nvarchar 100 null
IsActive bit 1 ((1))
CreatedAt datetime 16,3 null
UpdatedAt datetime 16,3 null

Indexes

Constraint Name Type Sort Column(s)
PK_JobTypeId Primary key Asc JobTypeId
IX_JobType_Category Performance Asc Category
IX_JobType_JobName Must be unique Asc JobName

Relationships