Changes between Version 12 and Version 13 of ERModel


Ignore:
Timestamp:
09/22/26 08:34:44 (7 days ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ERModel

    v12 v13  
    11== ERModel Final version ==
    22== Diagram ==
    3 [[Image(Handcarfts-storeDB-edit4.1.png)]]
     3[[Image(Handcarfts-storeDB-edit5.png)]]
    44
    55== Data requirements ==
    … …  
    130130[[BR]]
    131131----
    132 {{{CHANGE}}}
    133 [[BR]]
    134 Represents changes made to products or systems.
    135 [[BR]]
    136 '''[[span(style=color: #9A0000, Candidate keys:)]]'''
    137 Composite key: ({{{date_and_time}}}, {{{product_code}}}).
    138 [[BR]]
    139 '''[[span(style=color: #9A0000, Attributes:)]]'''
    140 * {{{date_and_time}}} – timestamp, required. Primary key.
    141 * {{{product_code}}} - numeric, required.
    142 * {{{changes}}} – text, required.
    143 [[BR]]
    144 ----
    145132{{{ORDER}}}
    146133[[BR]]
    … …  
    152139'''[[span(style=color: #9A0000, Attributes:)]]'''
    153140* {{{order_num}}} – numeric, required. Auto-generated primary key.
    154 * {{{client_ID}}} - numeric, required. Foreign key from {{{CLIENT}}}.
    155141* {{{quantity}}} – numeric, required.
    156142* {{{status}}} – text, required.
    … …  
    241227[[BR]]
    242228----
     229{{{orders (CLIENT – ORDER)}}}
     230[[BR]]
     231Represents clients making an order.
     232[[BR]]
     233'''[[span(style=color: #9A0000, Keys:)]]'''
     234Composite key: ({{{client_ID}}}, {{{order_num}}}).
     235[[BR]]
     236----
    243237{{{answers (REQUEST – PERSONAL)}}}
    244238[[BR]]
    … …  
    249243[[BR]]
    250244----
    251 {{{makes_change (PERSONAL – CHANGE)}}}
     245{{{makes_change (PERSONAL – PRODUCT)}}}
    252246[[BR]]
    253247Represents personnel making changes to products when they have a certain permission.
    254248[[BR]]
    255249'''[[span(style=color: #9A0000, Keys:)]]'''
    256 Composite key: ({{{personal_id}}}, {{{date_and_time}}}, {{{product_code}}}).
     250Composite key: ({{{personal_id}}}, {{{product_code}}}).
     251[[BR]]
     252'''[[span(style=color: #9A00, Attributes:)]]'''
     253* {{{date_and_time}}} - timestamp, required.
     254* {{{changes}}} - varchar, required.
    257255[[BR]]
    258256----
    … …  
    318316Edited on 18.09.2026
    319317
    320 Last edited on 19.09.2026
     318Еdited on 19.09.2026
     319
     320Last edited on 22.09.2026