AttendanceHistory


Description

Attendance modification history tracking all changes made to attendance records for audit and accountability purposes. This audit table maintains a complete history of attendance modifications including who made changes, when they were made, and what actions were performed for compliance and data integrity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null

Primary key - Unique identifier for each attendance history record
fkUserID int 4 null
AccessUser.UserID FK_AttendanceHistory_AccessUser R

User reference - Links to AccessUser table for the person who made the attendance change
fkAttendanceID int 4 null
Attendances.Id FK_AttendanceHistory_Attendances R

Attendance reference - Links to Attendances table for the attendance record that was modified
Time datetime 16,3 √ null

Action timestamp - Date and time when the attendance change was made
Action nvarchar 100 √ null

Action description - Description of what action was performed (Created, Updated, Deleted, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK_AttendanceHistory Primary key Asc Id

Relationships

Close relationships within degrees of separation