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 3,701–3,725 of 4,762

card_payment, page 149 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
42671Nantes CommerceFranceLucas Thomas4940763832022NULL
426817Bilbao AbandoSpainHugo Martín4153679532022NULL
42691Nantes CommerceFranceHugo Dubois5505826382021Google Pay
427010Chengdu JinjiangChinaJun Liu5250022992023Google Pay
427111Manchester Market StUnited KingdomGeorge Evans51831154102022NULL
42725Chicago LoopUnited StatesLogan Jones49653946112021NULL
42731Paris OpéraFranceGabriel Laurent52342196122024NULL
427412Birmingham New StUnited KingdomFreddie Taylor4395416692020NULL
427519München MarienplatzGermanyFinn Weber4619179912021Apple Pay
427618Berlin Unter den LindenGermanyElias Hoffmann4714309592021NULL
42776Atlanta MidtownUnited StatesOlivia Anderson4415538232020NULL
427812Leeds BriggateUnited KingdomLily Williams42388622122022NULL
42797Seattle Pike PlaceUnited StatesOlivia Anderson5439562452021Google Pay
42801Paris OpéraFranceLucas Dubois40633319122021Apple Pay
42818Shanghai PudongChinaJing Chen5267875492020NULL
42821Lyon BellecourFranceLucas Dubois44462650102023NULL
428418Frankfurt TaunusanlageGermanyBen Schneider5356018332020NULL
428521Brasília Asa SulBrazilValentina Rodrigues42339804112024Apple Pay
428620São Paulo PaulistaBrazilAlice Pereira5245514852021Google Pay
42875Austin DowntownUnited StatesMason Anderson4863662692024Google Pay
42887Seattle Pike PlaceUnited StatesElla Smith5511191572021NULL
42891Nantes CommerceFranceJules Robert47256301102024NULL
429020Rio CentroBrazilAlice Pereira4777386412021NULL
42912Marseille CanebièreFranceHugo Martin4816340772024NULL
429229Utrecht CentrumNetherlandsTess Visser4393065532021NULL
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;