Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AcID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| AttendanceCodeID | Unknown | 0 | null |
|
|
Primary key - AttendanceCode unique identifier for each attendance code |
||
| Code | varchar | 10 | √ | null |
|
|
Code identifier - Standardized code or identifier for AttendanceCode classification |
|
| CodeDescription | varchar | 255 | √ | null |
|
|
Code description - Detailed description of what the attendance code represents |
|
| CodeValue | Unknown | 0 | null |
|
|
Code value - Short code or abbreviation for the attendance status |
||
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this attendance code is currently available for use |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AttendanceCode | Primary key | Asc | AcID |