AttendanceMaster


Columns

Column Type Size Nulls Auto Default Children Parents Comments
AttendanceMasterSeq int identity 4 √ null
AttendanceMaster.SeqLinkedTo FK_AttendanceMaster_SeqLinkedTo R
tAttendances.AttendanceMasterSeq FK_tAttendances_AttendanceMaster R
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
FileType varchar 5 null
FileYear int 4 null
FileSemester int 4 null
ClassCampus varchar 3 ('')
ClassCode varchar 15 ('')
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 ('')
ClassCancelledFlag bit 1 ((0))
AttendanceOfficerModeFlag bit 1 ((0))
SystemProcessNumber int 4 ((0))
SeqLinkedTo int 4 √ null
AttendanceMaster.AttendanceMasterSeq FK_AttendanceMaster_SeqLinkedTo R
MarkRollAsMultiPeriodFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_AttendanceMaster_AttendanceMasterSeq Primary key Asc AttendanceMasterSeq
AK_AttendanceMaster_ Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc FileType + FileYear + FileSemester + ClassCampus + ClassCode + AttendanceDate + AttendancePeriod
AK_AttendanceMaster_AttendanceDate Performance Asc AttendanceDate
AK_AttendanceMaster_AttendanceDate_includes Performance Asc AttendanceDate
AK_AttendanceMaster_AttendanceDateTimeFrom_AttendanceDateTimeTo_includes Performance Asc/Asc AttendanceDateTimeFrom + AttendanceDateTimeTo
AK_AttendanceMaster_SeqLinkedTo_AttendancePeriod Performance Asc/Asc SeqLinkedTo + AttendancePeriod
AK_AttendanceMaster_SeqLinkedTo_AttendancePeriod_includes Performance Asc/Asc SeqLinkedTo + AttendancePeriod

Relationships

Close relationships within degrees of separation