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,901–3,925 of 4,762

card_payment, page 157 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
447517Barcelona EixampleSpainDaniel Pérez4515075742023NULL
447629Utrecht CentrumNetherlandsTess Visser5249199112021NULL
44773Rennes RépubliqueFranceArthur Robert5545193912022NULL
44788Shanghai PudongChinaJun Zhou4134681282021NULL
447932Stockholm Sergels TorgSwedenAlice Persson4842242222023NULL
44801Paris OpéraFranceLéa Thomas40403400122023Apple Pay
44813Bordeaux ChartronsFranceHugo Leroy4752148042020NULL
44821Nantes CommerceFranceLucas Thomas4718607452023NULL
448330Saint Petersburg NevskyRussiaAnastasia Smirnov4099100652021NULL
44844Strasbourg KléberFranceInès Simon4247020112023NULL
448518Berlin Unter den LindenGermanyElias Koch4842869822023NULL
448619Hamburg JungfernstiegGermanyElias Koch45224545122024NULL
44871Nantes CommerceFranceManon Petit5293309042024NULL
448816Madrid Gran VíaSpainLucía Gómez47011885112022Google Pay
44897Denver Union StationUnited StatesEthan Wilson5596189262022NULL
449016Madrid Gran VíaSpainLucía Rodríguez47298931122021NULL
449115Firenze Santa Maria NovellaItalyGiulia Rossi4632131072023NULL
44923Bordeaux ChartronsFranceLéa Bernard51691602102023NULL
449312Leeds BriggateUnited KingdomGeorge Walker5467854642021NULL
449430Saint Petersburg NevskyRussiaDaria Vasiliev48000886102023Google Pay
449515Roma TerminiItalyMatteo Russo4556860672023NULL
44961Nantes CommerceFranceZoé Simon42153241122023NULL
44976Atlanta MidtownUnited StatesEmma Taylor5122329032023NULL
44989Shenzhen FutianChinaJun Zhou44863550122021NULL
449918Berlin Unter den LindenGermanyElias Schneider4231582732021NULL
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;