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

card_payment, page 180 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
51005Austin DowntownUnited StatesLiam Jones5317715112021NULL
51014Strasbourg KléberFranceJules Bernard4783783122024Apple Pay
510215Roma TerminiItalyGinevra Ricci4127264032021NULL
51037Seattle Pike PlaceUnited StatesNoah Brown5310155172020NULL
510410Chengdu JinjiangChinaMin Wu6204464282024NULL
51057Denver Union StationUnited StatesNoah Johnson37305502112023NULL
510621Brasília Asa SulBrazilHelena Alves5215050322021NULL
51078Shanghai PudongChinaWei Wang5283376662021NULL
51082Marseille CanebièreFranceZoé Bernard4904783962021NULL
510931Warszawa ŚródmieściePolandZuzanna Wiśniewski4954572422022NULL
511024Seoul YeouidoSouth KoreaSu-ah Yoon4622793622021Google Pay
511129Eindhoven StratumseindNetherlandsJulia Jansen54969356122020NULL
51127Seattle Pike PlaceUnited StatesEthan Moore5133068362023NULL
51132Paris La DéfenseFranceJules Bernard5470833182022NULL
511425Seoul GangnamSouth KoreaYe-jun Cho52086159102020Google Pay
51154Strasbourg KléberFranceZoé Robert55422041102024NULL
511619München MarienplatzGermanyLea Hoffmann5473115262024NULL
511730Saint Petersburg NevskyRussiaAnastasia Vasiliev5407176912020NULL
51185Chicago LoopUnited StatesAva Johnson54196466102020NULL
511912Birmingham New StUnited KingdomLily Wilson4460517352023NULL
512014Torino CentroItalyLorenzo Bianchi4158532522020NULL
51213Bordeaux ChartronsFranceInès Laurent5377054782021Google Pay
512218Berlin Unter den LindenGermanyPaul Schmidt42805207122024Google Pay
51233Rennes RépubliqueFranceChloé Moreau4706813722022NULL
512431Kraków RynekPolandJakub Kowalski4249203732023NULL
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;