Gift Card and Account Credit Data Model
The new tables introduced are meant to manage gift cards and account credits in the database.
Tables
| Table | Related Entity | Description |
|---|---|---|
BLC_CREDIT_ACCOUNT |
CreditAccount | The balance of the entire credit account as a whole |
BLC_CUSTOMER_CREDIT_ACCOUNT |
CustomerCreditAccount | A credit account that relates to a particular Customer |
BLC_GIFT_CARD_ACCOUNT |
GiftCardAccount | Similar to a credit account but for a gift card that can be redeemed |
BLC_CREDIT_ACCOUNT_EVENT |
CreditAccountEvent | Audit trail of modifications to the balance of a credit account |
BLC_CREDIT_ACCOUNT_EVENT_DTL |
CreditAccountEventDetail | More information about the audit trail of credit account modifications |