=== Релациска шема со мапирачка трансформација\\

Примарни клучеви означени со __underline__\\
Надворешни клучеви означени со * и табела кон која покажува\\
Not null атрибути означени со **bold**\\

----

Roles (__**roleId**__, **roleName**, roleDescription)

Users ( __**userId**__, **userUsername**, **userPassword**, **userName**, **userSurname**, userPictureUrl, **userEmail**, **userPhoneNumber**, roleId*(Roles))

Manufacturers (__**manufacturerId**__, **manufactuterName**, **manufacturerCountry**)

Categories (__**categoryId**__, parentCategoryId, **categoryName**)

Product Characteristics (__**characteristicId**__, **characteristicDescription**)

Products (__**productId**__, **productName**, **postDate**, **manufacturerId***(Manufacturers), **categoryId***(Categories), **characteristicId***(Product Characteristics))

User Favourites (__**userFavouriteId**__, **userId***(Users), **productId***(Products))

User Comments (__**commentId**__, **userComment**,  **userId***(Users), **productId***(Products))

Ratings (__**ratingId**__, **ratingValue**,  **userId***(Users), **productId***(Products))

WatchList Products (__**watchListProductId**__, **priceLimit**, **userId***(Users), **productId***(Products))

Product Images (__**productImageId**__, **productImageUrl**, **productId***(Products))

Stores (__**storeId**__, **storeName**)

Product Intances (__**productInstanceId**__, **productInstancePrice**, **productId***(Products), **storeId***(Stores))

[[span(style=color: #1c76ad, belongs_to )]] (**productId***(Products), **categoryId***(Categories))

----

=== DDL скрипта за бришење на табелите и креирање на табелите\\

[attachment:kreiranje.sql]

=== DML скрипта за полнење на табелите со податоци\\

[attachment:polnenje.sql]

=== Релациски дијаграм изваден од DBeaver \\

[[Image(schema.png)]]