Get Promotioncode from user order

Is it possible to get the user promotioncode for every orderwhich was made?

I have access to the Orders table but in this one the used promotioncodes are not stored.

How can i find out which code was used for which order?

Thats a good question i couldn’t find a solution either

But im pretty sure somebody can assist you here with your request.