ActivityCategory


Description

Activity categories defining different categories or types of activities for organizational and security purposes. This table provides classification for activities, enabling categorization of appointments, meetings, and healthcare activities for reporting, security permissions, and workflow management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkActivityCategoryID int identity 4 √ null
Activity.fkActivityCategoryID FK_Activity_ActivityCategory R
ActivityCategorySecurity.fkActivityCategoryID FK_ActivityCategorySecurity_ActivityCategory R
ActivityStatusInCategory.fkActivityCategoryID FK_ActivityStatusInCategory_ActivityCategory R

Primary key - Unique identifier for each activity category
CategoryName varchar 50 √ null

Category name - Descriptive name for the activity category
CategoryDescription varchar 500 √ null

Category description - Detailed description of the activity category and its purpose
fkAATID int 4 √ null
ActivityAssignmentTypes.pkAssignmentTypeID FK_ActivityCategory_ActivityAssignmentTypes R

Assignment type reference - Links to ActivityAssignmentTypes for associated assignment type

Indexes

Constraint Name Type Sort Column(s)
PK_ActivityCategory Primary key Asc pkActivityCategoryID

Relationships

Close relationships within degrees of separation