Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| RunYear | int | 4 | √ | null |
|
|
||
| RunMonth | int | 4 | √ | null |
|
|
||
| FileYear | int | 4 | √ | null |
|
|
||
| Campus | varchar | 3 | √ | null |
|
|
||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| Type | varchar | 5 | √ | null |
|
|
||
| TotalBoys | int | 4 | √ | null |
|
|
||
| TotalGirls | int | 4 | √ | null |
|
|
||
| BoarderBoys | int | 4 | √ | null |
|
|
||
| BoarderGirls | int | 4 | √ | null |
|
|
||
| CampusSort | int | 4 | √ | null |
|
|
||
| YearLevelSort | int | 4 | √ | null |
|
|
||
| FullFeeBoys | int | 4 | √ | null |
|
|
||
| FullFeeGirls | int | 4 | √ | null |
|
|
||
| TotalOther | int | 4 | √ | null |
|
|
||
| BoarderOther | int | 4 | √ | null |
|
|
||
| FullFeeOther | int | 4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FutureStudentAppStatistics_IDX | Performance | Asc/Asc/Asc/Asc/Asc/Asc | RunYear + RunMonth + FileYear + Campus + YearLevel + Type |