SQL Playground

One fictional retail-banking customer.

• customer_idINTEGERPK

  Customer key

• full_nameTEXT

  Fictional name

• cityTEXT

  Home city

• stateTEXT

  Home state

• date_of_birthTEXT

  Date of birth

• customer_sinceTEXT

  Relationship start date

• risk_tierTEXT

  low, medium or high (internal credit-risk tier)

One deposit or credit-card account owned by one customer.

• account_idINTEGERPK

  Account key

• customer_idINTEGER→ customers

  Owner

• account_typeTEXT

  checking, savings or credit_card

• opened_atTEXT

  Opening date

• closed_atTEXT · nullable

  Closing date; NULL while open

• credit_limit_centsINTEGER · nullable

  Credit limit for credit cards; NULL for deposit accounts

• opening_balance_centsINTEGER

  Ledger balance at 2025-01-01 00:00 (or 0 if opened later); credit-card balances owed are negative

One payment card. Lost or expired cards are replaced by a new card on the same account.

• card_idINTEGERPK

  Card key

• account_idINTEGER→ accounts

  Funding account (checking for debit, credit_card for credit)

• card_typeTEXT

  debit or credit

• networkTEXT

  visa, mastercard or amex

• last4TEXT

  Last four digits

• issued_atTEXT

  Issue date

• expires_onTEXT

  Expiry date

• statusTEXT

  active, lost, expired or frozen

One card-accepting merchant location.

• merchant_idINTEGERPK

  Merchant key

• merchant_nameTEXT

  Fictional merchant name

• categoryTEXT

  Merchant category

• mccTEXT

  ISO 18245 merchant category code

• cityTEXT

  City

• countryTEXT

  ISO country code

One card authorization request. The same request can appear more than once when the network retries.

• authorization_idINTEGERPK

  Authorization key

• request_keyTEXT

  Merchant request id; a retried request reuses it

• card_idINTEGER→ cards

  Card presented

• merchant_idINTEGER→ merchants

  Merchant

• requested_atTEXT

  Request time (UTC)

• amountREAL

  Requested amount in the transaction currency

• currencyTEXT

  USD, EUR, GBP, CAD or MXN

• channelTEXT

  in_store, online or recurring

• statusTEXT

  approved or declined

• decline_reasonTEXT · nullable

  insufficient_funds, credit_limit, suspected_fraud, expired_card or card_frozen; NULL when approved

One completed card purchase. The final amount can differ from the authorization (tips, hotels, currency conversion).

• settlement_idINTEGERPK

  Settlement key

• authorization_idINTEGER→ authorizations

  Authorization being cleared

• settled_atTEXT

  Clearing time (UTC)

• amount_centsINTEGER

  Cleared amount in US cents

One merchant refund against a settlement; a settlement can have several partial refunds.

• refund_idINTEGERPK

  Refund key

• settlement_idINTEGER→ settlements

  Settlement refunded

• refunded_atTEXT

  Refund time (UTC)

• amount_centsINTEGER

  Refunded US cents (positive)

• reasonTEXT

  returned_item, price_adjustment, canceled_service or duplicate_charge

One cardholder dispute against a settlement.

• chargeback_idINTEGERPK

  Dispute key

• settlement_idINTEGER→ settlements

  Disputed settlement

• opened_atTEXT

  Dispute opened (UTC)

• amount_centsINTEGER

  Disputed US cents

• reason_codeTEXT

  fraud, not_received, not_as_described or duplicate

• statusTEXT

  credited (cardholder won), rejected or open

• resolved_atTEXT · nullable

  Resolution time; NULL while open

One money movement on an account. Negative amounts are money out. Pending entries have no posted time yet.

• transaction_idINTEGERPK

  Ledger entry key

• account_idINTEGER→ accounts

  Account

• transaction_typeTEXT

  Kind of money movement (purchase, refund, transfer, fee, and similar)

• statusTEXT

  posted, pending or reversed

• amount_centsINTEGER

  Signed US cents

• initiated_atTEXT

  When the movement started (UTC)

• posted_atTEXT · nullable

  When it reached the ledger; NULL while pending or after reversal

• descriptionTEXT

  Statement description

• merchant_idINTEGER · nullable→ merchants

  Merchant for card and bill entries

• authorization_idINTEGER · nullable→ authorizations

  Card authorization for card purchases

• refund_idINTEGER · nullable→ refunds

  Refund credited

• chargeback_idINTEGER · nullable→ chargebacks

  Dispute credited