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 3,976–4,000 of 4,762

card_payment, page 160 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
455515Roma TerminiItalyBeatrice Greco5262651212023NULL
45566Atlanta MidtownUnited StatesOlivia Taylor4664241482022Apple Pay
45578Shanghai PudongChinaYang Wang4074463492021NULL
45587Seattle Pike PlaceUnited StatesElla Smith3741468042020NULL
45595Manhattan MidtownUnited StatesElla Smith4292981792022NULL
45606San Francisco Market StUnited StatesLiam Jones5286885492020NULL
45615Chicago LoopUnited StatesOlivia Davis5155899062024NULL
45627Denver Union StationUnited StatesLiam Wilson5327127932022NULL
45633Rennes RépubliqueFranceChloé Thomas5310804832024NULL
456514Milano DuomoItalyLorenzo Ferrari40799474112022Apple Pay
45664Paris LouvreFranceZoé Simon5126545952022NULL
45676Boston Back BayUnited StatesEmma Smith4073993332023NULL
456827Sydney Martin PlaceAustraliaJack Ryan5358558852024Apple Pay
456915Firenze Santa Maria NovellaItalyLeonardo Marino5180990222021NULL
45704Paris LouvreFranceZoé Bernard4179473672022Google Pay
457120São Paulo PaulistaBrazilLaura Santos5165717762024NULL
45725Chicago LoopUnited StatesLiam Wilson4850868852023NULL
457317Bilbao AbandoSpainLucía González4830395512020Apple Pay
457525Seoul GangnamSouth KoreaYe-jun Kang4083956152023NULL
457630Moscow TverskayaRussiaDaria Vasiliev5281348762022NULL
45771Lyon BellecourFranceLouis Moreau5487756432022NULL
45782Paris La DéfenseFranceCamille Robert5472107442023NULL
457923Yokohama MinatomiraiJapanAoi Sato48525129102024NULL
45804Paris LouvreFranceLucas Laurent49051994102021NULL
458112Birmingham New StUnited KingdomLily Evans4642728812023NULL
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;