Changes between Version 7 and Version 8 of ERModel


Ignore:
Timestamp:
09/19/26 06:15:20 (10 days ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v7 v8  
    1414[[BR]]
    1515'''[[span(style=color: #9A0000, Attributes:)]]'''
    16 * {{{code}}} – numeric, required. Auto-generated primary key.
     16* {{{code}}} – surrogare numeric identifier, required. Auto-generated primary key.
    1717* {{{price}}} – numeric, required.
    1818* {{{availability}}} – numeric, required.
    19 * {{{description}}} – text, required.
    20 * {{{images}}} – multi-valued, media, required.
    21 * {{{dimensions}}} – complex, text, required.
    2219* {{{weight}}} – numeric, required.
    2320* {{{width_X_length_X_depth}}} – text, required.
    24 * {{{colors}}} – multi-valued, text, required.
    2521* {{{approx_production_time}}} – numeric, required. Expressed in days.
     22* {{{description}}} – text, required.
     23* {{{cathegory_id}}} - text, required, foreign key from {{{category}}} entity.
     24* {{{image}}} – multi-valued, media, required.
     25* {{{color}}} – multi-valued, text, required.
     26
     27[[BR]]
     28----
     29{{{category}}}
     30[[BR]]
     31Represents all the categories of products there are on the marketplace. The primary category is the only one with the parent_category_id being the same as the id attribute.
     32[[BR]]
     33'''[[span(style=color: #9A0000, Candidate keys:)]]'''
     34* {{{id}}} - surrogare numeric identifier (primary key).
     35[[BR]]
     36'''[[span(style=color: #9A0000, Attributes:)]]'''
     37* {{{id}}} - surrogare numeric identifier, required. Auto-generated primary key.
     38* {{{name}}} - text, required.
     39* {{{parent_category_id}}} - surrogate numeric identifier, required.
     40
    2641[[BR]]
    2742----
    … …  
    3146[[BR]]
    3247'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    33 * {{{SSN}}} – numeric identifier (primary key).
    34 [[BR]]
    35 '''[[span(style=color: #9A0000, Attributes:)]]'''
    36 * {{{SSN}}} – numeric, required. Primary key.
     48* {{{id}}} – surrogate numeric identifier (primary key).
     49[[BR]]
     50'''[[span(style=color: #9A0000, Attributes:)]]'''
    3751* {{{name}}} – complex, text, required.
    3852* {{{first_name}}} – text, required.
    3953* {{{last_name}}} – text, required.
    40 * {{{middle_name}}} – text, optional.
     54* {{{SSN}}} – numeric, required.
    4155* {{{email}}} – text, required.
    4256* {{{password}}} – hash value, required.
    … …  
    5165[[BR]]
    5266'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    53 * {{{SSN}}} – inherited primary key.
    54 * {{{signature}}} - boss' signature for authorising Reports and Permissions.
     67* {{{boss_ID}}} – inherited primary key.
    5568[[BR]]
    5669----
    … …  
    6073[[BR]]
    6174'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    62 * {{{SSN}}} – inherited primary key.
     75* {{{employee_ID}}} – inherited primary key.
    6376[[BR]]
    6477'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    90103[[BR]]
    91104'''[[span(style=color: #9A0000, Attributes:)]]'''
    92 * {{{client_ID}}} – numeric, required. Auto-generated primary key.
    93105* {{{name}}} – complex, text, required.
    94106* {{{first_name}}} – text, required.
    … …  
    96108* {{{email}}} – text, required.
    97109* {{{password}}} – hash value, required.
    98 * {{{delivery_address}}} – multi-valued text, required.
     110* {{{delivery_address}}} – complex, multi-valued text, required.
     111* {{{address}}} - text, required.
     112* {{{city}}} - text, required.
     113* {{{postcode}}} - text, required.
     114* {{{country}}} - text, required.
     115* {{{is_default}}} - boolean, required.
    99116[[BR]]
    100117----
    … …  
    107124[[BR]]
    108125'''[[span(style=color: #9A0000, Attributes:)]]'''
    109 * {{{request_num}}} – numeric, required. Auto-generated primary key.
    110126* {{{date_and_time}}} – timestamp, required.
    111127* {{{problem}}} – text, required.
    … …  
    119135[[BR]]
    120136'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    121 * {{{date_and_time}}} – timestamp identifier (primary key).
     137Composite key: ({{{date_and_time}}}, {{{product_code}}}).
    122138[[BR]]
    123139'''[[span(style=color: #9A0000, Attributes:)]]'''
    124140* {{{date_and_time}}} – timestamp, required. Primary key.
    125141* {{{product_code}}} - numeric, required.
    126 * {{{changes_made}}} – text, required.
     142* {{{changes}}} – text, required.
    127143[[BR]]
    128144----
    … …  
    136152'''[[span(style=color: #9A0000, Attributes:)]]'''
    137153* {{{order_num}}} – numeric, required. Auto-generated primary key.
     154* {{{client_ID}}} - numeric, required. Foreign key from {{{CLIENT}}}.
    138155* {{{quantity}}} – numeric, required.
    139156* {{{status}}} – text, required.
    … …  
    167184[[BR]]
    168185'''[[span(style=color: #9A0000, Attributes:)]]'''
    169 * {{{comment}}} – text, required.
    170 * {{{rating}}} – numeric, required.
    171 * {{{last_modified_date}}} – timestamp, required.
     186* {{{reason}}} – text, required.
     187* {{{amount}}} – numeric, required.
     188* {{{status}}} – text, required.
    172189[[BR]]
    173190----
    … …  
    178195'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    179196* {{{date}}} – date identifier (partial key).
    180 * {{{store_ID}}} – surrogate numeric identifier (foreign partial key), gotten from STORE entity.
    181 [[BR]]
    182 '''[[span(style=color: #9A0000, Attributes:)]]'''
    183 * {{{date}}} – date, required. Partial primary key.
    184 * {{{store_ID}}} – numeric, required. Foreign partial key.
     197* {{{store_ID}}} – surrogate numeric identifier (foreign partial key), gotten from {{{STORE}}} entity.
     198[[BR]]
     199'''[[span(style=color: #9A0000, Attributes:)]]'''
    185200* {{{overall_profit}}} – numeric, required. Profit of the store from date of founding.
    186 * {{{monthly_profit}}} – complex, multi-valued, numeric, required.
    187 * {{{month_and_year}}} – text, required.
    188 * {{{profit}}} – numeric, required.
    189201* {{{sales_trend}}} – text, optional.
    190202* {{{marketing_growth}}} – text, optional.
    191203* {{{owner_signature}}} – text, required.
     204* {{{monthly_profit}}} – complex, multi-valued, numeric, required.
     205* {{{month_and_year}}} – date, required.
     206* {{{profit}}} – numeric, required.
    192207[[BR]]
    193208----
    … …  
    200215[[BR]]
    201216'''[[span(style=color: #9A0000, Keys:)]]'''
    202 Composite key: ({{{SSN}}}, {{{store_ID}}}).
     217Composite key: ({{{personal_ID}}}, {{{store_ID}}}).
    203218[[BR]]
    204219----
    … …  
    208223[[BR]]
    209224'''[[span(style=color: #9A0000, Keys:)]]'''
    210 Composite key: ({{{SSN}}}, {{{date}}}, {{{store_ID}}}).
    211 [[BR]]
    212 '''[[span(style=color: #9A0000, Attributes:)]]'''
     225Composite key: ({{{personal_ID}}}, {{{report_date}}}, {{{store_ID}}}).
     226[[BR]]
     227'''[[span(style=color: #9A0000, Attributes:)]]'''
     228* {{{wage}}} – numeric, required.
     229* {{{pay_method}}} – text, required.
     230* {{{working_hours}}} – numeric,complex, required.
    213231* {{{week}}} – numeric, required.
    214 * {{{total_week}}} – numeric, required. Total hours worked that certain week.
    215 * {{{pay_method}}} – text, required.
    216 * {{{wage}}} – numeric, required.
    217 * {{{working_hours}}} – numeric, required.
    218 [[BR]]
    219 ----
    220 {{{make_request (CLIENT – REQUEST)}}}
     232* {{{total_week}}} – numeric, required.
     233[[BR]]
     234----
     235{{{makes_request (CLIENT – REQUEST)}}}
    221236[[BR]]
    222237Represents clients making requests.
    … …  
    231246[[BR]]
    232247'''[[span(style=color: #9A0000, Keys:)]]'''
    233 Composite key: ({{{request_num}}}, {{{SSN}}}).
     248Composite key: ({{{request_num}}}, {{{personal_ID}}}).
    234249[[BR]]
    235250----
    … …  
    239254[[BR]]
    240255'''[[span(style=color: #9A0000, Keys:)]]'''
    241 Composite key: ({{{SSN}}}, {{{date_and_time}}}).
    242 [[BR]]
    243 '''[[span(style=color: #9A0000, Attributes:)]]'''
    244 * {{{permission}}} – complex, text, required.
    245 * {{{type}}} – text, required.
    246 * {{{authorisation}}} – text, required.
     256Composite key: ({{{personal_id}}}, {{{date_and_time}}}, {{{product_code}}}).
    247257[[BR]]
    248258----
    … …  
    252262[[BR]]
    253263'''[[span(style=color: #9A0000, Keys:)]]'''
    254 Composite key: ({{{date}}}, {{{store_ID}}}).
    255 [[BR]]
    256 '''[[span(style=color: #9A0000, Attributes:)]]'''
    257 * {{{store_ID}}} - numeric, required.
     264Composite key: ({{{report_date}}}, {{{store_ID}}}).
     265[[BR]]
     266'''[[span(style=color: #9A0000, Attributes:)]]'''
    258267* {{{monthly_profit}}} – numeric, required.
     268* {{{date}}} - timestamp, optional.
    259269* {{{sales}}} – numeric, required.
    260270* {{{damages}}} – numeric, required.
    … …  
    266276[[BR]]
    267277'''[[span(style=color: #9A0000, Keys:)]]'''
    268 Composite key: ({{{code}}}, {{{store_ID}}}).
    269 [[BR]]
    270 '''[[span(style=color: #9A0000, Attributes:)]]'''
    271 * {{{quantity}}} – numeric, required.
     278Composite key: ({{{product_codecode}}}, {{{store_ID}}}).
     279[[BR]]
     280'''[[span(style=color: #9A0000, Attributes:)]]'''
    272281* {{{discount}}} – numeric, optional.
    273282[[BR]]
    … …  
    278287[[BR]]
    279288'''[[span(style=color: #9A0000, Keys:)]]'''
    280 Composite key: ({{{date}}}, {{{SSN}}}).
    281 [[BR]]
     289Composite key: ({{{report_date}}}, {{{store_ID}}}, {{{boss_ID}}}).
     290[[BR]]
     291'''[[span(style=color: #9A0000, Attributes:)]]'''
     292* {{{owner_signature}}} - media, optional.
    282293----
    283294{{{includes (PRODUCT – ORDER)}}}
    … …  
    286297[[BR]]
    287298'''[[span(style=color: #9A0000, Keys:)]]'''
    288 Composite key: ({{{code}}}, {{{order_num}}}).
     299Composite key: ({{{product_code}}}, {{{order_num}}}).
    289300[[BR]]
    290301----