Changes between Version 29 and Version 30 of RelationalModel


Ignore:
Timestamp:
12/14/24 17:48:27 (5 weeks ago)
Author:
153093
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalModel

    v29 v30  
    1111=== Табели
    1212
    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**)
    2626
    2727=== DDL скрипта за бришење на табелите и креирање на табелите