Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each teacher-classroom assignment, auto-incrementing integer |
|
| ClassroomId | int | 4 | √ | null |
|
|
Classroom reference - Foreign key linking to ClassRooms.Id for the assigned classroom |
|
| UserId | int | 4 | √ | null |
|
|
Teacher reference - Reference to the user/teacher assigned to this classroom |
|
| ActiveDate | datetime | 16,3 | √ | null |
|
|
Assignment start date - When the teacher assignment became active |
|
| InactiveDate | datetime | 16,3 | √ | null |
|
|
Assignment end date - When the teacher assignment ended or became inactive |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this assignment was logically deleted |
|
| Status | nvarchar | 40 | √ | null |
|
|
Assignment status - Current status of the teacher-classroom assignment |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__ClassRoo__3214EC07467D75B8 | Primary key | Asc | Id |