Changes between Version 30 and Version 31 of RelationalModel

Timestamp:

12/14/24 19:13:39 (5 weeks ago)

Author:

153093

Comment:

--

RelationalModel

@@ -15 +15 @@
 * Wine (**__Wine_Id__**, **Wine_Type_Id***(Wine_Type), **Wine_Name**, **Base_Price**, **Year_Produced**)
 * Customer_Type (**__Customer_Type_Id__**, **Customer_Type_Name**, **Customer_Type_Description**)
-* Customer (**__Customer_Id__**, **Customer_Type_Id***(Customer_Type), **Address_Id***(Address), **Customer_Name**, **Customer_Email**, **Phone_Number**)
+* Customer (**__Customer_Id__**, **Customer_Type_Id***(Customer_Type), **Address_Id***(Address), **Customer_Name**, **Customer_Email**, **Customer_Phone_Number**)
 * Vehicle_Type (**__Vehicle_Type_Id__**, **Vehicle_Type_Name**)
 * Vehicle (**__Vehicle_Id__**, **Vehicle_Type_Id***(Vehicle_Type), **Make**, **Model**, **Registration**, **Capacity**)
@@ -23 +23 @@
 * Shipment (**__Shipment_Id__**, **Employee_Id***(Employee), **Payment_Id***(Payment), **Vehicle_Id***(Vehicle), **Shipment_Date**)
 * Payment (**__Payment_Id__**, **Payment_Status**)
-* Load (**__Load_Id__**, **Shipment_Id***(Shipment),**Customer_Id***(Customer), **Wine_Id***(Wine), **Quantity**, **Base_Price**, **Agreed_Price**)
-
+* Shipment_Load (**__Shipment_Id__***(Shipment),**__Customer_Id__***(Customer), **__Wine_Id__***(Wine), **Quantity**, **Base_Price**, **Agreed_Price**)
+* Shipment_has_expense_of_Expense_Type(**__Shipment_Id__***(Shipment),**__Expense_Type_Id__***(Expense_Type), **Amount**)
+* Employee_Drives_Vehicle(**__Employee_Id__***(Employee),**__Vehicle_Id_***(Vehicle))
 === DDL скрипта за бришење на табелите и креирање на табелите