Changes between Version 25 and Version 26 of RelationalDesign


Ignore:
Timestamp:
07/10/23 09:14:35 (19 months ago)
Author:
201144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v25 v26  
    88----
    99
    10 * Faculty(**__FacultyID__,CityName*(City),Fname**)
    11 * Building(**__BuildingID__,CityName*(City),Building_Adress**)
    12 * City(**__CityName__**)
     10* Faculty(**__FacultyID__,CityID*(City),Fname**)
     11* Building(**__BuildingID__,CityID*(City),Building_Adress**)
     12* City(**__CityID__**,CityName)
    1313* Apartment(**__ApartmentID__, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size**)
    1414* ApartmentAgreement(**__AgreementID__, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent**)
    1515* User(**__UserID__,Name,Surname,Password,Phone_Number**,City_of_Residency)
    16 * Post(**__PID__, CityName*(City), Num_Roomates, Price, Date_Posted**, Description)
     16* Post(**__PID__, CityID*(City), Num_Roomates, Price, Date_Posted**, Description)
    1717* Apartment_photos(**__PostID*(OwnerPost),Apartment_photos__**)
    1818* Admin(**__UserID*(User)__, Role**)
    … …  
    2121* StudentPost(**__PID*(Post)__,UserID*(Student)**)
    2222* OwnerPost(**__PID*(Post)__, ApartmentID*(Apartment),UserID(Owner)**)
    23 * Moderates_Posts_For(**__CityName*(City),UserID*(Admin)__**)
     23* Moderates_Posts_For(**__CityID*(City),UserID*(Admin)__**)
    2424* Student_Signs(**__UserID*(Student),AgreementID*(Agreement)__**)
    2525