Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
AttendanceSeq | int | 4 | null |
|
|
|||
FileType | varchar | 5 | null |
|
|
|||
FileYear | int | 4 | null |
|
|
|||
FileSemester | int | 4 | null |
|
|
|||
ClassCampus | varchar | 3 | null |
|
|
|||
ClassCode | varchar | 15 | null |
|
|
|||
ID | int | 4 | null |
|
|
|||
AttendanceDate | datetime | 16,3 | null |
|
|
|||
AttendancePeriod | tinyint | 1 | null |
|
|
|||
PossibleAbsenceCode | varchar | 15 | null |
|
|
|||
PossibleDescription | varchar | 100 | √ | null |
|
|
||
AttendedFlag | bit | 1 | null |
|
|
|||
StaffID | int | 4 | null |
|
|
|||
StudentSurname | varchar | 30 | √ | null |
|
|
||
StudentPreferred | varchar | 20 | √ | null |
|
|
||
PossibleReasonCode | varchar | 15 | null |
|
|
|||
AttendanceMasterSeq | int | 4 | null |
|
|
|||
LatearrivalTime | datetime | 16,3 | √ | null |
|
|
||
Gender | varchar | 15 | √ | null |
|
|
||
GenderSynergyMeaning | varchar | 30 | √ | null |
|
|
Table contained 0 rows