tbl1_Buildings — Rutgers Building Codes¶
- Description
This table translates Rutgers building codes and numbers to building names.
- Source
User data entry.
- Apps
Database, any others?
- Footnote
It appears that Rutges does not have an official list of building codes, so this table is updated by user entry. Some buildings are listed <a href=”https://dcs.rutgers.edu/classrooms/building-identification-codes”>here</a> Additional building lists are provided by scheudling office in a pdf file to office staff once or twice a year. There is also an IMS screen that gives building info. Some research into where we can find a single trusted source might be worth pursuing.
Columns¶
ID int(11) NOT NULL
- Options
display="false", null="false", search="false", type="int"
Bldg_Code varchar(255) DEFAULT NULL
Rutgers Building Code
- Description
Official code of Rutgers building, e.g. HLL for Hill Center.
- Options
display="true", null="false", search="false", type="str"
Bldg_Name varchar(255) DEFAULT NULL
Rutgers Building Name
- Description
Official name of building used by Rutgers
- Options
display="true", null="false", search="false", type="str"
Bldg_Campus_Code varchar(255) DEFAULT NULL
Rutgers Campus Code
- Description
Campus this building is located on.
- Footnote
Campus abbreviation: BUS=Busch, C/D=Cook Douglass, LIV=Livingston, CAC=College Avenue, NEW=Newark
- Options
display="true", null="false", search="false", type="str"
Bldg_Number smallint(6) DEFAULT NULL
Rutgers Building Number
- Description
Official number assigned to this building by Rutgers.
- Options
display="true", null="true", search="false", type=""
building_notes mediumtext DEFAULT NULL
Building Notes
- Description
Notes about this building entered by Math department staff.
- Options
display="false", null="true", search="false", type="text"
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""
References¶
source=Bldg_Campus_Code;table=tbl1_Campuses;target=Campus_Code