Database Schema

Relationship Overview

======================================================================
DATABASE RELATIONSHIP OVERVIEW
======================================================================

Account
-------
  .default_credit_card ──N:1──> fold.CreditCard
  .created ──1:1──> fold.AccountCreated
  .account_enabled_features ──N:M──> fold.Feature
  .shipping_address ──N:1──> fold.AccountAddress
  .billing_address ──N:1──> fold.AccountAddress

Order
-----
  .transfers ──N:M──> merchant_dash.Transfer
  .profile ──N:1──> CardForCoinProfile
  .account_manager ──N:1──> CardForCoinProfile
  .amount_owed ──N:1──> CurrencyAmount
  .payments ──N:M──> merchant_dash.Payment
  .status ──N:1──> OrderStatus
  .auto_buy_config ──N:1──> AutoBuyConfig

Brand
-----
  .brand_parent ──N:1──> BrandParent
  .tags ──N:M──> Tag
  .countries ──N:M──> Country

FoldCardTransaction
-------------------
  .account ──N:1──> fold.Account
  .card ──N:1──> fold.FoldCardCard
  .fold_order ──1:1──> fold.Order
  .group ──N:1──> fold.FoldCardTransactionGroup
  .transaction_boost ──1:1──> fold.FoldCardTransactionBoost
  .base_reward_balance_change ──1:1──> fold.BalanceChange
  .ach_reward_rate ──N:1──> fold.ACHRewardRate
  .ach_reward_balance_change ──1:1──> fold.BalanceChange
  .merchant_boost_reward_balance_change ──1:1──> fold.BalanceChange
  .merchant_boost ──N:1──> fold.MerchantBoost

CurrentBalance
--------------
  .profile ──N:1──> CardForCoinProfile

AccountGameReward
-----------------
  .account ──N:1──> fold.Account
  .created ──1:1──> fold.AccountGameRewardCreated
  .balance_change ──1:1──> fold.BalanceChange
  .extra_spin_entries ──N:M──> fold.AccountGameEntry

======================================================================
SUMMARY
======================================================================
Total Tables: 284
Total Relationships: 367