Changes between Version 11 and Version 12 of RelationalDesign


Ignore:
Timestamp:
02/13/25 11:54:12 (9 days ago)
Author:
185022
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v11 v12  
    55== Табели
    66=== Ентитети
     7* ORDER_STATUS (__''order_status_id''__, order_status_name, order_status_description)
     8* DELIVERY_STATUS (__''delivery_status_id''__, delivery_status_name, delivery_status_description)
     9* PRO_FORMA_STATUS (__''pro_forma_status_id''__, pro_forma_status_name, pro_forma_status_description)
     10* WEEKDAY (__''day_id''__, day_name)
    711* CATEGORY (__'''category_id'''__, category_name)
    8 * CITY (__'''city_id'''__, city_name)
    9 * ORDER_STATUS (__**order_status_id**__, order_status_name, order_status_description)
    10 * DELIVERY_STATUS (__**delivery_status_id**__, delivery_status_name, delivery_status_description)
    11 * PRO_FORMA_STATUS (__**pro_forma_status_id**__, pro_forma_status_name, pro_forma_status_description)
    12 * USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_email_conf, user_mobile, user_image, city_id*)
     12* REGION (__''region_id''__, region_name)
     13* CITY (__'''city_id'''__, city_name, region_id*)
     14 * * референцира до REGION (region_id)
     15* WAREHOUSE (__'''wh_id'''__, wh_adr, city_id*)
    1316 * * референцира до CITY (city_id)
    14 * CUSTOMER (__'''user_id*''''__, customer_EDB, customer_company_name, customer_address, customer_open_time, customer_close_time, customer_representative_image)
    15 * WAREHOUSE (__'''warehouse_id'''__, warehouse_address, city_id*)
     17* VEHICLE (__'''veh_id'''__, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg, wh_id*)
     18 * * референцира до WAREHOUSE (wh_id)
     19* USERS (__'''user_id'''__, user_name, user_surname, user_pass, user_salt, user_email, user_active, user_mobile, user_image, clazz_ city_id*)
    1620 * * референцира до CITY (city_id)
    17 * MANAGER (__'''user_id*''''__, warehouse_id!**)
     21* CUSTOMER (__'''user_id*''''__, cust_EDB, cust_company_name, cust_adr, cust_representative_image)
    1822 * * референцира до USER (user_id)
    19  * !** референцира до WAREHOUSE (warehouse_id)
     23* MANAGER (__'''user_id*''''__, wh_id!**)
    2024 * * референцира до USER (user_id)
    21 * VEHICLE (__'''vehicle_id'''__, vehicle_carry_weight, vehicle_service_interval, vehicle_kilometers, vehicle_last_service, vehicle_last_service_km, vehicle_plate, vehicle_vin, vehicle_reg, warehouse_id*)
    22  * * референцира до WAREHOUSE (warehouse_id)
    23 * DRIVER (__'''user_id*''''__, vehicle_id!**)
     25 * !** референцира до WAREHOUSE (wh_id)
    2426 * * референцира до USER (user_id)
    25  * !** референцира до VEHICLE (vehicle_id)
    26 * MANUFACTURER (__'''manufacturer_id'''__, manufacturer_name, manufacturer_address, manufacturer_mobile, manufacturer_email)
    27 * ARTICLE (__'''article_id'''__, article_image, article_name, article_weight, category_id*, manufacturer_id!**)
    28  * * референцира до CATEGORY (category_id)
    29  * !** референцира до MANUFACTURER (manufacturer_id)
    30 * PRICE (__'''price_id'''__, price, price_eff_date, article_id*)
    31  * * референцира до ARTICLE (article_id)
    32 * PRO_FORMA (__'''pro_forma_id'''__, pro_forma_status, pro_forma_deadline, pro_forma_date_created, order_id*, pro_forma_status_id!**)
    33  * * референцира до ORDERS (order_id)
    34  * !** референцира до PRO_FORMA_STATUS (pro_forma_status_id)
    35 * DELIVERY (__'''delivery_id'''__, delivery_date_created, delivery_date, delivery_start_km, delivery_end_km, delivery_start_time, delivery_end_time, vehicle_id*, delivery_status_id!**)
    36  * * референцира до VEHICLE (vehicle_id)
    37  * !** референцира до DELIVERY_STATUS (delivery_status_id)
    38 * ORDERS (__'''order_id'''__, order_date, order_sum, order_fulfillment_date, order_comment, customer_id*, delivery_id!**, pro_forma_id!***, order_status_id!**!**)
     27* DRIVER (__'''user_id*''''__, veh_id!**)
     28 * * референцира до USER (user_id)
     29 * !** референцира до VEHICLE (veh_id)
     30* MANUFACTURER (__'''man_id'''__, man_name, man_adr, man_mobile, man_email)
     31* ARTICLE (__'''art_id'''__, art_image, art_name, art_weight, ctg_id*, manr_id!**)
     32 * * референцира до CATEGORY (ctg_id)
     33 * !** референцира до MANUFACTURER (man_id)
     34* PRICE (__'''price_id'''__, price, price_eff_date, art_id*)
     35 * * референцира до ARTICLE (art_id)
     36* PRO_FORMA (__'''pf_id'''__, pf_status, pf_deadline, pf_date_created, pf_status_id*)
     37 * * референцира до PRO_FORMA_STATUS (pf_status_id)
     38* DELIVERY (__'''del_id'''__, del_date_created, del_date, del_start_km, del_end_km, del_start_time, delivery_end_time, veh_id*, d_status_id!**)
     39 * * референцира до VEHICLE (veh_id)
     40 * !** референцира до DELIVERY_STATUS (d_status_id)
     41* ORDERS (__'''ord_id'''__, ord_date, ord_sum, ord_fulfillment_date, ord_comment, cust_id*, del_id!**, prf_id!***, o_status_id!**!**)
    3942 * * референцира до CUSTOMER (user_id)
    40  * !** референцира до DELIVERY (delivery_id)
    41  * !*** референцира до PRO_FORMA(pro_forma_id)
    42  * !**!** референцира до ORDER_STATUS(order_status_id)
    43 * ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, article_id*, warehouse_id !** order_id!***)
    44  * * референцира до ARTICLE (article_id)
    45  * !** референцира до WAREHOUSE (warehouse_id)
    46  * !*** референцира до ORDERS (order_id)
     43 * !** референцира до DELIVERY (del_id)
     44 * !*** референцира до PRO_FORMA(pf_id)
     45 * !**!** референцира до ORDER_STATUS(o_status_id)
     46* ARTICLE_UNIT (__**unit_id**__, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id * ord_id!**)
     47 * * референцира до WAREHOUSE (wh_id)
     48 * !** референцира до ORDERS (ord_id)
     49* UNIT_PRICE (__unit_id*,price_id!**__)
     50 * * референцира до ARTICLE_UNIT (unit_id)
     51 * !** референцира до PRICE (price_id)
     52* CUSTOMER_WEEKDAY (__cust_day_id__, cust_id*, day_id!**, start_time, end_time)
     53 * * референцира до CUSTOMER (user_id)
     54 * !** референцира до WEEKDAY (day_id)
     55* TOKEN (__t_id__, t_value, t_date, t_type, t_expiry, t_validated_at, t_user*)
     56 * * референцира до USERS (user_id)
    4757
    4858== DDL скрипта за креирање и бришење на табелите