| 106 | | * ''project.rooms'' – contains information about rooms, capacity, and room type. |
| 107 | | * ''project.buildings'' – contains the building name and address of each room. |
| 108 | | * ''project.room_equipment'' – used when the requester searches for a room with specific equipment. |
| 109 | | * ''project.room_equipment'' – used to search for equipment assigned to rooms; this table was created from the has_equipment M:N relationship in Phase P2. |
| 110 | | * ''project.equipment'' – contains equipment names. |
| 111 | | * ''project.reservations'' – used to check whether a room is already reserved for the selected date and time interval. |
| | 106 | * ''project.rooms'' – contains information about rooms, capacity, and room type. |
| | 107 | * ''project.buildings'' – contains the building name and address of each room. |
| | 108 | * ''project.room_equipment'' – used when the requester searches for a room with specific equipment; this table was created from the ''has_equipment'' M:N relationship in Phase P2. |
| | 109 | * ''project.equipment'' – contains equipment names. |
| | 110 | * ''project.reservations'' – used to check whether a room is already reserved for the selected date and time interval. |
