ObjectiveInGoal


Description

Objective-goal relationship mapping linking objectives to their associated goals for IFSP management and goal tracking. This junction table manages the many-to-many relationship between objectives and goals, supporting flexible goal structure, objective organization, and comprehensive IFSP planning for early intervention services and family-centered care coordination.

Columns

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

Primary key - Unique identifier for each objective-goal relationship
fkObjectiveID int 4 √ null
CustomConfig.configID FK__Objective__fkObj__4FFE54FF R

Objective reference - Links to CustomConfig table for the objective configuration (foreign key to CustomConfig.configID)
fkGoalID int 4 √ null
Goal.GoalID FK__Objective__fkGoa__50F27938 R

Goal reference - Links to Goal table for the associated goal (foreign key to Goal.GoalID)

Indexes

Constraint Name Type Sort Column(s)
PK__ObjectiveInGoal__4F0A30C6 Primary key Asc obGlID

Relationships

Close relationships within degrees of separation