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,951–2,975 of 4,762

card_payment, page 119 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
34347Denver Union StationUnited StatesNoah Anderson4307653652023NULL
343521Belo Horizonte SavassiBrazilArthur Santos44076401102023NULL
34362Lille Grand PlaceFranceLucas Lefebvre4464617222020NULL
34374Paris LouvreFranceLucas Lefebvre4290442312021NULL
34394Paris LouvreFranceManon Leroy47607900122019Apple Pay
34403Bordeaux ChartronsFranceLucas Laurent5490339342019NULL
344119Hamburg JungfernstiegGermanyElias Wagner48127814122022Apple Pay
344226WoolloomoolooAustraliaJack Jones4085299072022NULL
34447Denver Union StationUnited StatesElla Moore40393040112019NULL
34453Bordeaux ChartronsFranceHugo Leroy5567913632019NULL
344611Manchester Market StUnited KingdomGrace Taylor52180839102020Apple Pay
344831Kraków RynekPolandJulia Zieliński5255606752022Google Pay
345018Berlin Unter den LindenGermanyHannah Weber4374628072019Apple Pay
34521Paris OpéraFranceGabriel Laurent4068952352019Apple Pay
34534Strasbourg KléberFranceManon Bernard5330569352019Apple Pay
34544Strasbourg KléberFranceManon Bernard4846099932021Apple Pay
345512Birmingham New StUnited KingdomFreddie Wright4579902562021NULL
345630Moscow TverskayaRussiaAnna Morozov5457521982021NULL
34576Atlanta MidtownUnited StatesMason Miller3746732772019NULL
345828Rotterdam CoolsingelNetherlandsEmma Meijer4416986842021NULL
345934Tampere HämeenkatuFinlandAino Korhonen4714365852022NULL
346133Oslo BjørvikaNorwayNora Pedersen4095809862019NULL
34621Nantes CommerceFranceLucas Lefebvre5571911732021NULL
346326Melbourne Collins StAustraliaCharlotte Williams4390590432021Apple Pay
346419Hamburg JungfernstiegGermanyLea Müller5422063232020NULL
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;