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,551–2,575 of 4,762

card_payment, page 103 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
29932Paris La DéfenseFranceZoé Thomas42680588112019NULL
29946San Francisco Market StUnited StatesElla Wilson37328654122021NULL
29954Strasbourg KléberFranceJules Laurent4202514322021NULL
29963Bordeaux ChartronsFranceLéa Moreau4106178952022NULL
29976Atlanta MidtownUnited StatesLogan Davis5448681682023Apple Pay
29985Chicago LoopUnited StatesLogan Davis49836033122021NULL
30002Lille Grand PlaceFranceHugo Moreau54769619122019Google Pay
300115Firenze Santa Maria NovellaItalyMatteo Rossi4557750242022NULL
30026San Francisco Market StUnited StatesHarper Taylor5416410612020NULL
30033Rennes RépubliqueFranceHugo Dubois4216061772019NULL
30049Shenzhen FutianChinaJun Wang4297777052020NULL
30058Shanghai PudongChinaHao Sun5436323172022NULL
30068Beijing XidanChinaHao Sun6271424222021NULL
30079Guangzhou TianheChinaHao Sun5264635312019NULL
300819München MarienplatzGermanyFinn Becker49615805102020Google Pay
30096San Francisco Market StUnited StatesLiam Johnson4067774142019NULL
301016Madrid Gran VíaSpainÁlvaro Sánchez5556754182022Google Pay
30118Beijing XidanChinaJing Sun6277651232022NULL
30128Beijing XidanChinaJing Sun5106289992022Apple Pay
30135Manhattan MidtownUnited StatesLiam Johnson4752604372020NULL
301435Montréal Ville-MarieCanadaBenjamin Lee4058249732020NULL
301529Utrecht CentrumNetherlandsLucas van den Berg4944703892023NULL
301634Helsinki AleksanterinkatuFinlandAada Hämäläinen5426400282023Google Pay
30172Marseille CanebièreFranceZoé Durand40861169112020NULL
301913Bristol Corn StUnited KingdomAlfie Evans5370267612019Apple Pay
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;