Changes between Initial Version and Version 1 of ProductCreation


Ignore:
Timestamp:
12/30/25 15:19:58 (15 hours ago)
Author:
235018
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ProductCreation

    v1 v1  
     1== Product Creation
     2
     3==== Actors: **Registered Boss / Employee**
     4
     5**1.** The user selects “Create Product”.
     6
     7**2.** Product information is entered.
     8
     9**3.** The application inserts the product into {{{product}}}.
     10
     11{{{#!sql
     12INSERT INTO product (code, price, availability, weight, width_x_length_x_depth, aprox_production_time, description, category_id, store_id) VALUES
     13('00100001', 49.99, 20, 1.20, '20x15x10', 7, 'Handmade wooden box', 1, '001');
     14}}}
     15
     16**4.** The colors in which the product is availabe are inseted into {{{color}}}.
     17
     18{{{#!sql
     19INSERT INTO color (product_code, color) VALUES
     20('00100001', 'Red'),
     21('00100001', 'Black');
     22
     23**5.** The images with the product are inserted into {{{image}}}.
     24
     25{{{#!sql
     26INSERT INTO image (product_code, image) VALUES
     27('00100001', 'Wooden-box-red_front.png'),
     28('00100001', 'Wooden-box-red_side.png'),
     29('00100001', 'Wooden-box-black_side.png');
     30
     31}}}
     32
     33**4.** Product is shown publicly with the other products.