Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StudentID | int | 4 | null |
|
|
|||
| ClassCampus | varchar | 3 | null |
|
|
|||
| ClassCode | varchar | 15 | null |
|
|
|||
| StaffID | int | 4 | null |
|
|
|||
| AttendancePeriod | tinyint | 1 | null |
|
|
|||
| AttendanceDayNumber | smallint | 2 | √ | null |
|
|
||
| TimetableGroup | varchar | 15 | null |
|
|
|||
| AttendanceDateTimeFrom | datetime | 16,3 | √ | null |
|
|
||
| AttendanceDateTimeTo | datetime | 16,3 | √ | null |
|
|
||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| StudentSurname | varchar | 30 | null |
|
|
|||
| StaffPreferred | varchar | 20 | null |
|
|
|||
| StaffSurname | varchar | 30 | null |
|
|
|||
| StaffMailName | varchar | 100 | null |
|
|
|||
| Parent1Preferred | varchar | 20 | √ | null |
|
|
||
| Parent1Surname | varchar | 30 | √ | null |
|
|
||
| Parent1MailNamePrimary | varchar | 100 | √ | null |
|
|
||
| Parent1DefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| Parent1DefaultEmail | varchar | 201 | √ | null |
|
|
||
| Parent1HomePhone | varchar | 15 | √ | null |
|
|
||
| Parent1OccupPhone | varchar | 15 | √ | null |
|
|
||
| Parent2Preferred | varchar | 20 | √ | null |
|
|
||
| Parent2Surname | varchar | 30 | √ | null |
|
|
||
| Parent2MailNamePrimary | varchar | 100 | √ | null |
|
|
||
| Parent2DefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| Parent2DefaultEmail | varchar | 201 | √ | null |
|
|
||
| Parent2HomePhone | varchar | 15 | √ | null |
|
|
||
| Parent2OccupPhone | varchar | 15 | √ | null |
|
|
Table contained 0 rows