ActivityShowTimeAs


Description

Activity calendar display options defining how activities appear on calendars and scheduling interfaces. This lookup table provides options for displaying activity time blocks (busy, free, tentative, out of office) to support calendar integration and scheduling coordination.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkShowTimeAs int identity 4 √ null
Activity.ShowTimeAs FK_Activity_ActivityShowTimeAs R
ActivityStatus.fkShowTime FK_ActivityStatus_ActivityShowTimeAs R

Primary key - Unique identifier for each display option
ShowTimeDesc varchar 20 √ null

Display description - Description of how the activity time should be displayed (Busy, Free, Tentative, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_ActivityShowTimeAs Primary key Asc pkShowTimeAs

Relationships

Close relationships within degrees of separation