Changes between Version 2 and Version 3 of RelationalDesign


Ignore:
Timestamp:
04/23/26 00:00:22 (10 days ago)
Author:
185022
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v2 v3  
    99=== Ентитети
    1010
    11 * API_USER(__'''user_id'''__, user_first_name, user_last_name, user_email, user_phone_no, user_password_hash)
     11ADMIN(admin_id, admin_name, admin_email, admin_password)
    1212
    13 * COMPANY(__'''company_id'''__, company_name, company_address)
     13API_USER(api_user_id, username, password, role)
    1414
    15 * RESTAURANT(__'''rest_id'''__, rest_name, rest_email, rest_location, rest_phone, rest_website)
     15COMPANY(company_id, company_name, company_email, company_phone, company_address)
    1616
    17 * CATEGORY(__'''cat_id'''__, cat_name, cat_description)
     17CONTRACT_STATUS(contract_status_id, status_name)
    1818
    19 * CONTRACT_STATUS(__'''contract_status_id'''__, contract_status_name)
     19ORDER_STATUS(order_status_id, status_name)
    2020
    21 * DELIVERY_STATUS(__'''d_status_id'''__, d_status_name)
     21DELIVERY_STATUS(delivery_status_id, status_name)
    2222
    23 * ORDER_STATUS(__'''o_status_id'''__, o_status_name)
     23LOYALTY_TIER(loyalty_tier_id, tier_name, min_points, discount_percent)
    2424
    25 * EMPLOYEE_LOYALTY_STATUS(__'''emp_loyalty_status_id'''__, emp_loyalty_status_name)
     25CUSTOMER_LOYALTY_STATUS(customer_loyalty_status_id, status_name)
    2626
    27 * INGREDIENT(__'''ingr_id'''__, ingr_name)
     27INGREDIENT(ingredient_id, ingredient_name)
    2828
    29 * ALLERGEN(__'''allergen_id'''__, allergen_name, allergen_description)
     29ALERGEN(alergen_id, alergen_name)
    3030
    31 * LOYALTY_TIER(__'''tier_id'''__, tier_name, tier_minimum_points, tier_maximum_points, tier_discount_percentage, tier_free_delivery_eligibility, tier_priority_support, tier_created_at, tier_update_at)
     31CATEGORY(category_id, category_name)
    3232
    33 * REVIEW(__'''review_id'''__, review_comment, review_created_at, review_rating)
     33LUNCH_TIME(lunch_time_id, lunch_name, start_time, end_time)
    3434
    35 * COMPANY_EMPLOYEE(__'''user_id*'''__, company_id!**)
    36  * * референцира до API_USER (user_id)
    37  * !** референцира до COMPANY (company_id)
     35REVIEW(review_id, customer_id*, review_text, rating)
     36* референцира до CUSTOMER (customer_id)
    3837
    39 * ADMIN(__'''user_id*'''__)
    40  * * референцира до API_USER (user_id)
     38RESTAURANT(rest_id, rest_name, rest_location, rest_website, rest_phone, rest_email, company_id*)
     39* референцира до COMPANY (company_id)
    4140
    42 * CUSTOMER(__'''user_id*'''__)
    43  * * референцира до API_USER (user_id)
     41CUSTOMER(customer_id, first_name, last_name, email, phone, address, password)
    4442
    45 * DRIVER(__'''user_id*'''__)
    46  * * референцира до API_USER (user_id)
     43DRIVER(driver_id, first_name, last_name, phone, vehicle_info, company_id*)
     44* референцира до COMPANY (company_id)
    4745
    48 * CONTRACT(__'''contract_id'''__, company_id*, rest_id!**, contract_status_id!***, contract_start_date, contract_end_date)
    49  * * референцира до COMPANY (company_id)
    50  * !** референцира до RESTAURANT (rest_id)
    51  * !*** референцира до CONTRACT_STATUS (contract_status_id)
     46CONTRACT(contract_id, company_id*, contract_status_id**, contract_start_date, contract_end_date, contract_value)
     47* референцира до COMPANY (company_id)
     48** референцира до CONTRACT_STATUS (contract_status_id)
    5249
    53 * DELIVERY(__'''delivery_id'''__, delivery_date, delivery_notes, d_status_id*, driver_user_id!**)
    54  * * референцира до DELIVERY_STATUS (d_status_id)
    55  * !** референцира до DRIVER (user_id)
     50CUSTOMER_LOYALTY(customer_loyalty_id, points, customer_id*, loyalty_tier_id**, customer_loyalty_status_id***)
     51* референцира до CUSTOMER (customer_id)
     52** референцира до LOYALTY_TIER (loyalty_tier_id)
     53*** референцира до CUSTOMER_LOYALTY_STATUS (customer_loyalty_status_id)
    5654
    57 * COMPANY_ORDER(__'''comp_order_id'''__, company_id*, delivery_id!**)
    58  * * референцира до COMPANY (company_id)
    59  * !** референцира до DELIVERY (delivery_id)
     55MEAL(meal_id, meal_name, meal_price, meal_description, rest_id*, category_id**, lunch_time_id***)
     56* референцира до RESTAURANT (rest_id)
     57** референцира до CATEGORY (category_id)
     58*** референцира до LUNCH_TIME (lunch_time_id)
    6059
    61 * LUNCH_TIME(__'''lunch_time_id'''__, comp_order_id*, contract_id!**, lunch_start, lunch_end, lunch_preorder_offset, lunch_weekday)
    62  * * референцира до COMPANY_ORDER (comp_order_id)
    63  * !** референцира до CONTRACT (contract_id)
     60DRINK(drink_id, drink_name, drink_price, rest_id*)
     61* референцира до RESTAURANT (rest_id)
    6462
    65 * MEAL(__'''meal_id'''__, cat_id*, rest_id!**, meal_name, meal_description, meal_price, meal_weight)
    66  * * референцира до CATEGORY (cat_id)
    67  * !** референцира до RESTAURANT (rest_id)
     63CUSTOMER_ORDER(order_id, order_date, total_amount, customer_id*, rest_id**, order_status_id***)
     64* референцира до CUSTOMER (customer_id)
     65** референцира до RESTAURANT (rest_id)
     66*** референцира до ORDER_STATUS (order_status_id)
    6867
    69 * DRINK(__'''drink_id'''__, rest_id*, drink_name, drink_milliliters, drink_price)
    70  * * референцира до RESTAURANT (rest_id)
     68DELIVERY(delivery_id, delivered_at, order_id*, driver_id**, delivery_status_id***)
     69* референцира до CUSTOMER_ORDER (order_id)
     70** референцира до DRIVER (driver_id)
     71*** референцира до DELIVERY_STATUS (delivery_status_id)
    7172
    72 * CUSTOMER_ORDER(__'''order_id'''__, comp_order_id*, company_employee_user_id!**, order_datetime, o_status_id!***, order_total)
    73  * * референцира до COMPANY_ORDER (comp_order_id)
    74  * !** референцира до COMPANY_EMPLOYEE (user_id)
    75  * !*** референцира до ORDER_STATUS (o_status_id)
     73ORDER_REVIEW(order_review_id, order_id*, review_id**)
     74* референцира до CUSTOMER_ORDER (order_id)
     75** референцира до REVIEW (review_id)
    7676
    77 * INVOICE(__'''invoice_id'''__, comp_order_id*)
    78  * * референцира до COMPANY_ORDER (comp_order_id)
     77DELIVERY_REVIEW(delivery_review_id, delivery_id*, review_id**)
     78* референцира до DELIVERY (delivery_id)
     79** референцира до REVIEW (review_id)
    7980
    80 * EMPLOYEE_LOYALTY(__'''emp_loyalty_id'''__, user_id*, emp_loyalty_curr_points, emp_loyalty_joined_at, emp_loyalty_status_id!**, tier_id!***)
    81  * * референцира до COMPANY_EMPLOYEE (user_id)
    82  * !** референцира до EMPLOYEE_LOYALTY_STATUS (emp_loyalty_status_id)
    83  * !*** референцира до LOYALTY_TIER (tier_id)
     81INVOICE(invoice_id, issued_at, amount, order_id*)
     82* референцира до CUSTOMER_ORDER (order_id)
    8483
    85 * ORDER_REVIEW(__'''review_id*'''__, order_id!**, order_review_food_rating, order_review_res_rating)
    86  * * референцира до REVIEW (review_id)
    87  * !** референцира до CUSTOMER_ORDER (order_id)
     84COMPANY_ORDER(company_order_id, company_id*, order_id**)
     85* референцира до COMPANY (company_id)
     86** референцира до CUSTOMER_ORDER (order_id)
    8887
    89 * DELIVERY_REVIEW(__'''review_id*'''__, delivery_id!**, del_review_courier_rating, del_review_speed_rating)
    90  * * референцира до REVIEW (review_id)
    91  * !** референцира до DELIVERY (delivery_id)
     88Релациски табели
    9289
    93 ==== Релациски табели
     90MEAL_INGREDIENT(meal_id*, ingredient_id**)
     91* референцира до MEAL (meal_id)
     92** референцира до INGREDIENT (ingredient_id)
    9493
    95 * MEAL_INGREDIENT(__'''meal_id*, ingr_id!**'''__)
    96  * * референцира до MEAL (meal_id)
    97  * !** референцира до INGREDIENT (ingr_id)
     94ALERGEN_INGREDIENT(alergen_id*, ingredient_id**)
     95* референцира до ALERGEN (alergen_id)
     96** референцира до INGREDIENT (ingredient_id)
    9897
    99 * ALLERGEN_INGREDIENT(__'''allergen_id*, ingr_id!**'''__)
    100  * * референцира до ALLERGEN (allergen_id)
    101  * !** референцира до INGREDIENT (ingr_id)
     98ORDER_MEAL(order_id*, meal_id**, quantity)
     99* референцира до CUSTOMER_ORDER (order_id)
     100** референцира до MEAL (meal_id)
    102101
    103 * ORDER_MEAL(__'''order_id*, meal_id!**'''__, quantity)
    104  * * референцира до CUSTOMER_ORDER (order_id)
    105  * !** референцира до MEAL (meal_id)
    106 
    107 * ORDER_DRINK(__'''order_id*, drink_id!**'''__, quantity)
    108  * * референцира до CUSTOMER_ORDER (order_id)
    109  * !** референцира до DRINK (drink_id)
     102ORDER_DRINK(order_id*, drink_id**, quantity)
     103* референцира до CUSTOMER_ORDER (order_id)
     104** референцира до DRINK (drink_id)
    110105
    111106== DDL скрипта за креирање на табелите