Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReviewID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each review due record |
|
| ReviewDueDate | datetime | 16,3 | √ | null |
|
|
Review due date - Date when the review is scheduled to be completed |
|
| ActualReviewDate | datetime | 16,3 | √ | null |
|
|
Actual review date - Date when the review was actually completed |
|
| ReviewType | char | 20 | √ | null |
|
|
Review type - Type or category of review (e.g., ‘IFSP Annual’, ‘IFSP Interim’, ‘Quality Review’) |
|
| IFSPID | int | 4 | √ | null |
|
|
IFSP reference - Links to IFSP table for IFSP-related reviews |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ReviewDue | Primary key | Asc | ReviewID |
Relationships
Close relationships within degrees of separation
