Changes between Version 2 and Version 3 of RelationalDesign

Timestamp:

12/02/22 23:42:08 (18 months ago)

Author:

201085

Comment:

--

RelationalDesign

@@ -1 @@
-== Логички и физички дизајн - Креирање база податоци (со SQL DDL)
-
-\\
-
 === Релациска шема со мапирачка трансформација\\
 
@@ -11 +7 @@
 ----
 
-Users ( __**userId**__, **userName**, **userSurname**, **userUsername**, **userPassword**, **userPhoneNumber**, **userEmail**, roleId*(Roles), userPictureUrl)
-
 Roles (__**roleId**__, **roleName**, roleDescription)
 
-Products (__**productId**__, **productName**, **postDate**, manufacturerId*(Manufacturers), categoryId*(Categories), charcteristicId*(Characteristics))
+Users ( __**userId**__, **userUsername**, **userPassword**, **userName**, **userSurname**, userPictureUrl, **userEmail**, **userPhoneNumber**, roleId*(Roles))
 
-Product Intances (__**productIntanceId**__, **productIntancePrice**, productId*(Products), storeId*(Stores))
+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**)
 
-Manufacturers (__**manufacturerId**__, **manufactuterName**, **manufacturerCountry**)
+Product Intances (__**productInstanceId**__, **productInstancePrice**, **productId***(Products), **storeId***(Stores))
 
-Categories (__**categoryId**__, **categoryName**, parentCategory)
-
-Characteristics (__**characteristicId**__, **characteristicDescription**)
-
-User Favourites (__**userFavouriteId**__, userId*(Users), productId*(Products))
-
-Comments (__**commentId**__, **commentText**,  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))
-
-[[span(style=color: #1c76ad, belongs_to )]] (categoryId*(Categories), productid*(Products))
+[[span(style=color: #1c76ad, belongs_to )]] (**productId***(Products), **categoryId***(Categories))
 
 ----
@@ -43 +39 @@
 === DDL скрипта за бришење на табелите и креирање на табелите\\
 
+[attachment:kreiranje.sql]
+
 === DML скрипта за полнење на табелите со податоци\\
 
-=== Релациски дијаграм (DBeaver) \\
+[attachment:polnenje.sql]
 
+=== Релациски дијаграм изваден од DBeaver \\
+
+[[Image(schema.png)]]