Changes between Initial Version and Version 1 of SubmitRequest

Timestamp:

12/30/25 16:23:59 (14 hours ago)

Author:

235018

Comment:

--

SubmitRequest

@@ +1 @@
+== Submitting a Custumer Request
+
+==== Actors: **Registered Shopper**
+
+**1.** The user submits a customer request to a specific store.
+
+**2.** The request is stored in {{{request}}}.
+
+{{{#!sql
+INSERT INTO request (request_num, date_and_time, problem, customer_satisfaction) VALUES
+('0010120241001', CURRENT_TIMESTAMP,'Military discount', -1);
+
+}}}
+
+**3.** The request is linked to the client in {{{makes_request}}}.
+
+{{{#!sql
+INSERT INTO makes_request (client_ID, request_num) VALUES 
+(1001, '0010120241001');
+
+}}}
+
+**4.** The request is assigned to the specific store via {{{for_store}}}.
+
+{{{#!sql
+INSERT INTO for_store (request_num, store_ID) VALUES
+('0010120241001', '001');
+
+}}}