Bathroom data - Pittsburgh Building
Closed this issue · 0 comments
dong-eileen commented
Gather real bathroom data on Pittsburgh Building.
Update the bathroom data spreadsheet.
Backend:
- Edit data.sql
Insert the following into data.sql:
-
In building table:
-- INSERT INTO building (proper_name, region_id) VALUES ('Pittsburgh Building', 3); -
In building name table:
-- INSERT INTO building_name (name, building_id) VALUES ('Pittsburgh Building', INSERT NEW BUILDING ID HERE);
-- INSERT INTO building_name (name, building_id) VALUES ('Lally School of Management', INSERT NEW BUILDING ID HERE);
-- INSERT INTO building_name (name, building_id) VALUES ('Pittsburgh', INSERT NEW BUILDING ID HERE); -
Insert floor data
-
Insert floor plan data
-
Insert bathroom data
Look at existing data.sql for example queries and format.