Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| StudentID | int | 4 | null |
|
|
|||
| InstalmentSeq | int | 4 | null |
|
|
|||
| CurrentBalance | money | 21,4 | √ | null |
|
|
||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| YearLevelSort | smallint | 2 | √ | null |
|
|
||
| FileYear | smallint | 2 | √ | null |
|
|
||
| FileSemester | smallint | 2 | √ | null |
|
|
||
| FeeCodeDescription | varchar | 80 | √ | null |
|
|
||
| AnnualFees | money | 21,4 | null |
|
|
|||
| DebtorMailName | varchar | 100 | √ | null |
|
|
||
| PrimaryOnlyFlag | smallint | 2 | √ | null |
|
|
||
| DebtorSurname | varchar | 30 | √ | null |
|
|
||
| DebtorPreferred | varchar | 20 | √ | null |
|
|
||
| DebtorAddressFull | varchar | 602 | √ | null |
|
|
||
| DebtorAddressComma | varchar | 8000 | √ | null |
|
|
||
| StudentSurname | varchar | 30 | √ | null |
|
|
||
| StudentPreferred | varchar | 20 | √ | null |
|
|
||
| StudentReference | varchar | 53 | √ | null |
|
|
||
| CurrentSemesterOnlyFlag | int | 4 | null |
|
|
|||
| DebtorStatementGroup | varchar | 10 | √ | null |
|
|
Table contained 0 rows