Changes between Version 21 and Version 22 of RelationalDesign


Ignore:
Timestamp:
12/21/22 15:50:50 (2 years ago)
Author:
201144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v21 v22  
    1515* User(**__UserID__,Name,Surname,Password,Phone_Number**,City_of_Residency)
    1616* Post(**__PID__, CityName*(City), Num_Roomates, Price, Date_Posted**, Description)
    17 * Apartment_photos(**__PID,Apartment_photos__**)
     17* Apartment_photos(**__PhotosID,Apartment_photos__**)
    1818* Admin(**__UserID*(User)__, Role**)
    1919* Owner(**__UserID*(User)__**)
    2020* Student(**__UserID*(User)__,FacultyID*(Faculty)**,Age,Gender)
    2121* StudentPost(**__PID*(Post)__,UserID*(Student)**)
    22 * OwnerPost(**__PID*(Post)__, ApartmentID*(Apartment),UserID(Owner)**,Apartment_photos)
     22* OwnerPost(**__PID*(Post)__, ApartmentID*(Apartment),UserID(Owner)**,PhotosID(Apartment_photos))
    2323* Moderates_Posts_For(**__CityName*(City),UserID*(Admin)__**)
    2424* Student_Signs(**__UserID*(Student),AgreementID*(Agreement)__**)