= Логички и физички дизајн

== Релациска шема

* BOLD=not null
* Underline = Primary Key
* * - takes from
----
* Faculty(FacultyID,CityName*(City),Fname)
* Building(BuildingID,CityName*(City),Building_Adress)
* City(CityName)
* Apartment(ApartmentID, BuildingID*(Building),UserID*(Owner),Aparment_Adress,Size)
* ApartmentAgreement(AgreementID, ApartmentID*(Apartment),UserID*(Owner), Date_Signed,Date_Expires,ApartmentRent)
* User(UserID,Name,Surname,Password,Phone_Number,City_of_Residency)
* Post(PID, CityName*(City), Num_Roomates, Price, Date_Posted, Description)
* Apartment_photos(PID,Apartment_photos)
* Admin(UserID*(User), Role)
* Owner(UserID*(User))
* Student(UserID*(User),FacultyID*(Faculty),Age,Gender)
* StudentPost(PID*(Post),UserID*(Student))
* OwnerPost(PID*(Post), ApartmentID*(Apartment),UserID(Owner),Apartment_photos)
* Moderates_Posts_For(CityName*(City),UserID*(Admin))
* Student_Signs(UserID*(Student),AgreementID*(Agreement))