ActivityAssignment


Description

Activity assignments linking scheduled activities to specific assignments or cases for healthcare service delivery. This table connects calendar activities to patient assignments, enabling tracking of which activities are associated with specific patient cases or service assignments.

Columns

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

Primary key - Unique identifier for each activity assignment
fkActivityID int 4 ((0))
Activity.ActivityID ActivityAssignment_FK_Activity_ID R

Activity reference - Links to the Activity table for the scheduled activity
AssignmentID int 4 ((0))

Assignment reference - Links to the specific assignment or case associated with this activity

Indexes

Constraint Name Type Sort Column(s)
pk_ActivityAssignmentID Primary key Asc pkActivityAssignmentID

Relationships

Close relationships within degrees of separation