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,526–3,550 of 4,762

card_payment, page 142 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
40807Denver Union StationUnited StatesMia Brown3792684032023NULL
40813Toulouse CapitoleFranceCamille Martin4139559232024NULL
408317Barcelona EixampleSpainHugo Gómez4021193522023NULL
40844Paris LouvreFranceCamille Leroy5460089372024NULL
40852Paris La DéfenseFranceZoé Lefebvre5565731842021NULL
40865Chicago LoopUnited StatesLiam Johnson4173761712020Google Pay
408729Eindhoven StratumseindNetherlandsEmma Smit5251320652024NULL
408823Yokohama MinatomiraiJapanRen Sato5385790332020NULL
40899Guangzhou TianheChinaJing Sun6214654882023Apple Pay
40905Austin DowntownUnited StatesEthan Davis37999760112023NULL
409114Torino CentroItalyLeonardo Colombo4774483552021NULL
409222Osaka UmedaJapanHaruto Sato3513908042022NULL
40937Seattle Pike PlaceUnited StatesLogan Davis4924977962020Apple Pay
409416Madrid Gran VíaSpainMateo López4804594662021Google Pay
40959Shenzhen FutianChinaYan Huang62626044122021Apple Pay
40965Chicago LoopUnited StatesHarper Brown4326394462021NULL
409725Seoul GangnamSouth KoreaDo-yun Choi4523646612022Google Pay
40983Bordeaux ChartronsFranceChloé Leroy4952534832021NULL
40994Strasbourg KléberFranceManon Thomas44636886122021NULL
41007Denver Union StationUnited StatesLogan Garcia5434389332020NULL
41017Denver Union StationUnited StatesEmma Johnson4733276362024NULL
41026San Francisco Market StUnited StatesElla Taylor4775448112024NULL
410312Birmingham New StUnited KingdomLily Brown4428763672021NULL
410424Busan SeomyeonSouth KoreaSu-ah Park49158337122022NULL
41057Seattle Pike PlaceUnited StatesLogan Davis4341230312020NULL
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;