| | 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 |
| | 12 | INSERT 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 |
| | 19 | INSERT 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 |
| | 26 | INSERT 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. |