Schema
LoyaltyCommerce

GiftCard

Digital gift card. Tracks created → activated → redeemed → refunded lifecycle.

10 fields3 relationships

Fields

NameTypeReqDescription
iduuidyesGift card UUID.
org_iduuidyesOwning organisation.
titlestringDisplay name (Birthday Gift etc.).
amountpenniesyesFace value in pennies.
currencystringISO 4217.
statusenumyesactive | redeemed | refunded | deactivated.
created_atdatetimeyesCreated. Indexed.
activated_atdatetimeActivated.
redeemed_atdatetimeRedeemed.
refunded_atdatetimeRefunded.

Relationships

Outbound (1)
Inbound (2)
  • Customer[:SENT_GIFT_CARD]GiftCardamount (pennies), currency, created_at
  • Customer[:REDEEMED_GIFT_CARD]GiftCardredeemed_at