Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each attendance code, auto-incrementing integer |
||||
| Name | nvarchar | 510 | √ | null |
|
|
Code name - Display name of the attendance code for user interface and reporting |
||||
| Description | nvarchar | 1000 | √ | null |
|
|
Code description - Detailed explanation of what this attendance code represents and when to use it |
||||
| Archive | bit | 1 | √ | null |
|
|
Archive status - Boolean flag indicating if this attendance code is archived and no longer active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__TutionAt__3214EC27308E3499 | Primary key | Asc | ID |