Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| OutcomeID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP outcome |
|
| fkIFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for the associated Individualized Family Service Plan |
|
| Outcome | nvarchar | 1073741823 | √ | null |
|
|
Outcome description - Detailed description of the family-centered outcome |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the service coordinator who created this outcome |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation timestamp - Date and time when the outcome was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated this outcome |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Update timestamp - Date and time when the outcome was last modified |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Date and time when the outcome was soft deleted |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_OutcomeID | Primary key | Asc | OutcomeID |
Relationships
Close relationships within degrees of separation
