Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each tuition attendance code |
|
| Name | nvarchar | 510 | √ | null |
|
|
Attendance code name - Name of the attendance code (e.g., ‘Present’, ‘Absent’, ‘Partial Day’) |
|
| Description | nvarchar | 1000 | √ | null |
|
|
Code description - Detailed description of what the attendance code represents |
|
| Archive | bit | 1 | √ | null |
|
|
Archive status - Boolean indicating if the attendance code is archived and no longer active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__TutionAt__3214EC274AE269EC | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
