== Refund Proccessing

=== Actors: **Registered Shopper / Boss/ Employee**

**1.** The client requests a refund.

**2.** The refund is recorded in {{{refund}}}.
{{{#!sql
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.

{{{#!sql
UPDATE refund
SET status = 'processing'
WHERE refund_num = '001202500001';

}}}

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

**5.** The refund status is updated.

{{{#!sql
UPDATE refund
SET status = 'approved'
WHERE refund_num = '001202500001';

}}}