| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| StudentMaterialSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| ID |
int |
4 |
|
|
((0)) |
|
|
|
| ClassCampus |
varchar |
3 |
|
|
('') |
|
|
|
| ClassCode |
varchar |
15 |
|
|
('') |
|
|
|
| AreaSeq |
smallint |
2 |
|
|
((0)) |
|
|
|
| MaterialCampus |
varchar |
3 |
|
|
('') |
|
|
|
| MaterialCode |
varchar |
15 |
|
|
('') |
|
|
|
| ReturnableFlag |
bit |
1 |
|
|
((0)) |
|
|
|
| DateSentStudent |
datetime |
16,3 |
√ |
|
null |
|
|
|
| DateReceivedStudent |
datetime |
16,3 |
√ |
|
null |
|
|
|
|
varchar |
255 |
|
|
('') |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| AK_ClassArea |
Performance |
Asc/Asc |
ClassCode + AreaSeq |
| AK_IDClassArea_cdx |
Performance |
Asc/Asc/Asc |
ID + ClassCode + AreaSeq |
| AK_MaterialID |
Performance |
Asc/Asc |
MaterialCode + ID |