Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

01/20/25 23:44:53 (10 days ago)

Author:

221028

Comment:

--

RelationalDesign

@@ -8 +8 @@
 - останати атрибути      - без ознака
 === Табели
-- USER (**__user_id__**, **user_name**, **user_surename**, **password**, **role**)
--  (__**transaction_account_id**__, account_name, balance, user_id* (USER))
+- USER (**__user_id__**, **user_name**, **user_surename**, **username**, **password**, **role**)
 - LABEQUIPMENT (__**equipment_id__**, **equipment_name**, type, description, safety_info)
 - ELEMENT (__**element_id__**, **symbol**, **element_name**,**atomic_number**, **atomic_weight**, melting_point,boiling_point,hazzard_type,description_element)
-- Reaction (__**reaction_id__**, **element1_id*** (ELEMENT), **element2_id*** (ELEMENT), product,conditions)
+- REACTION (__**reaction_id__**, **element1_id*** (ELEMENT), **element2_id*** (ELEMENT), product,conditions)
 - EXPERIMENT(__**experiment_id**__, **user_id*** (USER), **reaction_id*** (REACTON),result,time_stamp,safety_warning)
 - EXPERIMENTLABEQUIPMENT(**__experiment_id__*** (EXPERIMENT), **__equipment_id__*** (LABEQUIPMENT))
@@ -22 +21 @@
 [wiki:dmlScript.sql DML скрипта]
 === Релациски дијаграм изваден од DBeaver
-[[Image(DBeaverExport.png)]]
+[[Image(dijagramRelaciski.png)]]