Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each attendance record |
||||
| fkEnrollmentID | int | 4 | null |
|
|
Enrollment reference - Links to Enrollments table for the student/client enrollment |
|||||
| CurrentStatus | nvarchar | 1073741823 | √ | null |
|
|
Attendance status - Current attendance status (Present, Absent, Late, etc.) |
||||
| Date | date | 20 | √ | null |
|
|
Attendance date - Date of the attendance record |
||||
| TimeSession | nvarchar | 100 | √ | null |
|
|
Session time - Time period or session for the attendance |
||||
| SignInTime | datetime | 16,3 | √ | null |
|
|
Sign-in time - Timestamp when student/client signed in |
||||
| SignOutTime | datetime | 16,3 | √ | null |
|
|
Sign-out time - Timestamp when student/client signed out |
||||
| Note | nvarchar | 1073741823 | √ | null |
|
|
Attendance notes - Notes about the attendance or any issues |
||||
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Soft delete flag for audit trail purposes |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the attendance record |
||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Timestamp when the record was created |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the record |
||||
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Timestamp of the most recent update |
||||
| StartTime | varchar | 20 | √ | null |
|
|
Session start time - Start time for the session |
||||
| EndTime | varchar | 20 | √ | null |
|
|
Session end time - End time for the session |
||||
| fkTutionAttendanceCodesId | int | 4 | √ | null |
|
|
Attendance code - Links to attendance code classification |
||||
| UserID | int | 4 | √ | null |
|
|
Staff reference - Links to AccessUser table for the staff member recording attendance |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Attendances | Primary key | Asc | Id |
Relationships
Close relationships within degrees of separation
