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

card_payment, page 40 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
117635Toronto Bay StCanadaOlivia Wilson5465629812021NULL
11773Toulouse CapitoleFranceLéa Thomas42026560102017NULL
11791Nantes CommerceFranceArthur Thomas4707761252021Apple Pay
118216Madrid Gran VíaSpainÁlvaro Gómez4710397412019Apple Pay
118320São Paulo PaulistaBrazilHelena Oliveira5412864272017NULL
11843Rennes RépubliqueFranceLéa Leroy48955948102020Google Pay
118511Manchester Market StUnited KingdomIsla Taylor5333256182017NULL
118629Utrecht CentrumNetherlandsEmma de Vries5547775272020NULL
118716Madrid Gran VíaSpainHugo Martín5143117872017NULL
118820São Paulo PaulistaBrazilDavi Silva54357353122018NULL
11904Paris LouvreFranceManon Martin4133787322017NULL
119132Stockholm Sergels TorgSwedenLucas Nilsson5372348062020NULL
11922Lille Grand PlaceFranceLéa Petit51678435102020NULL
119315Firenze Santa Maria NovellaItalyMatteo Rossi5241956622018NULL
119418Berlin Unter den LindenGermanyFinn Wagner4474928182020NULL
119517Bilbao AbandoSpainMateo López4700200592018NULL
119610Chengdu JinjiangChinaLei Sun62506327102017NULL
11978Shanghai PudongChinaJun Zhao5167563252019NULL
11983Rennes RépubliqueFranceLéa Thomas4727011032017NULL
119913Bristol Corn StUnited KingdomHarry Patel4658388532020NULL
120026Adelaide Rundle MallAustraliaWilliam Smith4057822132019NULL
12015Manhattan MidtownUnited StatesLiam Miller3761691912017NULL
12028Shanghai PudongChinaFang Sun4451532152017NULL
120430Moscow TverskayaRussiaIvan Petrov4256004022021NULL
120519Hamburg JungfernstiegGermanyBen Weber5511205752021NULL
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;