Changes between Version 2 and Version 3 of ERModel


Ignore:
Timestamp:
09/18/26 04:57:30 (11 days ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v2 v3  
    11== ERModel Current version ==
    22== Diagram ==
    3 [[Image(Handcrafts-storeDB-Edit3.png)]]
     3[[Image(Handcrafts-storeDB-edit3.png)]]
    44
    55== Data requirements ==
    … …  
    125125* {{{product_code}}} - numeric, required.
    126126* {{{changes_made}}} – text, required.
    127 [[BR]]CASCADE
     127[[BR]]
    128128----
    129129{{{ORDER}}}
    … …  
    141141* {{{payment_method}}} – text, required.
    142142* {{{discount}}} – numeric, optional.
     143[[BR]]
     144
     145----
     146{{{REVIEW}}}
     147[[BR]]
     148Represents reviews for orders.
     149[[BR]]
     150'''[[span(style=color: #9A0000, Candidate keys:)]]'''
     151* {{{order_num}}} - surrogate numeric identifier (foreign primary key).
     152[[BR]]
     153'''[[span(style=color: #9A0000, Attributes:)]]'''
     154* {{{comment}}} – text, required.
     155* {{{rating}}} – numeric, required.
     156* {{{last_modified_date}}} – timestamp, required.
     157[[BR]]
     158
     159----
     160{{{REFUND}}}
     161[[BR]]
     162Represents a refund/return for orders.
     163[[BR]]
     164'''[[span(style=color: #9A0000, Candidate keys:)]]'''
     165* {{{refund_id}}} - surrogate numeric identifier (primary key).
     166* {{{order_num}}} - surrogate numeric identifier (foreign partial key).
     167[[BR]]
     168'''[[span(style=color: #9A0000, Attributes:)]]'''
     169* {{{comment}}} – text, required.
     170* {{{rating}}} – numeric, required.
     171* {{{last_modified_date}}} – timestamp, required.
    143172[[BR]]
    144173----
    … …  
    166195=== RELATIONS ===
    167196
    168 {{{review (ORDER)}}}
    169 [[BR]]
    170 Represents reviews for orders.
    171 [[BR]]
    172 '''[[span(style=color: #9A0000, Keys:)]]'''
    173 ({{{order_num}}})
    174 [[BR]]
    175 '''[[span(style=color: #9A0000, Attributes:)]]'''
    176 * {{{comment}}} – text, required.
    177 * {{{rating}}} – numeric, required.
    178 * {{{last_modified_date}}} – timestamp, required.
    179 [[BR]]
    180 ----
    181197{{{works_in_store (PERSONAL – STORE)}}}
    182198[[BR]]
    … …  
    231247[[BR]]
    232248----
    233 {{{made_on (PRODUCT – CHANGE)}}}
    234 [[BR]]
    235 Represents changes made on products.
    236 [[BR]]
    237 '''[[span(style=color: #9A0000, Keys:)]]'''
    238 Composite key: ({{{code}}}, {{{date_and_time}}}).
    239 [[BR]]
    240 ----
    241249{{{exchanges_data (REPORT – STORE)}}}
    242250[[BR]]
    … …  
    281289[[BR]]
    282290----
    283 {{{makes_order (CLIENT – ORDER)}}}
    284 [[BR]]
    285 Represents clients making orders.
    286 [[BR]]
    287 '''[[span(style=color: #9A0000, Keys:)]]'''
    288 Composite key: ({{{client_ID}}}, {{{order_num}}}).
    289 [[BR]]
    290 ----
    291291{{{for_store (REQUEST – STORE)}}}
    292292[[BR]]
    … …  
    303303Edited on 17.12.2025
    304304
    305 Last edit on 20.12.2025
     305Edited on 20.12.2025
     306
     307Last edited on 18.09.2026