Changes between Version 6 and Version 7 of RelationModel


Ignore:
Timestamp:
01/05/23 01:11:43 (23 months ago)
Author:
201084
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationModel

    v6 v7  
    1515 - //administrator// (**__ID_user*__**(users_table), **authorized_from**, **authorized_till**)
    1616 - //review// (**__ID_review__**, **review_rating**, review_comment, **ID_repair***(repair), **ID_user***(client))
    17  - //repair// (**__ID_repair__**, **VIN***(car_sample), **ID_repair_shop***(repair_shop), ID_service_book*(service_book))
     17 - //repair// (**__ID_repair__**, **ID_order***(order_table), **ID_repair_shop***(repair_shop), ID_service_book*(service_book))
    1818 - //repair_shop// (**__ID_repair_shop__**, **rs_name**, **rs_location**, **rs_phone_number**)
    1919 - //car_manufacturer// (**__ID_car_manufacturer__**, **cm_name**, cm_country)
     
    3737== DDL скрипта за бришење на табелите и креирање на табелите
    3838
    39 '''[attachment:kreiranje_v3.sql]'''
     39'''[attachment:kreiranje_v4.sql]'''
    4040
    4141== DML скрипта за полнење на табелите со податоци
    4242
    43 '''[attachment:polnenje_v2.sql]'''
     43'''[attachment:polnenje_v4.sql]'''
    4444
    4545== Релациски дијаграм изваден од DBeaver
    4646
    47 [[Image(schema_v3.png, 100%, center)]]
     47[[Image(schema_v4.png, 100%, center)]]