Changes between Version 12 and Version 13 of ERModel

Timestamp:

09/22/26 08:34:44 (7 days ago)

Author:

235018

Comment:

--

ERModel

@@ -1 +1 @@
 == ERModel Final version ==
 == Diagram ==
-[[Image(Handcarfts-storeDB-edit4.1.png)]]
+[[Image(Handcarfts-storeDB-edit5.png)]]
 
 == Data requirements ==
@@ -130 +130 @@
 [[BR]]
 ----
-{{{CHANGE}}}
-[[BR]]
-Represents changes made to products or systems.
-[[BR]]
-'''[[span(style=color: #9A0000, Candidate keys:)]]'''
-Composite key: ({{{date_and_time}}}, {{{product_code}}}).
-[[BR]]
-'''[[span(style=color: #9A0000, Attributes:)]]'''
-* {{{date_and_time}}} – timestamp, required. Primary key.
-* {{{product_code}}} - numeric, required.
-* {{{changes}}} – text, required.
-[[BR]]
-----
 {{{ORDER}}}
 [[BR]]
@@ -152 +139 @@
 '''[[span(style=color: #9A0000, Attributes:)]]'''
 * {{{order_num}}} – numeric, required. Auto-generated primary key.
-* {{{client_ID}}} - numeric, required. Foreign key from {{{CLIENT}}}.
 * {{{quantity}}} – numeric, required.
 * {{{status}}} – text, required.
@@ -241 +227 @@
 [[BR]]
 ----
+{{{orders (CLIENT – ORDER)}}}
+[[BR]]
+Represents clients making an order.
+[[BR]]
+'''[[span(style=color: #9A0000, Keys:)]]'''
+Composite key: ({{{client_ID}}}, {{{order_num}}}).
+[[BR]]
+----
 {{{answers (REQUEST – PERSONAL)}}}
 [[BR]]
@@ -249 +243 @@
 [[BR]]
 ----
-{{{makes_change (PERSONAL – CHANGE)}}}
+{{{makes_change (PERSONAL – PRODUCT)}}}
 [[BR]]
 Represents personnel making changes to products when they have a certain permission.
 [[BR]]
 '''[[span(style=color: #9A0000, Keys:)]]'''
-Composite key: ({{{personal_id}}}, {{{date_and_time}}}, {{{product_code}}}).
+Composite key: ({{{personal_id}}}, {{{product_code}}}).
+[[BR]]
+'''[[span(style=color: #9A00, Attributes:)]]'''
+* {{{date_and_time}}} - timestamp, required.
+* {{{changes}}} - varchar, required.
 [[BR]]
 ----
@@ -318 +316 @@
 Edited on 18.09.2026
 
-Last edited on 19.09.2026
+Еdited on 19.09.2026
+
+Last edited on 22.09.2026