ActivityStatus


Description

Activity status definitions defining the various states that activities can have throughout their lifecycle. This lookup table provides standardized status values for activities including scheduled, completed, cancelled, and other workflow states with associated display and processing rules.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkStatusID int identity 4 √ null
Activity.fkActivityStatusID FK_Activity_ActivityStatus R
ActivityStatusInCategory.fkActivityStatusID FK_ActivityStatusInCategory_ActivityStatus R

Primary key - Unique identifier for each activity status
StatusName varchar 50 √ null

Status name - Short name for the activity status
StatusDescription varchar 200 √ null

Status description - Detailed description of what the status represents
fkShowTime int 4 √ null
ActivityShowTimeAs.pkShowTimeAs FK_ActivityStatus_ActivityShowTimeAs R

Show time reference - Links to ActivityShowTimeAs for calendar display behavior
LevelName varchar 30 √ null

Level name - Hierarchical level or category for the status
indicates int 4 √ null

Status indicator - Numeric indicator for status processing and business rules

Indexes

Constraint Name Type Sort Column(s)
PK_ActivityStatus Primary key Asc pkStatusID

Relationships

Close relationships within degrees of separation