Classrooms_VW


Description

Classroom information view providing a consolidated view of active classrooms with site information. This view combines classroom data with site names to support classroom management, reporting, and user interface displays for educational program administration and classroom assignment workflows.

Columns

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

Classroom ID - Unique identifier for the classroom

Name nvarchar 400 null

Classroom name - Name or identifier of the classroom

Description nvarchar 1073741823 null

Classroom description - Detailed description of the classroom

Ratio nvarchar 100 null

Student-teacher ratio - Ratio specification for classroom capacity

Site varchar 50 null

Site name - Name of the site where the classroom is located

Relationships

View Definition


Possibly Referenced Tables/Views