Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ObjectiveID | int identity | 4 | √ | null |
|
|
Objective primary key - Unique identifier for each IFSP objective |
|
| fkOutcomeID | int | 4 | √ | null |
|
|
Outcome reference - Links to Outcomes table for the associated IFSP outcome |
|
| Objective | nvarchar | 1073741823 | √ | null |
|
|
Objective description - Detailed description of the specific objective |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this objective |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when this objective was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this objective |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this objective was last modified |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this objective was soft deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ObjectiveID | Primary key | Asc | ObjectiveID |
Relationships
Close relationships within degrees of separation
