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



