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,476–2,500 of 4,762

card_payment, page 100 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
29142Marseille CanebièreFranceHugo Dubois40636055112022NULL
29156Atlanta MidtownUnited StatesAva Brown5182652722023NULL
29161Lyon BellecourFranceArthur Martin4380999282023NULL
29174Strasbourg KléberFranceLucas Leroy5481150582020NULL
29189Shenzhen FutianChinaYan Li5139405222021Apple Pay
291910Hangzhou XihuChinaYan Li6263218532020NULL
292014Milano DuomoItalyGiulia Colombo4507725752020NULL
29219Shenzhen FutianChinaFang Li5235339262022NULL
29222Marseille CanebièreFranceLucas Dubois5132571622022Apple Pay
29245Austin DowntownUnited StatesOlivia Anderson5160972082022NULL
29257Seattle Pike PlaceUnited StatesEmma Williams3774841862022NULL
292623Yokohama MinatomiraiJapanRen Watanabe4011401752022NULL
29277Seattle Pike PlaceUnited StatesMason Moore40406546122020NULL
292817Bilbao AbandoSpainLucía Pérez4107844622019NULL
292919München MarienplatzGermanyLina Meyer4332691982019Apple Pay
293031Warszawa ŚródmieściePolandMaja Wiśniewski4543624852022NULL
293118Frankfurt TaunusanlageGermanyHannah Becker4168476722020NULL
293217Barcelona EixampleSpainDaniel Sánchez4823035662023Apple Pay
293318Frankfurt TaunusanlageGermanyLea Koch4448486072019NULL
293419Hamburg JungfernstiegGermanyLea Koch4886162682022Apple Pay
293518Frankfurt TaunusanlageGermanyLea Koch5369939632022NULL
293632Göteborg AvenynSwedenAlice Larsson5432113592020NULL
29377Denver Union StationUnited StatesHarper Moore48000423122021Google Pay
29384Paris LouvreFranceHugo Dubois46700101122021NULL
29399Guangzhou TianheChinaJun Sun6243380812019NULL
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;