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 1,076–1,100 of 4,762

card_payment, page 44 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
129328Rotterdam CoolsingelNetherlandsDaan de Jong4230464742020NULL
129425Seoul GangnamSouth KoreaYe-jun Kim5473765962018NULL
12956Boston Back BayUnited StatesAva Garcia5255594852018Apple Pay
129624Busan SeomyeonSouth KoreaYe-jun Kim4285328132019NULL
12994Strasbourg KléberFranceInès Bernard4718695942021Google Pay
130116Madrid Gran VíaSpainMartina Martínez44059152112020NULL
130315Roma TerminiItalySofia Esposito5453571182020NULL
130426Adelaide Rundle MallAustraliaAmelia Kelly49038236122017NULL
13066San Francisco Market StUnited StatesHarper Wilson4276252412018NULL
130725Incheon SongdoSouth KoreaHa-eun Choi54981640102018NULL
130814Milano DuomoItalyBeatrice Esposito47282395122019NULL
13095Manhattan MidtownUnited StatesLogan Davis3796801382017NULL
13104Paris LouvreFranceChloé Robert44059981122021NULL
13117Seattle Pike PlaceUnited StatesAva Garcia4389132722020NULL
131218Berlin Unter den LindenGermanyMia Wagner52820608112020NULL
131335Toronto Bay StCanadaCharlotte Martin5597668192019NULL
13143Rennes RépubliqueFranceManon Bernard4800413252019NULL
13154Paris LouvreFranceLucas Dubois4620411712021NULL
13181Paris OpéraFranceZoé Lefebvre44040447112018NULL
132011London Canary WharfUnited KingdomFreddie Jones4703000812018NULL
13223Bordeaux ChartronsFranceChloé Moreau4339595732019NULL
13232Marseille CanebièreFranceJules Martin5309902592019NULL
132415Firenze Santa Maria NovellaItalySofia Rossi54692641102021NULL
13252Marseille CanebièreFranceInès Petit5154840152020NULL
13265Chicago LoopUnited StatesNoah Brown4733288552017NULL
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;