| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| IndividualPlanSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
null |
|
|
|
| IndividualPlanType |
varchar |
15 |
|
|
('') |
|
|
|
| IndividualPlanArea |
varchar |
15 |
|
|
('') |
|
|
|
| IndividualPlanStatus |
varchar |
15 |
|
|
('') |
|
|
|
| StartDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ReviewDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| EndDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| ReasonForPlan |
varchar |
255 |
|
|
('') |
|
|
|
| StaffMemberID |
int |
4 |
√ |
|
null |
|
|
|
| OtherStaff |
varchar |
100 |
|
|
('') |
|
|
|
| StartingLevel |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| LevelValue |
decimal |
6,2 |
√ |
|
null |
|
|
|
| Goal |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| Strategies |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| Monitoring |
varchar |
2147483647 |
√ |
|
null |
|
|
|
| RelevantToAllClasses |
tinyint |
1 |
|
|
((0)) |
|
|
|
| FileTypeFilter |
varchar |
5 |
|
|
('') |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_IndividualPlans |
Primary key |
Asc |
IndividualPlanSeq |
| AK_IndividualPlans_ID |
Performance |
Asc |
ID |