Refund Proccessing

Actors: Registered Shopper / Boss/ Employee

1. The client requests a refund.

2. The refund is recorded in refund.

INSERT INTO refund (refund_id, order_num, amount, reason, status)
VALUES ('001202500001', '00125100001', 149.00, 'Damaged product', 'requested');

3. The boss or an employee take over the refund and the refund status updates.

UPDATE refund
SET status = 'processing'
WHERE order_num = '00125100001';

4. The boss or an employee with the specific permission reviews and approves or declines it accordingly.

5. The refund status is updated.

UPDATE refund
SET status = 'approved'
WHERE order_num = '00125100001';