Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| RecipientSeq | tinyint | 1 | √ | null |
|
|
||
| RecipientID | 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 |
|
|
|||
| DebtorName | varchar | 100 | √ | null |
|
|
||
| RecipientMailName | varchar | 100 | √ | null |
|
|
||
| RecipientPrimaryOnlyFlag | smallint | 2 | √ | null |
|
|
||
| DebtorSurname | varchar | 30 | √ | null |
|
|
||
| DebtorPreferred | varchar | 20 | √ | null |
|
|
||
| RecipientSurname | varchar | 30 | √ | null |
|
|
||
| RecipientPreferred | varchar | 20 | √ | null |
|
|
||
| RecipientAddressFull | varchar | 602 | √ | null |
|
|
||
| RecipientAddressComma | 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