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,301–1,325 of 4,762

card_payment, page 53 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
156317Bilbao AbandoSpainValeria Fernández4308825742019NULL
156415Firenze Santa Maria NovellaItalyMatteo Greco51089162122021NULL
156535Toronto Bay StCanadaEmma Wilson5379514842018NULL
15662Lille Grand PlaceFranceArthur Simon4714414772018NULL
156725Incheon SongdoSouth KoreaSeo-jun Kang40224626122019Google Pay
156827Brisbane Queen StAustraliaIsla Smith4684577552017NULL
156933Bergen BryggenNorwayElla Pedersen5217902032019NULL
157012Birmingham New StUnited KingdomFreddie Smith4270297872019NULL
15713Bordeaux ChartronsFranceJules Simon51040007122020NULL
157215Firenze Santa Maria NovellaItalyBeatrice Marino40025563122017NULL
15736San Francisco Market StUnited StatesAva Moore5446749522021NULL
15755Manhattan MidtownUnited StatesMason Anderson4904109182019NULL
157616Madrid Gran VíaSpainValeria Sánchez5589628972019NULL
157716Madrid Gran VíaSpainValeria Sánchez4233067582020NULL
157819München MarienplatzGermanyEmma Wagner5132606612017NULL
15802Paris La DéfenseFranceZoé Moreau4615838992017NULL
158119Hamburg JungfernstiegGermanyEmma Schneider5182236862017Apple Pay
158224Seoul YeouidoSouth KoreaYe-jun Jung4089330072017NULL
158317Barcelona EixampleSpainÁlvaro Martínez5144095012021NULL
15841Nantes CommerceFranceLucas Robert4752393172020NULL
158510Chengdu JinjiangChinaMin Huang4268113822018NULL
158612Leeds BriggateUnited KingdomFreddie Wright4264495422020NULL
158718Frankfurt TaunusanlageGermanyMia Meyer5332466822020NULL
15891Paris OpéraFranceChloé Bernard4046484762017NULL
159021Belo Horizonte SavassiBrazilAlice Santos4469937982020NULL
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;