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 4,426–4,450 of 4,762

card_payment, page 178 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
504611Manchester Market StUnited KingdomAmelia Smith47288389122023NULL
50474Paris LouvreFranceChloé Bernard4079459752023Google Pay
504818Berlin Unter den LindenGermanyHannah Meyer5425425572024NULL
504916Sevilla TrianaSpainSofía Fernández5515758942021NULL
505033Bergen BryggenNorwayIngrid Larsen45329983102023NULL
50516Boston Back BayUnited StatesAva Garcia4680812382024NULL
50524Strasbourg KléberFranceInès Petit4636873232022NULL
505330Moscow TverskayaRussiaAnna Vasiliev5529420982021Apple Pay
505425Incheon SongdoSouth KoreaDo-yun Kang42067866122021Apple Pay
505530Saint Petersburg NevskyRussiaAnna Vasiliev45992717102023NULL
505630Moscow TverskayaRussiaAnna Vasiliev4750922262021Google Pay
505725Incheon SongdoSouth KoreaDo-yun Kang52893863122020NULL
50582Paris La DéfenseFranceZoé Laurent4383285462024NULL
50595Manhattan MidtownUnited StatesJames Jones5358477932022NULL
506128Rotterdam CoolsingelNetherlandsLucas de Jong46194973112020NULL
506229Eindhoven StratumseindNetherlandsSem Jansen4714344112021NULL
50631Nantes CommerceFranceZoé Laurent55301956122023NULL
506414Torino CentroItalyBeatrice Colombo4902958972020NULL
506627Brisbane Queen StAustraliaOliver Wilson5345547162021NULL
50673Rennes RépubliqueFranceManon Dubois5417418942022NULL
50685Austin DowntownUnited StatesJames Jones4366983092021Google Pay
506935Toronto Bay StCanadaNoah Gagnon53333048122024NULL
50704Paris LouvreFranceChloé Martin4948080472023Apple Pay
50716Atlanta MidtownUnited StatesOlivia Johnson4332472912020Apple Pay
507223Kyoto ShijoJapanAoi Sato3579743182020Google Pay
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;