ActivityStatusInCategory


Description

Activity status category associations linking activity statuses to specific activity categories for workflow management. This table defines which statuses are available for activities within different categories, enabling category-specific workflow rules and status transitions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkStatusInCatID int identity 4 √ null

Primary key - Unique identifier for each status-category association
fkActivityStatusID int 4 √ null
ActivityStatus.pkStatusID FK_ActivityStatusInCategory_ActivityStatus R

Activity status reference - Links to ActivityStatus for the available status
fkActivityCategoryID int 4 √ null
ActivityCategory.pkActivityCategoryID FK_ActivityStatusInCategory_ActivityCategory R

Activity category reference - Links to ActivityCategory for the category that can use this status

Indexes

Constraint Name Type Sort Column(s)
PK_ActivityStatusInCategory Primary key Asc pkStatusInCatID

Relationships

Close relationships within degrees of separation