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,101–2,125 of 4,762

card_payment, page 85 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
249028Rotterdam CoolsingelNetherlandsJulia Bakker4112810132022NULL
249122Tokyo MarunouchiJapanYuto Suzuki3571823712021NULL
249228Amsterdam ZuidasNetherlandsTess Jansen5533867042019NULL
249326Melbourne Collins StAustraliaIsla Nguyen5454812962020NULL
24954Strasbourg KléberFranceCamille Simon4136789282020NULL
24961Nantes CommerceFranceGabriel Dubois5376045782018NULL
24972Lille Grand PlaceFranceLucas Simon5517202242022NULL
24987Seattle Pike PlaceUnited StatesEthan Moore5230081692022NULL
249918Frankfurt TaunusanlageGermanyHannah Wagner41782536102018Google Pay
25001Lyon BellecourFranceLucas Lefebvre4318181882020NULL
250122Osaka UmedaJapanRen Ito4562594812022NULL
250220São Paulo PaulistaBrazilHelena Oliveira4967289912021NULL
25034Strasbourg KléberFranceChloé Robert41298830122019NULL
25044Paris LouvreFranceLouis Dubois49557193112022NULL
250517Bilbao AbandoSpainHugo López4627455072020NULL
250616Sevilla TrianaSpainSofía García4269272682018Google Pay
250719München MarienplatzGermanyEmma Hoffmann5449156992021NULL
25096San Francisco Market StUnited StatesMia Moore4595421192021NULL
25102Marseille CanebièreFranceLucas Leroy4479048492019Google Pay
251116Madrid Gran VíaSpainMartina Pérez5232931082022Apple Pay
251418Frankfurt TaunusanlageGermanyHannah Hoffmann44596010112019NULL
25155Austin DowntownUnited StatesNoah Taylor4387998742018NULL
25179Guangzhou TianheChinaMin Xu54403170122021NULL
25189Guangzhou TianheChinaYang Li6239658722019NULL
25196Atlanta MidtownUnited StatesEthan Davis3796719572020NULL
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;