InsertParkingSpace & SelectParkingSpace doesn't show all possible parking space types
Closed this issue · 8 comments
Here is what it shows:
Here are the space types that are in the database:
even for the Select Parking Space page, you could show all possible types then say or show nothing found. you currently look at parking spaces to get the types, so it only shows the space types that are currently in use, you should look at our rates type
That's because the parking space table hasn't been populated with any spots of of those types.
but you should be able to add a space of that type given that it exists in the rates table, no? The lot doesnt currently have any medium size spaces but given that it exists in the rates table, you should be able to add a space of that type.
Parking Spaces' space_type references Rates:
FOREIGN KEY (Space_Type) References Rate(Rate_Type)
Um looking back at our submissions for the milestones Space_Type is not a FK when did we change that?
In the normalization, we incorrectly created a M:M table for a space and a rate. However a space can only have one rate. So it is correctly stored in the space now. Was a recent change. There’s a commit for it.
Ok I'll take a look tomorrow.
fixed it!