wkAttendanceMaster


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkAttendanceMasterSeq int identity 4 √ null
wkAttendances.wkAttendanceMasterSeq FK_wkAttendances_wkAttendanceMaster R
AttendanceMasterSeq int 4 √ null
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
FileType varchar 5 null
FileYear int 4 null
FileSemester int 4 null
ClassCampus varchar 3 ('')
ClassCode varchar 15 null
StaffID int 4 null
AttendanceDate datetime 16,3 null
AttendancePeriod tinyint 1 null
AttendanceDateTimeFrom datetime 16,3 √ null
AttendanceDateTimeTo datetime 16,3 √ null
AttendanceDayNumber smallint 2 √ null
TimetableGroup varchar 15 ('')
HoldFlag bit 1 ((0))
AttendanceOfficerModeFlag bit 1 ((0))
AttendancePeriodDescription varchar 100 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_wkAttendanceMaster Primary key Asc wkAttendanceMasterSeq

Relationships

Close relationships within degrees of separation