Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| UserID | int | 4 | √ | null |
|
|
||
| SpouseID | int | 4 | √ | null |
|
|
||
| StudentID | int | 4 | null |
|
|
|||
| Given1 | varchar | 20 | null |
|
|
|||
| surname | varchar | 30 | null |
|
|
|||
| StudentCampus | varchar | 3 | null |
|
|
|||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| NameExternal | varchar | 100 | null |
|
|
|||
| CFPDisplayYear | int | 4 | √ | null |
|
|
||
| CFP | varchar | 1 | null |
|
|
|||
| ReportsFlag | int | 4 | null |
|
|
|||
| CommunityID | int | 4 | null |
|
|
|||
| StudentFlag | int | 4 | null |
|
|
|||
| FutureStudentFlag | int | 4 | null |
|
|
|||
| PastStudentFlag | int | 4 | null |
|
|
|||
| StudentContactFlag | int | 4 | null |
|
|
|||
| CurrentFileYearStudent | int | 4 | null |
|
|
|||
| CurrentFileSemesterStudent | int | 4 | null |
|
|
|||
| HasPrimaryID | int | 4 | √ | null |
|
|
||
| StudentContactReportsFlag | bit | 1 | √ | null |
|
|
||
| PastStudentContactReportsFlag | bit | 1 | √ | null |
|
|
||
| FutureStudentContactReportsFlag | bit | 1 | √ | null |
|
|
||
| NormalMailFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows