| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| ServicesSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| StudentId |
int |
4 |
|
|
null |
|
|
|
| SupportType |
varchar |
50 |
|
|
('') |
|
|
|
| StatusCode |
varchar |
50 |
|
|
('') |
|
|
|
| ApplicationLodgedById |
int |
4 |
√ |
|
('') |
|
|
|
| ApplicationDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| Details |
varchar |
2147483647 |
√ |
|
('') |
|
|
|
| Referral |
varchar |
2147483647 |
√ |
|
('') |
|
|
|
| ParentContact |
varchar |
2147483647 |
√ |
|
('') |
|
|
|
| ResponsibleStaffId |
int |
4 |
√ |
|
((0)) |
|
|
|
| ServiceDetails |
varchar |
2147483647 |
√ |
|
('') |
|
|
|
| ServiceEndDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_Services |
Primary key |
Asc |
ServicesSeq |
| AK_Services_StudentId |
Performance |
Asc/Asc |
ServicesSeq + StudentId |