13 | | * Address (**__AddressId__**, **Street**, **City**, **!PostCode**, **!PhoneNumber**, **!StreetNumber**) |
14 | | * !WineType (**__WineTypeId__**, **!WineTypeName**, **!WineTypeDescription**, **!WineTypeRegion**) |
15 | | * Wine (**__WineId__**, **!WineTypeID***(!WineType), **!WineName**, **!BasePrice**, **!YearProduced**) |
16 | | * !CustomerType (**__CustomerTypeId__**, **!CustomerTypeName**, **!CustomerTypeDescription**) |
17 | | * Customer (**__CustomerId__**, **!CustomerTypeId***(!CustomerType), **!AddressId***(Address), **!CustomerName**, **!CustomerEmail**) |
18 | | * !VehicleType (**__VehicleTypeId__**, **!VehicleTypeName**) |
19 | | * Vehicle (**__VehicleId__**, **!VehicleTypeId***(!VehicleType), **Make**, **Model**, **Registration**, **Capacity**) |
20 | | * !ExpenseType (**__ExpenseTypeId__**, **!ExpenseTypeName**, **!ExpenseTypeDescription**) |
21 | | * Employee (**__EmployeeId__**, **!EmployeeName**, **!EmployeeSurname**) |
22 | | * Warehouse (**__WarehouseId__**, **!AddressId***(Address), **!WarehouseName**) |
23 | | * Shipment (**__ShipmentId__**, **!EmployeeId***(Employee), **!PaymentId***(Payment), **!VehicleId***(Vehicle), **!ShipmentDate**) |
24 | | * Payment (**__PaymentId__**, **!PaymentStatus**) |
25 | | * Load (**__LoadId__**, **!ShipmentId***(Shipment),**!CustomerId***(Customer), **!WineId***(Wine), **Quantity**, **!BasePrice**, **!AgreedPrice**) |
| 13 | * Address (**__Address_Id__**, **Street**, **City**, **Postcode**, **Street_Number**) |
| 14 | * Wine_Type (**__Wine_Type_Id__**, **Wine_Type_Name**, **Wine_Type_Description**, **Wine_Type_Region**) |
| 15 | * Wine (**__Wine_Id__**, **Wine_Type_Id***(Wine_Type), **Wine_Name**, **Base_Price**, **Year_Produced**) |
| 16 | * Customer_Type (**__Customer_Type_Id__**, **Customer_Type_Name**, **Customer_Type_Description**) |
| 17 | * Customer (**__Customer_Id__**, **Customer_Type_Id***(Customer_Type), **Address_Id***(Address), **Customer_Name**, **Customer_Email**, **Phone_Number**) |
| 18 | * Vehicle_Type (**__Vehicle_Type_Id__**, **Vehicle_Type_Name**) |
| 19 | * Vehicle (**__Vehicle_Id__**, **Vehicle_Type_Id***(Vehicle_Type), **Make**, **Model**, **Registration**, **Capacity**) |
| 20 | * Expense_Type (**__Expense_Type_Id__**, **Expense_Type_Name**, **Expense_Type_Description**) |
| 21 | * Employee (**__Employee_Id__**, **Employee_Name**, **Employee_Surname**) |
| 22 | * Warehouse (**__Warehouse_Id__**, **Address_Id***(Address), **Warehouse_Name**) |
| 23 | * Shipment (**__Shipment_Id__**, **Employee_Id***(Employee), **Payment_Id***(Payment), **Vehicle_Id***(Vehicle), **Shipment_Date**) |
| 24 | * Payment (**__Payment_Id__**, **Payment_Status**) |
| 25 | * Load (**__Load_Id__**, **Shipment_Id***(Shipment),**Customer_Id***(Customer), **Wine_Id***(Wine), **Quantity**, **Base_Price**, **Agreed_Price**) |