Room, 139 (ver3.6.1)
This table stores information about actual rooms within a school that can be used for scheduling purposes. This is copied from ScheduleRooms when the schedule is published.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Building | 3.6.1 | Varchar(10) | Building where this room is located. This is optional. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Department | 3.6.1 | Varchar(12) | Name of department this room belongs to or is used by. See Department. |
Facilities | 3.6.1 | Varchar(50) | Any special characteristics of the room, such as Computer lab. |
House | 3.6.1 | Varchar(10) | If this room is located in a house, then its name would be maintained here, such as school that separate 9,10 grade into a house and 11,12 into another. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 3.6.1 | Varchar(30) | Name associated to this room, such as Gym, Classroom. |
Occupancy_Maximum | 3.6.1 | Number(10,0) | Maximum number of students who can be in this room. |
RoomInfo_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
Room_Number | 3.6.1 | Varchar(10) | Number given to this room. Indexed. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |