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

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

* 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)__**)

== DDL скрипта за бришење на табелите и креирање на табелите
[attachment:kreiranje.sql kreiranje.sql]

== DML скрипта за полнење на табелите со податоци
[attachment:sql insert script.sql kreiranje.sql]