tbl1_Rooms¶
- Description
This tables lists classrooms for use in room assignments etc
- Footnote
Would be nice one day to have this pull and automatically update from Rutgers central systems. But until we have not identified a single trusted source with the complete list.
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
room_campus_code varchar(10) DEFAULT NULL
- Description
BUS, C/D, CAC, LIV
- Options
display="true", null="true", search="false", type=""
room_bldg_code varchar(255) DEFAULT NULL
- Description
Building Code for building
- Options
display="true", null="true", search="false", type=""
room_number varchar(255) DEFAULT NULL
- Description
Room number
- Options
display="true", null="true", search="false", type=""
room_capacity int(11) DEFAULT NULL
- Description
Room capacity
- Options
display="true", null="true", search="false", type=""
room_IsAccessible bit(1) DEFAULT NULL
- Description
TRUE if room is accessible, FALSE otherwise
- Options
display="true", null="true", search="false", type=""
room_RestrictedUse bit(1) DEFAULT NULL
- Description
TRUE if a university designated restricted room
- Options
display="true", null="true", search="false", type=""
room_Notes varchar(255) DEFAULT NULL
- Description
Room notes
- Options
display="true", null="true", search="false", type=""
room_LectureHall bit(1) DEFAULT NULL
- Description
TRUE if room is a lecture hall
- Options
display="true", null="true", search="false", type=""
GoodForMath bit(1) DEFAULT NULL
- Description
TRUE by default. Set to FALSE if we learn for some reason that room is bad to teach math in (eg no chalkboards or whatever)
- Options
display="true", null="true", search="false", type=""
contact_email varchar(255) DEFAULT NULL
- Description
Contact person for this room, if appropriate (typically used when it is room managed by our department)
- Options
display="true", null="true", search="false", type=""
GoodForFinals bit(1) DEFAULT NULL
- Description
TRUE if room is good for final exams
- Options
display="true", null="true", search="false", type=""
MathRoom bit(1) DEFAULT NULL
- Description
TRUE if the room is one that we “own” – ie internally managed by math department.
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""