Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StaffScheduleSeq | int | 4 | null |
|
|
|||
| eventcode | varchar | 15 | null |
|
|
|||
| EventsSeq | int | 4 | null |
|
|
|||
| EventDescription | varchar | 50 | null |
|
|
|||
| StaffID | int | 4 | null |
|
|
|||
| ScheduleDateTimeFrom | datetime | 16,3 | null |
|
|
|||
| ScheduleTimeFrom | nvarchar | 8000 | √ | null |
|
|
||
| ScheduleDateTimeTo | datetime | 16,3 | null |
|
|
|||
| ScheduleTimeTo | nvarchar | 8000 | √ | null |
|
|
||
| StaffTypeDescription | varchar | 100 | √ | null |
|
|
||
| AttendeeID | int | 4 | null |
|
|
|||
| AttendeeSurname | varchar | 30 | null |
|
|
|||
| AttendeePreferredFormal | varchar | 20 | null |
|
|
|||
| AttendeeGiven1 | varchar | 20 | null |
|
|
|||
| AttendeeGiven2 | varchar | 50 | null |
|
|
|||
| StudentLegalFullName | varchar | 150 | null |
|
|
|||
| StudentPreferred | varchar | 20 | null |
|
|
|||
| AttendedFlag | bit | 1 | √ | null |
|
|
||
| StaffSurname | varchar | 30 | √ | null |
|
|
||
| StaffGiven1 | varchar | 20 | √ | null |
|
|
||
| StaffGiven2 | varchar | 50 | √ | null |
|
|
||
| StaffLegalFullName | varchar | 150 | √ | null |
|
|
||
| StaffPreferred | varchar | 20 | √ | null |
|
|
||
| SubGroupDescription | varchar | 200 | √ | null |
|
|
||
| GroupCode | varchar | 15 | √ | null |
|
|
||
| GroupDescription | varchar | 50 | √ | null |
|
|
Table contained 0 rows