Changes between Version 6 and Version 7 of RelationModel
- Timestamp:
- 01/05/23 01:11:43 (23 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationModel
v6 v7 15 15 - //administrator// (**__ID_user*__**(users_table), **authorized_from**, **authorized_till**) 16 16 - //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)) 18 18 - //repair_shop// (**__ID_repair_shop__**, **rs_name**, **rs_location**, **rs_phone_number**) 19 19 - //car_manufacturer// (**__ID_car_manufacturer__**, **cm_name**, cm_country) … … 37 37 == DDL скрипта за бришење на табелите и креирање на табелите 38 38 39 '''[attachment:kreiranje_v 3.sql]'''39 '''[attachment:kreiranje_v4.sql]''' 40 40 41 41 == DML скрипта за полнење на табелите со податоци 42 42 43 '''[attachment:polnenje_v 2.sql]'''43 '''[attachment:polnenje_v4.sql]''' 44 44 45 45 == Релациски дијаграм изваден од DBeaver 46 46 47 [[Image(schema_v 3.png, 100%, center)]]47 [[Image(schema_v4.png, 100%, center)]]