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,951–3,975 of 4,762

card_payment, page 159 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
452817Bilbao AbandoSpainPablo Fernández5529791272020NULL
452931Kraków RynekPolandHanna Kowalczyk5306151512024NULL
45303Toulouse CapitoleFranceCamille Thomas4740059442024NULL
45311Paris OpéraFranceInès Moreau45907395112023NULL
45329Guangzhou TianheChinaXin Wu4799681762023NULL
453311London Canary WharfUnited KingdomGeorge Walker44416764112022NULL
45345Manhattan MidtownUnited StatesElla Smith4397743742023NULL
453516Madrid Gran VíaSpainDaniel González5126433172023NULL
453621Belo Horizonte SavassiBrazilArthur Santos4365426782021Apple Pay
45382Lille Grand PlaceFranceZoé Simon4678832252021NULL
45397Seattle Pike PlaceUnited StatesOlivia Taylor4043255382022NULL
45401Nantes CommerceFranceInès Lefebvre4953435932020NULL
454116Sevilla TrianaSpainMartina Martínez49959015122022Apple Pay
454211London Canary WharfUnited KingdomAmelia Davies37739949102021Apple Pay
45438Shanghai PudongChinaXin Liu4230167012024NULL
45442Lille Grand PlaceFranceHugo Martin4969971452024NULL
454512Birmingham New StUnited KingdomOliver Johnson5368373072020NULL
454612Birmingham New StUnited KingdomOliver Taylor3792176152024NULL
45476San Francisco Market StUnited StatesHarper Taylor37897742102020NULL
454817Bilbao AbandoSpainMartina Martín45851398112021NULL
454917Barcelona EixampleSpainMartina Martín5508253512021NULL
455017Barcelona EixampleSpainMartina Martínez4930774992020NULL
455117Barcelona EixampleSpainMartina Martínez41670489122023NULL
455323Kyoto ShijoJapanAoi Sato35868410112022Apple Pay
455412Leeds BriggateUnited KingdomOliver Evans3729930722020NULL
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;