Changes between Version 5 and Version 6 of RelationalDesign

Timestamp:

12/18/25 02:43:36 (3 weeks ago)

Author:

221181

Comment:

--

RelationalDesign

@@ -11 +11 @@
 Customer (__'''customerId'''__, '''name''', '''email''', '''phone''', '''address''')
 
-Product (__'''productId'''__, '''name''', '''description''', '''sku''', '''unit_price''', '''reorder_level''', categoryId*(Category), supplierId*(Supplier))
+Product (__'''productId'''__, '''name''', '''description''', '''sku''', '''unit_price''', '''reorder_level''', '''categoryId'''*(Category), '''supplierId'''*(Supplier))
 
 Category (__'''categoryId'''__, '''name''', '''description''')
@@ -19 +19 @@
 Warehouse (__'''warehouseId'''__, '''name''', '''location''', '''capacity''')
 
-Sale (__'''saleId'''__, '''date_time''', '''total_amount''', userId*(Users), customerId*(Customer), warehouseId*(Warehouse))
+Sale (__'''saleId'''__, '''date_time''', '''total_amount''', '''userId'''*(Users), '''customerId'''*(Customer), '''warehouseId'''*(Warehouse))
 
-!SaleItem (__'''saleId*(Sale)'''__, __'''productId*(Product)'''__, '''quantity''', '''unit_price_at_sale''')
+!SaleItem (__'''saleId'''*(Sale)__, __'''productId'''*(Product)__, '''quantity''', '''unit_price_at_sale''')
 
-!PurchaseOrder (__'''poId'''__, '''order_date''', '''expected_delivery_date''', '''status''', supplierId*(Supplier), warehouseId*(Warehouse))
+!PurchaseOrder (__'''poId'''__, '''order_date''', '''expected_delivery_date''', '''status''', '''supplierId'''*(Supplier), '''warehouseId'''*(Warehouse))
 
-!PurchaseOrderItem (__'''poId*(!PurchaseOrder)'''__, __'''productId*(Product)'''__, '''quantity''', '''unit_cost''')
+!PurchaseOrderItem (__'''poId'''*(!PurchaseOrder)__, __'''productId'''*(Product)__, '''quantity''', '''unit_cost''')
 
-!WarehouseStock (__'''warehouseId*(Warehouse)'''__, __'''productId*(Product)'''__, '''quantity_on_hand''', '''last_updated''')
-
+!WarehouseStock (__'''warehouseId'''*(Warehouse)__, __'''productId'''*(Product)__, '''quantity_on_hand''', '''last_updated''')
 
 === DDL скрипта за бришење на табелите и креирање на табелите ===