Changes between Initial Version and Version 1 of RelationModel

Timestamp:

11/30/22 13:30:50 (3 years ago)

Author:

201084

Comment:

--

RelationModel

@@ +1 @@
+== Релациска шема (со мапирачка трансформација)
+
+=== Ознаки
+
+ - Примарните клучеви се означени со bold и underline
+ - Надворешните клучеви се означени со *
+ - Задолжителни атрибути, односно not null со bold 
+
+=== Табели 
+
+users_table (ID_user, username, e-mail, name_user, password, user_created_on, ID_user*(administrator))
+client (ID_ user*(users_table), phone_number_client)
+delivery_man (ID_ user*(users_table), employed_from)
+warehouseman (ID_ user*(users_table), employed_from, ID_warehouse*(warehouse))
+administrator (ID_ user*(users_table), authorized_from, authorized_till)
+review (ID_review, review_rating, review_comment, ID_repair*(repair), ID_user*(client))
+repair (ID_repair, VIN*(car_sample), ID_repair_shop*(repair_shop), ID_service_book*(service_book))
+repair_shop (ID_repair_shop, rs_name, rs_location, rs_phone_number)
+car_manufacturer (ID_car_manufacturer, cm_name, cm_country)
+car (ID_car, in_production_since, in_production_till, car_type, ID_car_manufacturer*(car_manufacturer))
+car_sample (VIN, year_of_production, engine_power, displacement, fuel_type, km_driven, ID_user*(client), ID_car*(car))
+service_book (ID_service_book, sb_created_on, VIN*(car_sample))
+order_table (ID_order, order_status, order_date), ID_user*(client))
+part_manufacturer (ID_part_manufacturer, pm_name, pm_location)
+part (ID_part, part_name, part_description, ID_part_manufacturer*(part_manufacturer))
+delivery (ID_delivery, delivery_status, delivery_address, ID_user*(delivery_man), ID_order*(order))
+warehouse (ID_warehouse, warehouse_location)
+price (ID_price, price_from, price_till, amount, ID_part*(part))
+category (ID_category, category_name, ID_parent_category*(category))
+part_is_from_category (ID_part*(part), ID_category*(category))
+repair_shop_is_authorized_for_car_make (ID_repair_shop*(repair_shop), ID_car_manufacturer*(car_manufacturer))
+order_contains_part (ID_order*(order), ID_part*(part),quantity)
+part_is_in_stock_in_warehouse (ID_part*(part), ID_warehouse*(warehouse),quantity)
+part_is_appropriate_for_car (ID_part*(part), ID_car*(car))
+
+
+== DDL скрипта за бришење на табелите и креирање на табелите
+
+'''[attachment:kreiranje_v1.sql]'''
+
+== DML скрипта за полнење на табелите со податоци
+
+'''[attachment:polnenje_v1.sql]'''
+
+== Релациски дијаграм изваден од DBeaver
+
+[[Image(schema_v1.jpg, 100%, center)]]