Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each attendance record, auto-incrementing integer |
||||
| Name | nvarchar | 510 | √ | null |
|
|
Session name - Descriptive name of the educational session or activity for identification |
||||
| Description | nvarchar | 1000 | √ | null |
|
|
Session description - Detailed description of the educational content, objectives, and activities |
||||
| Archive | bit | 1 | √ | null |
|
|
Archive status - Boolean flag indicating if this attendance record is archived for historical data management |
||||
| fkTutionAttendanceCodesId | int | 4 | √ | null |
|
|
Attendance code reference - Foreign key linking to TutionAttendanceCodes for standardized attendance classification |
||||
| StartTime | varchar | 20 | √ | null |
|
|
Session start time - When the educational session began for scheduling and duration tracking |
||||
| EndTime | varchar | 20 | √ | null |
|
|
Session end time - When the educational session concluded for duration calculation and scheduling |
||||
| fkEnrollmentID | int | 4 | √ | null |
|
|
Enrollment reference - Foreign key linking to student enrollment record for academic tracking |
||||
| Date | date | 20 | √ | null |
|
|
Session date - Calendar date when the educational session occurred for chronological organization |
||||
| Deleted | bit | 1 | √ | null |
|
|
Soft delete flag - Boolean indicating if attendance record is logically deleted but retained for audit |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update to the attendance record |
||||
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When the attendance record was most recently updated |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Record creator - User ID who initially created the attendance record for accountability |
||||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the attendance record was first created |
||||
| TimeSession | nvarchar | 100 | √ | null |
|
|
Session duration - Length of the educational session for billing and scheduling purposes |
||||
| Note | nvarchar | 1073741823 | √ | null |
|
|
Session notes - Additional notes about the session, student performance, or special circumstances |
||||
| UserID | int | 4 | √ | null |
|
|
Student user ID - Reference to the student user account for attendance tracking |
||||
| CurrentStatus | nvarchar | 1073741823 | √ | null |
|
|
Current attendance status - Real-time status of student attendance and participation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Attendan__3214EC27345EC57D | Primary key | Asc | ID |