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 526–550 of 4,762

card_payment, page 22 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
64332Stockholm Sergels TorgSwedenAstrid Johansson4452759172017NULL
6443Toulouse CapitoleFranceLouis Robert45247816102016NULL
6455Chicago LoopUnited StatesNoah Garcia5191048782020NULL
6461Nantes CommerceFranceHugo Robert5216726222018Google Pay
64710Hangzhou XihuChinaJun Zhang4512704572019NULL
6483Bordeaux ChartronsFranceJules Petit5305770082019NULL
65035Montréal Ville-MarieCanadaCharlotte Tremblay4494015312018NULL
65135Toronto Bay StCanadaCharlotte Tremblay4642973432018NULL
65221Belo Horizonte SavassiBrazilMiguel Santos4600964392018NULL
6532Marseille CanebièreFranceLucas Durand4446788582017Google Pay
6548Shanghai PudongChinaYang Yang6240884052016NULL
6555Manhattan MidtownUnited StatesMason Williams4363052972020NULL
6565Austin DowntownUnited StatesMason Williams4761866512016Apple Pay
6584Paris LouvreFranceZoé Durand4144708472017NULL
6608Shanghai PudongChinaYang Xu6206186782019NULL
66110Chengdu JinjiangChinaJing Zhao6202631292017NULL
6629Guangzhou TianheChinaLei Liu62431046122016NULL
6657Seattle Pike PlaceUnited StatesJames Brown5552957812020NULL
66613Edinburgh Princes StUnited KingdomAmelia Wilson4542990082017NULL
66826Adelaide Rundle MallAustraliaWilliam Smith5525915662017NULL
6694Strasbourg KléberFranceGabriel Moreau4863442742020NULL
67134Helsinki AleksanterinkatuFinlandVäinö Korhonen5502523572016Google Pay
6722Paris La DéfenseFranceArthur Dubois4392324842019NULL
6731Paris OpéraFranceJules Moreau4192998122020NULL
67424Seoul YeouidoSouth KoreaJi-woo Lee4716612282018NULL
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;