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


=== Ознаки


* Примарните клучеви се означени со bold и underline
* Надворешните клучеви се означени со *
* Задолжителни атрибути, односно not null со bold

=== Табели

* Address (**__Address_Id__**, **Street**, **City**, **Postcode**, **Street_Number**)
* Wine_Type (**__Wine_Type_Id__**, **Wine_Type_Name**, **Wine_Type_Description**, **Wine_Type_Region**)
* 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**, **Customer_Phone_Number**)
* Vehicle_Type (**__Vehicle_Type_Id__**, **Vehicle_Type_Name**)
* Vehicle_Details (**__Vehicle_Details_Id__**, **Vehicle_Type_Id***(Vehicle_Type), **Make**, **Model**, **Capacity**)
* Vehicle (**__Vehicle_Id__**, **Vehicle_Details_Id***(Vehicle_Details), **Registration**)
* Expense_Type (**__Expense_Type_Id__**, **Expense_Type_Name**, **Expense_Type_Description**)
* Employee (**__Employee_Id__**, **Employee_Name**, **Employee_Surname**)
* Warehouse (**__Warehouse_Id__**, **Address_Id***(Address), **Warehouse_Name**)
* Shipment (**__Shipment_Id__**, **Employee_Id***(Employee), **Payment_Id***(Payment), **Vehicle_Id***(Vehicle), **Shipment_Date**)
* Payment (**__Payment_Id__**, **Payment_Status**)
* 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 скрипта за бришење на табелите и креирање на табелите


[attachment:V2_Init_DB.sql]

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


[attachment:V2_Polnenje_DB.sql]

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

[[Image(ERDiagramDBeaverV3.png)]]