ClassRoomsTeachers


Description

Classroom teacher assignments managing the assignment of teachers to specific classrooms with date tracking. This table tracks which teachers are assigned to which classrooms including active and inactive dates to support teacher scheduling, classroom management, and educational program staffing coordination.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null

Primary key - Unique identifier for each teacher assignment
ClassroomId int 4 √ null

Classroom reference - Links to ClassRooms table for the assigned classroom
UserId int 4 √ null

Teacher reference - Links to AccessUser table for the assigned teacher
ActiveDate datetime 16,3 √ null

Active date - Date when the teacher assignment becomes active
InactiveDate datetime 16,3 √ null

Inactive date - Date when the teacher assignment becomes inactive
DeletedDate datetime 16,3 √ null

Deletion date - Soft delete timestamp for audit trail purposes
Status nvarchar 40 √ null

Assignment status - Current status of the teacher assignment

Indexes

Constraint Name Type Sort Column(s)
PK__ClassRoo__3214EC072C5DE2CC Primary key Asc Id

Relationships

Close relationships within degrees of separation