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,501–2,525 of 4,762

card_payment, page 101 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
29406San Francisco Market StUnited StatesAva Anderson4719528032021NULL
294115Roma TerminiItalyLeonardo Ferrari4785597562020NULL
294231Kraków RynekPolandHanna Wójcik53543690102023NULL
29441Paris OpéraFranceLéa Simon51677775102021NULL
29453Toulouse CapitoleFranceLéa Simon54452687122022NULL
294623Kyoto ShijoJapanRen Tanaka3544695462020NULL
29471Lyon BellecourFranceHugo Lefebvre4304283022023NULL
294818Berlin Unter den LindenGermanyLeon Meyer53774949112020NULL
29492Lille Grand PlaceFranceArthur Bernard4636530062020NULL
295015Firenze Santa Maria NovellaItalyGiulia Esposito4237505722023NULL
29526San Francisco Market StUnited StatesJames Johnson52768217102023NULL
295333Oslo BjørvikaNorwayFilip Johansen4927948782021NULL
295433Oslo BjørvikaNorwayFilip Johansen5374105362022NULL
295510Hangzhou XihuChinaFang Xu6215210662022NULL
295613Edinburgh Princes StUnited KingdomAva Jones52163635102020NULL
295716Sevilla TrianaSpainPaula Martínez5448855522022NULL
295821Brasília Asa SulBrazilMiguel Oliveira5391201982023NULL
295931Warszawa ŚródmieściePolandHanna Wójcik41760232122023NULL
29606Atlanta MidtownUnited StatesOlivia Garcia54532392102019NULL
29611Nantes CommerceFranceLouis Bernard42624768112022NULL
29629Guangzhou TianheChinaTao Li4044473772022NULL
29631Paris OpéraFranceHugo Moreau4025373272020NULL
29647Denver Union StationUnited StatesHarper Taylor47671189112021NULL
29657Denver Union StationUnited StatesEmma Jones4748730272021NULL
29666Boston Back BayUnited StatesAva Anderson5574336382023NULL
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;