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 2,801–2,825 of 4,762

card_payment, page 113 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
32695Manhattan MidtownUnited StatesEmma Jones47075612122022NULL
327013Edinburgh Princes StUnited KingdomJack Brown3750795292021NULL
327118Frankfurt TaunusanlageGermanyFinn Müller48953187102023NULL
327222Osaka UmedaJapanAoi Ito3587302592022NULL
32735Chicago LoopUnited StatesAva Brown53466240102020NULL
327415Roma TerminiItalyGiulia Ferrari41128508112020Apple Pay
327617Bilbao AbandoSpainValeria García5563709522023NULL
327717Bilbao AbandoSpainValeria García4063474022020NULL
327812Birmingham New StUnited KingdomJack Brown4658063852019Google Pay
327920São Paulo PaulistaBrazilHelena Rodrigues4660621042020NULL
32802Lille Grand PlaceFranceArthur Robert4501383032020NULL
32814Strasbourg KléberFranceArthur Moreau4058525752021Apple Pay
328333Bergen BryggenNorwayElla Larsen4985712612023NULL
32849Guangzhou TianheChinaTao Zhang43090156112020Apple Pay
328523Yokohama MinatomiraiJapanRen Yamamoto4760300132022NULL
32862Marseille CanebièreFranceGabriel Martin47356274112022NULL
32878Beijing XidanChinaJing Chen6237816372022Google Pay
32883Bordeaux ChartronsFranceJules Robert4605779952020Google Pay
32897Seattle Pike PlaceUnited StatesOlivia Smith54837119112021NULL
329021Brasília Asa SulBrazilLaura Ferreira4804423452019NULL
32918Shanghai PudongChinaLei Huang5310598822021NULL
32922Lille Grand PlaceFranceArthur Thomas5240076872020NULL
329329Eindhoven StratumseindNetherlandsEmma de Vries55135583102020NULL
329429Eindhoven StratumseindNetherlandsEmma de Vries4939536012023NULL
329515Firenze Santa Maria NovellaItalySofia Marino5147227142021NULL
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;