You do not give enough information ...

This table holds the customers_id and balance
coupon_gv_customer

This table holds the redemption code for Gift Certificates and the Y means waiting to be redeemed, N means redeemed and you can also cancel one marked Y by changing to N or by deleting the coupon if it has not already been redeemed:
coupons