Changes between Version 5 and Version 6 of RelationalDesign


Ignore:
Timestamp:
11/15/24 17:53:42 (3 months ago)
Author:
185022
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v5 v6  
    1010 * * референцира до DRIVER (user_id)
    1111 * !** референцира до WAREHOUSE (warehouse_id)
    12 * DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id*)
     12* DELIVERY (__'''delivery_id'''__, delivery_status, delivery_date_created, delivery_date, vehicle_id*, delivery_status_id!**)
    1313 * * референцира до VEHICLE (vehicle_id)
    14 * PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*)
     14 * !** референцира до DELIVERY_STATUS (delivery_status_id)
     15* PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*, pro_forma_status_id!**)
    1516 * * референцира до ORDERS (order_id)
     17 * !** референцира до PRO_FORMA_STATUS (pro_forma_status_id)
    1618* ARTICLE (__'''article_id'''__, article_price, article_image, article_name, article_weight, category_id*)
    1719 * * референцира до CATEGORY (category_id)
    18 * ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!***)
     20* ORDERS (__'''order_id'''__, order_date, order_status, order_sum, order_fulfillment_date, delivery_id*, pro_forma_id!**, customer_id!***, order_status_id!**!**)
    1921 * * референцира до DELIVERY (delivery_id)
    2022 * !** референцира до PRO_FORMA (pro_forma_id)
    2123 * !*** референцира до CUSTOMER(user_id)
     24 * !**!** референцира до ORDER_STATUS(order_status_id)
    2225* CITY (__'''city_id'''__, city_name)
    2326* MANAGER (__'''user_id*''''__, warehouse_id!**)
     
    3639 * * референцира до ARTICLE (article_id)
    3740 * !** референцира до ORDERS (order_id)
    38 === Релации
    39 * IN_STOCK (__'''city_id*, warehouse_id!**'''__)
    40  * * референцира до CITY (city_id)
    41  * !** референцира до WAREHOUSE (warehouse_id)
     41* ORDER_STATUS (__**order_status_id**__, order_status_name, order_status_description)
     42* DELIVERY_STATUS (__**delivery_status_id**__, delivery_status_name, delivery_status_description)
     43* PRO_FORMA_STATUS (__**pro_forma_status_id**__, pro_forma_status_name, pro_forma_status_description)
    4244
    4345== DDL скрипта за креирање и бришење на табелите