Skip to content
Louvre Ops DB

Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Download CSV Query in playground

Rows 1,276–1,300 of 4,762

card_payment, page 52 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
153328Rotterdam CoolsingelNetherlandsJulia de Jong4954993932020NULL
15345Manhattan MidtownUnited StatesHarper Moore5326300262020NULL
153518Berlin Unter den LindenGermanyElias Müller4004384282020NULL
153634Tampere HämeenkatuFinlandOliver Hämäläinen4515788022020NULL
153816Sevilla TrianaSpainMartina López5298384492021Google Pay
15395Manhattan MidtownUnited StatesEthan Williams53290505122018NULL
154114Milano DuomoItalyGiulia Greco43280030112021NULL
154215Firenze Santa Maria NovellaItalyGiulia Greco4780302752021NULL
154318Berlin Unter den LindenGermanyBen Meyer4255819062021Apple Pay
154410Chengdu JinjiangChinaLin Chen6289678092020NULL
15453Bordeaux ChartronsFranceInès Dubois5528425432020NULL
154623Kyoto ShijoJapanSakura Sato5545452512019NULL
154712Birmingham New StUnited KingdomGrace Williams3775958392017NULL
154812Leeds BriggateUnited KingdomGrace Williams4464914312021NULL
154913Bristol Corn StUnited KingdomOliver Walker4435312432020NULL
155018Frankfurt TaunusanlageGermanyLeon Fischer4524732632018NULL
155115Firenze Santa Maria NovellaItalyMatteo Esposito5557752672020NULL
155217Bilbao AbandoSpainValeria Sánchez48671285112021NULL
15555Manhattan MidtownUnited StatesMia Johnson4653112782017NULL
15566Atlanta MidtownUnited StatesElla Johnson3758403572021NULL
155713Edinburgh Princes StUnited KingdomAmelia Williams3742666682017NULL
155928Amsterdam ZuidasNetherlandsNoah Jansen41320751102021NULL
156020Rio CentroBrazilAlice Oliveira43699232112020NULL
15614Paris LouvreFranceChloé Leroy6268169742021NULL
15623Toulouse CapitoleFranceJules Leroy4244170982019NULL
Table definition
CREATE TABLE card_payment (
  payment_id     INTEGER PRIMARY KEY REFERENCES payment (payment_id),
  institution_id INTEGER NOT NULL REFERENCES financial_institution (institution_id),
  issuing_branch TEXT NOT NULL,
  issued_country TEXT NOT NULL,
  account_name   TEXT NOT NULL,
  card_first4    TEXT NOT NULL CHECK (length(card_first4) = 4 AND card_first4 NOT GLOB '*[^0-9]*'),
  card_last4     TEXT NOT NULL CHECK (length(card_last4) = 4 AND card_last4 NOT GLOB '*[^0-9]*'),
  expiry_month   INTEGER NOT NULL CHECK (expiry_month BETWEEN 1 AND 12),
  expiry_year    INTEGER NOT NULL CHECK (expiry_year BETWEEN 2000 AND 2099),
  wallet         TEXT CHECK (wallet IN ('Apple Pay', 'Google Pay'))
) STRICT;