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,651–2,675 of 4,762

card_payment, page 107 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
310135Montréal Ville-MarieCanadaBenjamin Lee4110595322022NULL
310213Bristol Corn StUnited KingdomGrace Wilson4716575882019NULL
310321Brasília Asa SulBrazilValentina Pereira4765701812022NULL
31047Denver Union StationUnited StatesHarper Williams4218830982019NULL
31052Marseille CanebièreFranceJules Robert5553154292022Apple Pay
310716Sevilla TrianaSpainPaula Martín5592836092021NULL
310817Barcelona EixampleSpainValeria Rodríguez54039431112022NULL
310917Barcelona EixampleSpainValeria Rodríguez5502029982023NULL
31107Denver Union StationUnited StatesNoah Anderson5529140582019NULL
31114Strasbourg KléberFranceZoé Dubois5336168822023NULL
31121Nantes CommerceFranceLéa Lefebvre4629978222019NULL
31134Strasbourg KléberFranceLéa Laurent4157441282021NULL
311428Amsterdam ZuidasNetherlandsSem Visser44060098122023Google Pay
311519Hamburg JungfernstiegGermanyLea Müller5500600682021NULL
311616Madrid Gran VíaSpainMateo Rodríguez5117881922020NULL
31174Paris LouvreFranceZoé Thomas5115056912020NULL
311819München MarienplatzGermanyEmma Meyer4412061872021NULL
31194Paris LouvreFranceArthur Leroy5455483042019NULL
31202Lille Grand PlaceFranceArthur Petit45171854122023NULL
312123Kyoto ShijoJapanHaruto Nakamura4010163832021NULL
312231Kraków RynekPolandMaja Wiśniewski47128722122020NULL
31238Beijing XidanChinaTao Wang4835039422023NULL
31243Rennes RépubliqueFranceZoé Laurent42661170112020NULL
312528Amsterdam ZuidasNetherlandsTess de Jong5441060552023NULL
312635Toronto Bay StCanadaChloé Roy4473478482019NULL
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;