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 4,276–4,300 of 4,762

card_payment, page 172 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
48845Chicago LoopUnited StatesAva Wilson37951669102023NULL
488514Torino CentroItalyFrancesco Marino43585637122022NULL
48868Beijing XidanChinaMin Zhang5599519742022NULL
488818Berlin Unter den LindenGermanyPaul Weber5247418022022NULL
48897Denver Union StationUnited StatesElla Garcia5357909042022NULL
48907Seattle Pike PlaceUnited StatesJames Brown4939166532022NULL
489117Bilbao AbandoSpainPaula García4176579642021NULL
48926San Francisco Market StUnited StatesMia Brown46906349112023NULL
48935Chicago LoopUnited StatesEthan Brown4330589572021NULL
48948Shanghai PudongChinaYan Zhao6231678342022NULL
489519Hamburg JungfernstiegGermanyEmma Koch4833014992023NULL
489626Melbourne Collins StAustraliaWilliam Ryan4098946412021NULL
48971Paris OpéraFranceHugo Simon51595676122021NULL
48981Nantes CommerceFranceJules Lefebvre51697138102023NULL
489918Frankfurt TaunusanlageGermanyHannah Hoffmann4308554342024NULL
490020São Paulo PaulistaBrazilArthur Souza4134417262022NULL
490221Brasília Asa SulBrazilArthur Souza5349267222021Apple Pay
49037Denver Union StationUnited StatesJames Brown37949581122020NULL
49042Paris La DéfenseFranceInès Leroy4066650132023NULL
49064Paris LouvreFranceChloé Lefebvre4280976712023NULL
490717Barcelona EixampleSpainÁlvaro Martín44808503102023Apple Pay
490810Chengdu JinjiangChinaTao Li4666186642024NULL
49091Paris OpéraFranceLéa Durand4737899632022NULL
491032Göteborg AvenynSwedenHugo Eriksson5476989422021Google Pay
491119Hamburg JungfernstiegGermanyLina Schneider5294259322024NULL
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;