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


=== Ознаки


* Примарните клучеви се означени со 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**, **Phone_Number**)
* Vehicle_Type (**__Vehicle_Type_Id__**, **Vehicle_Type_Name**)
* Vehicle (**__Vehicle_Id__**, **Vehicle_Type_Id***(Vehicle_Type), **Make**, **Model**, **Registration**, **Capacity**)
* 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**)
* Load (**__Load_Id__**, **Shipment_Id***(Shipment),**Customer_Id***(Customer), **Wine_Id***(Wine), **Quantity**, **Base_Price**, **Agreed_Price**)

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


[attachment:V1_Init_DB.sql]

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


[attachment:V1_Polnenje_DB.sql]

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

[[Image(ERDiagram DBeaver.png)]]