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 376–400 of 4,762

card_payment, page 16 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
4609Shenzhen FutianChinaTao Liu62715905112018NULL
46115Firenze Santa Maria NovellaItalyAlessandro Ferrari4663515962020NULL
4626Boston Back BayUnited StatesMason Garcia3761528042018NULL
46313Bristol Corn StUnited KingdomAva Walker5357600842019NULL
46432Göteborg AvenynSwedenWilliam Johansson5457110862020NULL
4654Strasbourg KléberFranceInès Robert5378010022017NULL
46614Milano DuomoItalyFrancesco Russo4084647342017Google Pay
46710Hangzhou XihuChinaTao Liu5549969632019NULL
46815Roma TerminiItalyLeonardo Ricci4685360832020Google Pay
46918Frankfurt TaunusanlageGermanyLina Wagner45852901112019Apple Pay
47030Moscow TverskayaRussiaAnastasia Petrov4916355892016NULL
47130Saint Petersburg NevskyRussiaAlexander Smirnov4713001242020NULL
47230Moscow TverskayaRussiaAnastasia Kuznetsov54303266102020NULL
47323Kyoto ShijoJapanSakura Ito3521000432017NULL
47419München MarienplatzGermanyHannah Hoffmann48742504112020NULL
4765Manhattan MidtownUnited StatesMason Moore4164471852019NULL
4776Boston Back BayUnited StatesNoah Williams54997463122020NULL
47812Birmingham New StUnited KingdomSophie Jones5138804822019NULL
48026Adelaide Rundle MallAustraliaWilliam Taylor5353268042018NULL
4812Lille Grand PlaceFranceChloé Simon5446244892019NULL
48228Amsterdam ZuidasNetherlandsSem Smit4668403522019NULL
48320São Paulo PaulistaBrazilLaura Rodrigues4164172692020Apple Pay
4845Austin DowntownUnited StatesElla Davis4473899552020NULL
48523Kyoto ShijoJapanHaruto Sato5112108692017NULL
48613Bristol Corn StUnited KingdomSophie Davies53276855122018NULL
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;