Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each classroom |
||||
| Name | nvarchar | 400 | √ | null |
|
|
Classroom name - Name or identifier of the classroom |
||||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Classroom description - Detailed description of the classroom and its purpose |
||||
| Status | nvarchar | 100 | √ | null |
|
|
Classroom status - Current status of the classroom (Active, Inactive, etc.) |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
||||
| Ratio | nvarchar | 100 | √ | null |
|
|
Student-teacher ratio - Ratio specification for classroom capacity |
||||
| SiteId | int | 4 | √ | null |
|
|
Site reference - Links to AgencySite table for the classroom location |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ClassRooms | Primary key | Asc | Id |
Relationships
Close relationships within degrees of separation
