search

TechnionYP5779 / team1

Git repo of team 1 of the yearly project technion CS
6 stars 3 forks source link

Update parking DB fields #188

Closed ofiralexi closed 5 years ago

ofiralexi commented 5 years ago

Description: In the wiki under image There is a description of the different tables of the project. Please give more information about the columns. For example names, constraints.

yoavz1997 commented 5 years ago

Note that in the current sprint a parking spot is purchased so there is no need for the Transaction table and in the Parking table another column with the new owner is added to indicate that the parking spot is taken. This corresponds to #193

yoavz1997 commented 5 years ago

Fixed the wiki page https://github.com/TechnionYP5779/team1/wiki/Parking-Space-Management-Idea

ofiralexi commented 5 years ago

@yoavz1997 you mentioned that for the current sprint there is no need in transaction table. However there is one in the wiki page. So do we have a transaction table or not ?

yoavz1997 commented 5 years ago

The scheme in the wiki page is the official one, for the entire project. On the current sprint, the layout will not include the Transaction table, and an "owner" column will be added to the Parking Spot table (which will be a foreign key from the User table) to indicate by whom (if any) the parking was purchased.

ofiralexi commented 5 years ago

Interesting. I believe that this scheme should be more extended for more complicated features (filtering by shadow, soil, rank and reviews etc... ). But they do not conceren this sprint, where the current schema does sufficient , and it is probably best discussed in the next team meeting for next sprints . Closing #79