Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReviewTypeID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each IFSP review type |
|
| ReviewDesc | varchar | 30 | √ | null |
|
|
Review description - Descriptive name of the review type (e.g., ‘Annual Review’, ‘Interim Review’, ‘Six-Month Review’) |
|
| LabelID | int | 4 | √ | null |
|
|
Label identifier - Numeric identifier for display labels and system categorization |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_ReviewType | Must be unique | Asc | ReviewTypeID |
Relationships
Close relationships within degrees of separation
